LibraryManagement

Tables (4)

Book (도서)

  • Book_id (Key) — INT — Primary key — NOT NULL
  • Title (Field) — VARCHAR(30)
  • Author (Field2) — VARCHAR(20)
  • Genre (Field3) — VARCHAR(10)
  • Publisher (Field4) — VARCHAR(20)
  • IsLoan (Field5) — BOOLEAN
  • LoanNum (Field6) — INT

Loan (대출)

  • Loan_id (Key) — INT — Primary key — NOT NULL
  • Book_id (Field) — INT
  • User_id (Field2) — INT
  • StartDate (Field3) — DATETIME
  • ReturnDate (Field4) — DATETIME

Manager (관리자)

  • Manager_id (Key) — INT — Primary key — NOT NULL
  • Name (Field) — VARCHAR(20)
  • Phone (Field2) — VARCHAR(15)
  • ID (Field3) — VARCHAR(20)
  • Password (Field4) — VARCHAR(20)
  • Question (Field5) — VARCHAR(25)
  • Hint (Field6) — VARCHAR(15)

User (사용자)

  • User_id (Key) — INT — Primary key — NOT NULL
  • Name (Field) — VARCHAR(20)
  • Phone (Field2) — VARCHAR(15)
  • ID (Field3) — VARCHAR(20)
  • Password (Field4) — VARCHAR(20)
  • Question (Field5) — VARCHAR(25)
  • Hint (Field6) — VARCHAR(15)