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