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)