Database Preview - TDawg4Lyf3/HumanReview GitHub Wiki

Tables:

Note: $id stands for the id of the person

allpersons

Shows information for all people, used to determine id and for a search engine i will make later. Information: id - Id which links the person to the tables created for him name - Name of the person

data_$id

Shows data of person, this should be only one row. Do want to make this into one table with lots of rows. Information: name - Name of person sex - Man or woman? age - Age group of person (These are 0-19, 20-59 and 60-100) imagelink - Link to a image of the person averagerating - How he is rated on average

review_$id

Shows reviews Information: name - Name of writer, turns into Anonymous when blank rating - Rating that the writer gave text - What the writer has to say about the person

badges_$id

Not done with this yet, but here is the information for when i am done with it. Information: badgename - Name of badge why - Why he got the badge