예제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