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