2023기말

테이블 (6)

Untitled (BOOK)

  • Key (ISBN) — char(20) — 기본 키 — NOT NULL
  • Field (Title) — char(30)
  • Field (Author) — char(8)
  • Field (genre) — char(30)
  • Field (PublishedYear) — int
  • Field (Publisher) — char(30)
  • Key (Branch_ID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Author)

  • Key (AuthorID) — int — 기본 키 — NOT NULL
  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (Author_Name) — char(30)
  • Field (Author_Birthdate) — date
  • Field (Author_nationality) — char(10)

Untitled (Member)

  • Key (Member_ID) — int — 기본 키 — NOT NULL
  • Key (Branch_ID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (Member_Name) — char(10)
  • Field (Member_Address) — char(30)
  • Field (Member_email) — char(30)
  • Field (Memer_PNB) — char(30)

Untitled (library branch)

  • Key (Branch_ID) — int — 기본 키 — NOT NULL
  • Field (Branch_Name) — char(20)
  • Field (Branch_Location) — char(30)
  • Field (Branch_Hours) — time

Untitled (Payment)

  • Key (CheckoutID) — int — 기본 키 — NOT NULL
  • Field (BookISBN) — char(20)
  • Field (MemberID) — int
  • Field (CheckoutDate) — date
  • Field (DueDate) — date
  • Field (ReturnDate) — date
  • Key (CheckoutID2) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (Branch_ID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (genre)

  • Key (GenreID) — int — 기본 키 — NOT NULL
  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (GenreName) — Char(30)
  • Field (Genre_Description) — text