BOARD

Tables (4)

author (Untitled)

  • 글쓴이 id (id) — BIGINT — Primary key — NOT NULL
  • 이메일 email (email) — varchar(255)
  • 이름 name (name) — varchar(255)
  • 패스워드 (password) — varchar(255) — NOT NULL

author_address (Untitled3)

  • 주소id (address) — varchar(255) — Primary key — NOT NULL
  • 글쓴이 id (id) — BIGINT — Foreign key → author.글쓴이 id — NOT NULL
  • 국가 (country) — varchar(255)
  • 도시 (Field) — varchar(255)
  • 거리 (Field2) — varchar(255)
  • 생성시간 (Field3) — datetime — NOT NULL

author_post (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • 글 id (post_id) — BIGINT — Foreign key → post.글 id — NOT NULL
  • 글쓴이 id (author_id) — BIGINT — Foreign key → author.글쓴이 id — NOT NULL
  • 수정시간 (update time) — datetime — NOT NULL
  • 생성시간 (created time) — datetime — NOT NULL
  • Field

post (Untitled2)

  • 글 id (id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — varchar(255)
  • 내용 (content) — varchar(255)
  • 생성시간 (created_date) — datetime — NOT NULL