book

Tables (3)

Customer (Untitled)

  • customer_id (int) — int — Primary key — NOT NULL
  • name (VARCHAR(30)) — int
  • email (VARCHAR(50))
  • phone (VARCHAR(20))
  • address (VARCHAR(10))

Member (Untitled2)

  • MemberId (int) — Primary key — NOT NULL
  • name (VARCHAR(10))
  • phone (VARCHAR(11))
  • address (VARCHAR(100))

Product (Loan)

  • product_id (int) — int — Primary key — NOT NULL
  • name (int2) — int — Foreign key → Customer.customer_id — NOT NULL
  • description (int3) — Foreign key → Member.MemberId — NOT NULL
  • MemberId (VARCHAR(30)) — VARCHAR(30)
  • bookID (VARCHAR(50))
  • loan_date (VARCHAR(20))
  • due_date (VARCHAR(10))
  • return_date (Field)