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