board

Tables (4)

address (주소)

  • 주소ID (id) — BIGINT — Primary key — NOT NULL
  • 글쓴이ID (author_id) — BIGINT — Foreign key → author.id — NOT NULL
  • 국가 (country) — VARCHAR(255)
  • 도시 (city) — VARCHAR(255)
  • 길거리 (street) — VARCHAR(255)

author (글쓴이)

  • id (글쓴이ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(50) — NOT NULL
  • name (이름) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255) — NOT NULL

author_post (연결)

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

post (게시글)

  • 아이디 (id) — BIGINT — Primary key — NOT NULL
  • 내용 (contents) — VARCHAR(65536)
  • 제목 (title) — VARCHAR(255) — NOT NULL