board

Tables (4)

adress (주소)

  • id (주소 ID) — bigint — Primary key — NOT NULL
  • author_id (글쓴이 ID) — bigint — Foreign key → author.id — NOT NULL
  • region (국가) — varchar(255)
  • city (도시) — varchar(255)

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
  • author_id (글쓴이 ID) — bigint — Foreign key → author.id — NOT NULL
  • post_id (글ID) — bigint — Foreign key → post.id — NOT NULL

post (게시글)

  • id (글ID) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(255) — NOT NULL
  • contents (내용) — varchar(255)