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