board

Tables (4)

Address (주소)

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

Author (글쓴이)

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

author_post (공동작업)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • 글쓴이ID (id2) — BIGINT — Foreign key → Author.글쓴이ID — NOT NULL
  • POST_ID (id3) — BIGINT — Foreign key → post.POST_ID — NOT NULL

post (게시글)

  • POST_ID (id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(255) — NOT NULL
  • 내용 (contents) — VARCHAR(65535)