locadora_laravel

Tables (10)

Admin (Untitled3)

  • adm_id (Key) — Primary key — NOT NULL
  • user_id (PK) — auto_increment(int) — Foreign key → User.user_id — NOT NULL

Category (Untitled4)

  • cat_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar

Cost (Untitled6)

  • cost_id (Key) — Primary key — NOT NULL
  • cost_per_day (Field2) — decimal
  • service_tax (Field4) — decimal

Customer (Untitled2)

  • cus_id (Key) — Primary key — NOT NULL
  • user_id (PK) — auto_increment(int) — Foreign key → User.user_id — NOT NULL

PersonalData (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • firstName (Field)
  • lastName (Field2)
  • cpf (Field3)
  • birth_dt (Field4)
  • Field5

Rental

  • rental_id (Key) — auto_increment(int) — Primary key — NOT NULL
  • veh_id (PK) — auto_increment(int) — Foreign key → Vehicle.veh_id — NOT NULL
  • cost_id (Key2) — Foreign key → Vehicle.cost_id — NOT NULL
  • cus_id (Key3) — Foreign key → Customer.cus_id — NOT NULL
  • user_id (PK2) — auto_increment(int) — Foreign key → Customer.user_id — NOT NULL
  • adm_id (Key4) — Foreign key → Admin.adm_id — NOT NULL
  • start_date (Field) — datetime
  • end_date (Field2) — datetime
  • return_time (Field5) — time
  • pickup_time (Field6) — time
  • mileage_returned (Field4) — varchar — NOT NULL
  • is_returned (Field7) — boolean

Transaction (Untitled)

  • trans_id (Key) — int — Primary key — NOT NULL
  • rental_id (Key3) — auto_increment(int) — Foreign key → Rental.rental_id — NOT NULL
  • trans_date (Field) — datetime
  • payment_amount (Field2) — decimal

User

  • user_id (PK) — auto_increment(int) — Primary key — NOT NULL
  • first_name (Field) — varchar(30)
  • email (Field2) — varchar
  • password (Field3) — varchar
  • cpf (UNQ) — varchar(14)
  • birth_dt (Field5) — datetime
  • UF (Field6) — varchar(2)
  • addr_city (Field7) — varchar(32)
  • addr_street (Field8) — varchar
  • addr_number (Field9) — varchar
  • rg (Field10) — varchar
  • last_name (Field11) — varchar
  • gender (Field12) — char
  • cnh (Field13) — varchar
  • role (Field14) — varchar

Vehicle

  • veh_id (PK) — auto_increment(int) — Primary key — NOT NULL
  • cost_id (Key) — Foreign key → Cost.cost_id — NOT NULL
  • model (Field) — varchar
  • brand (Field2) — varchar
  • is_available (Field3) — boolean
  • description (Field4) — varchar
  • manuf_year (Field5) — smallint
  • daily_rent_tax (Field6) — float
  • license_plate (UNQ) — varchar
  • category (Field7) — varchar
  • mileage (Field8) — varchar
  • date_bought (Field9) — date
  • number_doors (Field10) — smallint
  • amount_seats (Field11) — smallint

Vehicle_Category (Untitled5)

  • veh_cat_id (Key) — int — Primary key — NOT NULL
  • veh_id (PK) — auto_increment(int) — Foreign key → Vehicle.veh_id — NOT NULL
  • cat_id (Key2) — int — Foreign key → Category.cat_id — NOT NULL
  • cost_id (Key3) — Foreign key → Vehicle.cost_id — NOT NULL