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