test

테이블 (3)

대출 (LOAN)

  • id (member_id) — BIGINT — 외래 키 → 멤버.id — NOT NULL
  • Key (book_id) — BIGINT — 외래 키 → 책.Key — NOT NULL
  • Field2 (status) — VARCHAR — NOT NULL
  • Field2 (loan_date) — VARCHAR — NOT NULL
  • Field (return_date) — NOT NULL

멤버 (MEMBER)

  • id (member_id) — BIGINT — 기본 키 — NOT NULL
  • 이름 (name) — VARCHAR — NOT NULL
  • Field (id) — VARCHAR — NOT NULL
  • Field2 (password) — VARCHAR — NOT NULL
  • Field2 (phone) — VARCHAR — NOT NULL
  • Field (jumin_no) — VARCHAR — NOT NULL
  • Field (address) — VARCHAR — NOT NULL

책 (BOOK)

  • Key (book_id) — BIGINT — 기본 키 — NOT NULL
  • Field (ISBN) — VARCHAR(13) — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field4 (author) — VARCHAR(20) — NOT NULL
  • Field (publisher) — VARCHAR(20) — NOT NULL
  • Field2 (pub_date) — VARCHAR(20)