0429_KDTstudy
Tables (8)
Author (저자)
- author_id (PK) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
Author-book (책-저자)
- id (Key) — Primary key — NOT NULL
- author_id (PK) — INT — Foreign key → Author.author_id — NOT NULL
- book_id (PK2) — INT — Foreign key → Book.book_id — NOT NULL
Book (도서)
- book_id (PK) — INT — Primary key — NOT NULL
- Publisher_id (Key2) — INT — Foreign key → Publisher.Publisher_id — NOT NULL
- title (Field) — VARCHAR
- count (Field3) — INT
Borrow_list (대여목록)
- idx (PK) — INT — Primary key — NOT NULL
- member_id (FK1) — INT — Foreign key → Member.member_id — NOT NULL
- book_id (FK2) — INT — Foreign key → Book.book_id — NOT NULL
- Publisher_id (Key2) — INT — Foreign key → Book.Publisher_id — NOT NULL
- d_day (Field2) — INT
- borrow_date (Field3) — DATE
- fee (Field) — INT
- Field4
Category (장르)
- category_id (PK) — INT — Primary key — NOT NULL
- category (Field) — VARCHAR
Category-Book (책-장르)
- id (Key) — INT — Primary key — NOT NULL
- book_id (PK) — INT — Foreign key → Book.book_id — NOT NULL
- category_id (PK2) — INT — Foreign key → Category.category_id — NOT NULL
Member (회원)
- member_id (PK) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
- tel (Field2) — VARCHAR
- sex (Field3) — VARCHAR
- age (Field4) — INT
Publisher (출판사)
- Publisher_id (Key) — INT — Primary key — NOT NULL
- publisher (Field) — VARCHAR