ASSEMBLE
Tables (6)
bbs
- partyNum — int — Primary key — NOT NULL — PK
- bbsTitle — varchar
- bbsContent — varchar
- bbsOpenChat — varchar
- maxNum — int
- nowNum — int
- bbsDate — datetime
- bbsAction — int
- categoryName — char
- userID — char — Foreign key → user.userID — NOT NULL — PK
chat
- chatID — int — Primary key — NOT NULL
- fromID — varchar(20) — Foreign key → user.userID — NOT NULL
- toID — varchar(20)
- chatContent — varchar(100)
- chatTime — datetime
comment (Untitled)
- cmtNum — int — Primary key — NOT NULL
- cmtDate — datetime
- cmtContent — varchar
- cmtParent — int
- cmtAction — int
- partyNum — int — Foreign key → bbs.partyNum — NOT NULL — PK
- userID — char — Foreign key → user.userID — NOT NULL — PK
party
- partyNum — int — Foreign key → bbs.partyNum — NOT NULL — PK
- userID — char — Foreign key → user.userID — NOT NULL — PK
- partyLeader — char
partyJoinCheck
- partyNum — int — Foreign key → bbs.partyNum — NOT NULL — PK
- userID — char — Foreign key → user.userID — NOT NULL — PK
user
- userID — char — Primary key — NOT NULL — PK
- userPassword — varchar
- userName — char
- userBirth — date
- userPhone — char