board

Tables (4)

author (Untitled)

  • 글쓴이ID (id) — bigint — Primary key — NOT NULL — auto_increament
  • 이메일 (email) — varchar(255) — NOT NULL
  • 패스워드 (password) — varchar(255)
  • 이름 (name) — varchar(255)
  • 회원가입일 (created_time) — datetime — current_timestamp

author_address (Untitled3)

  • 주소ID (id) — bigint — Primary key — NOT NULL — auto_increament
  • 글쓴이ID (author_id) — bigint — Foreign key → author.글쓴이ID — NOT NULL
  • 국가 (country) — varchar
  • 도시 (city) — varchar
  • 상세주소 (street) — varchar
  • 생성시간 (created_time) — datetime — current_timestamp

author_post (Untitled4)

  • id — bigint — Primary key — NOT NULL — auto_increament
  • 글ID (post_id) — bigint — Foreign key → post.글ID — NOT NULL
  • 글쓴이ID (author_id) — bigint — Foreign key → author.글쓴이ID — NOT NULL
  • 생성시간 (created_time) — datetime — current_timestamp

post (Untitled2)

  • 글ID (id) — bigint — Primary key — NOT NULL — auto_increament
  • 제목 (title) — varchar(255) — NOT NULL
  • 내용 (contents) — varchar(255)
  • 생성시간 (created_time) — datetime — current_timestamp