PBV_DATABASE
Tables (7)
Untitled (customer_info)
- Key (customer_id) — INTEGER — Primary key — NOT NULL
- Field3 (prefer_option) — TEXT
- Field (address) — TEXXT
Untitled (module_info)
- Key (module_id) — INTEGER — Primary key — NOT NULL
- Field (monule_name) — TEXT
- Field (status) — TEXT
- Field (cost) — INTEGER
- Field (description) — TEXT
Untitled (option_info)
- Key (option_id) — INTEGER — Primary key — NOT NULL
- Key (module_id) — INTEGER — Primary key — NOT NULL
- Field (name) — TEXT
- Field (status) — TEXT
- Field (volume) — INTEGER
- Field (description) — TEXT
- Field (addtional_cost) — INTEGER
Untitled (module_logs)
- Key (log_id) — INTEGER — Primary key — NOT NULL
- Key (vehicle_id) — INTEGER — Primary key — NOT NULL
- Key (module_id) — INTEGER — Primary key — NOT NULL
- Key (user_id) — INTEGER — Primary key — NOT NULL
- Field (rental_start) — INTEGER
- Field (rental_end) — INTEGER
- Field (distance_traveled) — INTEGER
Untitled (module_failures)
- Key (failure_id) — INTEGER — Primary key — NOT NULL
- Key (module_id) — INTEGER — Primary key — NOT NULL
- Key (registered_by) — INTEGER — Primary key — NOT NULL
- Field (failure_description) — TEXT
- Field (repair_duration) — INTEGER
- Field (created_at) — INTEGER
- Field (updated_at) — INTEGER
Untitled (rental_info)
- Key (rental_id) — INTEGER — Primary key — NOT NULL
- Key (user_id) — INTEGER — Primary key — NOT NULL
- Key2 (vehicle_id) — INTEGER — Primary key — NOT NULL
- Key (module_id) — INTEGER — Primary key — NOT NULL
- Field (rental_start) — INTEGER
- Field (rental_end) — INTEGER
- Field (location_start) — TEXT
- Field (location_end) — TEXT
- Field (total_cost) — INTEGER
- Field (create_at) — INTEGER
- Field (updated_at) — INTEGER
user_info
- user_id — INTEGER — Primary key — NOT NULL
- name — TEXT
- email — TEXT
- password (Field) — TEXT
- role — TEXT
- create_at — INTEGER