r

Tables (7)

AUTHOR (Untitled7)

  • autorID (Key) — inr(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • altanativename (Field2) — char(10)
  • description (Field3) — text
  • majorworks (Field4) — text

BOOK (Untitled3)

  • ISBN (Key) — char(13) — Primary key — NOT NULL
  • workID (Key2) — int(30) — Foreign key → WORK.workID — NOT NULL
  • title (Field) — char(30)
  • orignaltitle (Field2) — char(30)
  • kdc_6th (Field3) — char(20)
  • pubyear (Field4) — int(4)
  • type (Field5) — char(10)
  • expression (Field6) — char(3)
  • workID (Field7) — int(30)

MOVIE (Untitled)

  • title (Key) — char(50) — Primary key — NOT NULL
  • workID (Key2) — int(30) — Foreign key → WORK.workID — NOT NULL
  • originaltitle (Field) — char(50)
  • releasedyear (Field2) — int(4)
  • expression (Field3) — char(3)
  • description (Field4) — text
  • runtime (Field5) — int(3)
  • workID (Field6) — int(30)

MOVIE_PERSON (Untitled5)

  • roll (Key) — char(10) — Primary key — NOT NULL
  • title (Key2) — char(50) — Foreign key → MOVIE.title — NOT NULL
  • personID (Key3) — int(10) — Foreign key → PERSON.personID — NOT NULL
  • workID (Key22) — int(30) — Foreign key → MOVIE.workID — NOT NULL
  • personID (Field) — int(10)
  • movieID (Field2) — int(10)

PERSON (Untitled6)

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

WORK (Untitled2)

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

WORK AUTHOR (Untitled4)

  • autorID (Key) — inr(10) — Foreign key → AUTHOR.autorID — NOT NULL
  • workID (Key2) — int(30) — Foreign key → WORK.workID — NOT NULL
  • workID (Field) — int(30)
  • authorID (Field2) — inr(10)
  • roll (Field3) — char(30)