Relationship type | non-identifying | Cardinality | 1:N |
Parent table | contact_method_defn | ||
Child table | contact |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
contact_method_defn_id | contact_method_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | contact_subject_defn | ||
Child table | contact_subject |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
contact_subject_defn_id | contact_subject_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | contact | ||
Child table | contact_subject |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
contact_id | contact_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | county_defn | ||
Child table | easement_proj_county |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
county_defn_id | county_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | county_defn | ||
Child table | loctn |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
county_defn_id | county_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | fund_defn | ||
Child table | donation |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
fund_defn_id | fund_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | income_category_defn | ||
Child table | donation |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
income_category_defn_id | income_category_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | donation_type_defn | ||
Child table | donation |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
donation_type_defn_id | donation_type_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | easement_proj | ||
Child table | easement_proj_county |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
easement_proj_id | easement_proj_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | ecosystem_defn | ||
Child table | easement_proj |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
ecosystem_defn_id | ecosystem_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | donation |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | final_donor_party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | group_defn | ||
Child table | group_mbr_period |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
group_defn_id | group_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | group_type_defn | ||
Child table | group_defn |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
group_type_defn_id | group_type_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | loctn | ||
Child table | phone |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
loctn_id | loctn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | loctn_type_defn | ||
Child table | loctn |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
loctn_type_defn_id | loctn_type_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | milestone_type_defn | ||
Child table | easement_proj_milestone |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
milestone_type_id | milestone_type_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | donation |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | orig_donor_party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | party_category |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party_category_defn | ||
Child table | party_category |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_category_defn_id | party_category_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | contact |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | group_mbr_period |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | loctn |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | party_mbr |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | person | ||
Child table | party_mbr |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
person_id | person_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party_mbr_role_defn | ||
Child table | party_mbr |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_mbr_role_defn_id | party_mbr_role_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | phone |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | pledge |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party | ||
Child table | easement_proj_party |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_id | party_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | party_type_defn | ||
Child table | party |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
party_type_defn_id | party_type_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | person | ||
Child table | person_event |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
person_id | person_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | person_event_type_defn | ||
Child table | person_event |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
person_event_type_defn_id | person_event_type_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | phone_type_defn | ||
Child table | phone |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
phone_type_defn_id | phone_type_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | pledge | ||
Child table | donation |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
pledge_id | pledge_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | easement_proj | ||
Child table | easement_proj_milestone |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
easement_proj_id | easement_proj_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | easement_proj | ||
Child table | easement_proj_party |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
easement_proj_id | easement_proj_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | easement_proj_role_defn | ||
Child table | easement_proj_party |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
easement_proj_role_defn_id | easement_proj_role_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | easement_proj | ||
Child table | easement_proj_staff |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
easement_proj_id | easement_proj_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | easement_proj_role_defn | ||
Child table | easement_proj_staff |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
easement_proj_role_defn_id | easement_proj_role_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | group_defn | ||
Child table | pub |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
group_defn_id | group_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | pub | ||
Child table | pub_issue |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
pub_id | pub_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | region_defn | ||
Child table | loctn |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
region_defn_id | region_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | region_defn | ||
Child table | easement_proj |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
region_defn_id | region_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | person | ||
Child table | related_person |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
person_id | related_person_person_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | related_person_role_defn | ||
Child table | related_person |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
related_person_role_defn_id | related_person_role_defn_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | staff_mbr | ||
Child table | contact |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
staff_mbr_id | staff_mbr_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | staff_mbr | ||
Child table | party |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
staff_mbr_id | assigned_staff_mbr_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | staff_mbr | ||
Child table | easement_proj_staff |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
staff_mbr_id | staff_mbr_id |
Name | Value |
Join type | FULL |
Relationship type | non-identifying | Cardinality | 1:N |
Parent table | person | ||
Child table | related_person |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
person_id | person_id |
Name | Value |
Join type | FULL |