library

Tables (9)

Untitled (BOOK)

  • Key (ISBN) — int(13) — Primary key — NOT NULL
  • Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (pubdate) — date
  • Field (bookname) — char(40)
  • Field (price) — int(10)
  • Field (buyingdate) — date

Untitled (TOPIC NAME)

  • Key (Keyword) — char(40) — Primary key — NOT NULL
  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (kdc class number) — int(20)
  • Field (description) — tex

Untitled (PUBLISHER)

  • Key (pubID) — int(20) — Primary key — NOT NULL
  • Field (pubname) — char(30)
  • Field (pubaddress) — char(50)

Untitled (AUTHOR)

  • Key (authorcode) — int(20) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)

Untitled (BOOK-AUTHOR)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (authorcode) — int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (USER)

  • Key (userID) — int(100) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(40)
  • Field (phone) — int(14)
  • Field (email) — char(30)

Untitled (RENT)

  • Key (rentID) — int(100) — Primary key — NOT NULL
  • Field (rentdate) — date
  • Field (returndate) — date
  • Field
  • Key (userID) — int(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (REALATD-PERSON)

  • Key (personID) — char(20) — Primary key — NOT NULL
  • Field (realated) — text
  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (REALATE-EVENT)

  • Key (eventcode) — char(100) — Primary key — NOT NULL
  • Field (eventdate)
  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL