도서관

테이블 (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)