220811 게시판 Table

테이블 (4)

Board (Untitled2)

  • board_id — BIGINT — 기본 키 — NOT NULL
  • writter — VARCHAR
  • title — VARCHAR
  • content — VARCHAR
  • register_date — DATETIME
  • update_date — DATETIME
  • delete_date — DATETIME

File (Untitled4)

  • file_id — BIGINT — 기본 키 — NOT NULL
  • board_id — BIGINT — 외래 키 → Board.board_id — NOT NULL
  • file_name — VARCHAR
  • register_date — DATETIME
  • update_date — DATETIME
  • delete_date — DATETIME

Reply (Untitled3)

  • user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
  • board_id — BIGINT — 외래 키 → Board.board_id — NOT NULL
  • writter — VARCHAR
  • content — VARCHAR
  • register_date — DATETIME
  • update_date — DATETIME
  • delete_date — DATETIME

User (Untitled)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR
  • id — VARCHAR
  • pw — VARCHAR
  • post_number — VARCHAR
  • address — VARCHAR
  • address_detail — VARCHAR
  • signup_date — DATETIME