Pickcar
Tables (12)
accident
- id — BIGINT — Primary key — NOT NULL
- car_id — BIGINT — Foreign key → car.id — NOT NULL
- rent_id — BIGINT — Foreign key → rent.id
- time — DATETIME(6) — NOT NULL
- part — VARCHAR(255) — NOT NULL
- status — ENUM('COMPLETED','REPAIRED','REPAIRING','REPORT','SUIT') — NOT NULL
- repair_cost — BIGINT
- client_liability — BIGINT
- description — VARCHAR(255)
- location — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_accident_car_id
- INDEX — idx_accident_rent_id
alert
- id — BIGINT — Primary key — NOT NULL
- employee_id — BIGINT — Foreign key → employee.id — NOT NULL
- type — VARCHAR(255) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- date — DATE
- is_read — BIT(1) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_alert_employee_id
branch
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- car_count — INT — NOT NULL
- employ_count — INT — NOT NULL
- manager_id — BIGINT — Foreign key → employee.id
- manager_name — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_branch_manager_id
car
- id — BIGINT — Primary key — NOT NULL
- branch_id — BIGINT — Foreign key → branch.id — NOT NULL
- brand — VARCHAR(255) — NOT NULL
- model — VARCHAR(255) — NOT NULL
- car_number — VARCHAR(255) — NOT NULL
- vehicle_id_number — VARCHAR(255) — NOT NULL
- image — VARCHAR(255)
- insurance_name — VARCHAR(255)
- color — ENUM('BLACK','GRAY','WHITE') — NOT NULL
- fuel_type — ENUM('DIESEL','GASOLINE') — NOT NULL
- status — ENUM('DRIVING','MAINTENANCE','WAITING') — NOT NULL
- age_limit — INT — NOT NULL
- seater — INT — NOT NULL
- year — INT — NOT NULL
- mileage — BIGINT — NOT NULL
- last_maintenance_mileage — BIGINT — NOT NULL
- maintenance_date — DATE
- purchase_price — BIGINT — NOT NULL
- model_price — BIGINT — NOT NULL
- price — BIGINT — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_car_branch_id
client
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255) — NOT NULL
- resident_number — VARCHAR(255) — NOT NULL
- birthday — DATE — NOT NULL
- licence_area — VARCHAR(255) — NOT NULL
- licence_number — VARCHAR(255) — NOT NULL
- licence_day — DATE — NOT NULL
- blacklisted — BIT(1) — NOT NULL
- blacklist_info — VARCHAR(255)
- gender — ENUM('FEMALE','MALE') — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
client_coupon
- id — BIGINT — Primary key — NOT NULL
- client_id — BIGINT — Foreign key → client.id
- coupon_id — BIGINT — Foreign key → coupon.id
- is_used — BIT(1)
- used_at — DATETIME(6)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_client_coupon_client_id
- INDEX — idx_client_coupon_coupon_id
coupon
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(255) — NOT NULL
- coupon_name — VARCHAR(255) — NOT NULL
- discount — INT — NOT NULL
- max_quantity — INT — NOT NULL
- issued_quantity — INT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- exp_date — DATE — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
employee
- id — BIGINT — Primary key — NOT NULL
- branch_id — BIGINT — Foreign key → branch.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- login_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255) — NOT NULL
- grade — VARCHAR(255) — NOT NULL
- authority — ENUM('ADMIN','MANAGER','STAFF') — NOT NULL
- entry_date — DATE — NOT NULL
- quit_date — DATE
- join_change_password — TINYINT(1) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_employee_branch_id
maintenance
- id — BIGINT — Primary key — NOT NULL
- branch_id — BIGINT — Foreign key → branch.id — NOT NULL
- car_id — BIGINT — Foreign key → car.id — NOT NULL
- employee_id — BIGINT — Foreign key → employee.id — NOT NULL
- maintenance_date — DATE — NOT NULL
- title — VARCHAR(255) — NOT NULL
- detail — VARCHAR(255)
- consumables — VARCHAR(255)
- cost — BIGINT — NOT NULL
- employee_name — VARCHAR(255) — NOT NULL
- vehicle_id_number — VARCHAR(255) — NOT NULL
- status — ENUM('COMPLETED','ONGOING','SCHEDULE') — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_maintenance_branch_id
- INDEX — idx_maintenance_car_id
- INDEX — idx_maintenance_employee_id
notice
- id — BIGINT — Primary key — NOT NULL
- branch_id — BIGINT — Foreign key → branch.id
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255)
- important — BIT(1)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_notice_branch_id
payment
- id — BIGINT — Primary key — NOT NULL
- rent_id — BIGINT — Foreign key → rent.id — NOT NULL
- client_id — BIGINT — Foreign key → client.id — NOT NULL
- amount — BIGINT — NOT NULL
- imp_uid — VARCHAR(255) — NOT NULL
- merchant_uid — VARCHAR(255) — NOT NULL
- payment_method — VARCHAR(255)
- pg_provider — VARCHAR(255)
- status — ENUM('CANCELLED','FAILED','PAID','READY') — NOT NULL
- paid_at — DATETIME(6)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_payment_client_id
rent
- id — BIGINT — Primary key — NOT NULL
- car_id — BIGINT — Foreign key → car.id — NOT NULL
- client_id — BIGINT — Foreign key → client.id — NOT NULL
- client_coupon_id — BIGINT — Foreign key → client_coupon.id
- rental_fee — BIGINT — NOT NULL
- start_rent_date_time — DATETIME(6)
- end_rent_date_time — DATETIME(6)
- status — ENUM('CANCELLED','COMPLETED','RESERVED','WAITING_PAYMENT') — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_rent_car_id
- INDEX — idx_rent_client_id
- INDEX — idx_rent_client_coupon_id