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)