LIbrary
Tables (4)
BOOKs (Untitled)
- Book_ID (Key) — Primary key — NOT NULL
- titl (Field) — nvarchar(35)
- author (Field2) — nvarchar(35)
- ISBN (Field3) — nvarchar(20)
- publication dat (Field4) — DateTime
- genre. (Field5) — nvarchar(20)
Borrowing Rigester (Untitled3)
- Borrow_ID (Key) — int — Primary key — NOT NULL
- borrowing dat (Field) — DateTime
- User_ID (Key3) — int — Foreign key → USERs.User_ID — NOT NULL
- due _Date (Field2) — DateTime
- Returen Date (Field3) — DateTime
- fines (Field4) — int
- ID_CopyBook (Key2) — int — Foreign key → Copy Of Book.ID_CopyBook — NOT NULL
Copy Of Book (Untitled4)
- ID_CopyBook (Key2) — int — Primary key — NOT NULL
- Book_ID (Key) — int — Foreign key → BOOKs.Book_ID — NOT NULL
- AbilityToBorrow (Field) — Bit
USERs (Untitled2)
- User_ID (Key) — int — Primary key — NOT NULL
- User_Name (Field) — nvarchar(40)
- phone Number (Field2) — int
- library card (Field3) — int