과제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)