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