aboutmatch
Tables (3)
Member
- Key (id) — INTEGER — Primary key — NOT NULL
- Field (memberId) — VARCHAR(30) — NOT NULL
- Field2 (memberEmail) — VARCHAR(60) — NOT NULL
- Field3 (memberPwd) — VARCHAR(40) — NOT NULL
- Field4 (memberAddress) — VARCHAR(60) — NOT NULL
- Field (memberName) — VARCHAR(30) — NOT NULL
Untitled (Board)
- Key (id) — INTEGER — Primary key — NOT NULL
- Field (title) — VARCHAR(60) — NOT NULL
- Field2 (content) — VARCHAR(600) — NOT NULL
- Field3 (time) — DATETIME — NOT NULL
- Field4 (good) — INTEGER — NOT NULL
- Key (memid) — INTEGER — Foreign key → Member.Key — NOT NULL
Untitled (record)
- Field2 (name) — VARCHAR(40) — NOT NULL
- Field3 (matchNum) — VARCHAR(40) — NOT NULL
- Field4 (score) — VARCHAR(40) — NOT NULL
- Field (assist) — VARCHAR(40) — NOT NULL
- Field (backNum) — VARCHAR(40) — NOT NULL