task_3_4
Tables (7)
BOOK (Untitled)
- Book_id — UUID — Primary key — NOT NULL
- Publisher_name — VARCHAR
- Title — VARCHAR
BOOK_AUTHOR (Untitled2)
- Author_name (Key) — Primary key — NOT NULL
- Book_id — UUID — Foreign key → BOOK.Book_id — NOT NULL
BOOK_COPIES (Untitled4)
- Book_id — UUID — Foreign key → BOOK.Book_id — NOT NULL
- No_of_copies — BIGINT — NOT NULL
- Branch_id — UUID — Foreign key → LIBRARY_BRANCH.Branch_id — NOT NULL
BOOK_LOANS (Untitled5)
- Book_id — UUID — Foreign key → BOOK.Book_id — NOT NULL
- Card_no — BIGINT — Foreign key → BORROWER.Card_no — NOT NULL
- Branch_id — UUID — Foreign key → LIBRARY_BRANCH.Branch_id — NOT NULL
- Date_out — TIMESTAMP
- Due_date — TIMESTAMP
BORROWER (Untitled7)
- Card_no — BIGINT — Primary key — NOT NULL
- Name — VARCHAR
- Address — VARCHAR
- Phone — UUID
LIBRARY_BRANCH (Untitled6)
- Branch_id — UUID — Primary key — NOT NULL
- Branch_name — VARCHAR
- Address — VARCHAR
PUBLISHER (Untitled3)
- Publisher_name — VARCHAR — Foreign key → BOOK.Book_id — NOT NULL
- Phone — UUID
- Address — VARCHAR — NOT NULL