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