또시판

테이블 (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