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)