DailyQuiz0327
Tables (7)
bonusBook (Untitled6)
- code (Key) — NOT NULL — Primary key — NOT NULL
- book_id (Key2) — NOT NULL — Foreign key → book.id — NOT NULL — book number
- bonusBookName (Field) — NOT NULL
book (Untitled3)
- id (Key) — NOT NULL — Primary key — NOT NULL — book number
- bookInfo_ISBN (Key2) — NOT NULL — Foreign key → bookInfo.ISBN — NOT NULL
- isBooking (Field) — NOT NULL
bookInfo (Untitled4)
- ISBN (Key) — NOT NULL — Primary key — NOT NULL
- category_type (Key2) — NOT NULL — Foreign key → category.type — NOT NULL
- writer (Field) — NOT NULL
- publisher (Field2) — NOT NULL
- releaseDate (Field3) — NOT NULL
- bookName (Field4) — NOT NULL
booking (Untitled7)
- bookingDate (Field) — NOT NULL
- member_id (Key) — NOT NULL — Foreign key → member.id — NOT NULL
- book_id (Key2) — NOT NULL — Foreign key → book.id — NOT NULL — book number
category (Untitled5)
- type (Key) — NOT NULL — Primary key — NOT NULL
- typeName (Field2) — NOT NULL
member (Untitled)
- id (Key) — NOT NULL — Primary key — NOT NULL
- name (Field) — NOT NULL
- ssn (Field2) — NOT NULL — 주민번호 생년월일 8자리 ex)20110101
- grade (Field3) — NOT NULL
- address (Field4) — NOT NULL
- phoneNum (Field5) — NOT NULL
- email (Field6) — NOT NULL
rent (Untitled2)
- id (Key) — NOT NULL — Primary key — NOT NULL
- book_id (Key3) — NOT NULL — Foreign key → book.id — NOT NULL — book number
- member_id (Key2) — NOT NULL — Foreign key → member.id — NOT NULL
- rentDate (Field2) — NOT NULL
- returnDate (Field3) — NOT NULL
- rentBonusBook (Field4) — NOT NULL
- extend (Field5) — NOT NULL