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