CARe(제출용)
테이블 (16)
car_image
- id — varchar(100) — 기본 키 — NOT NULL
- car_id — varchar(100) — 외래 키 → owned_car.car_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- ipfs_cid — varchar(200) — NOT NULL
- s3_url — varchar(500) — NOT NULL
- side — enum('FRONT','FRONT_LEFT','FRONT_RIGHT','REAR','REAR_LEFT','REAR_RIGHT') — NOT NULL
car_model
- model_id — varchar(100) — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- brand — varchar(50) — NOT NULL
- car_size — enum('LARGE','MEDIUM','SMALL') — NOT NULL
- fuel_type — varchar(20) — NOT NULL
- model_name — varchar(100) — NOT NULL
- thumbnail_ipfs_cid — varchar(200)
- thumbnail_url — varchar(500)
company
- company_id — varchar(100) — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- airport_code — varchar(10) — NOT NULL
- biz_number — varchar(50)
- city — varchar(50)
- country_code — varchar(2)
- detail_address — varchar(255)
- did_verified — bit(1) — NOT NULL
- email — varchar(100) — NOT NULL
- language_code — varchar(10)
- name — varchar(100) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- privy_wallet_id — varchar(100)
- wallet_address — varchar(100)
company_notification
- notification_id — varchar(100) — 기본 키 — NOT NULL
- company_id — varchar(100) — 외래 키 → company.company_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- dispute_id — varchar(100)
- message — text — NOT NULL
- notification_type — varchar(50) — NOT NULL
- is_read — bit(1) — NOT NULL
- read_at — datetime(6)
- reservation_id — varchar(100)
- title — varchar(100) — NOT NULL
dispute
- dispute_id — varchar(100) — 기본 키 — NOT NULL
- defense_log_id — varchar(100) — 외래 키 → scratch.log_id — NOT NULL
- target_log_id — varchar(100) — 외래 키 → scratch.log_id — NOT NULL
- reservation_id — varchar(100) — 외래 키 → reservation.reservation_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- claim_amount — int — NOT NULL
- company_settlement_agreed — bit(1) — NOT NULL
- reason — text — NOT NULL
- renter_settlement_agreed — bit(1) — NOT NULL
- settlement_agreed_at — datetime(6)
- settlement_final_amount — bigint
- settlement_status — varchar(20)
- snapshot_after_crop_s3_url — varchar(255)
- snapshot_before_crop_s3_url — varchar(255)
- snapshot_before_log_id — varchar(100)
- snapshot_captured_at — datetime(6)
- snapshot_diff_score — double
- snapshot_similarity — double
- snapshot_threshold — double
- snapshot_warning — bit(1) — NOT NULL
- status — varchar(20) — NOT NULL
- ai_analysis_cached_at — datetime(6)
- ai_analysis_report — longtext
insurance
- insurance_id — varchar(100) — 기본 키 — NOT NULL
- company_id — varchar(100) — 외래 키 → company.company_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- description — text — NOT NULL
- name — varchar(100) — NOT NULL
- price — int — NOT NULL
owned_car
- car_id — varchar(100) — 기본 키 — NOT NULL
- company_id — varchar(100) — 외래 키 → company.company_id — NOT NULL
- model_id — varchar(100) — 외래 키 → car_model.model_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- daily_price — int — NOT NULL
- nft_token_id — varchar(100)
- plate_number — varchar(100) — NOT NULL
- status — enum('ACTIVE','FAILED','PENDING') — NOT NULL
renter
- user_id — varchar(100) — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- did_uri — varchar(100)
- did_verified — bit(1) — NOT NULL
- email — varchar(100) — NOT NULL
- language_code — varchar(10)
- name — varchar(100) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- privy_wallet_id — varchar(100)
- vc_cid — varchar(255)
- wallet_address — varchar(100)
renter_document
- doc_id — varchar(100) — 기본 키 — NOT NULL
- user_id — varchar(100) — 외래 키 → renter.user_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- doc_type — enum('INT_LICENSE','PASSPORT') — NOT NULL
- verified — bit(1) — NOT NULL
- verified_at — datetime(6)
renter_notification
- notification_id — varchar(100) — 기본 키 — NOT NULL
- renter_id — varchar(100) — 외래 키 → renter.user_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- dispute_id — varchar(100)
- message — text — NOT NULL
- notification_type — varchar(50) — NOT NULL
- is_read — bit(1) — NOT NULL
- read_at — datetime(6)
- reservation_id — varchar(100)
- title — varchar(100) — NOT NULL
report
- report_id — varchar(36) — 기본 키 — NOT NULL
- reservation_id — varchar(100) — 외래 키 → reservation.reservation_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- generated_at — datetime(6) — NOT NULL
- similarity_threshold — double — NOT NULL
- warning_count — int — NOT NULL
report_item
- item_id — varchar(36) — 기본 키 — NOT NULL
- report_id — varchar(36) — 외래 키 → report.report_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- after_crop_s3_url — varchar(255)
- after_log_id — varchar(100) — NOT NULL
- before_crop_s3_url — varchar(255)
- before_log_id — varchar(100)
- car_part — varchar(100) — NOT NULL
- diff_score — double — NOT NULL
- is_new_scratch — bit(1) — NOT NULL
- similarity — double — NOT NULL
- warning — bit(1) — NOT NULL
reservation
- reservation_id — varchar(100) — 기본 키 — NOT NULL
- user_id — varchar(100) — 외래 키 → renter.user_id — NOT NULL
- insurance_id — varchar(100) — 외래 키 → insurance.insurance_id — NOT NULL
- car_id — varchar(100) — 외래 키 → owned_car.car_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- after_scan_tx_hash — varchar(100)
- before_scan_tx_hash — varchar(100)
- deposit_status — enum('DEDUCTED','LOCKED','SAFE')
- payment_tx_hash — varchar(100)
- pickup_date — datetime(6)
- return_date — datetime(6)
- smart_contract_address — varchar(100) — NOT NULL
- status — varchar(20) — NOT NULL
- total_price — int
review
- review_id — varchar(100) — 기본 키 — NOT NULL
- reservation_id — varchar(100) — 외래 키 → reservation.reservation_id — NOT NULL
- car_id — varchar(100) — 외래 키 → owned_car.car_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- content — text — NOT NULL
- rating — int — NOT NULL
scratch
- log_id — varchar(100) — 기본 키 — NOT NULL
- reservation_id — varchar(100) — 외래 키 → reservation.reservation_id — NOT NULL
- car_id — varchar(100) — 외래 키 → owned_car.car_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- car_part — varchar(255) — NOT NULL
- coord_x — float — NOT NULL
- coord_y — float — NOT NULL
- crop_s3_url — varchar(255) — NOT NULL
- is_disputed — bit(1) — NOT NULL
- is_manual — bit(1) — NOT NULL
- log_type — varchar(50) — NOT NULL
- original_s3_url — varchar(255) — NOT NULL
- proof_ipfs_cid — varchar(255)
- ai_before_log_id — varchar(100)
- ai_diff_score — double
- ai_similarity — double
- ai_before_crop_s3_url — varchar(255)
smart_key
- smart_key_id — varchar(100) — 기본 키 — NOT NULL
- reservation_id — varchar(100) — 외래 키 → reservation.reservation_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — bit(1) — NOT NULL
- expires_at — datetime(6) — NOT NULL
- lock_status — enum('LOCKED','UNLOCKED') — NOT NULL
- revoked_at — datetime(6)
- token — varchar(255) — NOT NULL