test

Tables (5)

BOARD

  • board_id — INT
  • board_name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL

MEMBER

  • member_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

POST

  • post_id — INT
  • board_id — INT — Foreign key → BOARD.board_id — NOT NULL
  • member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • is_deleted — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

POST_COMMENT

  • comment_id — INT
  • post_id — INT — Foreign key → POST.post_id — NOT NULL
  • member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
  • parent_comment_id — INT
  • content — VARCHAR(1000) — NOT NULL
  • is_deleted — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

POST_LIKE

  • member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
  • post_id — INT — Foreign key → POST.post_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL