s
Tables (4)
BookCopy (Untitled3)
- id (Key) — Primary key — NOT NULL
- id (primary) — Foreign key → USER.id — NOT NULL
- book_id (Field)
- Long (Field2)
- LocalData (Field3)
LOAN (Untitled4)
- id (primanry) — Primary key — NOT NULL
- id (primary) — Foreign key → USER.id — NOT NULL
- loan_date (Field)
- Field2
- retrun_data (Field3)
- book_copy_id (Field5)
- user_id (Field4)
- DueDate (Field6)
USER (Untitled)
- id (primary) — Primary key — NOT NULL
- name (Field2)
- password (Field3)
- phone (Field4)
- role (Field5)
book (Untitled2)
- id (priamary) — Primary key — NOT NULL
- id (primary) — Foreign key → USER.id — NOT NULL
- title (Field)
- author (Field2)
- publisher (Field3)
- Integer (Field4)