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