board

Tables (4)

ADDRESS

  • 주소ID (ID) — BIGINT — Primary key — NOT NULL
  • 글쓴이ID (AUTHOR_ID) — BIGINT — Foreign key → AUTHOR.글쓴이ID — NOT NULL
  • 국가 (NATIONS) — VARCHAR(50) — NOT NULL
  • 도시 (CITY) — VARCHAR(50) — NOT NULL
  • 길거리 (STREET) — VARCHAR(50)

AUTHOR

  • 글쓴이ID (ID) — BIGINT — Primary key — NOT NULL
  • 이메일 (EMAIL) — VARCHAR(50) — NOT NULL
  • Field (NAME) — VARCHAR(255)
  • Field2 (PASSWORD) — VARCHAR(255) — NOT NULL

AUTHOR_POST

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • 글쓴이ID (AUTHOR_ID) — BIGINT — Foreign key → AUTHOR.글쓴이ID — NOT NULL
  • 게시글ID (POST_ID) — BIGINT — Foreign key → POST.게시글ID — NOT NULL

POST

  • 게시글ID (ID) — BIGINT — Primary key — NOT NULL
  • 제목 (TITLE) — VARCHAR(255) — NOT NULL
  • 내용 (CONTENTS) — VARCHAR(65535)