board2

Tables (4)

address (Untitled)

  • id (Key) — Primary key — NOT NULL
  • author_id (글쓴이) — BIGINT — Foreign key → author.id
  • nation (국가) — VARCHAR(255) — NOT NULL
  • city (도시) — VARCHAR(255) — NOT NULL

author (회원(글쓴이))

  • id (글쓴이) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • name (Field) — VARCHAR(255)

post (게시글)

  • id (글 ID) — Primary key — NOT NULL
  • title (제목) — VARCHAR(255) — NOT NULL
  • Field3 (내용) — VARCHAR(255)

post_author_list (Untitled2)

  • id — Primary key — NOT NULL
  • author_id (글쓴이) — BIGINT — Foreign key → author.id — NOT NULL
  • post_id (글 ID) — BIGINT — Foreign key → post.id — NOT NULL