E-book_library
Tables (3)
Untitled (User)
- Key (Login_id) — VARCHAR(20) — Primary key — NOT NULL
- Field (password) — VARCHAR(200)
- Field2 (name) — VARCHAR(20)
- Field (contact) — VARCHAR(20)
- Field (loan_limit) — INT
- Field (loan_over) — BOOLEAN
Untitled (Book)
- Field (id) — BINGINT
- Field2 (title) — VARCHAR
- Field3 (author) — VARCHAR
- Field4 (publisher) — VARCHAR
- Field5 (decription) — VARCHAR
Untitled (Loans)
- Field (id)
- Field2 (user_id) — VARCHAR(20)
- Field3 (book_id) — VARCHAR(20)
- Field (loan_date) — DATETIME
- Field2 (due_date) — DATETIME
- Field (return_date) — DATETIME
- Field