Library
Tables (5)
book (책)
- 책 식별키 (book_id) — varchar(10000) — Primary key — NOT NULL — book_pk
- 제목 (book_title) — varchar(50) — NOT NULL
- 저자 (book_author) — varchar(30) — NOT NULL
- 출판사 (book_publisher) — varchar(20) — NOT NULL
- 분야 (book_genre) — varchar(20) — NOT NULL
borrow (대출)
- 대출 식별키 (borrow_id) — int — Primary key — NOT NULL — borrow_pk
- 고객 식별키 (customer_id) — int — Foreign key → customer.고객 식별키 — NOT NULL — customer_pk
- 책 식별키 (book_id) — varchar(10000) — Foreign key → book.책 식별키 — NOT NULL — book_pk
- 대출 날짜 (reservation_date) — int — NOT NULL
- 반납 날짜 (return_date) — int — NOT NULL
customer (고객)
- 고객 식별키 (customer_id) — int — Primary key — NOT NULL — customer_pk
- 고객 이름 (customer_name) — varchar(30) — NOT NULL
- 고객 성별 (customer_sex) — varchar(10) — NOT NULL
- 고객 나이 (customer_age) — int — NOT NULL
- 고객 주소 (customer_address) — varchar(200) — NOT NULL
- 고객 전화번호 (customer_pNum) — int — NOT NULL
library (서고)
- 서고 식별키 (library_id) — int — Primary key — NOT NULL — library_pk
- Field
reservation (예약)
- 예약 식별키 (reservation_id) — int — Primary key — NOT NULL — reservation_pk
- 고객 식별키 (customer_id) — int — Foreign key → customer.고객 식별키 — NOT NULL — customer_pk
- 책 식별키 (book_id) — varchar(10000) — Foreign key → book.책 식별키 — NOT NULL — book_pk