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)