hw2

Tables (7)

LINK (Untitled3)

  • moID (Key) — int(10 — Foreign key → movie.moID — NOT NULL
  • personID (Key2) — int(10) — Foreign key → person.personID — NOT NULL

LINK (Untitled7)

  • workID (Key) — int(30) — Foreign key → work.workID — NOT NULL
  • authorID (Key2) — int(10) — Foreign key → author.authorID — NOT NULL

author (Untitled6)

  • authorID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • alternativeName (Field2) — char(50)
  • description (Field3) — text
  • majorWork (Field4) — text

book (Untitled)

  • ISBN (Key) — char(13) — Primary key — NOT NULL
  • title (Field) — char(30)
  • originalTitle (Field2) — char(50)
  • pubyear (Field3) — int(4)
  • type (Field4) — char(10)
  • expression (Field5) — char(3)

movie (Untitled2)

  • moID (Key) — int(10 — Primary key — NOT NULL
  • title (Field) — char(50)
  • originalTitle (Field2) — char(50)
  • year (Field3) — int(4)
  • expression (Field4) — char(3)
  • description (Field5) — text
  • runTime (Field6) — int(3)
  • workID (Key2) — int(30) — Foreign key → work.workID — NOT NULL

person (Untitled5)

  • personID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text
  • nationality (Field3) — text
  • repRole (Field4) — char(10)
  • majorWorks (Field5) — text

work (Untitled4)

  • workID (Key) — int(30) — Primary key — NOT NULL
  • workTitlt (Field) — char(50)