board

Tables (4)

ADDRESS (주소)

  • ID (주소ID) — BIGINT — Primary key — NOT NULL
  • AUTHOR_ID (글쓴이ID) — BIGINT — Foreign key → AUTHOR.ID — NOT NULL
  • NATION (국가) — VARCHAR(255) — NOT NULL
  • CITY (도시) — VARCHAR(255) — NOT NULL

AUTHOR (회원(글쓴이))

  • ID (글쓴이ID) — BIGINT — Primary key — NOT NULL
  • EMAIL (이메일) — VARCHAR(255) — NOT NULL
  • NAME (이름) — VARCHAR(255)

AUTHOR_POST_LIST (글_회원_목록)

  • ID (중복글ID) — BIGINT — Primary key — NOT NULL
  • AUTOHR_ID (글쓴이ID) — BIGINT — Foreign key → AUTHOR.ID — NOT NULL
  • POST_ID (글ID2) — Foreign key → POST.ID — NOT NULL

POST (게시글)

  • ID (글ID) — Primary key — NOT NULL
  • TITLE (제목) — VATCHAR(255) — NOT NULL
  • CONTENTS (내용) — VARCHAR(3000)