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