ERD6(R)

Tables (10)

Untitled (WORK_SUBJECT)

  • Key (workID) — int(20) — Foreign key → work.Key — NOT NULL
  • Key — int(25) — Foreign key → Untitled.Key — NOT NULL

Untitled (SUBJECT)

  • Key — int(25) — Primary key — NOT NULL
  • Field (subjectfeading) — char(3)
  • Field (description) — text

Untitled (WORK_AUTHOR)

  • Key (workID) — int(20) — Foreign key → work.Key — NOT NULL
  • Key (audID) — int(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (role) — char(20)

Untitled (AUTHOR)

  • Key (audID) — int(30) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field2 (sName) — char(30)
  • Field (description) — text
  • Field (email) — char(30)
  • Field (web) — text

Untitled (BOOK_PRESON)

  • Key (workID) — int(20) — Foreign key → work.Key — NOT NULL
  • Key (personID) — int(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (BOOK)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (pubcuts) — date
  • Field (type) — char(10)
  • Field (experemlon) — char(3)
  • Field (price) — intiger
  • Field
  • Key (workID) — int(20) — Foreign key → work.Key — NOT NULL
  • Key (pudID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (BUBLISHER)

  • Key (pudID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (adress) — char(50)
  • Field (phone) — char(20)
  • Field (tax) — char(20)
  • Field (emali) — char(20)

Untitled (ITEM)

  • Key (ITEMID) — char(30) — Primary key — NOT NULL
  • Field (tellhone) — char(30)
  • Field (pudautDate) — date
  • Key (ISBN) — char(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (PERSON)

  • Key (personID) — int(30) — Primary key — NOT NULL
  • Field (pername) — char(30)
  • Field (description) — text

work (WORK)

  • Key (workID) — int(20) — Primary key — NOT NULL
  • Field (wokTitle) — char(50)