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