인테리어
테이블 (8)
COMMENTS (댓글)
- comment_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- parent_comment_id — BIGINT — 외래 키 → COMMENTS.comment_id
- content — TEXT — NOT NULL
- is_deleted — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
LIKES (좋아요)
- like_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
NOTIFICATIONS (알림)
- notif_id — BIGINT — 기본 키 — NOT NULL
- recipient_id — BIGINT — NOT NULL
- actor_id — BIGINT — NOT NULL
- type — VARCHAR(20) — NOT NULL
- post_id — BIGINT
- comment_id — BIGINT
- is_read — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
POSTS (게시물)
- post_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- room_id — BIGINT
- title — VARCHAR(100) — NOT NULL
- caption — TEXT
- thumbnail_url — TEXT — NOT NULL
- style_tag — VARCHAR(20)
- room_type — VARCHAR(20)
- like_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- save_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- post_id (post_id2) — BIGINT — 외래 키 → POSTS.post_id — NOT NULL
- post_id (post_id3) — BIGINT — 외래 키 → POSTS.post_id — NOT NULL
POST_FURNITURE (게시물에 태그된 가구)
- pf_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — NOT NULL
- item_name — VARCHAR(100) — NOT NULL
- brand — VARCHAR(100)
- category — VARCHAR(30) — NOT NULL
- price — INT
- purchase_url — TEXT
ROOM_INFO (방 정보)
- room_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- area_sqm — FLOAT
- width_cm — FLOAT
- height_cm — FLOAT
- budget_range — VARCHAR(30)
- snapshot_3d_url — TEXT
- room_id (room_id2) — BIGINT — 외래 키 → ROOM_INFO.room_id — NOT NULL
SAVES (저장/북마크)
- save_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
USERS (회원 정보)
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — TEXT
- bio — TEXT
- created_at — DATETIME — NOT NULL