도서관리시스템
테이블 (9)
Author (Untitled2)
- author_id (PK) — int — 기본 키 — NOT NULL
- author_name (Field) — String
- Field2
Author_Book (Untitled3)
- wite_book_id (Key) — int — 기본 키 — NOT NULL
- author_id (FK) — int — 외래 키 → Author.author_id — NOT NULL
- book_id (FK2) — int — 외래 키 → Book.book_id — NOT NULL
- publisher_id (Key3) — int — 외래 키 → Book.publisher_id — NOT NULL
- Field
Book
- book_id (PK) — int — 기본 키 — NOT NULL
- publisher_id (FK2) — int — 외래 키 → Publisher.publisher_id — NOT NULL
- book_title — varchar
- published_date (publication_date) — datetime
- book_genre (Field5) — String
- location (Field2)
- reservation_available (Field) — boolean
- Field3
Genre (Untitled5)
- genre_id (Key) — int — 기본 키 — NOT NULL
- Field
Genre_Book (Untitled)
- genre_book_id (Key) — int — 기본 키 — NOT NULL
- book_id (PK) — int — 외래 키 → Book.book_id — NOT NULL
- publisher_id (FK2) — int — 외래 키 → Book.publisher_id — NOT NULL
- genre_id (Key2) — int — 외래 키 → Genre.genre_id — NOT NULL
- Field
Member
- member_id (PK) — int — 기본 키 — NOT NULL
- member_name — varchar
- phone — String
- e-mail (adress) — String
- adress (grade) — String
- Field3
Publisher (Untitled4)
- publisher_id (Key) — int — 기본 키 — NOT NULL
- Field
Rent_book (Rental)
- rent_book_id (Key) — int — 기본 키 — NOT NULL
- rental_id (PK2) — int — 외래 키 → Rental_System.rental_id — NOT NULL
- book_id (PK) — int — 외래 키 → Book.book_id — NOT NULL
- publisher_id (FK2) — int — 외래 키 → Book.publisher_id — NOT NULL
- Field
Rental_System (RentalSystem)
- rental_id (PK) — int — 기본 키 — NOT NULL
- member_id (FK) — int — 외래 키 → Member.member_id — NOT NULL
- rental_date (retal_date) — datetime
- return_date — datetime
- extension — datetime
- Field4