HH_Second

Tables (3)

Checkout (Untitled3)

  • checkout_id (대출아이디) — NN — Primary key — NOT NULL
  • member_id (멤버아이디) — NN — Foreign key → Member.member_id — NOT NULL
  • document_id (도서아이디) — NN — Foreign key → Document.document_id — NOT NULL
  • Status (대출상태) — NN
  • checkout_date (대출일) — NN
  • return_date (반납일) — NN

Document (Untitled2)

  • document_id (도서아이디) — NN — Primary key — NOT NULL
  • title (제목) — NN
  • author (저자) — NN
  • language (언어) — NN
  • publisher (출판사) — NN
  • add_date (등록일) — NN

Member (Untitled)

  • member_id (멤버아이디) — NN — Primary key — NOT NULL
  • name (이름) — NN
  • sex (성별) — NN
  • personal_number (주민번호) — Unique
  • phone_number (전화번호) — Unique
  • address (주소) — NN