Guide to Database

Categories: store name, id of category, each good has category id column ci_session: session cookies for each user demands: when there is request for specific good, who initiated interaction (demander_id, decide_id, good_id, type of demand) events: types of events that occur, stores new events (new user_id, transcation,message) event_types: followings_users: who's following who goods: gifts and needs with user id (type is gift or need) goods_tags: keeps id of good with tags it's associated with links: locations: location of user, location of good messages: stores actual message, thread id, and users involved
notifications: creates unread messages or gift requests photos: of users and goods, and url of thumbnail redirects: reviews: stores reviewer,reviewed, rating states: converts initials of states into actual state name tags: name and id of tag terms: thankyous: gifts that are thankyou cards, lists credits per user threads: keeps messages togther in thread threads_users: who's involved in thread transactions: id number, date of each transcation, gifts involved, status (pending, active, completed, canceled) transcations_users: users involved in transcation users: list of users users_openids: store google tokens users_settings: watches: what each person is watching for, matches gifts posed with that