DB_COURSE
Tables (4)
Car
- car_id (PK) — INT — Primary key — NOT NULL
- car_name (Field1) — VARCHAR(50) — NOT NULL
- car_number (Field2) — VARCHAR(15) — NOT NULL
- customer_id (PK2) — INT — Foreign key → Customer.customer_id — NOT NULL
Customer
- customer_id (PK) — INT — Primary key — NOT NULL
- name (Field1) — VARCHAR(50) — NOT NULL
- phone_number (Field2) — VARCHAR(15)
- email (Field3) — VARCHAR(50) — NOT NULL
- password (Field4) — VARCHAR(50) — NOT NULL
Reservation
- reservation_id (PK) — INT — Primary key — NOT NULL
- reservation_date (Field1) — DATE
- status (Field2) — VARCHAR(20)
- customer_id (PK2) — INT — Foreign key → Customer.customer_id — NOT NULL
- car_id (PK3) — INT — Foreign key → Car.car_id — NOT NULL
- service_id (PK4) — INT — Foreign key → Service.service_id — NOT NULL
Service
- service_id (PK) — INT — Primary key — NOT NULL
- service_type (Field1) — VARCHAR(50) — NOT NULL
- price (Field2) — INT
- duration (Field3) — INT