123
테이블 (5)
대여 (LOAN)
- LoanID (PK) — INT
- LoanDate (Field) — DATE
- ReturnDAte (Field2) — DATE
- OverdueStatus (Field3) — BOOLEAN
- UserID (fk) — INT
- ISBN (FK2) — CHAR(13)
서적 (BOOK)
- ISBN (PK) — CHAR(13)
- TITLE (Field) — VARCHAR(100)
- PUBLISHYEAR (Field2) — YEAR
- PRICE (Field3) — DECIMAL(10,2)
- AuthorID (FK) — INT
- PublisherID (FK2) — INT
저자 (AUTHOR)
- Field (PK) — INT
- NAME (Field) — VARCHAR(50)
- BIRTHDATE (Field2) — DATE
- NATIONALITY (Field3) — VARCHAR(30)
출판사 (Publisher)
- PublisherID (PK) — INT
- NAME (Field) — VARCHAR(50)
- LOCATION (Field2) — VARCHAR(100)
- contact (Field3) — VARCHAR(15)
회원 (user)
- UESRID (PK) — INT — 기본 키
- NAME (Field) — VARCHAR(50)
- JOINDATE (Field2) — DATE
- ADDRESS (Field3) — VARCHAR(100)