ERD_2023910139
Tables (6)
Copy Of Untitled (Studyroom)
- Key (roomNo) — int — Primary key — NOT NULL
- Field (place) — char(50)
- Field (maximum) — char(2)
- Field (minimum) — char(1)
- Key (ssn) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Loan_Return)
- Field (loanDate) — date
- Field (returnDate) — date
- Key (userID) — char(12) — Foreign key → User.Key — NOT NULL
- Key (bookID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Book)
- Key (bookID) — int — Primary key — NOT NULL
- Field (Title) — char(50)
- Field (stacks) — char(10)
- Field (publisher) — char(30)
- Field (pubyear) — year
- Field (price) — char(10)
- Key (ssn) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Reservation)
- Field (reservationDate) — date
- Field (reservationTime) — time
- Key (userID) — char(12) — Foreign key → User.Key — NOT NULL
- Key (roomNo) — int — Foreign key → Copy Of Untitled.Key — NOT NULL
Untitled (Library)
- Key (ssn) — int — Primary key — NOT NULL
- Field (name) — char(20)
- Field (Phone) — char(13)
- Field (adress) — char(50)
User
- Key (userID) — char(12) — Primary key — NOT NULL
- Field (Name) — char(30)
- Field (department) — char(20)
- Field (position) — char(10)
- Field (identity) — char(10)
- Field (phone) — char(12)
- Field (adress) — char(50)