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