Some unclear questions about db construction
Posted: Wed Jan 01, 2014 11:41 am
1) i have feedbacks on the site. Should I dublicate information: i have itemId column (item id on which is written a feedback). Using it I can find out a seller. Should i create each one column for a seller or i need to find out it every time using itemId?
2) I have soldItems table. Inside contains information about purchases. A seller and for a buyer has some operations (deleting, archiving of a purchase, ect). How i can organise that? Should i dublicate records for a seller and for a buyer (and mark every time a record as archived, deleted ect) or i should choice an another way? For example, two columns for buyer's status and seller's status
2) I have soldItems table. Inside contains information about purchases. A seller and for a buyer has some operations (deleting, archiving of a purchase, ect). How i can organise that? Should i dublicate records for a seller and for a buyer (and mark every time a record as archived, deleted ect) or i should choice an another way? For example, two columns for buyer's status and seller's status