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 — 생성일