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)