База данных

Построить в ERWin ERD-диаграмму. Сущности и атрибуты даны ниже. Связи не должны пересекаться и перекрываться сущностями.

Структура сущностей:

actors:

- id_actor

- id_agent

- login

- password

- photo

- first_name

- last_name

- gender

- age

- location

- bio

- phone

- email

agents:

- id_agent

- login

- password

- photo

- first_name

- last_name

- bio

- phone

- email

casting_directors:

- id_director

- login

- password

- photo

- first_name

- last_name

- bio

- phone

- email

castings:

- id_casting

- id_type_project

- id_type_genre

- id_type_role

- id_director

- photo

- title

- description

- requirements

- script

- created_at

- deadline

- status 

casting_questions:

- id_question 

- id_casting

- id_actor

- id_director

- question

- answer

- send_at_question

- send_at_answer

- status 

casting_requests:

- id_request

- id_casting

- id_actor

- send_at

- video

- notes

- comment

- status 

educations:

- id_education

- id_actor

- title

- location

- start_year

- end_year

experiences:

- id_experience 

- id_type_project

- id_type_genre

- id_type_role

- id_actor

- title

- role

- year 

invitations:

- id_invitation 

- id_type_invite

- id_agent

- id_director

- id_actor

- id_casting

- title

- description

- send_at

- comment 

- status 

invitation_types:

- id_type_invite

- title 

genre_types:

- id_type_genre 

- title 

role_types:

- id_type_role 

- title 

project_types:

- id_type_project 

- title 

reviews:

- id_review

- id_type_review

- id_agent 

- id_director

- id_actor

- id_casting 

- send_at

- rating 

- comment 

review_types:

- id_type_review

- title 

skills:

- id_skill

- id_actor

- title 

my_genre_types:

- id_my_type_genre

- id_actor

- title 

my_project_types:

- id_my_type_project

- id_actor

- title 

my_role_types:

- id_my_type_role

- id_actor

- title