인테리어

테이블 (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