movein

Tables (7)

CHALLENGE

  • challenge_id — BIGINT — NOT NULL
  • schedule_id — BIGINT — Foreign key → MOVING_SCHEDULE.schedule_id — NOT NULL
  • mission_name — VARCHAR(150) — NOT NULL
  • mission_status — VARCHAR(50) — NOT NULL
  • point — INT
  • badge — VARCHAR(100)
  • completed_at — TIMESTAMP

COMMUNITY_POST

  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — TEXT
  • like_count — INT
  • comment_count — INT
  • created_at — TIMESTAMP

MOVING_SCHEDULE

  • schedule_id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • move_date — DATE — NOT NULL
  • current_address — VARCHAR(255) — NOT NULL
  • new_address — VARCHAR(255) — NOT NULL
  • house_type — VARCHAR(50) — NOT NULL
  • moving_stage — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

ROOM_PLANNER

  • planner_id — BIGINT — NOT NULL
  • schedule_id — BIGINT — Foreign key → MOVING_SCHEDULE.schedule_id — NOT NULL
  • floor_plan_url — TEXT
  • lifestyle — VARCHAR(100)
  • mood — VARCHAR(100)
  • house_size — VARCHAR(50)
  • room_structure — VARCHAR(100)
  • layout_result — TEXT
  • recommended_products — TEXT
  • created_at — TIMESTAMP

SAFE_REPORT

  • report_id — BIGINT — NOT NULL
  • schedule_id — BIGINT — Foreign key → MOVING_SCHEDULE.schedule_id — NOT NULL
  • before_image_url — TEXT
  • after_image_url — TEXT
  • risk_score — INT
  • defect_summary — TEXT
  • checklist — TEXT
  • created_at — TIMESTAMP

TRADE_IN

  • tradein_id — BIGINT — NOT NULL
  • schedule_id — BIGINT — Foreign key → MOVING_SCHEDULE.schedule_id — NOT NULL
  • image_url — TEXT — NOT NULL
  • product_type — VARCHAR(100)
  • brand — VARCHAR(100)
  • model_name — VARCHAR(100)
  • purchase_year — INT
  • condition_grade — VARCHAR(50)
  • estimated_price — DECIMAL(10,2)
  • tradein_bonus — DECIMAL(10,2)
  • recommended_action — VARCHAR(100)
  • generated_title — VARCHAR(255)
  • listing_status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

USER

  • user_id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • login_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP