board

Tables (4)

address (주소)

  • address (주소) — Primary key — NOT NULL
  • ID (글쓴이ID) — BIGINT — Foreign key → author.ID — NOT NULL
  • name (이름)
  • numer (번호) — VARXHER (255)

author (회원(글쓴이))

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

author_post_list (Untitled)

  • id (상품id) — bigint — Primary key — NOT NULL
  • ID (글ID) — BIGINT — Foreign key → post.ID — NOT NULL
  • ID (글쓴이ID) — BIGINT — Foreign key → author.ID — NOT NULL

post (게시글)

  • ID (글ID) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(255) — NOT NULL
  • comtents (내용) — VARCHAR(3000)