lidrary

Tables (5)

Member (회원)

  • Key (Member_id) — 회원정보 — Primary key — NOT NULL
  • Field (name) — 이름
  • Field (Address) — 주소
  • Field (Phone_Number) — 전화번호
  • Field (Email) — 회원가입일

Untitled (책 대출)

  • Key (Loan_id) — 대출ID — Primary key — NOT NULL
  • Field (Loan_Date) — 대출일
  • Field (Return_Date) — 반납일
  • Key (Member_id) — 회원정보 — Foreign key → Member.Key — NOT NULL
  • book_id — 책 — Foreign key → book.book_id — NOT NULL
  • Key (Librarian_Id) — 사서_ID — Foreign key → Untitled.Key — NOT NULL

Untitled (사서)

  • Key (Librarian_Id) — 사서_ID — Primary key — NOT NULL
  • Field — Primary key
  • Field (Name) — 이름
  • Field (Contact) — 연락처

Untitled (카테고리)

  • Key (Category_id) — 카테고리_ID — Primary key — NOT NULL
  • Field (Category_Name) — 이름
  • book_id — 책 — Foreign key → book.book_id — NOT NULL

book

  • book_id — 책 — Primary key — NOT NULL
  • Field (Title) — 제목
  • Field (Author) — 저자
  • Field (Publisher) — 출판사
  • Field (Category) — 카테고리
  • Field (Quantity) — 재고 수량
  • Key (Category_id) — 카테고리_ID — NOT NULL