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