mini
Tables (5)
Applicant (Untitled5)
- BoardId (Key2) — NUMBER — Foreign key → Board.BoardId — NOT NULL
- MemberId (Key3) — NUMBER — Foreign key → Member.MemberId — NOT NULL
- createdAt (Field) — Date
Board (Untitled2)
- BoardId (Key2) — NUMBER — Primary key — NOT NULL
- MemberId (Key) — NUMBER — Foreign key → Member.MemberId — NOT NULL
- type — VARCHAR — NOT NULL
- title — VARCHAR
- contents — VARCHAR
- memberNum — VARCHAR
- date — Date — NOT NULL
- createdAt — Date
- modifiedAt — Date
Comment (Untitled3)
- CommentId (Key3) — NUMBER — Primary key — NOT NULL
- BoardId (Key2) — NUMBER — Foreign key → Board.BoardId — NOT NULL
- MemberId (Key) — NUMBER — Foreign key → Member.MemberId — NOT NULL
- contents — VARCHAR
- createdAt — Date
- modifiedAt — Date
Member (Untitled)
- MemberId (Key) — NUMBER — Primary key — NOT NULL
- loginId — VARCHAR — NOT NULL
- nickname (Field2) — VARCHAR — NOT NULL
- password (Field3) — VARCHAR — NOT NULL
TIMESTAMPED (Untitled4)
- createdAt — Date
- modifiedAt — Date