ㅇㅇ
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