dd
Tables (6)
CAMPING_CAR
- id — INT — Primary key — NOT NULL
- car_type — VARCHAR(100) — NOT NULL
- registration_date — VARCHAR(100) — NOT NULL
- lastrepair_date — VARCHAR(100)
- company_id — INT — Foreign key → CARRENTAL_COMPANY.id — NOT NULL
CARBODY_SHOP
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- phone — VARCHAR(100) — NOT NULL
CARRENTAL_COMPANY
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- phone — VARCHAR(100) — NOT NULL
CAR_RENTAL
- Key — INT — Primary key — NOT NULL
- start_date — VARCHAR(100) — NOT NULL
- rental_period — INT — NOT NULL
- cost — VARCHAR(100) — NOT NULL
- car_id — INT — Foreign key → CAMPING_CAR.id — NOT NULL
- customer_id — INT — Foreign key → CUSTOMER.id — NOT NULL
CAR_REPAIR
- id — INT — Primary key — NOT NULL
- repair_date — VARCHAR(100) — NOT NULL
- repair_info — VARCHAR(255)
- cost — VARCHAR(100) — NOT NULL
- car_id — INT — Foreign key → CAMPING_CAR.id — NOT NULL
- carbodyshop_id — INT — Foreign key → CARBODY_SHOP.id — NOT NULL
CUSTOMER
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- license — VARCHAR(100) — NOT NULL
- phone — VARCHAR(100) — NOT NULL