libary

Tables (5)

BOOK (책)

  • BOOK_ID (Key) — varchar2 — Primary key — NOT NULL
  • BOOK_NAME (Field) — varchar2
  • BOOK_PUB (Field2) — varchar2

MEMBER (회원)

  • MEM_ID (Key) — varchar2 — Primary key — NOT NULL
  • MEM_NAME (Field) — varchar2
  • MEM_ADDR (Field2) — varchar2
  • MEM_NUM (Field3) — varchar2

RENTAL (대여)

  • LOAN_ID (Key) — varchar2 — Primary key — NOT NULL
  • LOAN_DATE (Field2) — date
  • MEM_ID (Key3) — varchar2 — Foreign key → MEMBER.MEM_ID — NOT NULL
  • BOOK_ID (Key4) — varchar2 — Foreign key → BOOK.BOOK_ID — NOT NULL

RETURN (반납)

  • RETURN_ID (Key) — varchar2 — Primary key — NOT NULL
  • RETURN_DATE (Field2) — date
  • MEM_ID (Key3) — varchar2 — Foreign key → MEMBER.MEM_ID — NOT NULL
  • BOOK_ID (Key4) — varchar2 — Foreign key → BOOK.BOOK_ID — NOT NULL

USER (회원가입)

  • Key — Primary key — NOT NULL