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