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)