lv2
Tables (3)
book (Untitled2)
- book_id (Key) — int — Primary key — NOT NULL
- title (Field) — String
- author (Field2) — String
- publisher (Field3) — String
- book_registerdAt (Field4) — Datetime
loan (Untitled3)
- loan_id (Key) — int — Primary key — NOT NULL
- user_id (Field) — int
- book_id (Field2) — int
- isLoan (Field3) — boolean
- loanAt (Field4) — Datetime
- returnedAt (Field5) — Datetime
user (Untitled)
- user_id (Key) — int — Primary key — NOT NULL
- username (Field) — String
- gender (Field2) — String
- registnumber (Field3) — String
- phonenumber (Field4) — String
- address (Field5) — String