기말고사
테이블 (3)
BOOK_LOAN_RETURN (Untitled4)
- BookTitle (Field2) — char(50)
- BookLoanDate (Field) — date
- BookReturnDate (Field3) — date
- BookStartID (Key3) — int(20) — 외래 키 → BOOK_START.BookStartID — NOT NULL
- UserID (Key32) — int(10) — 외래 키 → READING_1000BOOKS.UserID — NOT NULL
- TotalNumberOfLoan (Field4)
BOOK_START (Untitled3)
- BookStartID (Key) — int(20) — 기본 키 — NOT NULL
- UserName (Field) — char(30)
- Description (Field3) — text
- ParentName (Field4) — char(30)
- BirthDate (Field5) — date
- Address (Field2) — char(30)
- BookStartLevel (Field6) — int(5)
- PhoneNumber (Field7) — int(10)
READING_1000BOOKS (Untitled2)
- UserID (Key3) — int(20) — 기본 키 — NOT NULL
- UserName (Field) — char(30)
- UserGender (Field2) — char(2))
- UserBirthDate (Field3) — date
- UserAddress (Field4) — char(30)
- UserPhoneNumber (Field5) — int(10)
- Description (Field6) — text
- UserParentName (Field7) — char(30)
- UserParentID (Field8) — int(10)
- 1000BooksLevel (Field9) — int(5)