contact method (contact method)
General info
Relationship type non-identifying Cardinality 1:N
Parent table contact_method_defn
Child table contact
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
contact_method_defn_id contact_method_defn_id
User-defined variables
Name Value
Join type FULL


contact subject defn (contact subject defn)
General info
Relationship type non-identifying Cardinality 1:N
Parent table contact_subject_defn
Child table contact_subject
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
contact_subject_defn_id contact_subject_defn_id
User-defined variables
Name Value
Join type FULL


contat subject (contat subject)
General info
Relationship type non-identifying Cardinality 1:N
Parent table contact
Child table contact_subject
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
contact_id contact_id
User-defined variables
Name Value
Join type FULL


county easement proj (county easement proj)
General info
Relationship type non-identifying Cardinality 1:N
Parent table county_defn
Child table easement_proj_county
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
county_defn_id county_defn_id
User-defined variables
Name Value
Join type FULL


county loctn (county loctn)
General info
Relationship type non-identifying Cardinality 1:N
Parent table county_defn
Child table loctn
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
county_defn_id county_defn_id
User-defined variables
Name Value
Join type FULL


donation fund (donation fund)
General info
Relationship type non-identifying Cardinality 1:N
Parent table fund_defn
Child table donation
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
fund_defn_id fund_defn_id
User-defined variables
Name Value
Join type FULL


donation income category (donation income category)
General info
Relationship type non-identifying Cardinality 1:N
Parent table income_category_defn
Child table donation
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
income_category_defn_id income_category_defn_id
User-defined variables
Name Value
Join type FULL


donation type (donation type)
General info
Relationship type non-identifying Cardinality 1:N
Parent table donation_type_defn
Child table donation
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
donation_type_defn_id donation_type_defn_id
User-defined variables
Name Value
Join type FULL


easement proj county (easement proj county)
General info
Relationship type non-identifying Cardinality 1:N
Parent table easement_proj
Child table easement_proj_county
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
easement_proj_id easement_proj_id
User-defined variables
Name Value
Join type FULL


ecosystem proj (ecosystem proj)
General info
Relationship type non-identifying Cardinality 1:N
Parent table ecosystem_defn
Child table easement_proj
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
ecosystem_defn_id ecosystem_defn_id
User-defined variables
Name Value
Join type FULL


final donor (final donor)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table donation
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
party_id final_donor_party_id
User-defined variables
Name Value
Join type FULL


group mbr (group mbr)
General info
Relationship type non-identifying Cardinality 1:N
Parent table group_defn
Child table group_mbr_period
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
group_defn_id group_defn_id
User-defined variables
Name Value
Join type FULL


group type (group type)
General info
Relationship type non-identifying Cardinality 1:N
Parent table group_type_defn
Child table group_defn
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
group_type_defn_id group_type_defn_id
User-defined variables
Name Value
Join type FULL


loctn phone (loctn phone)
General info
Relationship type non-identifying Cardinality 1:N
Parent table loctn
Child table phone
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
loctn_id loctn_id
User-defined variables
Name Value
Join type FULL


loctn type (loctn type)
General info
Relationship type non-identifying Cardinality 1:N
Parent table loctn_type_defn
Child table loctn
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
loctn_type_defn_id loctn_type_defn_id
User-defined variables
Name Value
Join type FULL


milestone type (milestone type)
General info
Relationship type non-identifying Cardinality 1:N
Parent table milestone_type_defn
Child table easement_proj_milestone
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
milestone_type_id milestone_type_id
User-defined variables
Name Value
Join type FULL


orig donor (orig donor)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table donation
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
party_id orig_donor_party_id
User-defined variables
Name Value
Join type FULL


party category (party category)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table party_category
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party category defn (party category defn)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party_category_defn
Child table party_category
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
party_category_defn_id party_category_defn_id
User-defined variables
Name Value
Join type FULL


party contact (party contact)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table contact
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party email (party email)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table email
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party group mbr (party group mbr)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table group_mbr_period
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party loctn (party loctn)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table loctn
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party mbr (party mbr)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table party_mbr
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party mbr person (party mbr person)
General info
Relationship type non-identifying Cardinality 1:N
Parent table person
Child table party_mbr
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
person_id person_id
User-defined variables
Name Value
Join type FULL


party mbr role (party mbr role)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party_mbr_role_defn
Child table party_mbr
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
party_mbr_role_defn_id party_mbr_role_defn_id
User-defined variables
Name Value
Join type FULL


party phone (party phone)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table phone
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party pledge (party pledge)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table pledge
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party proj (party proj)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party
Child table easement_proj_party
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
party_id party_id
User-defined variables
Name Value
Join type FULL


party type (party type)
General info
Relationship type non-identifying Cardinality 1:N
Parent table party_type_defn
Child table party
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
party_type_defn_id party_type_defn_id
User-defined variables
Name Value
Join type FULL


person event (person event)
General info
Relationship type non-identifying Cardinality 1:N
Parent table person
Child table person_event
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
person_id person_id
User-defined variables
Name Value
Join type FULL


person event type (person event type)
General info
Relationship type non-identifying Cardinality 1:N
Parent table person_event_type_defn
Child table person_event
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
person_event_type_defn_id person_event_type_defn_id
User-defined variables
Name Value
Join type FULL


phone type (phone type)
General info
Relationship type non-identifying Cardinality 1:N
Parent table phone_type_defn
Child table phone
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
phone_type_defn_id phone_type_defn_id
User-defined variables
Name Value
Join type FULL


pledge donation (pledge donation)
General info
Relationship type non-identifying Cardinality 1:N
Parent table pledge
Child table donation
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
pledge_id pledge_id
User-defined variables
Name Value
Join type FULL


proj milestone (proj milestone)
General info
Relationship type non-identifying Cardinality 1:N
Parent table easement_proj
Child table easement_proj_milestone
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
easement_proj_id easement_proj_id
User-defined variables
Name Value
Join type FULL


proj party (proj party)
General info
Relationship type non-identifying Cardinality 1:N
Parent table easement_proj
Child table easement_proj_party
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
easement_proj_id easement_proj_id
User-defined variables
Name Value
Join type FULL


proj party role (proj party role)
General info
Relationship type non-identifying Cardinality 1:N
Parent table easement_proj_role_defn
Child table easement_proj_party
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
easement_proj_role_defn_id easement_proj_role_defn_id
User-defined variables
Name Value
Join type FULL


proj staff (proj staff)
General info
Relationship type non-identifying Cardinality 1:N
Parent table easement_proj
Child table easement_proj_staff
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
easement_proj_id easement_proj_id
User-defined variables
Name Value
Join type FULL


proj staff role (proj staff role)
General info
Relationship type non-identifying Cardinality 1:N
Parent table easement_proj_role_defn
Child table easement_proj_staff
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
easement_proj_role_defn_id easement_proj_role_defn_id
User-defined variables
Name Value
Join type FULL


pub group defn (pub group defn)
General info
Relationship type non-identifying Cardinality 1:N
Parent table group_defn
Child table pub
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
group_defn_id group_defn_id
User-defined variables
Name Value
Join type FULL


pub issue (pub issue)
General info
Relationship type non-identifying Cardinality 1:N
Parent table pub
Child table pub_issue
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
pub_id pub_id
User-defined variables
Name Value
Join type FULL


region loctn (region loctn)
General info
Relationship type non-identifying Cardinality 1:N
Parent table region_defn
Child table loctn
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
region_defn_id region_defn_id
User-defined variables
Name Value
Join type FULL


region proj (region proj)
General info
Relationship type non-identifying Cardinality 1:N
Parent table region_defn
Child table easement_proj
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
region_defn_id region_defn_id
User-defined variables
Name Value
Join type FULL


related person (related person)
General info
Relationship type non-identifying Cardinality 1:N
Parent table person
Child table related_person
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
person_id related_person_person_id
User-defined variables
Name Value
Join type FULL


related person role (related person role)
General info
Relationship type non-identifying Cardinality 1:N
Parent table related_person_role_defn
Child table related_person
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
related_person_role_defn_id related_person_role_defn_id
User-defined variables
Name Value
Join type FULL


staff mbr contact (staff mbr contact)
General info
Relationship type non-identifying Cardinality 1:N
Parent table staff_mbr
Child table contact
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
staff_mbr_id staff_mbr_id
User-defined variables
Name Value
Join type FULL


staff party (staff party)
General info
Relationship type non-identifying Cardinality 1:N
Parent table staff_mbr
Child table party
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
staff_mbr_id assigned_staff_mbr_id
User-defined variables
Name Value
Join type FULL


staff proj (staff proj)
General info
Relationship type non-identifying Cardinality 1:N
Parent table staff_mbr
Child table easement_proj_staff
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
staff_mbr_id staff_mbr_id
User-defined variables
Name Value
Join type FULL


starting person (starting person)
General info
Relationship type non-identifying Cardinality 1:N
Parent table person
Child table related_person
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
person_id person_id
User-defined variables
Name Value
Join type FULL