Tesla app

Tables (14)

Configuration

  • 구성ID(PK) (config_id) — VARCHAR(36)
  • 모델 (model) — VARCHAR(50) — NOT NULL
  • 트림 (trim) — VARCHAR(50)
  • 옵션Json스냅샷 (options_json) — TEXT
  • 총가격 스냅샷 (price_total) — DECIMAL(12,2)
  • 스냅샷 시각 (snapshotted_at) — TIMESTAMP

DeliveryAppointment

  • appointment_id — VARCHAR(36)
  • order_id — VARCHAR(36) — NOT NULL
  • mode — VARCHAR(16)
  • location — VARCHAR(255)
  • scheduled_at — TIMESTAMP
  • status — VARCHAR(32)

Document

  • 문서ID(PK) (doc_id) — VARCHAR(36)
  • 주문ID(FK) (order_id) — VARCHAR(36) — NOT NULL
  • 문서유형(ID/보험) (doc_type) — VARCHAR(64) — NOT NULL
  • 저장경로 (storage_uri) — VARCHAR(512)
  • 검증상태 (verify_status) — VARCHAR(32)

FinancingApplication

  • fin_app_id — VARCHAR(36)
  • order_id — VARCHAR(36) — NOT NULL
  • fin_type — VARCHAR(16)
  • status — VARCHAR(32)
  • apr — DECIMAL(5,2)
  • term_months — INT

Invoice

  • invoice_id — VARCHAR(36)
  • order_id — VARCHAR(36) — NOT NULL
  • amount_total — DECIMAL(12,2)
  • taxes — DECIMAL(12,2)
  • fees — DECIMAL(12,2)
  • discounts — DECIMAL(12,2)
  • status — VARCHAR(32)
  • issued_at — TIMESTAMP

Notification

  • notif_id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • order_id — VARCHAR(36)
  • channel — VARCHAR(16)
  • template_key — VARCHAR(64)
  • sent_at — TIMESTAMP
  • result — VARCHAR(64)

Order

  • 주문ID(PK) (order_id) — VARCHAR(36)
  • 사용자ID(FK) (user_id) — VARCHAR(36) — NOT NULL
  • 구성ID(FK) (config_id) — VARCHAR(36) — NOT NULL
  • VIN (vin) — VARCHAR(32)
  • 정책ID (policy_id) — VARCHAR(36)
  • 주문유형 (order_type) — VARCHAR(32) — NOT NULL
  • 상태(생성/배정/인도) (status) — VARCHAR(32) — NOT NULL
  • 지역코드(스냅샷) (region_code) — VARCHAR(10)
  • 주문시각 (ordered_at) — TIMESTAMP

Payment

  • payment_id — VARCHAR(36)
  • order_id — VARCHAR(36) — NOT NULL
  • invoice_id — VARCHAR(36)
  • method — VARCHAR(32)
  • amount — DECIMAL(12,2)
  • auth_code — VARCHAR(64)
  • status — VARCHAR(32)
  • paid_at — TIMESTAMP

PreDeliveryTask

  • 작업ID(PK) (task_id) — VARCHAR(36)
  • 주문ID(FK) (order_id) — VARCHAR(36) — NOT NULL
  • 작업유형(등록/보험) (task_type) — VARCHAR(64) — NOT NULL
  • 필수여부 (required) — BOOLEAN
  • 상태(pending/완료) (status) — VARCHAR(32)
  • 완료시각 (completed_at) — TIMESTAMP

RegionPolicy

  • 정책ID(PK) (policy_id) — VARCHAR(36)
  • 지역코드 (region_code) — VARCHAR(10) — NOT NULL
  • 결제규정문서 URI (payment_rules_uri) — VARCHAR(512)
  • 환불규정문서URI (refund_rules_uri) — VARCHAR(512)
  • 유효시작 (valid_from) — DATE
  • 유효종료 (valid_to) — DATE

TradeIn

  • tradein_id — VARCHAR(36)
  • order_id — VARCHAR(36) — NOT NULL
  • vehicle_desc — VARCHAR(255)
  • mileage — INT
  • offer_amount — DECIMAL(12,2)
  • status — VARCHAR(32)

UserAccount

  • 사용자ID(PK) (user_id) — VARCHAR(36)
  • 이메일 (email) — VARCHAR(255) — NOT NULL
  • 휴대폰 번호 (phone) — VARCHAR(50)
  • 거주지역 코드 (country_code) — VARCHAR(10)
  • 계정상태 (status) — VARCHAR(32)
  • created_at — TIMESTAMP

Vehicle

  • VIN(PK) (vin) — VARCHAR(32)
  • 모델명 (model) — VARCHAR(50)
  • 트림 (trim) — VARCHAR(50)
  • 외장색 (ext_color) — VARCHAR(50)
  • 내장색 (int_color) — VARCHAR(50)
  • 상태 (status) — VARCHAR(32)

WalletPaymentMethod

  • 지갑ID(PK) (wallet_id) — VARCHAR(36)
  • 사용자ID(PK) (user_id) — VARCHAR(36) — NOT NULL
  • 수단유형(card/bank) (method_type) — VARCHAR(32) — NOT NULL
  • 마스킹토큰/식별값 (token_masked) — VARCHAR(64)
  • 기본결제수단 여부 (is_default) — BOOLEAN
  • 생성시각 (created_at) — TIMESTAMP