도서 대출 관리 시스템
테이블 (9)
Book (Untitled2)
- Book_id (PK) — 기본 키 — NOT NULL
- book_name (Field)
- book_count (Field4)
- book_pubdate (Field5)
- publish_id (pk) — 외래 키 → publish.publish_id — NOT NULL
Member (Untitled)
- member_id (PK) — 기본 키 — NOT NULL
- member_name (varchar)
- member_phone (FIELD)
- member_address (Field)
- member_joinmembership_date (Field2)
- member_age (Field3)
author (Untitled4)
- author_id (Key) — 기본 키 — NOT NULL
- author_name (varchar)
book_author (Untitled6)
- Book_id (PK) — 외래 키 → Book.Book_id — NOT NULL
- author_id (Key) — 외래 키 → author.author_id — NOT NULL
book_category (Untitled8)
- category_id (pk) — 외래 키 → category.category_id — NOT NULL
- Book_id (PK) — 외래 키 → Book.Book_id — NOT NULL
category (Untitled7)
- category_id (pk) — 기본 키 — NOT NULL
- category_name (Field)
loan (Untitled3)
- loan_id (pk) — 기본 키 — NOT NULL
- member_id (PK) — 외래 키 → Member.member_id — NOT NULL
- loan_start_at (Field)
- loan_end_at (Field2)
- due_date (Field3)
loan_book (Untitled9)
- id (pk) — 기본 키 — NOT NULL
- loan_id (pk2) — 외래 키 → loan.loan_id — NOT NULL
- Book_id (PK) — 외래 키 → Book.Book_id — NOT NULL
- count (Field)
publish (Untitled5)
- publish_id (pk) — 기본 키 — NOT NULL
- publish_name (Field)