ERD.test

Tables (3)

CarRental (BookingHotel)

  • Key (BookingNo) — number(8,2) — Primary key — NOT NULL
  • Key (CustomerName) — varchar2(30) — Primary key — NOT NULL
  • Key (C_bday) — date — Primary key — NOT NULL
  • Key (BookingDate) — date — Primary key — NOT NULL
  • Field4 (RoomNO) — varchar2(15) — Primary key
  • Field (C_addr) — varchar2(100)
  • Field2 (C_mobile) — number(15)
  • Field3 (C_email) — varchar2(30)
  • Field

Untitled (RegCustomer)

  • Key (BookingNo) — number(8,2) — Foreign key → CarRental.Key — NOT NULL
  • Key (CustomerName) — varchar2(30) — Foreign key → CarRental.Key — NOT NULL
  • Key (C_bday) — date — Foreign key → CarRental.Key — NOT NULL
  • Key (BookingDate) — date — Foreign key → CarRental.Key — NOT NULL
  • Field4 (RoomNO) — varchar2(15) — Foreign key → CarRental.Field4

Untitled2 (N_RegCustomer)

  • Key (BookingNo) — number(8,2) — Foreign key → CarRental.Key — NOT NULL
  • Key (CustomerName) — varchar2(30) — Foreign key → CarRental.Key — NOT NULL
  • Key (C_bday) — date — Foreign key → CarRental.Key — NOT NULL
  • Key (BookingDate) — date — Foreign key → CarRental.Key — NOT NULL
  • Field4 (RoomNO) — varchar2(15) — Foreign key → CarRental.Field4