vofee-v1
Tables (6)
COMMENT
- id — INT — Primary key — NOT NULL
- content — VARCHAR(191) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
- fk_user_id — INT — Foreign key → USER.id — NOT NULL
- fk_post_id — INT — Foreign key → POST.id — NOT NULL
- fk_parent_comment_id — INT — Foreign key → COMMENT.id
- fk_comment_id — INT — Foreign key → COMMENT.id
- INDEX — `fk_post_id`
- INDEX — `fk_user_id`
- INDEX — `fk_parent_comment_id`
- INDEX — `fk_comment_id`
COMMNET_RECORD
- id — INT — Primary key — NOT NULL
- fk_comment_id — INT — Foreign key → COMMENT.id — NOT NULL
- fk_record_id — INT — Foreign key → RECORD.id — NOT NULL
POST
- id — INT — Primary key — NOT NULL
- fk_user_id — INT — Foreign key → USER.id — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
- INDEX — `fk_user_id`
POST_RECORD
- id — INT — Primary key — NOT NULL
- fk_post_id — INT — Foreign key → POST.id — NOT NULL
- fk_record_id — INT — Foreign key → RECORD.id — NOT NULL
RECORD
- id — INT — Primary key — NOT NULL
- url — VARCHAR(191) — NOT NULL
- is_expired — TINYINT(1) — NOT NULL
- expired_at — DATETIME(3) — NOT NULL
- fk_user_id — INT — Foreign key → USER.id — NOT NULL
- INDEX — `fk_user_id`
USER
- id — INT — Primary key — NOT NULL
- nickname — VARCHAR(191) — NOT NULL
- avatar — VARCHAR(191)
- kakao_id — VARCHAR(191)
- google_id — VARCHAR(191)
- apple_id — VARCHAR(191)
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)