ERD MyWQL EX
Tables (12)
AUTHOR (Untitled7)
- authorID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(30)
- alternativeName (Field2) — char(30)
- description (Field3) — text
- email (Field4) — char(30)
- majorWorks (Field5) — text
BOOK (Untitled2)
- ISBN (Key) — char(13) — Primary key — NOT NULL
- title (Field) — char(50)
- pubDate (Field2) — date
- type (Field3) — char(10)
- kdc(6th) (Field4) — char(20)
- expression (Field5) — char(3)
- price (Field6) — integer
- workIDey (Key2) — int(20) — Foreign key → WORK.workIDey — NOT NULL
- pubID (Key3) — char(10) — Foreign key → PUBLISHER.pubID — NOT NULL
BOOK_PERSON (Untitled8)
- PersonID (Key) — int(20) — Foreign key → PERSON.PersonID — NOT NULL
- ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
EVENT (Untitled11)
- eventID (Key) — char(20) — Primary key — NOT NULL
- eventName (Field) — char(20)
- description (Field2) — text
ITEM (Untitled10)
- itemEM (Key) — char(30) — Primary key — NOT NULL
- callNum (Field) — char(30)
- purchasedDate (Field2) — ate
- ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
PERSON (Untitled12)
- PersonID (Key) — int(20) — Primary key — NOT NULL
- perName (Field) — char(30)
- description (Field2) — text
PUBLISHER (Untitled3)
- pubID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(30)
- address (Field2) — char(50)
- phone (Field3) — char(20)
- fax (Field4) — char(20)
- email (Field5) — char(30)
SUBJECT (Untitled6)
- subjectID (Key) — int(20) — Primary key — NOT NULL
- subjectHeading (Field) — char(30)
- description (Field2) — text
WORK (Untitled)
- workIDey (Key) — int(20) — Primary key — NOT NULL
WORK_AUTHOR (Untitled4)
- workIDey (Key) — int(20) — Foreign key → WORK.workIDey — NOT NULL
- authorID (Key2) — int(10) — Foreign key → AUTHOR.authorID — NOT NULL
- role (Field) — char(20)
WORK_EVENT (Untitled9)
- eventID (Key) — char(20) — Foreign key → EVENT.eventID — NOT NULL
- workIDey (Key2) — int(20) — Foreign key → WORK.workIDey — NOT NULL
WORK_SUBJECT (Untitled5)
- workIDey (Key) — int(20) — Foreign key → WORK.workIDey — NOT NULL
- subjectID (Key2) — int(20) — Foreign key → SUBJECT.subjectID — NOT NULL