tesla 연습모드
테이블 (13)
configuration
- config_id — VARCHAR(36)
- model — VARCHAR(50) — NOT NULL
- trim — VARCHAR(50)
- options_json — TEXT
- price_total — DECIMAL(12,2)
- snapshotted_at — TIMESTAMP
delivery_appointment
- appointment_id — VARCHAR(36)
- order_id — VARCHAR(36) — NOT NULL
- mode — VARCHAR(16
document
- doc_id — VARCHAR(36)
- order_id — VARCHAR(36) — NOT NULL
- doc_type — VARCHAR(64) — NOT NULL
- storage_uri — VARCHAR(512)
- verify_status — VARCHAR(32)
financing_application
- 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
orders
- order_id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- config_id — VARCHAR(36) — NOT NULL
- vin — VARCHAR(32)
- 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
pre_delivery_task
- task_id — VARCHAR(36)
- order_id — VARCHAR(36) — NOT NULL
- task_type — VARCHAR(64) — NOT NULL
- required — BOOLEAN
- status — VARCHAR(32)
- completed_at — TIMESTAMP
region_policy
- policy_id — VARCHAR(36)
- region_code — VARCHAR(10) — NOT NULL
- payment_rules_uri — VARCHAR(512)
- refund_rules_uri — VARCHAR(512)
- valid_from — DATE
- valid_to — DATE
trade_in
- tradein_id — VARCHAR(36)
- order_id — VARCHAR(36) — NOT NULL
- vehicle_desc — VARCHAR(255)
- mileage — INT
- offer_amount — DECIMAL(12,2)
- status — VARCHAR(32)
user_account
- user_id — VARCHAR(36)
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(50)
- country_code — VARCHAR(10)
- status — VARCHAR(32)
- created_at — TIMESTAMP
vehicle
- vin — VARCHAR(32)
- model — VARCHAR(50)
- trim — VARCHAR(50)
- ext_color — VARCHAR(50)
- int_color — VARCHAR(50)
- status — VARCHAR(32)
wallet_payment_method
- wallet_id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- method_type — VARCHAR(32) — NOT NULL
- token_masked — VARCHAR(64)
- is_default — BOOLEAN
- created_at — TIMESTAMP