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). One transaction should have a demand associated with it for each good requested.

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). One transaction can have many demands, and many transaction_users.

transcations_users: users involved in transcation

users: list of users

users_openids: store google tokens

watches: what each person is watching for, matches gifts posed with that