webLib
Tables (3)
Book (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- author (Field) — string
- title (Field2) — string
- available (Field3) — boolean
- publisher (Field4) — string
- price (Field5) — int
- crate_date (Field6)
Loan (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- book_id (Key3) — int — Foreign key → Book.id — NOT NULL
- user_id (Key4) — int — Foreign key → User.id — NOT NULL
- loan_date (Field) — date
- return_date (Field2) — date
- is_returned (Field3) — date
- is_over (Field4) — boolean
- return_deadline (Field5) — +15d
User (Untitled)
- id (Key) — int — Primary key — NOT NULL
- name (Field4) — string
- memo (Field) — string
- admin_id (Field2) — string
- admin_password (Field3) — string