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