특화_test

테이블 (5)

DAMAGE_REPORTS (손상정보)

  • id — BIGINT
  • inspection_id — BIGINT — 외래 키 → INSPECTIONS.id — NOT NULL
  • title — VARCHAR(255)
  • location — VARCHAR(255)
  • severity — VARCHAR(20)
  • description — TEXT
  • estimated_cost_krw — BIGINT
  • pos_x — DOUBLE
  • pos_y — DOUBLE
  • pos_z — DOUBLE
  • ai_confidence — DOUBLE
  • ai_model — VARCHAR(100)
  • image_url — VARCHAR(500)

INSPECTIONS

  • id — BIGINT
  • inspection_code — VARCHAR(50) — NOT NULL
  • vehicle_id — BIGINT — 외래 키 → VEHICLES.id — NOT NULL
  • inspection_date — DATE
  • status — VARCHAR(20)
  • damage_count — INT
  • total_cost_krw — BIGINT
  • inspector — VARCHAR(100)
  • note — TEXT
  • tx_hash — VARCHAR(255)
  • block_number — VARCHAR(100)
  • ipfs_hash — VARCHAR(255)
  • network — VARCHAR(100)
  • created_at — DATETIME

MEMBERS (회원)

  • id — BIGINT
  • member_code — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • country — VARCHAR(100)
  • type — VARCHAR(20)
  • status — VARCHAR(20)
  • wallet_address — VARCHAR(255)
  • did — VARCHAR(255)
  • license_ipfs_hash — VARCHAR(255)
  • passport_ipfs_hash — VARCHAR(255)
  • biz_license_ipfs_hash — VARCHAR(255)
  • language — VARCHAR(10)
  • created_at — DATETIME
  • updated_at — DATETIME

RESERVATIONS (예약)

  • id — BIGINT
  • reservation_code — VARCHAR(50) — NOT NULL
  • user_id — VARCHAR(50) — 외래 키 → MEMBERS.member_code — NOT NULL
  • user_name — VARCHAR(100)
  • vehicle_id — BIGINT — 외래 키 → VEHICLES.id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • country — VARCHAR(100)
  • city — VARCHAR(100)
  • status — VARCHAR(20)
  • payment_token — VARCHAR(20)
  • payment_amount — DOUBLE
  • tx_hash — VARCHAR(255)
  • insurance_type — VARCHAR(20)
  • pickup_inspection_code — VARCHAR(50)
  • return_inspection_code — VARCHAR(50)
  • created_at — DATETIME

VEHICLES (차량)

  • id — BIGINT
  • vehicle_code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • plate — VARCHAR(50) — NOT NULL
  • year — INT
  • color — VARCHAR(50)
  • mileage — INT
  • seats — INT
  • location — VARCHAR(255)
  • status — VARCHAR(20)
  • nft_id — VARCHAR(100)
  • nft_tx_hash — VARCHAR(255)
  • company_id — VARCHAR(50) — 외래 키 → MEMBERS.member_code
  • created_at — DATETIME
  • updated_at — DATETIME