KTB-5주차-과제
테이블 (8)
comment
- id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.id — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- content — TEXT — NOT NULL
- edited — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
edit_revision
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- image_url — VARCHAR(500)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
member
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- encoded_password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- img_url — VARCHAR(500)
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
post
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- image_url — VARCHAR(500)
- like_count — BIGINT — NOT NULL
- comment_count — BIGINT — NOT NULL
- view_count — BIGINT — NOT NULL
- report_count — BIGINT — NOT NULL
- edited — BOOLEAN — NOT NULL
- blinded — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
post_draft
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- image_url — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
post_like
- id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.id — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
post_view_log
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT
- post_id — BIGINT
- viewed_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL
report
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- target_id — BIGINT — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- reason — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted — BOOLEAN — NOT NULL