도서관
테이블 (4)
BOOKING (Untitled)
- Key (member ID) — char(10) — 기본 키 — NOT NULL
- Key2 (book ID) — char(10) — 기본 키 — NOT NULL
- Field (booking date) — date(8)
- Key (member ID2) — char(10) — 외래 키 → member.Key — NOT NULL
- Key (book ID2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (rent ID) — char(10) — 기본 키 — NOT NULL
- Key2 (nemberID) — char(10) — 기본 키 — NOT NULL
- Field1 (The day of the rent) — date(8)
- Field2 (Due day of return) — date(8)
- Field3 (extension) — char(2)
- Key (member ID) — char(10) — 외래 키 → member.Key — NOT NULL
- Key (book ID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK)
- Key (book ID) — char(10) — 기본 키 — NOT NULL
- Field (auther) — char(20)
- Field2 (book name) — char(20)
- Field3 (publisher) — char(20)
- Fiel (The day of issue) — date(8)
- Field5 (ISBN) — char(13)
- Field6 (book code) — char(50)
- Field7 (booking) — char(5)
- Field8 (quantity) — char( 2)
member (MEMBER)
- Key (member ID) — char(10) — 기본 키 — NOT NULL
- Field (member name) — char(20)
- Field2 (member adress) — char(50)
- Field4 (member phone) — char(11)
- Field3 (member e-mail) — char(30)