특화_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