LV2.Spring

Tables (4)

Book

  • BOOK_ID (book_Id) — bigint — Primary key — NOT NULL
  • TITLE (title) — varchar(100)
  • AUTHOR (author) — varchar(100)
  • LANGUAGE (language) — varchar(100)
  • PUBLISHER (publisher) — varchar(100)
  • CREATED_AT (created_At) — TimeStamp

Loan (CheckOut)

  • LOAN_ID (loan_Id) — bigint — Primary key — NOT NULL
  • BOOK_ID (book_Id) — bigint — Foreign key → Book.BOOK_ID — NOT NULL
  • USER_ID (user_Id) — bigint — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • RETURN_STATUS (return_Status) — varchar(100)
  • LOAN_DATE (loan_Date) — timestamp
  • RETURN_DATE (return_Date) — timestamp

MEMBER (User)

  • MEMBER_ID (user_Id) — bigint — Primary key — NOT NULL
  • USERNAME (username) — varchar(100)
  • GENDER (gender) — varchar(100)
  • PHONE_NUMBER (phone_Number) — varchar(100)
  • ADDRESS (address) — varchar(100)
  • SOCIAL_NUMBER (social_Number) — varchar(100)

Untitled