SSUBOOK
Tables (3)
Board (Untitled3)
- bid — INT — Primary key — NOT NULL
- BGid (BGid2) — INT — Foreign key → BoardGroup.BGid — NOT NULL
- uid (uid2) — INT — Foreign key → User.uid — NOT NULL
- bgid (BGid) — INT
- uid — INT
- Title — VARCHAR(40)
- Subject — VARCHAR(255)
- Date — VARCHAR(40)
BoardGroup (Untitled2)
- BGid — INT — Primary key — NOT NULL
- BGName — VARCHAR(20)
User (Untitled)
- uid — INT — Primary key — NOT NULL
- id — VARCHAR(8)
- password — VARCHAR(20)
- nickname — VARCHAR(20)
- name — VARCHAR(20)
- email — VARCHAR(40)
- profilepic — VARCHAR(255)
- phone — VARCHAR(13)
- Major — VARCHAR(5)
- MajorSpec — VARCHAR(20)
- Notify — BOOLEAN