SchemaSpy Analysis of odyssey_test._oat - Constraints Generated by
SchemaSpy
6 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
oat_permission_parent_fkey oat_permission.parent oat_permission.permission Restrict delete 
oat_student_view_advisor_userid_fkey std_advisor_view.advisor_userid usr_user.userid Cascade on delete 
oat_tag_content_group_id_fkey oat_tag_content.group_id
oat_tag_content.tag
oat_tag.group_id
oat_tag.tag
Restrict delete 
oat_user_permission_permission_fkey usr_permission.permission oat_permission.permission Restrict delete 
oat_user_permission_userid_fkey usr_permission.userid usr_user.userid Cascade on delete 
qry_parameter_param_type_fkey qry_parameter.param_type qry_parameter_type.param_type Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected