ㅇㅇ

Tables (4)

ACCOUNT (사용자)

  • account_id (사용자 식별자) — BIGINT — Primary key — NOT NULL
  • nickname (닉네임) — VARCHAR
  • account_type (계정 타입) — VARCHAR
  • account_status (탈퇴 여부) — VARCHAR
  • created_at (계정 생성일) — DATETIME
  • last_modified_at (계정 수정일) — DATETIME

BOARD (게시글)

  • board_id (게시글 식별자) — BIGINT — Primary key — NOT NULL
  • title (게시글 제목) — VARCHAR
  • content (게시글 내용) — VARCHAR
  • created_at (게시글 생성일) — DATETIME
  • last_modified_at (게시글 수정일) — DATETIME
  • delete_time (게시글 삭제일) — DATETIME
  • account_id (사용자 식별자) — BIGINT — Foreign key → ACCOUNT.account_id — NOT NULL

COMMENTS (댓글)

  • comments_id (댓글 식별자) — BIGINT — Primary key — NOT NULL
  • board_id (게시글 식별자) — BIGINT — Foreign key → BOARD.board_id — NOT NULL
  • comments (댓글 내용) — VARCHAR
  • created_at (댓글 생성일) — DATETIME
  • last_modified_at (댓글 수정일) — DATETIME
  • account_id (사용자 식별자) — BIGINT — Foreign key → ACCOUNT.account_id — NOT NULL

LIKES (좋아요)

  • likes_id (좋아요 식별자) — BIGINT — Primary key — NOT NULL
  • board_id (게시글 식별자) — BIGINT — Foreign key → BOARD.board_id — NOT NULL
  • created_at (좋아요 생성일) — DATETIME
  • account_id (사용자 식별자) — BIGINT — Foreign key → ACCOUNT.account_id — NOT NULL