커뮤니티
테이블 (10)
Comment (Untitled4)
- Key — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- id (Field) — bigint
- post_id (Field2) — bigint
- author_id (Field3) — bigint
- parent_id (Field4) — bigint
- content (Field5) — text
- is_deleted (Field6) — boolean
- created_at (Field7) — DATETIME
- updated_at (Field8) — DATETIME
- Key (Key3) — 외래 키 → User.Key — NOT NULL
POST_IMAGE (Untitled3)
- Key — 기본 키 — NOT NULL
- id (Field) — bigint
- post_id (Field2) — bigint
- url (Field3) — varchar
- sort_order (Field4) — bigint
- uploaded_at (Field5) — DATETIME
- Key (Key2) — 외래 키 → Post.Key — NOT NULL
POST_LIKE (Untitled5)
- Key — 기본 키 — NOT NULL
- post_id (Field) — bigint
- user_id (Field2) — bigint
- created_at (Field3) — DATETIME
- Key (Key2) — 외래 키 → Post.Key — NOT NULL
Post (Untitled2)
- Key — 기본 키 — NOT NULL
- id (Field) — bigint
- author_id (Field2) — bigint
- title (Field3) — varchar
- content (Field4) — longtext
- views (Field5) — bigint
- likes_count (Field6) — bigint
- comments_count (Field7) — bigint
- is_deleted (Field8) — boolean
- created_at (Field9) — DATETIME
- updated_at (Field10) — DATETIME
- Key (Key2) — 외래 키 → User.Key — NOT NULL
User (Untitled)
- Key — 기본 키 — NOT NULL
- id (Field) — int
- email (Field2) — varchar
- password (Field3) — varchar
- profile_image (Field4) — varchar
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
comments
- id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- parent_comment_id — BIGINT
- content — TEXT — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- id (id2) — BIGINT — 외래 키 → users.id — NOT NULL
post_images
- id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — NOT NULL
- url — VARCHAR(1024) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- id (id2) — BIGINT — 외래 키 → posts.id — NOT NULL
- id (id22) — BIGINT — 외래 키 → posts.id — NOT NULL
post_likes
- post_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 기본 키 — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- id (id2) — BIGINT — 외래 키 → posts.id — NOT NULL
- id (id22) — BIGINT — 외래 키 → posts.id — NOT NULL
posts
- id — BIGINT — 기본 키 — NOT NULL
- id (id2) — BIGINT — 외래 키 → users.id — NOT NULL
- author_id — BIGINT — NOT NULL
- title — VARCHAR(26) — NOT NULL
- content — LONGTEXT — NOT NULL
- views — INT — NOT NULL
- likes_count — INT — NOT NULL
- comments_count — INT — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(1024)
- is_active — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL