frber

Tables (6)

Untitled (author)

  • Key (authorid) — char — Primary key — NOT NULL
  • Field (name) — char
  • Field (altername) — char
  • Field (descrption) — text
  • Field (majorwork) — char(100)

Untitled (publisher)

  • Key (id2) — char — Primary key — NOT NULL
  • Field (pubname) — char

Untitled (work)

  • Key (workid) — char(11) — Primary key — NOT NULL
  • Field (wtitle) — char(50)
  • Field (descrption) — text

Untitled (mani)

  • Key (isbn) — char(13) — Primary key — NOT NULL
  • Key (workid) — char(11) — Foreign key → Untitled.Key — NOT NULL
  • Field (booktitle) — char(50)
  • Field (author) — char(50)
  • Field (pubYear) — int(4)
  • Field (size) — int(2)
  • Field (page) — int(4)
  • Field (price) — int(8)
  • Field (language) — char(3)
  • Key (id2) — char — Foreign key → Untitled.Key — NOT NULL

Untitled (item)

  • Key (itemID) — char — Primary key — NOT NULL
  • Key (isbn) — char(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (workid) — char(11) — Foreign key → Untitled.Key — NOT NULL
  • Field (budate) — int
  • Field (price) — int

Untitled

  • Key (workid) — char(11) — Foreign key → Untitled.Key — NOT NULL
  • Key (authorkd) — char — Foreign key → Untitled.Key — NOT NULL