Schema migrations - Githubissues

jasonkliu / ClassLive

live class chat

MIT License

0 stars 0 forks source link

Schema migrations #2

Closed jasonkliu closed 10 years ago

jasonkliu commented 10 years ago

plz make

petahwin commented 10 years ago

Users:

netID :: string, primary key
email :: string
First Name
Last Name
College :: enum type 'college' ("SY", "ES", "BK", "SM", "JE", "BR", "MC", "DC", "TD", "CC", "TC", "PC")
Year :: some sort of number thing 2015 onwards, let's stop at the year 3000

Chats:

Course ID :: Primary Key, string
Course Name :: string

Messages:

Msg ID :: autogen number, PK
Users NetID :: string, Foreign Key
chat Course ID :: string, Foreign Key
timestamp :: datetime thing
content :: string