과제3

테이블 (8)

Untitled (Order)

  • Key (ID) — PrimaryKey — 기본 키 — NOT NULL
  • Key (MemberID) — ForeignKey — 외래 키 → Untitled.Key — NOT NULL
  • Key (ProcessID) — ForeignKey — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (Title)
  • Field (Author)
  • Field (ISBN)
  • Field (Publisher)

Untitled (Member)

  • Key (ID) — PrimaryKey — 기본 키 — NOT NULL
  • Field (name)
  • Field (Contact)
  • Field (Loanstatus)
  • Field (Position)

Untitled (ProcessingStatus)

  • Key (ID) — PrimaryKey — 기본 키 — NOT NULL
  • Field (Status)

Untitled (Loan)

  • Key (ID) — PrimaryKey — 기본 키 — NOT NULL
  • Key (MenberID) — ForeignKey — 외래 키 → Untitled2.Key — NOT NULL
  • Key (DeliveriedBookID) — ForeignKey — 외래 키 → Untitled.Key — NOT NULL
  • Field (LoanDate)
  • Field (ReturnDue)
  • Field (ActualReturn)

Untitled (BookInfo)

  • Key (ISBN) — PrimaryKey — 기본 키 — NOT NULL
  • Key (CategoryID) — ForeignKey — 외래 키 → Untitled.Key — NOT NULL
  • Key (AuthorID) — ForeignKey — 외래 키 → Untitled.Key — NOT NULL
  • Field (Title)
  • Field (Edition)
  • Field (Publisher)
  • Field (PublishYear)
  • Field (PageNum)
  • Field (DelieverDate)

Untitled (Author)

  • Key (ID) — PrimaryKey — 기본 키 — NOT NULL
  • Field (Name)
  • Field (Affiliation)
  • Field (Carrer)
  • Field (RegisterDate)

Untitled (Category)

  • Key (ID) — PrimaryKey — 기본 키 — NOT NULL
  • Field (Name)

Untitled2 (DeliveredBook)

  • Key (ID) — PrimaryKey — 기본 키 — NOT NULL
  • Key (ISBN2) — ForeignKey — 외래 키 → Untitled.Key — NOT NULL
  • Key (OrderID) — ForeignKey — 외래 키 → Untitled.Key — NOT NULL
  • Field (LoanStatus)