또시판
테이블 (5)
Untitled (Comments)
- Key (commentId) — int — 기본 키 — NOT NULL — auto_increment
- Field (comment) — nvarchar(100)
- Field (registerDate) — datetime
- BoardId (boardId) — int — 외래 키 → 게시판.BoardId — NOT NULL — auto_increment
- Key (userId) — int — 외래 키 → Untitled3.Key — NOT NULL — auto_increment
Untitled3 (Users)
- Key (userId) — int — 기본 키 — NOT NULL — auto_increment
- Field (id) — nvarchar(100) — NOT NULL
- Field (password) — nvarchar(100) — NOT NULL
- Key (userTypeId) — int — 외래 키 → Untitled4.Key — NOT NULL — auto_increment
Untitled4 (UserType)
- Key (userId) — int — 기본 키 — NOT NULL — auto_increment
- Field (type) — int — NOT NULL
like (Likes)
- Key (userId) — int — 외래 키 → Untitled3.Key — NOT NULL — auto_increment
- BoardId (boardId) — int — 외래 키 → 게시판.BoardId — NOT NULL — auto_increment
- like — boolean — NOT NULL
게시판 (Boards)
- BoardId (boardId) — int — 기본 키 — NOT NULL — auto_increment
- Title (title) — nvarchar(100) — NOT NULL
- Field (commentId) — int — NOT NULL
- Field (createdAt) — datetime
- Field (modifyDate) — datetime
- Field (comment) — nvarchar(100) — NOT NULL
- Field (writer) — nvarchar(100) — NOT NULL
- Field (modifier) — nvarchar(100)
- Field (content) — nvarchar(100) — NOT NULL
- Key (userid) — int — 외래 키 → Untitled3.Key — NOT NULL — auto_increment