Library System
Tables (4)
Book (Untitled2)
- Book_ID (PK) — PK — Primary key — NOT NULL
- Member_ID (PK2) — PK — Foreign key → Member.Member_ID — NOT NULL
- Rent_ID (PK3) — PK — Foreign key → Rent.Rent_ID — NOT NULL
- Member_ID (varchar) — varchar — Foreign key → Rent.Member_ID — NOT NULL
- Member_ID (PK22) — PK — Foreign key → Rent.Member_ID — NOT NULL
- Book_Name (Field1) — varchar
- Book_Author (Field2) — varchar
- Book_PublishedDate (Field3) — timestamp
- Book_Genre (Field4) — varchar
- Book_PageCount (Field5) — int
- Book_ISBN (Field6) — varchar
BookRent (Untitled4)
- BookRent_ID (PK) — PK — Primary key — NOT NULL
- Book_ID (PK2) — PK — Foreign key → Book.Book_ID — NOT NULL
- Rent_ID (PK3) — PK — Foreign key → Book.Rent_ID — NOT NULL
- Member_ID (PK22) — PK — Foreign key → Book.Member_ID — NOT NULL
- Rented_Date (Field) — DateTime
- Returned_Date (Field3) — DateTime
Member (Untitled)
- Member_ID (PK) — PK — Primary key — NOT NULL
- Member_Name (Field1) — varchar
- Member_Phone (Field4) — varchar
- Member_Email (Field6) — varchar
- Member_Address (Field5) — varchar
- Member_JoinedDate (Field2) — DateTime
- Member_RentID (Field3) — varchar
Rent (Untitled3)
- Rent_ID (PK) — PK — Primary key — NOT NULL
- Member_ID (varchar) — varchar — Primary key — NOT NULL
- Member_ID (PK2) — PK — Foreign key → Member.Member_ID — NOT NULL