DailyQuiz 03/27
Tables (7)
appendix (Untitled7)
- appendix_code (Key) — BIGINT(10) — Primary key — NOT NULL — 부록코드
- book_id (Key2) — BIGINT(20) — Foreign key → book.book_id — NOT NULL — 도서번호
- appendix_name (Field2) — VARCHAR(50) — 부록명
book (Untitled4)
- book_id (Key) — BIGINT(20) — Primary key — NOT NULL — 도서번호
- ISBN (Key2) — VARCHAR(20) — Foreign key → book_information.ISBN — NOT NULL
- reservation (Field2) — BOOLEAN — NOT NULL — 예약 여부
book_category (Untitled6)
- category_symbol (Key) — VARCHAR(20) — Primary key — NOT NULL — 분류기호
- category_name (Field) — VARCHAR(20) — 분류명
book_information (Untitled5)
- ISBN (Key) — VARCHAR(20) — Primary key — NOT NULL
- category_symbol (Key2) — VARCHAR(20) — Foreign key → book_category.category_symbol — NOT NULL — 분류기호
- author (Field) — VARCHAR(20) — NOT NULL — 저자
- publisher (Field2) — VARCHAR(20) — NOT NULL — 출판사
- Issue_date (Field3) — DATETIME — NOT NULL — 발행
- book_name (Field4) — VARCHAR(30) — NOT NULL — 도서명
member (Untitled)
- memvber_id (Field1) — BIGINT(20) — Primary key — NOT NULL — 회원번호
- name (Field2) — VARCHAR(50) — NOT NULL — 회원명
- resident_number (Field3) — VARCHAR(20) — NOT NULL — 주민등록번호
- member_grade (Field4) — VARCHAR(10) — 등급
- address (Field5) — VARCHAR(100) — NOT NULL — 주소
- phone_number (Field6) — VARCHAR(20) — NOT NULL — 전화번호
- email (Field7) — VARCHAR(100)
rental (Untitled2)
- rental_num (Key) — BIGINT(20) — Primary key — NOT NULL
- book_id (Key2) — BIGINT(20) — Foreign key → book.book_id — NOT NULL — 도서번호
- memvber_id (Field1) — BIGINT(20) — Foreign key → member.memvber_id — NOT NULL — 회원번호
- borrow_date (Field2) — DATETIME — 대출일자
- return_date (Field3) — DATETIME — 반납일자
- appendix_borrow (Field4) — BOOLEAN — 부록대출여부
- extension (Field5) — BOOLEAN — 연장
reservation (Untitled3)
- reservation (Key) — DATETIME — Primary key — NOT NULL
- memvber_id (Field1) — BIGINT(20) — Foreign key → member.memvber_id — NOT NULL — 회원번호
- book_num (Key2) — BIGINT(20) — Foreign key → book.book_id — NOT NULL — 도서번호