LGMoveIn
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 COMMENT '게시글ID
- mission_status — VARCHAR(50) — NOT NULL — 회원ID
- 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 undefined `content` TEXT NOT NULL undefined `image_url` TEXT NULL undefined `like_c…
MOVING_SCHEDULE
- schedule_id — BIGINT — NOT NULL — 회원ID
- 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 DEFAULT CURRENT_TIMESTAMP COMMENT '플래너ID
ROOM_PLANNER
- planner_id — BIGINT — NOT NULL — 도면이미지URL
- 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) — AI배치결과
- room_structure — VARCHAR(100) — AI추천상품
- layout_result — TEXT — 생성일' `recommended_products` TEXT NULL COMMENT '트레이드인ID
- created_at — TIMESTAMP — 일정ID
SAFE_REPORT
- report_id — BIGINT — NOT NULL — AI위험도점수
- schedule_id — BIGINT — Foreign key → MOVING_SCHEDULE.schedule_id — NOT NULL — AI하자요약
- before_image_url — TEXT — 체크리스트데이터
- after_image_url — TEXT — 생성일' `risk_score` INT NULL COMMENT '챌린지ID
- defect_summary — TEXT — 일정ID
- checklist — TEXT — 미션명
- created_at — TIMESTAMP — 미션상태
TRADE_IN
- tradein_id — BIGINT — NOT NULL — AI인식품목
- schedule_id — BIGINT — Foreign key → MOVING_SCHEDULE.schedule_id — NOT NULL — AI인식브랜드
- image_url — TEXT — NOT NULL — AI인식모델명
- product_type — VARCHAR(100) — 구매연도
- brand — VARCHAR(100) — 상태등급
- model_name — VARCHAR(100) — AI산정시세
- purchase_year — INT — 트레이드인혜택가
- condition_grade — VARCHAR(50) — AI추천행동
- estimated_price — DECIMAL(10, 2) — AI생성제목
- tradein_bonus — DECIMAL(10, 2) — 판매상태
- recommended_action — VARCHAR(100) — 등록일시' `generated_title` VARCHAR(255) NULL COMMENT '리포트ID
- listing_status — VARCHAR(50) — NOT NULL — 일정ID
- created_at — TIMESTAMP — 이사전사진URL
USER
- user_id — BIGINT — Primary key — NOT NULL — 회원ID
- email — VARCHAR(255) — NOT NULL — 이메일
- password — VARCHAR(255) — NOT NULL — 비밀번호
- name — VARCHAR(100) — NOT NULL — 이름
- login_type — VARCHAR(50) — NOT NULL — 로그인타입
- created_at — TIMESTAMP — 생성일