artifacts/sipity-erd.dot
digraph models_diagram {
graph[overlap=false, splines=true]
"Sipity::Models::AccessRight" [shape=Mrecord, label="{Sipity::Models::AccessRight|id :integer\lentity_id :string\lentity_type :string\laccess_right_code :string\ltransition_date :date\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::AdditionalAttribute" [shape=Mrecord, label="{Sipity::Models::AdditionalAttribute|id :integer\lwork_id :string\lkey :string\lvalue :text\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Attachment" [shape=Mrecord, label="{Sipity::Models::Attachment|work_id :string\lpid :string\lpredicate_name :string\lfile_uid :string\lfile_name :string\lcreated_at :datetime\lupdated_at :datetime\lis_representative_file :boolean\l}"]
"Sipity::Models::Collaborator" [shape=Mrecord, label="{Sipity::Models::Collaborator|id :integer\lwork_id :string\lsequence :integer\lname :string\lrole :string\lcreated_at :datetime\lupdated_at :datetime\lnetid :string\lemail :string\lresponsible_for_review :boolean\l}"]
"Sipity::Models::EventLog" [shape=Mrecord, label="{Sipity::Models::EventLog|id :integer\luser_id :integer\lentity_id :string\lentity_type :string\levent_name :string\lcreated_at :datetime\lupdated_at :datetime\lrequested_by_id :integer\lrequested_by_type :string\l}"]
"Sipity::Models::Group" [shape=Mrecord, label="{Sipity::Models::Group|id :integer\lname :string\lcreated_at :datetime\lupdated_at :datetime\lapi_key :string\l}"]
"Sipity::Models::GroupMembership" [shape=Mrecord, label="{Sipity::Models::GroupMembership|id :integer\luser_id :integer\lgroup_id :integer\lmembership_role :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Notification::Email" [shape=Mrecord, label="{Sipity::Models::Notification::Email|id :integer\lmethod_name :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Notification::EmailRecipient" [shape=Mrecord, label="{Sipity::Models::Notification::EmailRecipient|id :integer\lemail_id :integer\lrole_id :integer\lrecipient_strategy :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Notification::NotifiableContext" [shape=Mrecord, label="{Sipity::Models::Notification::NotifiableContext|id :integer\lscope_for_notification_id :integer\lscope_for_notification_type :string\lreason_for_notification :string\lemail_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::Actor" [shape=Mrecord, label="{Sipity::Models::Processing::Actor|id :integer\lproxy_for_id :string\lproxy_for_type :string\lname_of_proxy :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::AdministrativeScheduledAction" [shape=Mrecord, label="{Sipity::Models::Processing::AdministrativeScheduledAction|id :integer\lscheduled_time :datetime\lreason :string\lentity_id :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::Comment" [shape=Mrecord, label="{Sipity::Models::Processing::Comment|id :integer\lentity_id :string\lactor_id :integer\lcomment :text\loriginating_strategy_action_id :integer\loriginating_strategy_state_id :integer\lcreated_at :datetime\lupdated_at :datetime\lstale :boolean\l}"]
"Sipity::Models::Processing::Entity" [shape=Mrecord, label="{Sipity::Models::Processing::Entity|id :integer\lproxy_for_id :string\lproxy_for_type :string\lstrategy_id :integer\lstrategy_state_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::EntityActionRegister" [shape=Mrecord, label="{Sipity::Models::Processing::EntityActionRegister|id :integer\lstrategy_action_id :integer\lentity_id :string\lcreated_at :datetime\lupdated_at :datetime\lrequested_by_actor_id :integer\lon_behalf_of_actor_id :integer\lsubject_id :string\lsubject_type :string\l}"]
"Sipity::Models::Processing::EntitySpecificResponsibility" [shape=Mrecord, label="{Sipity::Models::Processing::EntitySpecificResponsibility|id :integer\lstrategy_role_id :integer\lentity_id :string\lactor_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::Strategy" [shape=Mrecord, label="{Sipity::Models::Processing::Strategy|id :integer\lname :string\ldescription :text\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyAction" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyAction|id :integer\lstrategy_id :integer\lresulting_strategy_state_id :integer\lname :string\lcreated_at :datetime\lupdated_at :datetime\laction_type :string\lpresentation_sequence :integer\lallow_repeat_within_current_state :boolean\l}"]
"Sipity::Models::Processing::StrategyActionAnalogue" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyActionAnalogue|id :integer\lstrategy_action_id :integer\lanalogous_to_strategy_action_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyActionPrerequisite" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyActionPrerequisite|id :integer\lguarded_strategy_action_id :integer\lprerequisite_strategy_action_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyResponsibility" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyResponsibility|id :integer\lactor_id :integer\lstrategy_role_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyRole" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyRole|id :integer\lstrategy_id :integer\lrole_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyState" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyState|id :integer\lstrategy_id :integer\lname :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyStateAction" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyStateAction|id :integer\loriginating_strategy_state_id :integer\lstrategy_action_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyStateActionPermission" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyStateActionPermission|id :integer\lstrategy_role_id :integer\lstrategy_state_action_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Processing::StrategyUsage" [shape=Mrecord, label="{Sipity::Models::Processing::StrategyUsage|id :integer\lstrategy_id :integer\lusage_id :integer\lusage_type :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Role" [shape=Mrecord, label="{Sipity::Models::Role|id :integer\lname :string\ldescription :text\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::SubmissionWindow" [shape=Mrecord, label="{Sipity::Models::SubmissionWindow|id :integer\lwork_area_id :integer\lslug :string\lcreated_at :datetime\lupdated_at :datetime\lopen_for_starting_submissions_at :datetime\lclosed_for_starting_submissions_at :datetime\l}"]
"Sipity::Models::SubmissionWindowWorkType" [shape=Mrecord, label="{Sipity::Models::SubmissionWindowWorkType|id :integer\lsubmission_window_id :integer\lwork_type_id :integer\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::Work" [shape=Mrecord, label="{Sipity::Models::Work|id :string\ltitle :text\lcreated_at :datetime\lupdated_at :datetime\lwork_type :string\l}"]
"Sipity::Models::WorkArea" [shape=Mrecord, label="{Sipity::Models::WorkArea|id :integer\lslug :string\lpartial_suffix :string\ldemodulized_class_prefix_name :string\lcreated_at :datetime\lupdated_at :datetime\lname :string\l}"]
"Sipity::Models::WorkRedirectStrategy" [shape=Mrecord, label="{Sipity::Models::WorkRedirectStrategy|id :integer\lwork_id :string\lurl :string\lstart_date :date\lend_date :date\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::WorkSubmission" [shape=Mrecord, label="{Sipity::Models::WorkSubmission|id :integer\lwork_area_id :integer\lsubmission_window_id :integer\lwork_id :string\lcreated_at :datetime\lupdated_at :datetime\l}"]
"Sipity::Models::WorkType" [shape=Mrecord, label="{Sipity::Models::WorkType|id :integer\lname :string\ldescription :text\lcreated_at :datetime\lupdated_at :datetime\l}"]
"User" [shape=Mrecord, label="{User|id :integer\lemail :string\lremember_created_at :datetime\lsign_in_count :integer\lcurrent_sign_in_at :datetime\llast_sign_in_at :datetime\lcurrent_sign_in_ip :string\llast_sign_in_ip :string\lcreated_at :datetime\lupdated_at :datetime\lname :string\lrole :integer\lusername :string\lagreed_to_terms_of_service :boolean\l}"]
"Sipity::Models::Attachment" -> "Sipity::Models::AccessRight" [arrowtail=odot, arrowhead=dot, dir=both color="#276E2C"]
"Sipity::Models::Collaborator" -> "Sipity::Models::Processing::Actor" [label="processing_actor", arrowtail=odot, arrowhead=dot, dir=both color="#301154"]
"Sipity::Models::Group" -> "Sipity::Models::GroupMembership" [arrowtail=odot, arrowhead=crow, dir=both color="#2B98CC"]
"Sipity::Models::Group" -> "Sipity::Models::Processing::Actor" [label="processing_actor", arrowtail=odot, arrowhead=dot, dir=both color="#D14C87"]
"Sipity::Models::Group" -> "Sipity::Models::EventLog" [label="event_logs", arrowtail=odot, arrowhead=crow, dir=both color="#281BFB"]
"Sipity::Models::Notification::Email" -> "Sipity::Models::Notification::NotifiableContext" [label="notifiable_contexts", arrowtail=odot, arrowhead=crow, dir=both color="#51D7A6"]
"Sipity::Models::Notification::Email" -> "Sipity::Models::Notification::EmailRecipient" [label="recipients", arrowtail=odot, arrowhead=crow, dir=both color="#B1E0B6"]
"Sipity::Models::Processing::Actor" -> "Sipity::Models::Processing::StrategyResponsibility" [arrowtail=odot, arrowhead=crow, dir=both color="#37406A"]
"Sipity::Models::Processing::Actor" -> "Sipity::Models::Processing::EntitySpecificResponsibility" [arrowtail=odot, arrowhead=crow, dir=both color="#349F60"]
"Sipity::Models::Processing::Actor" -> "Sipity::Models::Processing::Comment" [label="processing_comments", arrowtail=odot, arrowhead=crow, dir=both color="#917691"]
"Sipity::Models::Processing::Actor" -> "Sipity::Models::Processing::EntityActionRegister" [label="actions_that_were_requested_by_me", arrowtail=odot, arrowhead=crow, dir=both color="#4885C3"]
"Sipity::Models::Processing::Actor" -> "Sipity::Models::Processing::EntityActionRegister" [label="actions_that_an_actor_took_on_my_behalf", arrowtail=odot, arrowhead=crow, dir=both color="#03391C"]
"Sipity::Models::Processing::Entity" -> "Sipity::Models::Processing::EntityActionRegister" [arrowtail=odot, arrowhead=crow, dir=both color="#E39009"]
"Sipity::Models::Processing::Entity" -> "Sipity::Models::Processing::EntitySpecificResponsibility" [arrowtail=odot, arrowhead=crow, dir=both color="#3B5CA9"]
"Sipity::Models::Processing::Entity" -> "Sipity::Models::Processing::Comment" [label="processing_comments", arrowtail=odot, arrowhead=crow, dir=both color="#52D2F7"]
"Sipity::Models::Processing::Entity" -> "Sipity::Models::Processing::AdministrativeScheduledAction" [label="administrative_scheduled_actions", arrowtail=odot, arrowhead=crow, dir=both color="#089A24"]
"Sipity::Models::Processing::Strategy" -> "Sipity::Models::Processing::Entity" [arrowtail=odot, arrowhead=crow, dir=both color="#64F8AF"]
"Sipity::Models::Processing::Strategy" -> "Sipity::Models::Processing::StrategyState" [arrowtail=odot, arrowhead=crow, dir=both color="#41CC3C"]
"Sipity::Models::Processing::Strategy" -> "Sipity::Models::Processing::StrategyAction" [arrowtail=odot, arrowhead=crow, dir=both color="#35AE08"]
"Sipity::Models::Processing::Strategy" -> "Sipity::Models::Processing::StrategyRole" [arrowtail=odot, arrowhead=crow, dir=both color="#0F288A"]
"Sipity::Models::Processing::Strategy" -> "Sipity::Models::Processing::StrategyUsage" [arrowtail=odot, arrowhead=crow, dir=both color="#EDC345"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Processing::EntityActionRegister" [arrowtail=odot, arrowhead=crow, dir=both color="#1130E3"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Processing::StrategyStateAction" [arrowtail=odot, arrowhead=crow, dir=both color="#9C3BD6"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Notification::NotifiableContext" [label="notifiable_contexts", arrowtail=odot, arrowhead=crow, dir=both color="#99D166"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Processing::StrategyActionPrerequisite" [label="guarding_strategy_action_prerequisites", arrowtail=odot, arrowhead=crow, dir=both color="#9F85CF"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Processing::StrategyActionPrerequisite" [label="requiring_strategy_action_prerequisites", arrowtail=odot, arrowhead=crow, dir=both color="#5F2F94"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Processing::Comment" [label="processing_comments", arrowtail=odot, arrowhead=crow, dir=both color="#7B2684"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Processing::StrategyActionAnalogue" [label="base_element_for_strategy_actions_analogues", arrowtail=odot, arrowhead=crow, dir=both color="#C1B18A"]
"Sipity::Models::Processing::StrategyAction" -> "Sipity::Models::Processing::StrategyActionAnalogue" [label="analog_element_for_strategy_actions_analogues", arrowtail=odot, arrowhead=crow, dir=both color="#61DD48"]
"Sipity::Models::Processing::StrategyRole" -> "Sipity::Models::Processing::StrategyResponsibility" [arrowtail=odot, arrowhead=crow, dir=both color="#75F2B7"]
"Sipity::Models::Processing::StrategyRole" -> "Sipity::Models::Processing::StrategyStateActionPermission" [arrowtail=odot, arrowhead=crow, dir=both color="#9DF8BA"]
"Sipity::Models::Processing::StrategyRole" -> "Sipity::Models::Processing::EntitySpecificResponsibility" [arrowtail=odot, arrowhead=crow, dir=both color="#21955B"]
"Sipity::Models::Processing::StrategyState" -> "Sipity::Models::Processing::StrategyStateAction" [label="originating_strategy_state_actions", arrowtail=odot, arrowhead=crow, dir=both color="#17F46F"]
"Sipity::Models::Processing::StrategyState" -> "Sipity::Models::Processing::StrategyAction" [label="resulting_strategy_actions", arrowtail=odot, arrowhead=crow, dir=both color="#060BF6"]
"Sipity::Models::Processing::StrategyState" -> "Sipity::Models::Processing::Comment" [label="processing_comments", arrowtail=odot, arrowhead=crow, dir=both color="#453948"]
"Sipity::Models::Processing::StrategyState" -> "Sipity::Models::Processing::Entity" [arrowtail=odot, arrowhead=crow, dir=both color="#124E71"]
"Sipity::Models::Processing::StrategyState" -> "Sipity::Models::Notification::NotifiableContext" [label="notifiable_contexts", arrowtail=odot, arrowhead=crow, dir=both color="#490A4F"]
"Sipity::Models::Processing::StrategyStateAction" -> "Sipity::Models::Processing::StrategyStateActionPermission" [arrowtail=odot, arrowhead=crow, dir=both color="#9B3B52"]
"Sipity::Models::Role" -> "Sipity::Models::Processing::StrategyRole" [label="processing_strategy_roles", arrowtail=odot, arrowhead=crow, dir=both color="#B1FE5F"]
"Sipity::Models::Role" -> "Sipity::Models::Notification::EmailRecipient" [label="email_recipients", arrowtail=odot, arrowhead=crow, dir=both color="#D8DB93"]
"Sipity::Models::SubmissionWindow" -> "Sipity::Models::SubmissionWindowWorkType" [arrowtail=odot, arrowhead=crow, dir=both color="#C00037"]
"Sipity::Models::SubmissionWindow" -> "Sipity::Models::WorkSubmission" [arrowtail=odot, arrowhead=crow, dir=both color="#5D8E85"]
"Sipity::Models::SubmissionWindow" -> "Sipity::Models::Processing::Entity" [label="processing_entity", arrowtail=odot, arrowhead=dot, dir=both color="#97DBC0"]
"Sipity::Models::SubmissionWindow" -> "Sipity::Models::Processing::StrategyUsage" [label="strategy_usage", arrowtail=odot, arrowhead=dot, dir=both color="#07CD87"]
"Sipity::Models::Work" -> "Sipity::Models::Collaborator" [arrowtail=odot, arrowhead=crow, dir=both color="#5711B9"]
"Sipity::Models::Work" -> "Sipity::Models::AdditionalAttribute" [arrowtail=odot, arrowhead=crow, dir=both color="#076D65"]
"Sipity::Models::Work" -> "Sipity::Models::Attachment" [arrowtail=odot, arrowhead=crow, dir=both color="#681330"]
"Sipity::Models::Work" -> "Sipity::Models::AccessRight" [arrowtail=odot, arrowhead=dot, dir=both color="#7D696E"]
"Sipity::Models::Work" -> "Sipity::Models::EventLog" [label="event_logs", arrowtail=odot, arrowhead=crow, dir=both color="#52EA98"]
"Sipity::Models::Work" -> "Sipity::Models::WorkSubmission" [arrowtail=odot, arrowhead=dot, dir=both color="#B3F6AB"]
"Sipity::Models::Work" -> "Sipity::Models::WorkRedirectStrategy" [arrowtail=odot, arrowhead=crow, dir=both color="#E8DD7E"]
"Sipity::Models::Work" -> "Sipity::Models::Processing::Entity" [label="processing_entity", arrowtail=odot, arrowhead=dot, dir=both color="#AD3761"]
"Sipity::Models::WorkArea" -> "Sipity::Models::SubmissionWindow" [arrowtail=odot, arrowhead=crow, dir=both color="#FDEBC8"]
"Sipity::Models::WorkArea" -> "Sipity::Models::WorkSubmission" [arrowtail=odot, arrowhead=crow, dir=both color="#231A87"]
"Sipity::Models::WorkArea" -> "Sipity::Models::Processing::Entity" [label="processing_entity", arrowtail=odot, arrowhead=dot, dir=both color="#944620"]
"Sipity::Models::WorkArea" -> "Sipity::Models::Processing::StrategyUsage" [label="strategy_usage", arrowtail=odot, arrowhead=dot, dir=both color="#988D18"]
"Sipity::Models::WorkType" -> "Sipity::Models::SubmissionWindowWorkType" [arrowtail=odot, arrowhead=crow, dir=both color="#D29777"]
"Sipity::Models::WorkType" -> "Sipity::Models::Processing::StrategyUsage" [label="strategy_usage", arrowtail=odot, arrowhead=dot, dir=both color="#0BC789"]
"User" -> "Sipity::Models::GroupMembership" [label="group_memberships", arrowtail=odot, arrowhead=crow, dir=both color="#298297"]
"User" -> "Sipity::Models::Processing::Actor" [label="processing_actor", arrowtail=odot, arrowhead=dot, dir=both color="#6D5660"]
"User" -> "Sipity::Models::EventLog" [label="event_logs", arrowtail=odot, arrowhead=crow, dir=both color="#30A3F1"]
}