게시판

okky erd

테이블 (3)

content (board)

  • id — bigint(20) — 기본 키 — NOT NULL
  • id (user_id) — bigint(20) — 외래 키 → user.id — NOT NULL
  • a_nick_name (username) — varchar(255)
  • Field2 (title) — varchar(255) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • selected — bit(1) — NOT NULL
  • text — longtext — NOT NULL
  • Field (view_count) — int(11) — NOT NULL

file

  • id — bigint(20) — 기본 키 — NOT NULL
  • id (board_id) — bigint(20) — 외래 키 → content.id — NOT NULL
  • version — bigint(20) — NOT NULL
  • attach_type — varchar(255) — NOT NULL
  • byte_size — int(11) — NOT NULL
  • height — int(11) — NOT NULL
  • name — varchar(255) — NOT NULL
  • org_name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • width — int(11) — NOT NULL

user

  • id — bigint(20) — 기본 키 — NOT NULL
  • version — bigint(20) — NOT NULL
  • account_expired — bit(1) — NOT NULL
  • date_created — datetime — NOT NULL
  • enabled — bit(1) — NOT NULL
  • last_updated — datetime — NOT NULL
  • password — varchar(255) — NOT NULL
  • username — varchar(15) — NOT NULL
  • Field (managed_user) — bit(1) — NOT NULL