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