NOTE

테이블 (3)

게임방 (GAMEROOM)

  • Key (roomNumber) — number — 기본 키 — NOT NULL
  • Field (roomName) — varchar — NOT NULL
  • Field2 (roomPw) — number
  • Field3 (host) — varchar — NOT NULL
  • Field4 (guest) — varchar
  • Field5 (status) — varchar — NOT NULL
  • Key (email) — varchar — 외래 키 → 멤버.Key — NOT NULL
  • Key2 (nickName) — varchar — 외래 키 → 멤버.Key2 — NOT NULL

공지사항 (NOTICE)

  • Key (noticeNumber) — number — 기본 키 — NOT NULL
  • Field (title) — varchar
  • Field2 (writer) — varchar
  • Field3 (contents) — varchar
  • Field4 (writeDate) — date — NOT NULL

멤버 (MEMBER)

  • Key (email) — varchar — 기본 키 — NOT NULL
  • Key2 (nickName) — varchar — 기본 키 — NOT NULL
  • Field (pw) — varchar — NOT NULL
  • Field2 (accountDate) — date — NOT NULL
  • Field3 (profile) — blob — NOT NULL
  • Field4 (rating) — number — NOT NULL
  • Field5 (win) — number — NOT NULL
  • Field6 (lose) — number — NOT NULL