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.게시글id — NOT NULL

post (게시글)

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