모델링 공부

테이블 (5)

Untitled (users)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (userId) — VARCHAR(50))
  • Field (userPassword) — VARCHAR(50)
  • Field (userName) — VARCHAR(20)
  • Field (userEmail) — VARCHAR(50)
  • Field (userMobile) — VARCHAR(50)
  • Field (createdAt) — DATE
  • Field2 (updatedAt) — DATE
  • Field (isDelete) — TINYINT(1)

Untitled (boards)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (title) — VARCHAR(200)
  • Field (content) — TEXT
  • Field (createdAt) — DATE
  • Field (updatedAt) — DATE
  • Field (isDelete) — TINIYINT(1)
  • Field (recommed) — INT
  • Field (views) — INT
  • Key (UserKey) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (TypeKey) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (commentsKey) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (boardTypes)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (typeName) — VARCHAR(30)
  • Field (isDelete) — TINYINT(1)

Untitled (files)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (originName) — VARCHAR(200)
  • Field (ext) — VARCHAR(10)
  • Field (filePath) — VARCHAR(500)
  • Key (bordKey) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (comments)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (content) — VARCHAR(200)
  • Field (grade) — INT(1)
  • Key (UserKey) — INT — 외래 키 → Untitled.Key — NOT NULL