03_27_daliyquiz
Tables (7)
Book (Untitled2)
- book_number (Key) — VARCHAR(20) — Primary key — NOT NULL
- reservation_status (Field) — BOOLEAN — NOT NULL
- ISBN (Key2) — VARCHAR(30) — Foreign key → Book Information.ISBN — NOT NULL
Book Classification (Untitled7)
- classification_symbol (Key) — VARCHAR(30) — Primary key — NOT NULL
- classification_name (Field) — VARCHAR(40) — NOT NULL
Book Information (Untitled5)
- ISBN (Key) — VARCHAR(30) — Primary key — NOT NULL
- classification_symbol (Key2) — VARCHAR(30) — Foreign key → Book Classification.classification_symbol — NOT NULL
- author (Field) — VARCHAR(50) — NOT NULL
- publisher (Field2) — VARCHAR(50) — NOT NULL
- publication_date (Field3) — BIGINT(20) — NOT NULL
- book_name (Field4) — VARCHAR(50) — NOT NULL
Loan (Untitled3)
- rental_number (Key3) — BIGINT(20) — Primary key — NOT NULL
- member_number (Key) — BIGINT(20) — Foreign key → Member.member_number — NOT NULL — 회원번호
- book_number (Key2) — VARCHAR(20) — Foreign key → Book.book_number — NOT NULL
- loan_date (Field) — DATETIME — NOT NULL
- return_date (Field2) — DATETIME — NOT NULL — 반납일자
- loan_status (Field3) — BOOLEAN
- extended_period (Field4) — BINGINT(10) — 연장
Member (Untitled)
- member_number (Key) — BIGINT(20) — Primary key — NOT NULL — 회원번호
- name (Field) — VARCHAR(50) — NOT NULL
- resident_number (Field2) — VARCHAR(20) — NOT NULL — 주민번호
- address (Field3) — VARCHAR(200)
- phone_number (Field4) — VARCHAR(20)
- email (Field5) — VARCHAR(100)
- membership_grade (Field6) — VARCHAR(10) — NOT NULL — 회원등급
Reservation (Untitled4)
- reservation_date (Key3) — DATETIME — Primary key — NOT NULL
- member_number (Key) — VARCHAR(20) — Foreign key → Member.member_number — NOT NULL — 회원번호
- book_number (Key2) — VARCHAR(20) — Foreign key → Book.book_number — NOT NULL
Supplement (Untitled6)
- supplement_code (Key2) — VARCHAR(20) — Primary key — NOT NULL
- book_number (Key) — VARCHAR(20) — Foreign key → Book.book_number — NOT NULL
- supplement_name (Field) — VARCHAR(100) — NOT NULL