예제1
테이블 (12)
Author (Untitled7)
- author_id (PK) — long — 기본 키 — NOT NULL
- author_name (Field) — long
Author_Book (Untitled8)
- ab_id (PK) — long — 기본 키 — NOT NULL
- book_id (FK) — long — 외래 키 → Book.book_id — NOT NULL
- author_id (FK2) — long — 외래 키 → Author.author_id — NOT NULL
- publisher_id (PK2) — long — 외래 키 → Book.publisher_id — NOT NULL
Book (Untitled2)
- book_id (PK) — long — 기본 키 — NOT NULL
- publisher_id (FK) — long — 외래 키 → Publisher.publisher_id — NOT NULL
- book_name (Field) — varchar
- book_amount (Field5) — long
- book_price (Field6) — long
- create_at (Field2) — date
Book_Lend (Untitled4)
- bl_id (PK) — long — 기본 키 — NOT NULL
- book_id (FK) — long — 외래 키 → Book.book_id — NOT NULL
- lend_id (FK2) — long — 외래 키 → Lend.lend_id — NOT NULL
- count (Field) — long
Book_Library (Untitled11)
- book_library_id (PK) — long — 기본 키 — NOT NULL
- book_id (FK) — long — 외래 키 → Book.book_id — NOT NULL
- library_id (FK2) — long — 외래 키 → Library.library_id — NOT NULL
- publisher_id (PK2) — long — 외래 키 → Book.publisher_id — NOT NULL
Category (Untitled12)
- category_id (PK) — long — 기본 키 — NOT NULL
- category_name (Field)
Category_Book (Untitled6)
- cb_id (PK) — long — 기본 키 — NOT NULL
- category_id (FK) — long — 외래 키 → Category.category_id — NOT NULL
- book_id (FK2) — long — 외래 키 → Book.book_id — NOT NULL
Lend (Untitled3)
- lend_id (PK) — long — 기본 키 — NOT NULL
- memeber_id (Fk) — long — 외래 키 → Member.memeber_id — NOT NULL
- lend_date (Field) — date
- due_date (Field2) — date
- return_date (Field3) — date
Library (Untitled9)
- library_id (PK) — long — 기본 키 — NOT NULL
- library_name (Field) — varchar
- library_address (Field2) — varchar
- library_tel (Field3) — varchar
- library_ closed (Field4) — varchar
Library_Lend (Untitled10)
- ll_id (Pk) — long — 기본 키 — NOT NULL
- library_id (FK) — long — 외래 키 → Library.library_id — NOT NULL
- lend_id (PK) — long — 외래 키 → Lend.lend_id — NOT NULL
Member (Untitled)
- memeber_id (PK) — long — 기본 키 — NOT NULL
- member_name (Field1) — varchar
- member_pwd (Field) — varchar
- member_jumin (Field2) — long
- member_phone (Field3) — varchar
- member_email (Field5) — varchar
- member_address (Field6) — varchar
- created_at (Field4) — date
Publisher (Untitled5)
- publisher_id (PK) — long — 기본 키 — NOT NULL
- publisher_name (Field) — varchar
- created_at (Field2) — date