movie:
    id       integer
    name     varchar
    director integer foreign key director.id

director:
    id     integer
    person integer foreign key person.id
    salary float

roles:
    movie  integer foreign key movie.id
    person integer foreign key person.id
    type   enum ('lead', 'supporting', 'bit')

person:
    id   integer
    name varchar