Library
Tables (5)
apply_loan (대출 신청 목록)
- (user_id) — varchar2(10) — Foreign key → members.ID — NOT NULL
- (book_code) — varchar2(5) — Foreign key → books.code — NOT NULL
books (책 목록)
- (code) — varchar2(5) — Primary key — NOT NULL
- (title) — varchar2(50)
- (write) — varchar2(30)
- (cn) — varchar2(20)
- (pub) — varchar2(20)
- (is_borrowed) — number(1)
loan_records (대출 기록 목록)
- (user_id) — varchar2(10) — Primary key — NOT NULL
- (book_code) — varchar2(5) — Primary key — NOT NULL
- (borrowed_at) — date — Primary key — NOT NULL
- user_id (회원 ID) — varchar2(10) — Foreign key → members.ID — NOT NULL
- book_code (책 Code) — varchar2(5) — Foreign key → books.code — NOT NULL
- returned_at (반납 날짜) — date
members (회원)
- (ID) — varchar2(10) — Primary key — NOT NULL
- (pw) — varchar2(20)
- (name) — varchar2(20)
- (bir) — date — 'yyyy-mm-dd'
- (phone) — varchar2(20)
- (email) — varchar2(20)
- (is_overdue) — number(1)
overdue_records (연체자 목록)
- (ID) — varchar2(10) — Primary key — NOT NULL
- (id) — varchar2(10) — Foreign key → members.ID — NOT NULL — on delete cascade
- cnt (연체 횟수) — number