Temporary DB

[Hyomin6349]

DB info

• host: "localhost",
• port: 3306,
• user: "root",
• password: "root",
• database: "memomeet"

userlist

• user_id varchar(30) primary key
• user_pw varchar(30)
• user_name varchar(30)
• user_email varchar(30)
• profile_url varchar(50)

grouplist

• group_id varchar(30) primary key
• group_pw varchar(30)
• group_name varchar(50)

memberlist

• group_id foreign key
• user_id foreign key

forwardmeet

• group_id foreign key
• meet_id primary key varchar(30)
• meet_title varchar(50)
• meet_day varchar(30)
• meet_time varchar(10)
• isfinish tinyint(1)

meetscript

• meet id foreign key
• chat text(60000)
• content text(60000)

finishedmeet

• meet_id foreign key
• summary text(1000)
• wordcloud varchar(100)
• contribution_keys varchar(500)
• contribution_values varchar(500)

taglist

• meet_id foreign key
• tag varchar(30)