mysql database design guideline

• • Reply

  12 years ago

  by ashwanisoft

  ashwanisoft

  , India

  Joined 13 years ago
  its realated to the problem where we have to store certain status in any table like we have a table Users ( id int, username varchar(32), status enum('a','d','i') // we can have well formed comment here ); that's what i prefer Q: but the question here is that if some other developer will work on that project someday after me he will not be able to understand this. second way is using integer as status field and using CONSTANTS in the global file to perform these operations so that another developer can remeber that Q: some suggestions are there that CONSTANTS make a load on php so that they should be avoided? and the other ways is Users ( id int, username varchar(32), status int ); and using another table to store status and fetch id and statusname whenever necessary masStatus ( id int, statusName varchar(15) ); Q: that what i wan't to avoid cause that is an unnecessary usage of database and this produces a extra load on php so please suggest me what should be the best way to handle that situation
  Report abuse