Entity Type Definition Model : STORET PROD DEV V02.0.1 Subset: ERD_DSD Jan. 05, 2005 12:13 Entity Type: ABSOLUTE_LOCATION_POINT Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 300000 Avg Occ: 3000000 Max Occ: 6000000 Growth Rate: 5% per year TD Name: TSMALP Relationship Properties: Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_ASSOCIATED_WITH one RF1_RIVER_REACH Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of RF1_RIVER_REACH Description: Destination Prop... Each RF1_RIVER_REACH Sometimes (10%) CHARACTERIZES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of RF1_RIVER_REACH is deleted: Disallow deletion of RF1_RIVER_REACH if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (75%) IS_PRIMARILY_LOCATED_BY one GEOPOLITICAL_AREA Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of GEOPOLITICAL_AREA Description: Destination Prop... Each GEOPOLITICAL_AREA Sometimes (10%) PRIMARILY_LOCATES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of GEOPOLITICAL_AREA is deleted: Disallow deletion of GEOPOLITICAL_AREA if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_ASSOCIATED_WITH one FIPS_HYDROLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of FIPS_HYDROLOGIC_UNIT Description: Destination Prop... Each FIPS_HYDROLOGIC_UNIT Sometimes (10%) CHARACTERIZES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of FIPS_HYDROLOGIC_UNIT is deleted: Disallow deletion of FIPS_HYDROLOGIC_UNIT if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_ASSOCIATED_WITH one NATIVE_AMERICAN_LAND Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of NATIVE_AMERICAN_LAND Description: Destination Prop... Each NATIVE_AMERICAN_LAND Sometimes (10%) CHARACTERIZES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of NATIVE_AMERICAN_LAND is deleted: Disallow deletion of NATIVE_AMERICAN_LAND if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_CHARACTERIZED_BY one GREAT_LAKE_LOCATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of GREAT_LAKE_LOCATION Description: Destination Prop... Each GREAT_LAKE_LOCATION Always (100%) CHARACTERIZES one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GREAT_LAKE_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_CHARACTERIZED_BY one OCEAN_LOCATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of OCEAN_LOCATION Description: Destination Prop... Each OCEAN_LOCATION Always (100%) CHARACTERIZES one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OCEAN_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (30%) IS_SECONDARILY_LOCATED_BY one GEOPOLITICAL_AREA Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of GEOPOLITICAL_AREA Description: Destination Prop... Each GEOPOLITICAL_AREA Sometimes (10%) SECONDARILY_LOCATES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEOPOLITICAL_AREA is deleted: Disallow deletion of GEOPOLITICAL_AREA if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_CHARACTERIZED_BY one ESTUARY_LOCATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of ESTUARY_LOCATION Description: Destination Prop... Each ESTUARY_LOCATION Always (100%) CHARACTERIZES one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (80%) IS_LOCATION_OF many ACTUAL_ACTIVITY_LOCATION Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of ACTUAL_ACTIVITY_LOCATION Description: Destination Prop... Each ACTUAL_ACTIVITY_LOCATION Always (100%) IS_CONDUCTED_AT one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ACTUAL_ACTIVITY_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one PERMANENT_GRID Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of PERMANENT_GRID Description: Destination Prop... Each PERMANENT_GRID Sometimes (10%) IS_LOCATED_BY one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMANENT_GRID is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one PERMANENT_TRANSECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of PERMANENT_TRANSECT Description: Destination Prop... Each PERMANENT_TRANSECT Sometimes (10%) IS_LOCATED_BY many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 10 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMANENT_TRANSECT is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one PIPE Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of PIPE Description: Destination Prop... Each PIPE Sometimes (10%) IS_LOCATED_BY one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PIPE is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (90%) IS_LOCATION_OF one STATION Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (98%) IS_LOCATED_BY many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Source Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one WELL_STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of WELL_STATION Description: Destination Prop... Each WELL_STATION Sometimes (10%) IS_LOCATED_BY one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: ================================================== Entity Type: ACTUAL_ACTIVITY_LOCATION Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 500000 Avg Occ: 1000000 Max Occ: 2000000 Growth Rate: 5% per year TD Name: TSRAAL Relationship Properties: Source Prop... Each ACTUAL_ACTIVITY_LOCATION Always (100%) IS_CONDUCTED_AT one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ACTUAL_ACTIVITY_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (80%) IS_LOCATION_OF many ACTUAL_ACTIVITY_LOCATION Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of ACTUAL_ACTIVITY_LOCATION Description: ================================================== Source Prop... Each ACTUAL_ACTIVITY_LOCATION Always (100%) PLACES one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ACTUAL_ACTIVITY_LOCATION is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (90%) TAKES_PLACE_AT many ACTUAL_ACTIVITY_LOCATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of ACTUAL_ACTIVITY_LOCATION Description: ================================================== Entity Type: ADDRESS Subject area: ADDRESSES Properties:Persistent Open Min Occ: 5000 Avg Occ: 150000 Max Occ: 500000 Growth Rate: 5% per year TD Name: TSMADDR Relationship Properties: Source Prop... Each ADDRESS Sometimes (10%) IS_FOR one WELL_LEGAL_ENTITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of WELL_LEGAL_ENTITY Description: Destination Prop... Each WELL_LEGAL_ENTITY Sometimes (90%) HAS many ADDRESS Cardinality Min: 1 (est) Max: 3 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_LEGAL_ENTITY is deleted: Delete each occurrence of ADDRESS Description: ================================================== Source Prop... Each ADDRESS Sometimes (1%) IS_ASSIGNED_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (1%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 3 (est) Avg: 1 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Delete each occurrence of ADDRESS Description: ================================================== Source Prop... Each ADDRESS Sometimes (1%) IS_ASSIGNED_TO one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (1%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of ADDRESS Description: ================================================== Source Prop... Each ADDRESS Sometimes (80%) IS_ASSIGNED_TO one LABORATORY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of LABORATORY Description: Destination Prop... Each LABORATORY Sometimes (80%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 10 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Delete each occurrence of ADDRESS Description: ================================================== Source Prop... Each ADDRESS Sometimes (10%) IS_ASSIGNED_TO one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: Destination Prop... Each COOPERATING_ORGANIZATION Sometimes (50%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of ADDRESS Description: ================================================== Entity Type: ANALYTICAL_EQUIPMENT Subject area: ANALYTICAL_PROCEDURES Properties:Persistent Open Min Occ: 500 Avg Occ: 10000 Max Occ: 15000 Growth Rate: 5% per year TD Name: TSRANLEQ Relationship Properties: Source Prop... Each ANALYTICAL_EQUIPMENT Sometimes (50%) IS_USED_IN many ANALYTICAL_PROCEDURE Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_EQUIPMENT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: Destination Prop... Each ANALYTICAL_PROCEDURE Sometimes (70%) USES one ANALYTICAL_EQUIPMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of ANALYTICAL_EQUIPMENT Description: ================================================== Entity Type: ANALYTICAL_PROCEDURE Subject area: ANALYTICAL_PROCEDURES Properties:Persistent Open Min Occ: 3000 Avg Occ: 5000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSRANLPR Relationship Properties: Source Prop... Each ANALYTICAL_PROCEDURE Sometimes (70%) USES one ANALYTICAL_EQUIPMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of ANALYTICAL_EQUIPMENT Description: Destination Prop... Each ANALYTICAL_EQUIPMENT Sometimes (50%) IS_USED_IN many ANALYTICAL_PROCEDURE Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_EQUIPMENT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: ================================================== Source Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) HAS_AS_ITS_NATIONAL_MODEL one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: Destination Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) IS_NATIONAL_MODEL_FOR many ANALYTICAL_PROCEDURE Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: ================================================== Source Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) IS_NATIONAL_MODEL_FOR many ANALYTICAL_PROCEDURE Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: Destination Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) HAS_AS_ITS_NATIONAL_MODEL one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: ================================================== Source Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) IS_ASSIGNED_TO many ORG_ANALYTICAL_PROCEDURE_ASGMT Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Delete each occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT Description: Destination Prop... Each ORG_ANALYTICAL_PROCEDURE_ASGMT Always (100%) ASSIGNS one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: ================================================== Source Prop... Each ANALYTICAL_PROCEDURE Sometimes (50%) IS_DESCRIBED_IN one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of CITATION Description: Destination Prop... Each CITATION Sometimes (50%) DESCRIBES many ANALYTICAL_PROCEDURE Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of ANALYTICAL_PROCEDURE Description: ================================================== Source Prop... Each ANALYTICAL_PROCEDURE Sometimes (50%) IS_USED_TO_CREATE many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disallow deletion of ANALYTICAL_PROCEDURE if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (85%) IS_CREATED_BY one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: ================================================== Source Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) DESCRIBES many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of CHARACTERISTIC_DEFAULT Description: Destination Prop... Each CHARACTERISTIC_DEFAULT Sometimes (5%) IS_DESCRIBED_BY one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: ================================================== Entity Type: AUTOMATED_DATA_LOGGER Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 2500 Avg Occ: 75000 Max Occ: 250000 Growth Rate: 5% per year TD Name: TSRADL Relationship Properties: Source Prop... Each AUTOMATED_DATA_LOGGER Sometimes (20%) DESCRIBED_BY one SAMPLE_MATRIX Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of AUTOMATED_DATA_LOGGER is deleted: Disassociate each occurrence of SAMPLE_MATRIX Description: Destination Prop... Each SAMPLE_MATRIX Sometimes (90%) USED_TO_DESCRIBE many AUTOMATED_DATA_LOGGER Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE_MATRIX is deleted: Disallow deletion of SAMPLE_MATRIX if there is one (or more) occurrence of AUTOMATED_DATA_LOGGER Description: ================================================== Source Prop... Each AUTOMATED_DATA_LOGGER Sometimes (80%) LOGS_DATA_WITHIN many OPERATING_PERIOD Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of AUTOMATED_DATA_LOGGER is deleted: Delete each occurrence of OPERATING_PERIOD Description: Destination Prop... Each OPERATING_PERIOD Always (100%) IS_MONITORED_BY one AUTOMATED_DATA_LOGGER Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPERATING_PERIOD is deleted: Disassociate each occurrence of AUTOMATED_DATA_LOGGER Description: ================================================== Source Prop... Each AUTOMATED_DATA_LOGGER Always (100%) COLLECTS_DATA_AT one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of AUTOMATED_DATA_LOGGER is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (10%) HAS_DATA_GENERATED_BY many AUTOMATED_DATA_LOGGER Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of AUTOMATED_DATA_LOGGER Description: ================================================== Entity Type: BIOLOGICAL_PART Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 100 Avg Occ: 150 Max Occ: 200 Growth Rate: 5% per year TD Name: TSRBIOPT Relationship Properties: Source Prop... Each BIOLOGICAL_PART Sometimes (95%) IS_SUBJECT_OF many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_PART is deleted: Disallow deletion of BIOLOGICAL_PART if there is one (or more) occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (50%) HAS_AS_ITS_SUBJECT one BIOLOGICAL_PART Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of BIOLOGICAL_PART Description: ================================================== Entity Type: BIOLOGICAL_RESULT_GROUP Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 5000 Max Occ: 100000 Growth Rate: 10% per year TD Name: TSRBRG Relationship Properties: Source Prop... Each BIOLOGICAL_RESULT_GROUP Sometimes (5%) CONTAINS many BIO_RESULT_GROUP_INDIVIDUAL Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Delete each occurrence of BIO_RESULT_GROUP_INDIVIDUAL Description: Destination Prop... Each BIO_RESULT_GROUP_INDIVIDUAL Always (100%) IS_PART_OF one BIOLOGICAL_RESULT_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIO_RESULT_GROUP_INDIVIDUAL is deleted: Disassociate each occurrence of BIOLOGICAL_RESULT_GROUP Description: ================================================== Source Prop... Each BIOLOGICAL_RESULT_GROUP Sometimes (5%) CONTAINS many RESULT Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Delete each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) IS_CONTAINED_IN one BIOLOGICAL_RESULT_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of BIOLOGICAL_RESULT_GROUP Description: ================================================== Source Prop... Each BIOLOGICAL_RESULT_GROUP Sometimes (50%) HAS_RESULT_TAXON_OF one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Disassociate each occurrence of CHARACTERISTIC Description: Destination Prop... Each CHARACTERISTIC Sometimes (20%) IS_THE_RESULT_TAXON_FOR many BIOLOGICAL_RESULT_GROUP Cardinality Min: 1 (est) Max: 1000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of BIOLOGICAL_RESULT_GROUP Description: ================================================== Source Prop... Each BIOLOGICAL_RESULT_GROUP Always (100%) IS_FOR one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (5%) HAS many BIOLOGICAL_RESULT_GROUP Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of BIOLOGICAL_RESULT_GROUP Description: ================================================== Entity Type: BIO_RESULT_GROUP_INDIVIDUAL Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 20000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSRBRGI Relationship Properties: Source Prop... Each BIO_RESULT_GROUP_INDIVIDUAL Sometimes (90%) IS_DESCRIBED_USING many RESULT Cardinality Min: 1 (est) Max: 10 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIO_RESULT_GROUP_INDIVIDUAL is deleted: Delete each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (10%) DESCRIBES one BIO_RESULT_GROUP_INDIVIDUAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of BIO_RESULT_GROUP_INDIVIDUAL Description: ================================================== Source Prop... Each BIO_RESULT_GROUP_INDIVIDUAL Always (100%) IS_PART_OF one BIOLOGICAL_RESULT_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIO_RESULT_GROUP_INDIVIDUAL is deleted: Disassociate each occurrence of BIOLOGICAL_RESULT_GROUP Description: Destination Prop... Each BIOLOGICAL_RESULT_GROUP Sometimes (5%) CONTAINS many BIO_RESULT_GROUP_INDIVIDUAL Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Delete each occurrence of BIO_RESULT_GROUP_INDIVIDUAL Description: ================================================== Entity Type: CASING Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMCSNG Relationship Properties: Source Prop... Each CASING Always (100%) IS_USED_IN one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CASING is deleted: Disassociate each occurrence of INTERVAL Description: Destination Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one CASING Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of CASING Description: ================================================== Entity Type: CELL_DESCRIPTOR Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 1000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSRCLDES Relationship Properties: Source Prop... Each CELL_DESCRIPTOR Always (100%) DESCRIBES_CELL_FORMS_FOR one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CELL_DESCRIPTOR is deleted: Disassociate each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) HAS_CELL_FORMS_DESCRIBED_BY one CELL_DESCRIPTOR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of CELL_DESCRIPTOR Description: ================================================== Entity Type: CHARACTERISTIC Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 10000 Avg Occ: 50000 Max Occ: 150000 Growth Rate: 10% per year TD Name: TSRCHAR Relationship Properties: Source Prop... Each CHARACTERISTIC Sometimes (50%) SECONDARILY_QUALIFIES many RESULT Cardinality Min: 1 (est) Max: 5000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) IS_SECONDARILY_QUALIFIED_BY one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: ================================================== Source Prop... Each CHARACTERISTIC Sometimes (20%) IS_THE_RESULT_TAXON_FOR many BIOLOGICAL_RESULT_GROUP Cardinality Min: 1 (est) Max: 1000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of BIOLOGICAL_RESULT_GROUP Description: Destination Prop... Each BIOLOGICAL_RESULT_GROUP Sometimes (50%) HAS_RESULT_TAXON_OF one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Disassociate each occurrence of CHARACTERISTIC Description: ================================================== Source Prop... Each CHARACTERISTIC Sometimes (90%) ASSIGNS many CHARACTERISTIC_TYPE_CHAR_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT Description: Destination Prop... Each CHARACTERISTIC_TYPE_CHAR_ASGMNT Always (100%) IS_ASSIGNED_TO one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: ================================================== Source Prop... Each CHARACTERISTIC Sometimes (25%) HAS_RESULTS_INCLUDED_AMONG many CHARACTERISTIC_PERMITD_VALUE Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_PERMITD_VALUE Description: A Sample Result for a Characteristic may be a description or other text, and this relationship provides a list of valid choices for a given Characteristic. This relationship is optional because a Characteristic may have no associated Characteristic Permitted Values if it provides quantitative (numeric) Sample Results. Destination Prop... Each CHARACTERISTIC_PERMITD_VALUE Always (100%) SERVES_AS_THE_RESULT_FOR one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_PERMITD_VALUE is deleted: Disassociate each occurrence of CHARACTERISTIC Description: This relationship identifies the Characteristic for which the Characteristic Permitted Value is valid. A Characteristic Permitted Value is a valid choice value for only one Characteristic because each Characteristic will have its own list of valid values. ================================================== Source Prop... Each CHARACTERISTIC Sometimes (50%) IS_A_SUBJECT_TAXON_FOR many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (25%) HAS_A_SUBJECT_TAXON_OF one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of CHARACTERISTIC Description: ================================================== Source Prop... Each CHARACTERISTIC Sometimes (50%) IS_ACCEPTED_FOR many ORG_ANA_PROC_CHAR_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of ORG_ANA_PROC_CHAR_ASGNMT Description: Destination Prop... Each ORG_ANA_PROC_CHAR_ASGNMT Always (100%) ACCEPTS one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANA_PROC_CHAR_ASGNMT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: ================================================== Source Prop... Each CHARACTERISTIC Sometimes (50%) IS_NAMED_BY many CHARACTERISTIC_ALIAS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_ALIAS Description: A characteristic will have one official name in STORET, but some characteristics may be named by one or more aliases to benefit users accustomed to alternative naming schemes. Destination Prop... Each CHARACTERISTIC_ALIAS Always (100%) ALTERNATIVELY_NAMES one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_ALIAS is deleted: Disassociate each occurrence of CHARACTERISTIC Description: The relationship is mandatory because aliases will only be stored for recognized characteristics. The cardinality is one because an alias is an alternative name at the same level of detail as the original characteristic. Do not confuse aliases with characteristic groups (which refer to several characteristics). ================================================== Source Prop... Each CHARACTERISTIC Sometimes (50%) IS_PLACED_IN_A_GROUP_BY many CHARACTERISTIC_CHAR_GROUP_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT Description: Destination Prop... Each CHARACTERISTIC_CHAR_GROUP_ASGNMT Always (100%) PLACES_IN_A_GROUP one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: ================================================== Source Prop... Each CHARACTERISTIC Sometimes (50%) QUALIFIES many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (100%) IS_QUALIFIED_BY one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: ================================================== Entity Type: CHARACTERISTIC_ALIAS Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 10000 Avg Occ: 50000 Max Occ: 150000 Growth Rate: 10% per year TD Name: TSRCHALS Relationship Properties: Source Prop... Each CHARACTERISTIC_ALIAS Always (100%) ALTERNATIVELY_NAMES one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_ALIAS is deleted: Disassociate each occurrence of CHARACTERISTIC Description: The relationship is mandatory because aliases will only be stored for recognized characteristics. The cardinality is one because an alias is an alternative name at the same level of detail as the original characteristic. Do not confuse aliases with characteristic groups (which refer to several characteristics). Destination Prop... Each CHARACTERISTIC Sometimes (50%) IS_NAMED_BY many CHARACTERISTIC_ALIAS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_ALIAS Description: A characteristic will have one official name in STORET, but some characteristics may be named by one or more aliases to benefit users accustomed to alternative naming schemes. ================================================== Source Prop... Each CHARACTERISTIC_ALIAS Always (100%) IS_CLASSIFIED_BY one CHARACTERISTIC_ALIAS_TYPE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_ALIAS is deleted: Disassociate each occurrence of CHARACTERISTIC_ALIAS_TYPE Description: Destination Prop... Each CHARACTERISTIC_ALIAS_TYPE Sometimes (80%) CLASSIFIES many CHARACTERISTIC_ALIAS Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_ALIAS_TYPE is deleted: Disallow deletion of CHARACTERISTIC_ALIAS_TYPE if there is one (or more) occurrence of CHARACTERISTIC_ALIAS Description: ================================================== Entity Type: CHARACTERISTIC_ALIAS_TYPE Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 1000 Avg Occ: 4000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSRCALT Relationship Properties: Source Prop... Each CHARACTERISTIC_ALIAS_TYPE Sometimes (80%) CLASSIFIES many CHARACTERISTIC_ALIAS Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_ALIAS_TYPE is deleted: Disallow deletion of CHARACTERISTIC_ALIAS_TYPE if there is one (or more) occurrence of CHARACTERISTIC_ALIAS Description: Destination Prop... Each CHARACTERISTIC_ALIAS Always (100%) IS_CLASSIFIED_BY one CHARACTERISTIC_ALIAS_TYPE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_ALIAS is deleted: Disassociate each occurrence of CHARACTERISTIC_ALIAS_TYPE Description: ================================================== Entity Type: CHARACTERISTIC_CHAR_GROUP_ASGNMT Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 20000 Avg Occ: 75000 Max Occ: 250000 Growth Rate: 5% per year TD Name: TSRCCGA Relationship Properties: Source Prop... Each CHARACTERISTIC_CHAR_GROUP_ASGNMT Always (100%) PLACES_IN_A_GROUP one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: Destination Prop... Each CHARACTERISTIC Sometimes (50%) IS_PLACED_IN_A_GROUP_BY many CHARACTERISTIC_CHAR_GROUP_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT Description: ================================================== Source Prop... Each CHARACTERISTIC_CHAR_GROUP_ASGNMT Always (100%) INCORPORATES_A_CHARACTERISTIC_TO one CHARACTERISTIC_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT is deleted: Disassociate each occurrence of CHARACTERISTIC_GROUP Description: Destination Prop... Each CHARACTERISTIC_GROUP Sometimes (50%) CONTAINS_CHARACTERISTICS_FROM many CHARACTERISTIC_CHAR_GROUP_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Delete each occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT Description: ================================================== Source Prop... Each CHARACTERISTIC_CHAR_GROUP_ASGNMT Sometimes (5%) IS_DESCRIBED_BY one CHARACTERISTIC_DEFAULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT is deleted: Delete each occurrence of CHARACTERISTIC_DEFAULT Description: Destination Prop... Each CHARACTERISTIC_DEFAULT Always (100%) DESCRIBES one CHARACTERISTIC_CHAR_GROUP_ASGNMT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT Description: ================================================== Entity Type: CHARACTERISTIC_DEFAULT Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 15000 Avg Occ: 50000 Max Occ: 150000 Growth Rate: 5% per year TD Name: TSRCHDEF Relationship Properties: Source Prop... Each CHARACTERISTIC_DEFAULT Always (100%) DESCRIBES one CHARACTERISTIC_CHAR_GROUP_ASGNMT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT Description: Destination Prop... Each CHARACTERISTIC_CHAR_GROUP_ASGNMT Sometimes (5%) IS_DESCRIBED_BY one CHARACTERISTIC_DEFAULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT is deleted: Delete each occurrence of CHARACTERISTIC_DEFAULT Description: ================================================== Source Prop... Each CHARACTERISTIC_DEFAULT Sometimes (100%) HAS_SAMPLE_FRACTION_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_SAMPLE_FRACTION_TYPE_OF many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of CHARACTERISTIC_DEFAULT Description: ================================================== Source Prop... Each CHARACTERISTIC_DEFAULT Sometimes (50%) HAS_HABIT_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (60%) IS_HABIT_OF many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of CHARACTERISTIC_DEFAULT Description: ================================================== Source Prop... Each CHARACTERISTIC_DEFAULT Sometimes (50%) HAS_VOLTINISM_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (60%) IS_VOLTINISM_FOR many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of CHARACTERISTIC_DEFAULT Description: ================================================== Source Prop... Each CHARACTERISTIC_DEFAULT Sometimes (5%) IS_DESCRIBED_BY one LAB_SAMPLE_PREP_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: Destination Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (5%) DESCRIBES many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Disassociate each occurrence of CHARACTERISTIC_DEFAULT Description: ================================================== Source Prop... Each CHARACTERISTIC_DEFAULT Sometimes (5%) IS_DESCRIBED_BY one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: Destination Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) DESCRIBES many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of CHARACTERISTIC_DEFAULT Description: ================================================== Entity Type: CHARACTERISTIC_GROUP Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 20000 Avg Occ: 100000 Max Occ: 1000000 Growth Rate: 5% per year TD Name: TSRCHGRP Relationship Properties: Source Prop... Each CHARACTERISTIC_GROUP Sometimes (10%) IS_EVALUATED_USING many HABITAT_CLASS_SCHEME_CHAR Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Delete each occurrence of HABITAT_CLASS_SCHEME_CHAR Description: Destination Prop... Each HABITAT_CLASS_SCHEME_CHAR Always (100%) EVALUATES one CHARACTERISTIC_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of HABITAT_CLASS_SCHEME_CHAR is deleted: Disassociate each occurrence of CHARACTERISTIC_GROUP Description: ================================================== Source Prop... Each CHARACTERISTIC_GROUP Sometimes (10%) IS_DEFINED_IN one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Disassociate each occurrence of CITATION Description: Destination Prop... Each CITATION Sometimes (10%) DEFINES many CHARACTERISTIC_GROUP Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of CHARACTERISTIC_GROUP Description: ================================================== Source Prop... Each CHARACTERISTIC_GROUP Sometimes (50%) CONTAINS_CHARACTERISTICS_FROM many CHARACTERISTIC_CHAR_GROUP_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Delete each occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT Description: Destination Prop... Each CHARACTERISTIC_CHAR_GROUP_ASGNMT Always (100%) INCORPORATES_A_CHARACTERISTIC_TO one CHARACTERISTIC_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_CHAR_GROUP_ASGNMT is deleted: Disassociate each occurrence of CHARACTERISTIC_GROUP Description: ================================================== Source Prop... Each CHARACTERISTIC_GROUP Always (100%) IS_ESTABLISHED_AND_CONTROLLED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (50%) ESTABLISHES_AND_CONTROLS many CHARACTERISTIC_GROUP Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of CHARACTERISTIC_GROUP Description: ================================================== Entity Type: CHARACTERISTIC_PERMITD_VALUE Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 1000 Avg Occ: 5000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSRCPV Relationship Properties: Source Prop... Each CHARACTERISTIC_PERMITD_VALUE Always (100%) SERVES_AS_THE_RESULT_FOR one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_PERMITD_VALUE is deleted: Disassociate each occurrence of CHARACTERISTIC Description: This relationship identifies the Characteristic for which the Characteristic Permitted Value is valid. A Characteristic Permitted Value is a valid choice value for only one Characteristic because each Characteristic will have its own list of valid values. Destination Prop... Each CHARACTERISTIC Sometimes (25%) HAS_RESULTS_INCLUDED_AMONG many CHARACTERISTIC_PERMITD_VALUE Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_PERMITD_VALUE Description: A Sample Result for a Characteristic may be a description or other text, and this relationship provides a list of valid choices for a given Characteristic. This relationship is optional because a Characteristic may have no associated Characteristic Permitted Values if it provides quantitative (numeric) Sample Results. ================================================== Entity Type: CHARACTERISTIC_TYPE Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 50 Avg Occ: 100 Max Occ: 500 Growth Rate: 5% per year TD Name: TSRCHTYP Relationship Properties: Source Prop... Each CHARACTERISTIC_TYPE Sometimes (50%) IS_ASSIGNED_TO many CHARACTERISTIC_TYPE_CHAR_ASGMNT Cardinality Min: 1 (est) Max: 1100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_TYPE is deleted: Disallow deletion of CHARACTERISTIC_TYPE if there is one (or more) occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT Description: Destination Prop... Each CHARACTERISTIC_TYPE_CHAR_ASGMNT Always (100%) ASSIGNS one CHARACTERISTIC_TYPE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT is deleted: Disassociate each occurrence of CHARACTERISTIC_TYPE Description: ================================================== Entity Type: CHARACTERISTIC_TYPE_CHAR_ASGMNT Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 10000 Avg Occ: 50000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSRCTCA Relationship Properties: Source Prop... Each CHARACTERISTIC_TYPE_CHAR_ASGMNT Always (100%) IS_ASSIGNED_TO one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: Destination Prop... Each CHARACTERISTIC Sometimes (90%) ASSIGNS many CHARACTERISTIC_TYPE_CHAR_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT Description: ================================================== Source Prop... Each CHARACTERISTIC_TYPE_CHAR_ASGMNT Always (100%) ASSIGNS one CHARACTERISTIC_TYPE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT is deleted: Disassociate each occurrence of CHARACTERISTIC_TYPE Description: Destination Prop... Each CHARACTERISTIC_TYPE Sometimes (50%) IS_ASSIGNED_TO many CHARACTERISTIC_TYPE_CHAR_ASGMNT Cardinality Min: 1 (est) Max: 1100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_TYPE is deleted: Disallow deletion of CHARACTERISTIC_TYPE if there is one (or more) occurrence of CHARACTERISTIC_TYPE_CHAR_ASGMNT Description: ================================================== Entity Type: CHECKPOINT_INFO Subject area: REPLICATION Properties:Persistent Open Min Occ: 1 Avg Occ: 1 Max Occ: 1 Growth Rate: 0% per year TD Name: TSMCHKPT Relationship Properties: Entity Type: CITATION Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 500 Avg Occ: 1000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSRCITN Relationship Properties: Source Prop... Each CITATION Sometimes (10%) DEFINES many CHARACTERISTIC_GROUP Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of CHARACTERISTIC_GROUP Description: Destination Prop... Each CHARACTERISTIC_GROUP Sometimes (10%) IS_DEFINED_IN one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Disassociate each occurrence of CITATION Description: ================================================== Source Prop... Each CITATION Sometimes (50%) IS_ASSIGNED_TO many CITATION_PROJECT_ASGNMT Cardinality Min: 100 (est) Max: 1000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Delete each occurrence of CITATION_PROJECT_ASGNMT Description: Destination Prop... Each CITATION_PROJECT_ASGNMT Always (100%) ASSIGNS one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION_PROJECT_ASGNMT is deleted: Disassociate each occurrence of CITATION Description: ================================================== Source Prop... Each CITATION Sometimes (50%) DESCRIBES many LAB_SAMPLE_PREP_PROCEDURE Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: Destination Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (50%) IS_DESCRIBED_BY one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Disassociate each occurrence of CITATION Description: ================================================== Source Prop... Each CITATION Sometimes (50%) CONTAINS many FIELD_PROCEDURE Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of FIELD_PROCEDURE Description: Destination Prop... Each FIELD_PROCEDURE Sometimes (90%) IS_DEFINED_IN one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_PROCEDURE is deleted: Disassociate each occurrence of CITATION Description: ================================================== Source Prop... Each CITATION Always (100%) IS_REFERENCED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (20%) REFERENCES many CITATION Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of CITATION Description: ================================================== Source Prop... Each CITATION Sometimes (50%) DESCRIBES many ANALYTICAL_PROCEDURE Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of ANALYTICAL_PROCEDURE Description: Destination Prop... Each ANALYTICAL_PROCEDURE Sometimes (50%) IS_DESCRIBED_IN one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disassociate each occurrence of CITATION Description: ================================================== Entity Type: CITATION_PROJECT_ASGNMT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 4000 Avg Occ: 20000 Max Occ: 200000 Growth Rate: 5% per year TD Name: TSRCPA Relationship Properties: Source Prop... Each CITATION_PROJECT_ASGNMT Always (100%) ASSIGNS one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION_PROJECT_ASGNMT is deleted: Disassociate each occurrence of CITATION Description: Destination Prop... Each CITATION Sometimes (50%) IS_ASSIGNED_TO many CITATION_PROJECT_ASGNMT Cardinality Min: 100 (est) Max: 1000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Delete each occurrence of CITATION_PROJECT_ASGNMT Description: ================================================== Source Prop... Each CITATION_PROJECT_ASGNMT Always (100%) CORRESPONDS_TO one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION_PROJECT_ASGNMT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (50%) HAS_A_CORRESPONDING many CITATION_PROJECT_ASGNMT Cardinality Min: 100 (est) Max: 1000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of CITATION_PROJECT_ASGNMT Description: ================================================== Entity Type: COOPERATING_ORGANIZATION Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 4000 Avg Occ: 20000 Max Occ: 200000 Growth Rate: 5% per year TD Name: TSMCPORG Relationship Properties: Source Prop... Each COOPERATING_ORGANIZATION Always (100%) ASSISTS one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (50%) IS_ASSISTED_BY many COOPERATING_ORGANIZATION Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Delete each occurrence of COOPERATING_ORGANIZATION Description: ================================================== Source Prop... Each COOPERATING_ORGANIZATION Sometimes (50%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of ADDRESS Description: Destination Prop... Each ADDRESS Sometimes (10%) IS_ASSIGNED_TO one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: ================================================== Source Prop... Each COOPERATING_ORGANIZATION Sometimes (25%) IS_ASSIGNED many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: Destination Prop... Each ELECTRONIC_ADDRESS Sometimes (10%) IS_ASSIGNED_TO one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: ================================================== Source Prop... Each COOPERATING_ORGANIZATION Sometimes (50%) IS_INVOLVED_IN many PROJECT_COOP_ORG_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of PROJECT_COOP_ORG_ASSIGNMENT Description: Destination Prop... Each PROJECT_COOP_ORG_ASSIGNMENT Always (100%) INVOLVES one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_COOP_ORG_ASSIGNMENT is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: ================================================== Source Prop... Each COOPERATING_ORGANIZATION Sometimes (50%) COLLECTS many FIELD_ACTIVITY_COOP_ORG_ASGMNT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT Description: Destination Prop... Each FIELD_ACTIVITY_COOP_ORG_ASGMNT Always (100%) IS_COLLECTED_BY one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: ================================================== Entity Type: DATA_LINE Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 2500 Avg Occ: 10000 Max Occ: 250000 Growth Rate: 5% per year TD Name: TSRDLIN Relationship Properties: Source Prop... Each DATA_LINE Sometimes (85%) IS_DESCRIBED_USING many RESULT Cardinality Min: 10 (est) Max: 20 (est) Avg: 15 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DATA_LINE is deleted: Delete each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (100%) DESCRIBES one DATA_LINE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of DATA_LINE Description: ================================================== Source Prop... Each DATA_LINE Always (100%) IS_PART_OF one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DATA_LINE is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (45%) CONTAINS many DATA_LINE Cardinality Min: 1 (est) Max: 100 (est) Avg: 50 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of DATA_LINE Description: ================================================== Entity Type: DBMS_USER Subject area: REFERENCE_TABLES Properties:Persistent Open Min Occ: 200 Avg Occ: 300 Max Occ: 500 Growth Rate: 10% per year TD Name: TSMDBUSR Relationship Properties: Entity Type: DETECTION_QUANTITATION_LIMIT Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 1000 Max Occ: 10000 Growth Rate: 10% per year TD Name: TSRDQL Relationship Properties: Source Prop... Each DETECTION_QUANTITATION_LIMIT Always (100%) HAS one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DETECTION_QUANTITATION_LIMIT is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: Destination Prop... Each UNIT_OF_MEASURE Sometimes (50%) IS_FOR many DETECTION_QUANTITATION_LIMIT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of DETECTION_QUANTITATION_LIMIT Description: ================================================== Source Prop... Each DETECTION_QUANTITATION_LIMIT Always (100%) QUALIFIES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DETECTION_QUANTITATION_LIMIT is deleted: Disassociate each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) IS_QUALIFIED_BY one DETECTION_QUANTITATION_LIMIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of DETECTION_QUANTITATION_LIMIT Description: ================================================== Entity Type: ELECTRONIC_ADDRESS Subject area: ADDRESSES Properties:Persistent Open Min Occ: 5000 Avg Occ: 150000 Max Occ: 500000 Growth Rate: 5% per year TD Name: TSMEADDR Relationship Properties: Source Prop... Each ELECTRONIC_ADDRESS Sometimes (1%) IS_FOR one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (1%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: ================================================== Source Prop... Each ELECTRONIC_ADDRESS Sometimes (1%) IS_FOR one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of PERSON Description: Destination Prop... Each PERSON Sometimes (1%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: ================================================== Source Prop... Each ELECTRONIC_ADDRESS Sometimes (1%) IS_FOR one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (1%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: ================================================== Source Prop... Each ELECTRONIC_ADDRESS Sometimes (50%) IS_FOR one LABORATORY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of LABORATORY Description: Destination Prop... Each LABORATORY Sometimes (50%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: ================================================== Source Prop... Each ELECTRONIC_ADDRESS Sometimes (10%) IS_ASSIGNED_TO one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: Destination Prop... Each COOPERATING_ORGANIZATION Sometimes (25%) IS_ASSIGNED many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: ================================================== Entity Type: ELECTROSHOCK_OPERATION_DETAIL Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 4000 Avg Occ: 40000 Max Occ: 200000 Growth Rate: 5% per year TD Name: TSREOD Relationship Properties: Source Prop... Each ELECTROSHOCK_OPERATION_DETAIL Always (100%) PROVIDES_DETAIL_ABOUT one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTROSHOCK_OPERATION_DETAIL is deleted: Disassociate each occurrence of SAMPLE Description: Destination Prop... Each SAMPLE Sometimes (25%) IS_DESCRIBED_BY one ELECTROSHOCK_OPERATION_DETAIL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Delete each occurrence of ELECTROSHOCK_OPERATION_DETAIL Description: ================================================== Entity Type: ENTITY_INTERNAL_SYSTEM_NUMBER Subject area: REFERENCE_TABLES Properties:Persistent Open Min Occ: 50 Avg Occ: 75 Max Occ: 200 Growth Rate: 5% per year TD Name: TSMEISN Relationship Properties: Entity Type: ERROR_MESSAGES Subject area: REFERENCE_TABLES Properties:Persistent Open Min Occ: 200 Avg Occ: 500 Max Occ: 2000 Growth Rate: 15% per year TD Name: tsmermsg Relationship Properties: Entity Type: ESTUARY Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 200 Avg Occ: 500 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSMESTRY Relationship Properties: Source Prop... Each ESTUARY Sometimes (1%) IS_LOCATED_IN one ESTUARY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY is deleted: Disassociate each occurrence of ESTUARY Description: Destination Prop... Each ESTUARY Sometimes (5%) CONTAINS many ESTUARY Cardinality Min: 1 (est) Max: 2 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY is deleted: Disassociate each occurrence of ESTUARY Description: ================================================== Source Prop... Each ESTUARY Sometimes (5%) CONTAINS many ESTUARY Cardinality Min: 1 (est) Max: 2 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY is deleted: Disassociate each occurrence of ESTUARY Description: Destination Prop... Each ESTUARY Sometimes (1%) IS_LOCATED_IN one ESTUARY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY is deleted: Disassociate each occurrence of ESTUARY Description: ================================================== Source Prop... Each ESTUARY Sometimes (10%) CHARACTERIZES many ESTUARY_LOCATION Cardinality Min: 1 (est) Max: 10000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY is deleted: Disallow deletion of ESTUARY if there is one (or more) occurrence of ESTUARY_LOCATION Description: Destination Prop... Each ESTUARY_LOCATION Sometimes (80%) IS_CHARACTERIZED_BY one ESTUARY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY_LOCATION is deleted: Disassociate each occurrence of ESTUARY Description: ================================================== Entity Type: ESTUARY_LOCATION Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 3000 Avg Occ: 30000 Max Occ: 60000 Growth Rate: 5% per year TD Name: TSMESTLC Relationship Properties: Source Prop... Each ESTUARY_LOCATION Sometimes (80%) IS_CHARACTERIZED_BY one ESTUARY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY_LOCATION is deleted: Disassociate each occurrence of ESTUARY Description: Destination Prop... Each ESTUARY Sometimes (10%) CHARACTERIZES many ESTUARY_LOCATION Cardinality Min: 1 (est) Max: 10000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY is deleted: Disallow deletion of ESTUARY if there is one (or more) occurrence of ESTUARY_LOCATION Description: ================================================== Source Prop... Each ESTUARY_LOCATION Always (100%) CHARACTERIZES one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ESTUARY_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_CHARACTERIZED_BY one ESTUARY_LOCATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of ESTUARY_LOCATION Description: ================================================== Entity Type: EXTERNAL_REFERENCE_SCHEME Subject area: STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMERS Relationship Properties: Source Prop... Each EXTERNAL_REFERENCE_SCHEME Always (100%) IS_DEFINED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of EXTERNAL_REFERENCE_SCHEME is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (80%) DEFINES many EXTERNAL_REFERENCE_SCHEME Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of EXTERNAL_REFERENCE_SCHEME Description: ================================================== Source Prop... Each EXTERNAL_REFERENCE_SCHEME Sometimes (10%) REFERENCED_BY many REFERENCE_LABEL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of EXTERNAL_REFERENCE_SCHEME is deleted: Delete each occurrence of REFERENCE_LABEL Description: An External Reference Number Scheme identifies Sampling Stations by using an alternate reference to a permit, another system, etc. An External Reference Number Scheme may have several associated Station Reference Numbers. For example, the FRDS numbering scheme would have a different number for each drinking water station. This relationship is mandatory because a Scheme will not be stored unless it is referenced by a Station Reference Number. Destination Prop... Each REFERENCE_LABEL Always (100%) REFERENCES one EXTERNAL_REFERENCE_SCHEME Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of REFERENCE_LABEL is deleted: Disassociate each occurrence of EXTERNAL_REFERENCE_SCHEME Description: A Station Reference Number is an alternate reference that provides supplemental information to characterize a Sampling Station. This relationship provides the correct context for this reference by identifying the appropriate scheme, method, or plan, i.e., External Reference Number Scheme. For example, the NPDES Permit Program is an External Reference Number Scheme, and individual NPDES permit numbers are Station Reference Numbers. ================================================== Entity Type: FACILITY_NAICS_ASSIGNMENT Subject area: FACILITY_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 1000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSMFNA Relationship Properties: Source Prop... Each FACILITY_NAICS_ASSIGNMENT Always (100%) IS_DESCRIBED_BY one NAICS Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_NAICS_ASSIGNMENT is deleted: Disassociate each occurrence of NAICS Description: Destination Prop... Each NAICS Sometimes (30%) DESCRIBES many FACILITY_NAICS_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of NAICS is deleted: Delete each occurrence of FACILITY_NAICS_ASSIGNMENT Description: ================================================== Source Prop... Each FACILITY_NAICS_ASSIGNMENT Always (100%) DESCRIBES one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_NAICS_ASSIGNMENT is deleted: Disassociate each occurrence of FACILITY_STATION Description: Destination Prop... Each FACILITY_STATION Sometimes (30%) IS_DESCRIBED_BY many FACILITY_NAICS_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Delete each occurrence of FACILITY_NAICS_ASSIGNMENT Description: ================================================== Entity Type: FACILITY_SIC_ASSIGNMENT Subject area: FACILITY_STATIONS Properties:Persistent Open Min Occ: 0 Avg Occ: 1000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSMFSA Relationship Properties: Source Prop... Each FACILITY_SIC_ASSIGNMENT Always (100%) DESCRIBES one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_SIC_ASSIGNMENT is deleted: Disassociate each occurrence of FACILITY_STATION Description: Destination Prop... Each FACILITY_STATION Sometimes (50%) IS_DESCRIBED_BY many FACILITY_SIC_ASSIGNMENT Cardinality Min: 1 (est) Max: 50 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Delete each occurrence of FACILITY_SIC_ASSIGNMENT Description: ================================================== Source Prop... Each FACILITY_SIC_ASSIGNMENT Always (100%) IS_DESCRIBED_BY one STANDARD_INDUSTRIAL_CLASS Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_SIC_ASSIGNMENT is deleted: Disassociate each occurrence of STANDARD_INDUSTRIAL_CLASS Description: Destination Prop... Each STANDARD_INDUSTRIAL_CLASS Sometimes (30%) DESCRIBES many FACILITY_SIC_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STANDARD_INDUSTRIAL_CLASS is deleted: Delete each occurrence of FACILITY_SIC_ASSIGNMENT Description: ================================================== Entity Type: FACILITY_STATION Subject area: FACILITY_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMFCLTY Relationship Properties: Source Prop... Each FACILITY_STATION Always (100%) IS one STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (10%) CONSISTS one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of FACILITY_STATION Description: ================================================== Source Prop... Each FACILITY_STATION Sometimes (50%) HAS many PIPE Cardinality Min: 1 (est) Max: 1100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Delete each occurrence of PIPE Description: Destination Prop... Each PIPE Always (100%) IS_PART_OF one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PIPE is deleted: Disassociate each occurrence of FACILITY_STATION Description: ================================================== Source Prop... Each FACILITY_STATION Sometimes (50%) IS_DESCRIBED_BY many FACILITY_SIC_ASSIGNMENT Cardinality Min: 1 (est) Max: 50 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Delete each occurrence of FACILITY_SIC_ASSIGNMENT Description: Destination Prop... Each FACILITY_SIC_ASSIGNMENT Always (100%) DESCRIBES one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_SIC_ASSIGNMENT is deleted: Disassociate each occurrence of FACILITY_STATION Description: ================================================== Source Prop... Each FACILITY_STATION Sometimes (30%) IS_DESCRIBED_BY many FACILITY_NAICS_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Delete each occurrence of FACILITY_NAICS_ASSIGNMENT Description: Destination Prop... Each FACILITY_NAICS_ASSIGNMENT Always (100%) DESCRIBES one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_NAICS_ASSIGNMENT is deleted: Disassociate each occurrence of FACILITY_STATION Description: ================================================== Entity Type: FIELD_ACTIVITY Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 100000 Avg Occ: 1000000 Max Occ: 5000000 Growth Rate: 5% per year TD Name: TSRFDACT Relationship Properties: Source Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_GATHERED_BY one FIELD_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_PROCEDURE Description: Destination Prop... Each FIELD_PROCEDURE Sometimes (10%) GATHERS many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_PROCEDURE is deleted: Disallow deletion of FIELD_PROCEDURE if there is one (or more) occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_FURNISHED_BY one FIELD_GEAR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_GEAR Description: Destination Prop... Each FIELD_GEAR Sometimes (10%) FURNISHES many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_GEAR is deleted: Disallow deletion of FIELD_GEAR if there is one (or more) occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_FURNISHED_BY one GEAR_CONFIGURATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of GEAR_CONFIGURATION Description: Destination Prop... Each GEAR_CONFIGURATION Sometimes (10%) FURNISHES many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Disallow deletion of GEAR_CONFIGURATION if there is one (or more) occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (90%) IS_COLLECTED_BY many FIELD_ACTIVITY_COOP_ORG_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT Description: Destination Prop... Each FIELD_ACTIVITY_COOP_ORG_ASGMNT Always (100%) COLLECTS one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (90%) TAKES_PLACE_AT many ACTUAL_ACTIVITY_LOCATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of ACTUAL_ACTIVITY_LOCATION Description: Destination Prop... Each ACTUAL_ACTIVITY_LOCATION Always (100%) PLACES one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ACTUAL_ACTIVITY_LOCATION is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (50%) BELONGS_TO many FIELD_ACTIVITY_FIELD_SET_ASGNMT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT Description: Destination Prop... Each FIELD_ACTIVITY_FIELD_SET_ASGNMT Always (100%) HAS one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (10%) COMPOSITES_INTO one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY for which this is the last FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (15%) IS_COMPOSITED_FROM many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (15%) IS_COMPOSITED_FROM many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (10%) COMPOSITES_INTO one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY for which this is the last FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (88%) CONTAINS one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of SAMPLE Description: Destination Prop... Each SAMPLE Always (100%) IS_PART_OF one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (50%) HAS many FIELD_ACTIVITY_PROJECT_ASSGNMT Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT Description: Destination Prop... Each FIELD_ACTIVITY_PROJECT_ASSGNMT Always (100%) IS_FOR one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (90%) IS_COLLECTED_BY many FIELD_ACTIVITY_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 10 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT Description: Destination Prop... Each FIELD_ACTIVITY_PERSON_ASSIGNMENT Always (100%) COLLECTS one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_SPLIT_FROM one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (15%) IS_SPLIT_INTO many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (15%) IS_SPLIT_INTO many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_SPLIT_FROM one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (50%) IS_VALIDATED_BY many FIELD_ACTIVITY_QC_SAMPLE_ASGN Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN Description: Destination Prop... Each FIELD_ACTIVITY_QC_SAMPLE_ASGN Always (100%) VALIDATES one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (5%) OCCURS_DURING one STATION_VISIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of STATION_VISIT Description: Destination Prop... Each STATION_VISIT Sometimes (50%) RESULTS_IN many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION_VISIT is deleted: Delete each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (50%) HAS_AS_ITS_SUBJECT one BIOLOGICAL_PART Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of BIOLOGICAL_PART Description: Destination Prop... Each BIOLOGICAL_PART Sometimes (95%) IS_SUBJECT_OF many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_PART is deleted: Disallow deletion of BIOLOGICAL_PART if there is one (or more) occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (5%) HAS many BIOLOGICAL_RESULT_GROUP Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of BIOLOGICAL_RESULT_GROUP Description: Destination Prop... Each BIOLOGICAL_RESULT_GROUP Always (100%) IS_FOR one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (25%) HAS_A_SUBJECT_TAXON_OF one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of CHARACTERISTIC Description: Destination Prop... Each CHARACTERISTIC Sometimes (50%) IS_A_SUBJECT_TAXON_FOR many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (95%) YIELDS many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (50%) IS_YIELDED_FROM one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (45%) CONTAINS many DATA_LINE Cardinality Min: 1 (est) Max: 100 (est) Avg: 50 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of DATA_LINE Description: Destination Prop... Each DATA_LINE Always (100%) IS_PART_OF one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DATA_LINE is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (35%) DESCRIBED_BY one SAMPLE_MATRIX Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of SAMPLE_MATRIX Description: Destination Prop... Each SAMPLE_MATRIX Sometimes (95%) USED_TO_DESCRIBE many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE_MATRIX is deleted: Disallow deletion of SAMPLE_MATRIX if there is one (or more) occurrence of FIELD_ACTIVITY Description: ================================================== Source Prop... Each FIELD_ACTIVITY Sometimes (10%) OCCURS_WITHIN one OPERATING_PERIOD Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of OPERATING_PERIOD Description: Destination Prop... Each OPERATING_PERIOD Sometimes (10%) PRODUCES many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPERATING_PERIOD is deleted: Delete each occurrence of FIELD_ACTIVITY Description: ================================================== Entity Type: FIELD_ACTIVITY_COOP_ORG_ASGMNT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 100000 Avg Occ: 1000000 Max Occ: 5000000 Growth Rate: 2% per year TD Name: TSRFACOA Relationship Properties: Source Prop... Each FIELD_ACTIVITY_COOP_ORG_ASGMNT Always (100%) COLLECTS one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (90%) IS_COLLECTED_BY many FIELD_ACTIVITY_COOP_ORG_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT Description: ================================================== Source Prop... Each FIELD_ACTIVITY_COOP_ORG_ASGMNT Always (100%) IS_COLLECTED_BY one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: Destination Prop... Each COOPERATING_ORGANIZATION Sometimes (50%) COLLECTS many FIELD_ACTIVITY_COOP_ORG_ASGMNT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of FIELD_ACTIVITY_COOP_ORG_ASGMNT Description: ================================================== Entity Type: FIELD_ACTIVITY_FIELD_SET_ASGNMT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 7500 Avg Occ: 50000 Max Occ: 150000 Growth Rate: 5% per year TD Name: TSRFAFSA Relationship Properties: Source Prop... Each FIELD_ACTIVITY_FIELD_SET_ASGNMT Always (100%) HAS one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (50%) BELONGS_TO many FIELD_ACTIVITY_FIELD_SET_ASGNMT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT Description: ================================================== Source Prop... Each FIELD_ACTIVITY_FIELD_SET_ASGNMT Always (100%) BELONGS_TO one FIELD_SET Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT is deleted: Disassociate each occurrence of FIELD_SET Description: Destination Prop... Each FIELD_SET Sometimes (50%) HAS many FIELD_ACTIVITY_FIELD_SET_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_SET is deleted: Delete each occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT Description: ================================================== Entity Type: FIELD_ACTIVITY_PERSON_ASSIGNMENT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 100000 Avg Occ: 1000000 Max Occ: 5000000 Growth Rate: 5% per year TD Name: TSRFAPEA Relationship Properties: Source Prop... Each FIELD_ACTIVITY_PERSON_ASSIGNMENT Always (100%) COLLECTS one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (90%) IS_COLLECTED_BY many FIELD_ACTIVITY_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 10 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT Description: ================================================== Source Prop... Each FIELD_ACTIVITY_PERSON_ASSIGNMENT Always (100%) IS_COLLECTED_BY one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON Description: Destination Prop... Each PERSON Sometimes (50%) COLLECTS many FIELD_ACTIVITY_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT Description: ================================================== Entity Type: FIELD_ACTIVITY_PROJECT_ASSGNMT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 50000 Avg Occ: 500000 Max Occ: 1000000 Growth Rate: 5% per year TD Name: TSRFAPRA Relationship Properties: Source Prop... Each FIELD_ACTIVITY_PROJECT_ASSGNMT Always (100%) IS_FOR one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (50%) HAS many FIELD_ACTIVITY_PROJECT_ASSGNMT Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT Description: ================================================== Source Prop... Each FIELD_ACTIVITY_PROJECT_ASSGNMT Always (100%) IS_FOR one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (50%) HAS many FIELD_ACTIVITY_PROJECT_ASSGNMT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Do not display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT Description: ================================================== Entity Type: FIELD_ACTIVITY_QC_SAMPLE_ASGN Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 50000 Avg Occ: 500000 Max Occ: 1000000 Growth Rate: 5% per year TD Name: TSRFAQSA Relationship Properties: Source Prop... Each FIELD_ACTIVITY_QC_SAMPLE_ASGN Always (100%) VALIDATES one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (50%) IS_VALIDATED_BY many FIELD_ACTIVITY_QC_SAMPLE_ASGN Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN Description: ================================================== Source Prop... Each FIELD_ACTIVITY_QC_SAMPLE_ASGN Always (100%) HAS_CHECK_PROVIDED_BY one FIELD_QC_SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN is deleted: Disassociate each occurrence of FIELD_QC_SAMPLE Description: Destination Prop... Each FIELD_QC_SAMPLE Sometimes (50%) PROVIDES_CHECK_FOR many FIELD_ACTIVITY_QC_SAMPLE_ASGN Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Delete each occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN Description: ================================================== Entity Type: FIELD_GEAR Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 500 Avg Occ: 10000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSRFLDGR Relationship Properties: Source Prop... Each FIELD_GEAR Sometimes (10%) FURNISHES many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_GEAR is deleted: Disallow deletion of FIELD_GEAR if there is one (or more) occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_FURNISHED_BY one FIELD_GEAR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_GEAR Description: ================================================== Source Prop... Each FIELD_GEAR Sometimes (50%) IS_DESCRIBED_BY many GEAR_CONFIGURATION Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_GEAR is deleted: Delete each occurrence of GEAR_CONFIGURATION Description: Destination Prop... Each GEAR_CONFIGURATION Always (100%) DESCRIBES one FIELD_GEAR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Disassociate each occurrence of FIELD_GEAR Description: ================================================== Entity Type: FIELD_PROCEDURE Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 500 Avg Occ: 10000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSRFLDPR Relationship Properties: Source Prop... Each FIELD_PROCEDURE Sometimes (10%) GATHERS many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_PROCEDURE is deleted: Disallow deletion of FIELD_PROCEDURE if there is one (or more) occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_GATHERED_BY one FIELD_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of FIELD_PROCEDURE Description: ================================================== Source Prop... Each FIELD_PROCEDURE Sometimes (90%) IS_DEFINED_IN one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_PROCEDURE is deleted: Disassociate each occurrence of CITATION Description: Destination Prop... Each CITATION Sometimes (50%) CONTAINS many FIELD_PROCEDURE Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of FIELD_PROCEDURE Description: ================================================== Source Prop... Each FIELD_PROCEDURE Always (100%) IS_DEFINED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_PROCEDURE is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (90%) DEFINES many FIELD_PROCEDURE Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of FIELD_PROCEDURE Description: ================================================== Entity Type: FIELD_QC_SAMPLE Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 15000 Avg Occ: 150000 Max Occ: 800000 Growth Rate: 5% per year TD Name: TSRFQS Relationship Properties: Source Prop... Each FIELD_QC_SAMPLE Sometimes (50%) PROVIDES_CHECK_FOR many FIELD_ACTIVITY_QC_SAMPLE_ASGN Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Delete each occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN Description: Destination Prop... Each FIELD_ACTIVITY_QC_SAMPLE_ASGN Always (100%) HAS_CHECK_PROVIDED_BY one FIELD_QC_SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_QC_SAMPLE_ASGN is deleted: Disassociate each occurrence of FIELD_QC_SAMPLE Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE Sometimes (90%) HAS many FIELD_QC_SAMPLE_PERSON_ASGNMT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Delete each occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT Description: Destination Prop... Each FIELD_QC_SAMPLE_PERSON_ASGNMT Always (100%) IS_FOR one FIELD_QC_SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT is deleted: Disassociate each occurrence of FIELD_QC_SAMPLE Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE Always (100%) IS_CREATED_FOR one TRIP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Disassociate each occurrence of TRIP Description: Destination Prop... Each TRIP Sometimes (50%) HAS many FIELD_QC_SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Delete each occurrence of FIELD_QC_SAMPLE Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE Sometimes (5%) HAS many RESULT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Delete each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) IS_FOR one FIELD_QC_SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of FIELD_QC_SAMPLE Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many FIELD_QC_SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many FIELD_QC_SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE Description: ================================================== Entity Type: FIELD_QC_SAMPLE_DEFAULT_PROFILE Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 1500 Avg Occ: 15000 Max Occ: 50000 Growth Rate: 5% per year TD Name: TSRFQSDP Relationship Properties: Source Prop... Each FIELD_QC_SAMPLE_DEFAULT_PROFILE Always (100%) IS_OWNED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (90%) DEFINES many FIELD_QC_SAMPLE_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE_DEFAULT_PROFILE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many FIELD_QC_SAMPLE_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE_DEFAULT_PROFILE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many FIELD_QC_SAMPLE_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE Description: ================================================== Entity Type: FIELD_QC_SAMPLE_PERSON_ASGNMT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 30000 Avg Occ: 150000 Max Occ: 1500000 Growth Rate: 5% per year TD Name: TSRFQSPA Relationship Properties: Source Prop... Each FIELD_QC_SAMPLE_PERSON_ASGNMT Always (100%) IS_FOR one FIELD_QC_SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT is deleted: Disassociate each occurrence of FIELD_QC_SAMPLE Description: Destination Prop... Each FIELD_QC_SAMPLE Sometimes (90%) HAS many FIELD_QC_SAMPLE_PERSON_ASGNMT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Delete each occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT Description: ================================================== Source Prop... Each FIELD_QC_SAMPLE_PERSON_ASGNMT Always (100%) IS_FOR one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT is deleted: Disassociate each occurrence of PERSON Description: Destination Prop... Each PERSON Sometimes (50%) HAS many FIELD_QC_SAMPLE_PERSON_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT Description: ================================================== Entity Type: FIELD_SET Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 10000 Avg Occ: 500000 Max Occ: 1000000 Growth Rate: 5% per year TD Name: TSRFDSET Relationship Properties: Source Prop... Each FIELD_SET Sometimes (50%) HAS many FIELD_ACTIVITY_FIELD_SET_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_SET is deleted: Delete each occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT Description: Destination Prop... Each FIELD_ACTIVITY_FIELD_SET_ASGNMT Always (100%) BELONGS_TO one FIELD_SET Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_FIELD_SET_ASGNMT is deleted: Disassociate each occurrence of FIELD_SET Description: ================================================== Source Prop... Each FIELD_SET Always (100%) IS_DEFINED_BY one STATION_VISIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_SET is deleted: Disassociate each occurrence of STATION_VISIT Description: Destination Prop... Each STATION_VISIT Sometimes (50%) DEFINES many FIELD_SET Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION_VISIT is deleted: Delete each occurrence of FIELD_SET Description: ================================================== Entity Type: FILL Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMFILL Relationship Properties: Source Prop... Each FILL Always (100%) IS_USED_IN one INTERVAL Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of FILL is deleted: Disassociate each occurrence of INTERVAL Description: Destination Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one FILL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of FILL Description: ================================================== Entity Type: FIPS_HYDROLOGIC_UNIT Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 3000 Avg Occ: 3000 Max Occ: 3000 Growth Rate: 10% per year TD Name: TSMFHU Relationship Properties: Source Prop... Each FIPS_HYDROLOGIC_UNIT Sometimes (10%) CHARACTERIZES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of FIPS_HYDROLOGIC_UNIT is deleted: Disallow deletion of FIPS_HYDROLOGIC_UNIT if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_ASSOCIATED_WITH one FIPS_HYDROLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of FIPS_HYDROLOGIC_UNIT Description: ================================================== Entity Type: GEAR_CONFIGURATION Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 1000 Avg Occ: 20000 Max Occ: 200000 Growth Rate: 5% per year TD Name: TSRGRCFG Relationship Properties: Source Prop... Each GEAR_CONFIGURATION Sometimes (10%) FURNISHES many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Disallow deletion of GEAR_CONFIGURATION if there is one (or more) occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (10%) IS_FURNISHED_BY one GEAR_CONFIGURATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of GEAR_CONFIGURATION Description: ================================================== Source Prop... Each GEAR_CONFIGURATION Always (100%) DESCRIBES one FIELD_GEAR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Disassociate each occurrence of FIELD_GEAR Description: Destination Prop... Each FIELD_GEAR Sometimes (50%) IS_DESCRIBED_BY many GEAR_CONFIGURATION Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_GEAR is deleted: Delete each occurrence of GEAR_CONFIGURATION Description: ================================================== Source Prop... Each GEAR_CONFIGURATION Always (100%) IS_DEFINED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (50%) DEFINES many GEAR_CONFIGURATION Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of GEAR_CONFIGURATION Description: ================================================== Source Prop... Each GEAR_CONFIGURATION Sometimes (5%) IS_DESCRIBED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 5 (est) Avg: 4 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Delete each occurrence of GENERIC_TEXT Description: Destination Prop... Each GENERIC_TEXT Sometimes (5%) DESCRIBES one GEAR_CONFIGURATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of GEAR_CONFIGURATION Description: ================================================== Entity Type: GENERIC_TEXT Subject area: REFERENCE_TABLES Properties:Persistent Open Min Occ: 100 Avg Occ: 2000 Max Occ: 300000 Growth Rate: 10% per year TD Name: TSMGNTXT Relationship Properties: Source Prop... Each GENERIC_TEXT Sometimes (5%) DEFINES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (1%) IS_DEFINED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of GENERIC_TEXT Description: ================================================== Source Prop... Each GENERIC_TEXT Sometimes (5%) DESCRIBES one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (5%) IS_DESCRIBED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 5 (est) Avg: 4 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of GENERIC_TEXT Description: ================================================== Source Prop... Each GENERIC_TEXT Sometimes (5%) DESCRIBES one PROGRAM Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of PROGRAM Description: Destination Prop... Each PROGRAM Sometimes (5%) IS_DESCRIBED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROGRAM is deleted: Delete each occurrence of GENERIC_TEXT Description: ================================================== Source Prop... Each GENERIC_TEXT Sometimes (5%) DESCRIBES one GEAR_CONFIGURATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of GEAR_CONFIGURATION Description: Destination Prop... Each GEAR_CONFIGURATION Sometimes (5%) IS_DESCRIBED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 5 (est) Avg: 4 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Delete each occurrence of GENERIC_TEXT Description: ================================================== Entity Type: GEOLOGIC_UNIT Subject area: STATIONS Properties:Persistent Open Min Occ: 5000 Avg Occ: 10000 Max Occ: 13000 Growth Rate: 10% per year TD Name: TSMGEOUN Relationship Properties: Source Prop... Each GEOLOGIC_UNIT Sometimes (5%) DESCRIBES many SPRING_STATION Cardinality Min: 1 (est) Max: 10 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEOLOGIC_UNIT is deleted: Disallow deletion of GEOLOGIC_UNIT if there is one (or more) occurrence of SPRING_STATION Description: Destination Prop... Each SPRING_STATION Sometimes (15%) IS_DESCRIBED_BY one GEOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SPRING_STATION is deleted: Disassociate each occurrence of GEOLOGIC_UNIT Description: ================================================== Source Prop... Each GEOLOGIC_UNIT Sometimes (50%) DESCRIBES many INTERVAL_GEOL_UNIT_ASGMNT Cardinality Min: 1 (est) Max: 100 (est) Avg: 50 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEOLOGIC_UNIT is deleted: Delete each occurrence of INTERVAL_GEOL_UNIT_ASGMNT Description: Destination Prop... Each INTERVAL_GEOL_UNIT_ASGMNT Always (100%) IS_DESCRIBED_BY one GEOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL_GEOL_UNIT_ASGMNT is deleted: Disassociate each occurrence of GEOLOGIC_UNIT Description: ================================================== Entity Type: GEOPOLITICAL_AREA Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 4000 Avg Occ: 4000 Max Occ: 4000 Growth Rate: 10% per year TD Name: TSMGEOPA Relationship Properties: Source Prop... Each GEOPOLITICAL_AREA Sometimes (10%) PRIMARILY_LOCATES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of GEOPOLITICAL_AREA is deleted: Disallow deletion of GEOPOLITICAL_AREA if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (75%) IS_PRIMARILY_LOCATED_BY one GEOPOLITICAL_AREA Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of GEOPOLITICAL_AREA Description: ================================================== Source Prop... Each GEOPOLITICAL_AREA Sometimes (10%) SECONDARILY_LOCATES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEOPOLITICAL_AREA is deleted: Disallow deletion of GEOPOLITICAL_AREA if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (30%) IS_SECONDARILY_LOCATED_BY one GEOPOLITICAL_AREA Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of GEOPOLITICAL_AREA Description: ================================================== Entity Type: GREAT_LAKE_LOCATION Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 3000 Avg Occ: 30000 Max Occ: 60000 Growth Rate: 5% per year TD Name: TSMGLL Relationship Properties: Source Prop... Each GREAT_LAKE_LOCATION Always (100%) CHARACTERIZES one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GREAT_LAKE_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_CHARACTERIZED_BY one GREAT_LAKE_LOCATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of GREAT_LAKE_LOCATION Description: ================================================== Entity Type: HABITAT_CLASS_SCHEME_CHAR Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 60000 Avg Occ: 300000 Max Occ: 3000000 Growth Rate: 5% per year TD Name: TSRHCSC Relationship Properties: Source Prop... Each HABITAT_CLASS_SCHEME_CHAR Always (100%) EVALUATES one CHARACTERISTIC_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of HABITAT_CLASS_SCHEME_CHAR is deleted: Disassociate each occurrence of CHARACTERISTIC_GROUP Description: Destination Prop... Each CHARACTERISTIC_GROUP Sometimes (10%) IS_EVALUATED_USING many HABITAT_CLASS_SCHEME_CHAR Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Delete each occurrence of HABITAT_CLASS_SCHEME_CHAR Description: ================================================== Source Prop... Each HABITAT_CLASS_SCHEME_CHAR Sometimes (10%) HAS many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of HABITAT_CLASS_SCHEME_CHAR is deleted: Disallow deletion of HABITAT_CLASS_SCHEME_CHAR if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (40%) IS_FOR one HABITAT_CLASS_SCHEME_CHAR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of HABITAT_CLASS_SCHEME_CHAR Description: ================================================== Entity Type: HOLE Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMHOLE Relationship Properties: Source Prop... Each HOLE Always (100%) IS one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of HOLE is deleted: Disassociate each occurrence of INTERVAL Description: Destination Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one HOLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of HOLE Description: ================================================== Entity Type: INTERVAL Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMINTVL Relationship Properties: Source Prop... Each INTERVAL Sometimes (5%) IS_DEFINED_BY one INTERVAL_GEOL_UNIT_ASGMNT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of INTERVAL_GEOL_UNIT_ASGMNT Description: Destination Prop... Each INTERVAL_GEOL_UNIT_ASGMNT Always (100%) FURTHER_DEFINES one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL_GEOL_UNIT_ASGMNT is deleted: Disassociate each occurrence of INTERVAL Description: ================================================== Source Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one HOLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of HOLE Description: Destination Prop... Each HOLE Always (100%) IS one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of HOLE is deleted: Disassociate each occurrence of INTERVAL Description: ================================================== Source Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one LITHOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Disassociate each occurrence of LITHOLOGIC_UNIT Description: Destination Prop... Each LITHOLOGIC_UNIT Sometimes (10%) IS_USED_IN many INTERVAL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of LITHOLOGIC_UNIT is deleted: Disallow deletion of LITHOLOGIC_UNIT if there is one (or more) occurrence of INTERVAL Description: ================================================== Source Prop... Each INTERVAL Always (100%) PARTITIONS one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Disassociate each occurrence of WELL_STATION Description: Destination Prop... Each WELL_STATION Sometimes (10%) IS_PARTITIONED_INTO many INTERVAL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of INTERVAL Description: ================================================== Source Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one CASING Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of CASING Description: Destination Prop... Each CASING Always (100%) IS_USED_IN one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CASING is deleted: Disassociate each occurrence of INTERVAL Description: ================================================== Source Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one FILL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of FILL Description: Destination Prop... Each FILL Always (100%) IS_USED_IN one INTERVAL Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of FILL is deleted: Disassociate each occurrence of INTERVAL Description: ================================================== Source Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one OPENING Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of OPENING Description: Destination Prop... Each OPENING Always (100%) IS one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPENING is deleted: Disassociate each occurrence of INTERVAL Description: ================================================== Entity Type: INTERVAL_GEOL_UNIT_ASGMNT Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 10000 Avg Occ: 15000 Max Occ: 20000 Growth Rate: 5% per year TD Name: TSMIGUA Relationship Properties: Source Prop... Each INTERVAL_GEOL_UNIT_ASGMNT Always (100%) FURTHER_DEFINES one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL_GEOL_UNIT_ASGMNT is deleted: Disassociate each occurrence of INTERVAL Description: Destination Prop... Each INTERVAL Sometimes (5%) IS_DEFINED_BY one INTERVAL_GEOL_UNIT_ASGMNT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of INTERVAL_GEOL_UNIT_ASGMNT Description: ================================================== Source Prop... Each INTERVAL_GEOL_UNIT_ASGMNT Always (100%) IS_DESCRIBED_BY one GEOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL_GEOL_UNIT_ASGMNT is deleted: Disassociate each occurrence of GEOLOGIC_UNIT Description: Destination Prop... Each GEOLOGIC_UNIT Sometimes (50%) DESCRIBES many INTERVAL_GEOL_UNIT_ASGMNT Cardinality Min: 1 (est) Max: 100 (est) Avg: 50 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEOLOGIC_UNIT is deleted: Delete each occurrence of INTERVAL_GEOL_UNIT_ASGMNT Description: ================================================== Entity Type: LABORATORY Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 200 Max Occ: 1000 Growth Rate: 10% per year TD Name: TSRLAB Relationship Properties: Source Prop... Each LABORATORY Sometimes (80%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 10 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Delete each occurrence of ADDRESS Description: Destination Prop... Each ADDRESS Sometimes (80%) IS_ASSIGNED_TO one LABORATORY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of LABORATORY Description: ================================================== Source Prop... Each LABORATORY Sometimes (50%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: Destination Prop... Each ELECTRONIC_ADDRESS Sometimes (50%) IS_FOR one LABORATORY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of LABORATORY Description: ================================================== Source Prop... Each LABORATORY Always (100%) IS_IDENTIFIED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (5%) IDENTIFIES many LABORATORY Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of LABORATORY Description: ================================================== Source Prop... Each LABORATORY Sometimes (20%) PRODUCES many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Disallow deletion of LABORATORY if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (75%) IS_PRODUCED_IN one LABORATORY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of LABORATORY Description: ================================================== Entity Type: LAB_REMARK Subject area: RESULTS Properties:Persistent Open Min Occ: 10 Avg Occ: 50 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSRLBRMK Relationship Properties: Source Prop... Each LAB_REMARK Sometimes (50%) QUALIFIES_A_RESULT_USING many RESULT_LAB_REMARK_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_REMARK is deleted: Disallow deletion of LAB_REMARK if there is one (or more) occurrence of RESULT_LAB_REMARK_ASGNMT Description: Destination Prop... Each RESULT_LAB_REMARK_ASGNMT Always (100%) QUALIFIES_A_RESULT_WITH one LAB_REMARK Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_LAB_REMARK_ASGNMT is deleted: Disassociate each occurrence of LAB_REMARK Description: ================================================== Entity Type: LAB_SAMPLE_PREP_PROCEDURE Subject area: ANALYTICAL_PROCEDURES Properties:Persistent Open Min Occ: 100 Avg Occ: 500 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSRLSPP Relationship Properties: Source Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (50%) IS_DESCRIBED_BY one CITATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Disassociate each occurrence of CITATION Description: Destination Prop... Each CITATION Sometimes (50%) DESCRIBES many LAB_SAMPLE_PREP_PROCEDURE Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disallow deletion of CITATION if there is one (or more) occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: ================================================== Source Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (50%) IS_USED_TO_MAKE many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Disallow deletion of LAB_SAMPLE_PREP_PROCEDURE if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (85%) IS_MADE_BY one LAB_SAMPLE_PREP_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: ================================================== Source Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (5%) IS_ASSIGNED_TO many ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Delete each occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Description: Destination Prop... Each ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Always (100%) ASSIGNS one LAB_SAMPLE_PREP_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT is deleted: Disassociate each occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: ================================================== Source Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (5%) DESCRIBES many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Disassociate each occurrence of CHARACTERISTIC_DEFAULT Description: Destination Prop... Each CHARACTERISTIC_DEFAULT Sometimes (5%) IS_DESCRIBED_BY one LAB_SAMPLE_PREP_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: ================================================== Entity Type: LITHOLOGIC_UNIT Subject area: STATIONS Properties:Persistent Open Min Occ: 5000 Avg Occ: 10000 Max Occ: 13000 Growth Rate: 10% per year TD Name: TSMLTHUN Relationship Properties: Source Prop... Each LITHOLOGIC_UNIT Sometimes (5%) DESCRIBES many SPRING_STATION Cardinality Min: 1 (est) Max: 10 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LITHOLOGIC_UNIT is deleted: Disallow deletion of LITHOLOGIC_UNIT if there is one (or more) occurrence of SPRING_STATION Description: Destination Prop... Each SPRING_STATION Sometimes (15%) IS_DESCRIBED_BY one LITHOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SPRING_STATION is deleted: Disassociate each occurrence of LITHOLOGIC_UNIT Description: ================================================== Source Prop... Each LITHOLOGIC_UNIT Sometimes (10%) IS_USED_IN many INTERVAL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of LITHOLOGIC_UNIT is deleted: Disallow deletion of LITHOLOGIC_UNIT if there is one (or more) occurrence of INTERVAL Description: Destination Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one LITHOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Disassociate each occurrence of LITHOLOGIC_UNIT Description: ================================================== Entity Type: LOG Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMLOG Relationship Properties: Source Prop... Each LOG Always (100%) DESCRIBES_CONSTRUCTION_OF one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LOG is deleted: Disassociate each occurrence of WELL_STATION Description: Destination Prop... Each WELL_STATION Sometimes (10%) IS_DESCRIBED_BY many LOG Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of LOG Description: ================================================== Entity Type: METHOD_AND_DATUM Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 500 Avg Occ: 750 Max Occ: 1500 Growth Rate: 10% per year TD Name: TSMMAD Relationship Properties: Entity Type: NAICS Subject area: FACILITY_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 500 Max Occ: 5000 Growth Rate: 5% per year TD Name: TSMNAICS Relationship Properties: Source Prop... Each NAICS Sometimes (30%) DESCRIBES many FACILITY_NAICS_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of NAICS is deleted: Delete each occurrence of FACILITY_NAICS_ASSIGNMENT Description: Destination Prop... Each FACILITY_NAICS_ASSIGNMENT Always (100%) IS_DESCRIBED_BY one NAICS Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_NAICS_ASSIGNMENT is deleted: Disassociate each occurrence of NAICS Description: ================================================== Entity Type: NATIVE_AMERICAN_LAND Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 1000 Avg Occ: 1000 Max Occ: 1000 Growth Rate: 10% per year TD Name: TSMNAL Relationship Properties: Source Prop... Each NATIVE_AMERICAN_LAND Sometimes (10%) CHARACTERIZES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of NATIVE_AMERICAN_LAND is deleted: Disallow deletion of NATIVE_AMERICAN_LAND if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_ASSOCIATED_WITH one NATIVE_AMERICAN_LAND Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of NATIVE_AMERICAN_LAND Description: ================================================== Entity Type: OCEAN_LOCATION Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 3000 Avg Occ: 30000 Max Occ: 60000 Growth Rate: 10% per year TD Name: TSMOCNLC Relationship Properties: Source Prop... Each OCEAN_LOCATION Always (100%) CHARACTERIZES one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OCEAN_LOCATION is deleted: Disassociate each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_CHARACTERIZED_BY one OCEAN_LOCATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Delete each occurrence of OCEAN_LOCATION Description: ================================================== Entity Type: OPENING Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMOPNG Relationship Properties: Source Prop... Each OPENING Always (100%) IS one INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPENING is deleted: Disassociate each occurrence of INTERVAL Description: Destination Prop... Each INTERVAL Sometimes (10%) CONSISTS_OF one OPENING Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of INTERVAL is deleted: Delete each occurrence of OPENING Description: ================================================== Entity Type: OPERATING_PERIOD Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 5000 Avg Occ: 150000 Max Occ: 500000 Growth Rate: 5% per year TD Name: TSROPPRD Relationship Properties: Source Prop... Each OPERATING_PERIOD Sometimes (10%) PRODUCES many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPERATING_PERIOD is deleted: Delete each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (10%) OCCURS_WITHIN one OPERATING_PERIOD Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of OPERATING_PERIOD Description: ================================================== Source Prop... Each OPERATING_PERIOD Always (100%) IS_MONITORED_BY one AUTOMATED_DATA_LOGGER Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPERATING_PERIOD is deleted: Disassociate each occurrence of AUTOMATED_DATA_LOGGER Description: Destination Prop... Each AUTOMATED_DATA_LOGGER Sometimes (80%) LOGS_DATA_WITHIN many OPERATING_PERIOD Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of AUTOMATED_DATA_LOGGER is deleted: Delete each occurrence of OPERATING_PERIOD Description: ================================================== Source Prop... Each OPERATING_PERIOD Sometimes (10%) PARTICIPATES_IN many PROJECT_OPERATING_PERIOD_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPERATING_PERIOD is deleted: Delete each occurrence of PROJECT_OPERATING_PERIOD_ASGMNT Description: Destination Prop... Each PROJECT_OPERATING_PERIOD_ASGMNT Always (100%) LINKS_A_PROJECT_TO one OPERATING_PERIOD Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_OPERATING_PERIOD_ASGMNT is deleted: Disassociate each occurrence of OPERATING_PERIOD Description: ================================================== Entity Type: ORGANIZATION Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 2000 Avg Occ: 10000 Max Occ: 100000 Growth Rate: 10% per year TD Name: TSMORGAN Relationship Properties: Source Prop... Each ORGANIZATION Sometimes (80%) DEFINES many EXTERNAL_REFERENCE_SCHEME Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of EXTERNAL_REFERENCE_SCHEME Description: Destination Prop... Each EXTERNAL_REFERENCE_SCHEME Always (100%) IS_DEFINED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of EXTERNAL_REFERENCE_SCHEME is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (1%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 3 (est) Avg: 1 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Delete each occurrence of ADDRESS Description: Destination Prop... Each ADDRESS Sometimes (1%) IS_ASSIGNED_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (1%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: Destination Prop... Each ELECTRONIC_ADDRESS Sometimes (1%) IS_FOR one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (1%) HAS many PERSON Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of PERSON Description: Destination Prop... Each PERSON Always (100%) IS_PART_OF one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (1%) SPONSORS many PROGRAM Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of PROGRAM Description: An Organization may sponsor many regulatory or non-regulatory Programs. This relationship is optional because Organizations play different roles. An Organization might not sponsor a Program if, for example, that Organization conducts Station Visits or defines a Sampling Procedure. Destination Prop... Each PROGRAM Always (100%) SPONSORED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROGRAM is deleted: Disassociate each occurrence of ORGANIZATION Description: This relationship identifies the Organization that sponsors a particular regulatory or non-regulatory program. For example, EPA sponsors the non-regulatory National Estuary Program and the regulatory 403(c) program. ================================================== Source Prop... Each ORGANIZATION Sometimes (50%) IS_ASSISTED_BY many COOPERATING_ORGANIZATION Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Delete each occurrence of COOPERATING_ORGANIZATION Description: Destination Prop... Each COOPERATING_ORGANIZATION Always (100%) ASSISTS one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (5%) ASSIGNS many ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Description: Destination Prop... Each ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Always (100%) IS_ASSIGNED_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (90%) DEFINES many FIELD_QC_SAMPLE_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE Description: Destination Prop... Each FIELD_QC_SAMPLE_DEFAULT_PROFILE Always (100%) IS_OWNED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (5%) IS_ACCESSIBLE_BY many USER_ORGANIZATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of USER_ORGANIZATION_ASSIGNMENT Description: Destination Prop... Each USER_ORGANIZATION_ASSIGNMENT Always (100%) ESTABLISHES_ACCESS_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of USER_ORGANIZATION_ASSIGNMENT is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (20%) REFERENCES many CITATION Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of CITATION Description: Destination Prop... Each CITATION Always (100%) IS_REFERENCED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (90%) DEFINES many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: Destination Prop... Each SAMPLING_DEFAULT_PROFILE Always (100%) IS_OWNED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (90%) DEFINES many FIELD_PROCEDURE Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of FIELD_PROCEDURE Description: Destination Prop... Each FIELD_PROCEDURE Always (100%) IS_DEFINED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_PROCEDURE is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (50%) DEFINES many GEAR_CONFIGURATION Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of GEAR_CONFIGURATION Description: Destination Prop... Each GEAR_CONFIGURATION Always (100%) IS_DEFINED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEAR_CONFIGURATION is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (50%) ESTABLISHES_AND_CONTROLS many CHARACTERISTIC_GROUP Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of CHARACTERISTIC_GROUP Description: Destination Prop... Each CHARACTERISTIC_GROUP Always (100%) IS_ESTABLISHED_AND_CONTROLLED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_GROUP is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (5%) IDENTIFIES many LABORATORY Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of LABORATORY Description: Destination Prop... Each LABORATORY Always (100%) IS_IDENTIFIED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (5%) ASSIGNS many ORG_ANALYTICAL_PROCEDURE_ASGMT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT Description: Destination Prop... Each ORG_ANALYTICAL_PROCEDURE_ASGMT Always (100%) IS_ASSIGNED_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (10%) ESTABLISHES many STATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of STATION Description: Destination Prop... Each STATION Always (100%) IS_ESTABLISHED_BY one ORGANIZATION Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (10%) IS_RESPONSIBLE_FOR many PROJECT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of PROJECT Description: Destination Prop... Each PROJECT Always (100%) IS_THE_RESPONSIBILITY_OF one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Source Prop... Each ORGANIZATION Sometimes (50%) SPONSORS many TRIP Cardinality Min: 1 (est) Max: 1000000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of TRIP Description: Destination Prop... Each TRIP Always (100%) SPONSORED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Disassociate each occurrence of ORGANIZATION Description: ================================================== Entity Type: ORG_ANALYTICAL_PROCEDURE_ASGMT Subject area: ANALYTICAL_PROCEDURES Properties:Persistent Open Min Occ: 5000 Avg Occ: 15000 Max Occ: 30000 Growth Rate: 5% per year TD Name: TSROAPA Relationship Properties: Source Prop... Each ORG_ANALYTICAL_PROCEDURE_ASGMT Always (100%) ASSIGNS one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: Destination Prop... Each ANALYTICAL_PROCEDURE Sometimes (5%) IS_ASSIGNED_TO many ORG_ANALYTICAL_PROCEDURE_ASGMT Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Delete each occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT Description: ================================================== Source Prop... Each ORG_ANALYTICAL_PROCEDURE_ASGMT Sometimes (5%) ACCEPTS many ORG_ANA_PROC_CHAR_ASGNMT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT is deleted: Delete each occurrence of ORG_ANA_PROC_CHAR_ASGNMT Description: Destination Prop... Each ORG_ANA_PROC_CHAR_ASGNMT Always (100%) IS_ACCEPTED_FOR one ORG_ANALYTICAL_PROCEDURE_ASGMT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANA_PROC_CHAR_ASGNMT is deleted: Disassociate each occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT Description: ================================================== Source Prop... Each ORG_ANALYTICAL_PROCEDURE_ASGMT Always (100%) IS_ASSIGNED_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (5%) ASSIGNS many ORG_ANALYTICAL_PROCEDURE_ASGMT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT Description: ================================================== Entity Type: ORG_ANA_PROC_CHAR_ASGNMT Subject area: CHARACTERISTICS Properties:Persistent Open Min Occ: 50000 Avg Occ: 100000 Max Occ: 150000 Growth Rate: 5% per year TD Name: TSROAPCA Relationship Properties: Source Prop... Each ORG_ANA_PROC_CHAR_ASGNMT Always (100%) ACCEPTS one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANA_PROC_CHAR_ASGNMT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: Destination Prop... Each CHARACTERISTIC Sometimes (50%) IS_ACCEPTED_FOR many ORG_ANA_PROC_CHAR_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of ORG_ANA_PROC_CHAR_ASGNMT Description: ================================================== Source Prop... Each ORG_ANA_PROC_CHAR_ASGNMT Always (100%) IS_ACCEPTED_FOR one ORG_ANALYTICAL_PROCEDURE_ASGMT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANA_PROC_CHAR_ASGNMT is deleted: Disassociate each occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT Description: Destination Prop... Each ORG_ANALYTICAL_PROCEDURE_ASGMT Sometimes (5%) ACCEPTS many ORG_ANA_PROC_CHAR_ASGNMT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_ANALYTICAL_PROCEDURE_ASGMT is deleted: Delete each occurrence of ORG_ANA_PROC_CHAR_ASGNMT Description: ================================================== Entity Type: ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Subject area: ANALYTICAL_PROCEDURES Properties:Persistent Open Min Occ: 5000 Avg Occ: 15000 Max Occ: 30000 Growth Rate: 5% per year TD Name: TSROLSPA Relationship Properties: Source Prop... Each ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Always (100%) ASSIGNS one LAB_SAMPLE_PREP_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT is deleted: Disassociate each occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: Destination Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (5%) IS_ASSIGNED_TO many ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Delete each occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Description: ================================================== Source Prop... Each ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Always (100%) IS_ASSIGNED_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (5%) ASSIGNS many ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of ORG_LAB_SMPL_PREP_PRCDRE_ASGMT Description: ================================================== Entity Type: PERMANENT_GRID Subject area: STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 100 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSMPMGRD Relationship Properties: Source Prop... Each PERMANENT_GRID Always (100%) BELONGS_TO one STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of PERMANENT_GRID is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (10%) HAS one PERMANENT_GRID Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of PERMANENT_GRID Description: ================================================== Source Prop... Each PERMANENT_GRID Sometimes (10%) IS_LOCATED_BY one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMANENT_GRID is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one PERMANENT_GRID Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of PERMANENT_GRID Description: ================================================== Entity Type: PERMANENT_TRANSECT Subject area: STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 100 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSMPMTCT Relationship Properties: Source Prop... Each PERMANENT_TRANSECT Always (100%) BELONGS_TO one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMANENT_TRANSECT is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (10%) HAS one PERMANENT_TRANSECT Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of PERMANENT_TRANSECT Description: ================================================== Source Prop... Each PERMANENT_TRANSECT Sometimes (10%) IS_LOCATED_BY many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 10 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMANENT_TRANSECT is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one PERMANENT_TRANSECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of PERMANENT_TRANSECT Description: ================================================== Entity Type: PERMITTED_VALUE Subject area: REFERENCE_TABLES Properties:Persistent Open Min Occ: 50000 Avg Occ: 75000 Max Occ: 150000 Growth Rate: 10% per year TD Name: TSMPRMVL Relationship Properties: Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many FIELD_QC_SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE Description: Destination Prop... Each FIELD_QC_SAMPLE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many FIELD_QC_SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE Description: Destination Prop... Each FIELD_QC_SAMPLE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many FIELD_QC_SAMPLE_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE Description: Destination Prop... Each FIELD_QC_SAMPLE_DEFAULT_PROFILE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many FIELD_QC_SAMPLE_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE Description: Destination Prop... Each FIELD_QC_SAMPLE_DEFAULT_PROFILE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLE Description: Destination Prop... Each SAMPLE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLE Description: Destination Prop... Each SAMPLE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: Destination Prop... Each SAMPLING_DEFAULT_PROFILE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: Destination Prop... Each SAMPLING_DEFAULT_PROFILE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_SAMPLE_FRACTION_TYPE_FOR many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (100%) HAS_SAMPLE_FRACTION_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_SAMPLE_FRACTION_TYPE_OF many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of CHARACTERISTIC_DEFAULT Description: Destination Prop... Each CHARACTERISTIC_DEFAULT Sometimes (100%) HAS_SAMPLE_FRACTION_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_TEMP_PRESRVTN_TYPE_FOR many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: Destination Prop... Each SAMPLING_DEFAULT_PROFILE Sometimes (100%) HAS_TEMP_PRESRVTN_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_TEMP_PRESRVTN_TYPE_FOR many SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLE Description: Destination Prop... Each SAMPLE Sometimes (100%) HAS_TEMP_PRESRVTN_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (60%) IS_HABIT_OF many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of CHARACTERISTIC_DEFAULT Description: Destination Prop... Each CHARACTERISTIC_DEFAULT Sometimes (50%) HAS_HABIT_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (60%) IS_HABIT_OF many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (50%) HAS_HABIT_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (60%) IS_VOLTINISM_FOR many CHARACTERISTIC_DEFAULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of CHARACTERISTIC_DEFAULT Description: Destination Prop... Each CHARACTERISTIC_DEFAULT Sometimes (50%) HAS_VOLTINISM_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC_DEFAULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (60%) IS_VOLTINISM_FOR many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (50%) HAS_VOLTINISM_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Source Prop... Each PERMITTED_VALUE Sometimes (95%) IS_TYPE_NAME_FOR many RESULT_QC_ADJUSTMENT_FACTOR Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT_QC_ADJUSTMENT_FACTOR Description: Destination Prop... Each RESULT_QC_ADJUSTMENT_FACTOR Always (100%) HAS_TYPE_NAME_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_QC_ADJUSTMENT_FACTOR is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: ================================================== Entity Type: PERSON Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 20000 Avg Occ: 200000 Max Occ: 750000 Growth Rate: 5% per year TD Name: TSMPERSN Relationship Properties: Source Prop... Each PERSON Sometimes (1%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: Destination Prop... Each ELECTRONIC_ADDRESS Sometimes (1%) IS_FOR one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of PERSON Description: ================================================== Source Prop... Each PERSON Always (100%) IS_PART_OF one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (1%) HAS many PERSON Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of PERSON Description: ================================================== Source Prop... Each PERSON Sometimes (1%) HAS many PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of PERSON_ROLE_ASSIGNMENT Description: Destination Prop... Each PERSON_ROLE_ASSIGNMENT Always (100%) IS_FOR one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON Description: ================================================== Source Prop... Each PERSON Sometimes (1%) HAS many PROJECT_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of PROJECT_PERSON_ASSIGNMENT Description: Destination Prop... Each PROJECT_PERSON_ASSIGNMENT Always (100%) HAS one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON Description: ================================================== Source Prop... Each PERSON Sometimes (50%) COLLECTS many FIELD_ACTIVITY_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT Description: Destination Prop... Each FIELD_ACTIVITY_PERSON_ASSIGNMENT Always (100%) IS_COLLECTED_BY one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON Description: ================================================== Source Prop... Each PERSON Sometimes (50%) HAS many FIELD_QC_SAMPLE_PERSON_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT Description: Destination Prop... Each FIELD_QC_SAMPLE_PERSON_ASGNMT Always (100%) IS_FOR one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE_PERSON_ASGNMT is deleted: Disassociate each occurrence of PERSON Description: ================================================== Entity Type: PERSON_ROLE Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 100 Avg Occ: 200 Max Occ: 500 Growth Rate: 1% per year TD Name: TSMPROLE Relationship Properties: Source Prop... Each PERSON_ROLE Sometimes (1%) HAS many PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE is deleted: Disallow deletion of PERSON_ROLE if there is one (or more) occurrence of PERSON_ROLE_ASSIGNMENT Description: Destination Prop... Each PERSON_ROLE_ASSIGNMENT Always (100%) IS_FOR one PERSON_ROLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON_ROLE Description: ================================================== Source Prop... Each PERSON_ROLE Sometimes (1%) HAS many PROJECT_PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE is deleted: Disallow deletion of PERSON_ROLE if there is one (or more) occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT Description: Destination Prop... Each PROJECT_PERSON_ROLE_ASSIGNMENT Always (100%) IS_FOR one PERSON_ROLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON_ROLE Description: ================================================== Entity Type: PERSON_ROLE_ASSIGNMENT Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 20000 Avg Occ: 200000 Max Occ: 750000 Growth Rate: 10% per year TD Name: TSMPRA Relationship Properties: Source Prop... Each PERSON_ROLE_ASSIGNMENT Always (100%) IS_FOR one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON Description: Destination Prop... Each PERSON Sometimes (1%) HAS many PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of PERSON_ROLE_ASSIGNMENT Description: ================================================== Source Prop... Each PERSON_ROLE_ASSIGNMENT Always (100%) IS_FOR one PERSON_ROLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON_ROLE Description: Destination Prop... Each PERSON_ROLE Sometimes (1%) HAS many PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE is deleted: Disallow deletion of PERSON_ROLE if there is one (or more) occurrence of PERSON_ROLE_ASSIGNMENT Description: ================================================== Entity Type: PIPE Subject area: FACILITY_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 1000 Max Occ: 2000 Growth Rate: 5% per year TD Name: TSMPIPE Relationship Properties: Source Prop... Each PIPE Always (100%) IS_PART_OF one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PIPE is deleted: Disassociate each occurrence of FACILITY_STATION Description: Destination Prop... Each FACILITY_STATION Sometimes (50%) HAS many PIPE Cardinality Min: 1 (est) Max: 1100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Delete each occurrence of PIPE Description: ================================================== Source Prop... Each PIPE Sometimes (10%) IS_LOCATED_BY one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PIPE is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one PIPE Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of PIPE Description: ================================================== Entity Type: PROGRAM Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 500 Avg Occ: 2500 Max Occ: 25000 Growth Rate: 5% per year TD Name: TSMPROGM Relationship Properties: Source Prop... Each PROGRAM Always (100%) SPONSORED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROGRAM is deleted: Disassociate each occurrence of ORGANIZATION Description: This relationship identifies the Organization that sponsors a particular regulatory or non-regulatory program. For example, EPA sponsors the non-regulatory National Estuary Program and the regulatory 403(c) program. Destination Prop... Each ORGANIZATION Sometimes (1%) SPONSORS many PROGRAM Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of PROGRAM Description: An Organization may sponsor many regulatory or non-regulatory Programs. This relationship is optional because Organizations play different roles. An Organization might not sponsor a Program if, for example, that Organization conducts Station Visits or defines a Sampling Procedure. ================================================== Source Prop... Each PROGRAM Sometimes (1%) PARTICIPATES_IN many PROJECT_PROGRAM_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROGRAM is deleted: Delete each occurrence of PROJECT_PROGRAM_ASSIGNMENT Description: A Program such as EPA s 403(c) program may require that Organizations undertake monitoring efforts, or Project/Special Studies. The relationship is optional because a Program may have no Projects associated with it when the Program is first established and specific monitoring efforts have not been planned. Destination Prop... Each PROJECT_PROGRAM_ASSIGNMENT Always (100%) PARTICIPATED_IN_BY one PROGRAM Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PROGRAM_ASSIGNMENT is deleted: Disassociate each occurrence of PROGRAM Description: A Project/Special Study may be undertaken in support of a regulatory or non-regulatory program, and this relationship identifies that Program. This relationship is optional because a Project/Special Study may not be associated with a Program if it is a one-time study. ================================================== Source Prop... Each PROGRAM Sometimes (5%) IS_DESCRIBED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROGRAM is deleted: Delete each occurrence of GENERIC_TEXT Description: Destination Prop... Each GENERIC_TEXT Sometimes (5%) DESCRIBES one PROGRAM Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of PROGRAM Description: ================================================== Entity Type: PROJECT Subject area: PROJECTS Properties:Persistent Open Min Occ: 2000 Avg Occ: 10000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSMPROJ Relationship Properties: Source Prop... Each PROJECT Sometimes (1%) DESIGNATES many VOUCHER_SPECIMEN_COLLECTION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of VOUCHER_SPECIMEN_COLLECTION Description: Destination Prop... Each VOUCHER_SPECIMEN_COLLECTION Always (100%) IS_DESIGNATED_BY one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of VOUCHER_SPECIMEN_COLLECTION is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (1%) HAS many PROJECT_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_PERSON_ASSIGNMENT Description: Destination Prop... Each PROJECT_PERSON_ASSIGNMENT Always (100%) HAS one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (1%) HAS many PROJECT_PROGRAM_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_PROGRAM_ASSIGNMENT Description: Destination Prop... Each PROJECT_PROGRAM_ASSIGNMENT Always (100%) IS_FOR one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PROGRAM_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (50%) HAS_A_CORRESPONDING many CITATION_PROJECT_ASGNMT Cardinality Min: 100 (est) Max: 1000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of CITATION_PROJECT_ASGNMT Description: Destination Prop... Each CITATION_PROJECT_ASGNMT Always (100%) CORRESPONDS_TO one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CITATION_PROJECT_ASGNMT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (50%) INVOLVES many PROJECT_COOP_ORG_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_COOP_ORG_ASSIGNMENT Description: Destination Prop... Each PROJECT_COOP_ORG_ASSIGNMENT Always (100%) IS_INVOLVED_IN one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_COOP_ORG_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (50%) HAS many FIELD_ACTIVITY_PROJECT_ASSGNMT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Do not display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT Description: Destination Prop... Each FIELD_ACTIVITY_PROJECT_ASSGNMT Always (100%) IS_FOR one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY_PROJECT_ASSGNMT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (1%) HAS many TRIP_PROJECT_ASSIGNMENT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of TRIP_PROJECT_ASSIGNMENT Description: Destination Prop... Each TRIP_PROJECT_ASSIGNMENT Always (100%) IS_FOR one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_PROJECT_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (5%) PARTICIPATES_IN many PROJECT_OPERATING_PERIOD_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_OPERATING_PERIOD_ASGMNT Description: Destination Prop... Each PROJECT_OPERATING_PERIOD_ASGMNT Always (100%) LINKS_AN_OPERATING_PERIOD_TO one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_OPERATING_PERIOD_ASGMNT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (5%) IS_DESCRIBED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 5 (est) Avg: 4 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of GENERIC_TEXT Description: Destination Prop... Each GENERIC_TEXT Sometimes (5%) DESCRIBES one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Sometimes (10%) USES many PROJECT_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of PROJECT is deleted: Disallow deletion of PROJECT if there is one (or more) occurrence of PROJECT_STATION_ASSIGNMENT Description: Destination Prop... Each PROJECT_STATION_ASSIGNMENT Always (100%) IS_USED_BY one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: ================================================== Source Prop... Each PROJECT Always (100%) IS_THE_RESPONSIBILITY_OF one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (10%) IS_RESPONSIBLE_FOR many PROJECT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of PROJECT Description: ================================================== Entity Type: PROJECT_COOP_ORG_ASSIGNMENT Subject area: PROJECTS Properties:Persistent Open Min Occ: 2000 Avg Occ: 10000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSMPCOA Relationship Properties: Source Prop... Each PROJECT_COOP_ORG_ASSIGNMENT Always (100%) INVOLVES one COOPERATING_ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_COOP_ORG_ASSIGNMENT is deleted: Disassociate each occurrence of COOPERATING_ORGANIZATION Description: Destination Prop... Each COOPERATING_ORGANIZATION Sometimes (50%) IS_INVOLVED_IN many PROJECT_COOP_ORG_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of COOPERATING_ORGANIZATION is deleted: Delete each occurrence of PROJECT_COOP_ORG_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_COOP_ORG_ASSIGNMENT Always (100%) IS_INVOLVED_IN one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_COOP_ORG_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (50%) INVOLVES many PROJECT_COOP_ORG_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_COOP_ORG_ASSIGNMENT Description: ================================================== Entity Type: PROJECT_OPERATING_PERIOD_ASGMNT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 7500 Avg Occ: 200000 Max Occ: 1500000 Growth Rate: 5% per year TD Name: TSRPOPA Relationship Properties: Source Prop... Each PROJECT_OPERATING_PERIOD_ASGMNT Always (100%) LINKS_A_PROJECT_TO one OPERATING_PERIOD Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_OPERATING_PERIOD_ASGMNT is deleted: Disassociate each occurrence of OPERATING_PERIOD Description: Destination Prop... Each OPERATING_PERIOD Sometimes (10%) PARTICIPATES_IN many PROJECT_OPERATING_PERIOD_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of OPERATING_PERIOD is deleted: Delete each occurrence of PROJECT_OPERATING_PERIOD_ASGMNT Description: ================================================== Source Prop... Each PROJECT_OPERATING_PERIOD_ASGMNT Always (100%) LINKS_AN_OPERATING_PERIOD_TO one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_OPERATING_PERIOD_ASGMNT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (5%) PARTICIPATES_IN many PROJECT_OPERATING_PERIOD_ASGMNT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_OPERATING_PERIOD_ASGMNT Description: ================================================== Entity Type: PROJECT_PERSON_ASSIGNMENT Subject area: PROJECTS Properties:Persistent Open Min Occ: 6000 Avg Occ: 30000 Max Occ: 300000 Growth Rate: 10% per year TD Name: TSMPPA Relationship Properties: Source Prop... Each PROJECT_PERSON_ASSIGNMENT Always (100%) HAS one PERSON Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON Description: Destination Prop... Each PERSON Sometimes (1%) HAS many PROJECT_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON is deleted: Delete each occurrence of PROJECT_PERSON_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_PERSON_ASSIGNMENT Always (100%) HAS one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (1%) HAS many PROJECT_PERSON_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_PERSON_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_PERSON_ASSIGNMENT Sometimes (5%) HAS many PROJECT_PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT Description: Destination Prop... Each PROJECT_PERSON_ROLE_ASSIGNMENT Always (100%) HAS one PROJECT_PERSON_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_PERSON_ASSIGNMENT for which this is the last PROJECT_PERSON_ROLE_ASSIGNMENT Description: ================================================== Entity Type: PROJECT_PERSON_ROLE_ASSIGNMENT Subject area: PROJECTS Properties:Persistent Open Min Occ: 6000 Avg Occ: 30000 Max Occ: 300000 Growth Rate: 10% per year TD Name: TSMPPRA Relationship Properties: Source Prop... Each PROJECT_PERSON_ROLE_ASSIGNMENT Always (100%) IS_FOR one PERSON_ROLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PERSON_ROLE Description: Destination Prop... Each PERSON_ROLE Sometimes (1%) HAS many PROJECT_PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERSON_ROLE is deleted: Disallow deletion of PERSON_ROLE if there is one (or more) occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_PERSON_ROLE_ASSIGNMENT Always (100%) HAS one PROJECT_PERSON_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_PERSON_ASSIGNMENT for which this is the last PROJECT_PERSON_ROLE_ASSIGNMENT Description: Destination Prop... Each PROJECT_PERSON_ASSIGNMENT Sometimes (5%) HAS many PROJECT_PERSON_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PERSON_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_PERSON_ROLE_ASSIGNMENT Description: ================================================== Entity Type: PROJECT_PROGRAM_ASSIGNMENT Subject area: PROJECTS Properties:Persistent Open Min Occ: 2000 Avg Occ: 5000 Max Occ: 50000 Growth Rate: 5% per year TD Name: TSMPRPRA Relationship Properties: Source Prop... Each PROJECT_PROGRAM_ASSIGNMENT Always (100%) PARTICIPATED_IN_BY one PROGRAM Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PROGRAM_ASSIGNMENT is deleted: Disassociate each occurrence of PROGRAM Description: A Project/Special Study may be undertaken in support of a regulatory or non-regulatory program, and this relationship identifies that Program. This relationship is optional because a Project/Special Study may not be associated with a Program if it is a one-time study. Destination Prop... Each PROGRAM Sometimes (1%) PARTICIPATES_IN many PROJECT_PROGRAM_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROGRAM is deleted: Delete each occurrence of PROJECT_PROGRAM_ASSIGNMENT Description: A Program such as EPA s 403(c) program may require that Organizations undertake monitoring efforts, or Project/Special Studies. The relationship is optional because a Program may have no Projects associated with it when the Program is first established and specific monitoring efforts have not been planned. ================================================== Source Prop... Each PROJECT_PROGRAM_ASSIGNMENT Always (100%) IS_FOR one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_PROGRAM_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (1%) HAS many PROJECT_PROGRAM_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of PROJECT_PROGRAM_ASSIGNMENT Description: ================================================== Entity Type: PROJECT_STATION_ASSIGNMENT Subject area: PROJECTS Properties:Persistent Open Min Occ: 200000 Avg Occ: 4000000 Max Occ: 10000000 Growth Rate: 10% per year TD Name: TSMPSA Relationship Properties: Source Prop... Each PROJECT_STATION_ASSIGNMENT Sometimes (1%) HAS many PROJECT_STATION_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_STATION_ROLE_ASSIGNMENT Description: Destination Prop... Each PROJECT_STATION_ROLE_ASSIGNMENT Always (100%) IS_FOR one PROJECT_STATION_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT_STATION_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_STATION_ASSIGNMENT Sometimes (70%) GATHERS one PROJECT_STATION_WEIGHT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_STATION_WEIGHT Description: Destination Prop... Each PROJECT_STATION_WEIGHT Always (100%) IS_GATHERED_FOR one PROJECT_STATION_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_WEIGHT is deleted: Disassociate each occurrence of PROJECT_STATION_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_STATION_ASSIGNMENT Always (100%) USES one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (10%) IS_USED_BY many PROJECT_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of PROJECT_STATION_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_STATION_ASSIGNMENT Always (100%) IS_USED_BY one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (10%) USES many PROJECT_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of PROJECT is deleted: Disallow deletion of PROJECT if there is one (or more) occurrence of PROJECT_STATION_ASSIGNMENT Description: ================================================== Entity Type: PROJECT_STATION_ROLE Subject area: PROJECTS Properties:Persistent Open Min Occ: 20 Avg Occ: 50 Max Occ: 100 Growth Rate: 10% per year TD Name: TSMPSR Relationship Properties: Source Prop... Each PROJECT_STATION_ROLE Sometimes (1%) HAS many PROJECT_STATION_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ROLE is deleted: Disallow deletion of PROJECT_STATION_ROLE if there is one (or more) occurrence of PROJECT_STATION_ROLE_ASSIGNMENT Description: Destination Prop... Each PROJECT_STATION_ROLE_ASSIGNMENT Always (100%) IS_FOR one PROJECT_STATION_ROLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT_STATION_ROLE Description: ================================================== Entity Type: PROJECT_STATION_ROLE_ASSIGNMENT Subject area: PROJECTS Properties:Persistent Open Min Occ: 200000 Avg Occ: 4000000 Max Occ: 10000000 Growth Rate: 10% per year TD Name: TSMPSRA Relationship Properties: Source Prop... Each PROJECT_STATION_ROLE_ASSIGNMENT Always (100%) IS_FOR one PROJECT_STATION_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT_STATION_ASSIGNMENT Description: Destination Prop... Each PROJECT_STATION_ASSIGNMENT Sometimes (1%) HAS many PROJECT_STATION_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_STATION_ROLE_ASSIGNMENT Description: ================================================== Source Prop... Each PROJECT_STATION_ROLE_ASSIGNMENT Always (100%) IS_FOR one PROJECT_STATION_ROLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ROLE_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT_STATION_ROLE Description: Destination Prop... Each PROJECT_STATION_ROLE Sometimes (1%) HAS many PROJECT_STATION_ROLE_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ROLE is deleted: Disallow deletion of PROJECT_STATION_ROLE if there is one (or more) occurrence of PROJECT_STATION_ROLE_ASSIGNMENT Description: ================================================== Entity Type: PROJECT_STATION_WEIGHT Subject area: PROJECTS Properties:Persistent Open Min Occ: 2000 Avg Occ: 10000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSMPSW Relationship Properties: Source Prop... Each PROJECT_STATION_WEIGHT Always (100%) IS_GATHERED_FOR one PROJECT_STATION_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_WEIGHT is deleted: Disassociate each occurrence of PROJECT_STATION_ASSIGNMENT Description: Destination Prop... Each PROJECT_STATION_ASSIGNMENT Sometimes (70%) GATHERS one PROJECT_STATION_WEIGHT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Delete each occurrence of PROJECT_STATION_WEIGHT Description: ================================================== Entity Type: PUMP Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 10 Max Occ: 100 Growth Rate: 5% per year TD Name: TSMPUMP Relationship Properties: Source Prop... Each PUMP Always (100%) DRAWS_WATER_FROM one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PUMP is deleted: Disassociate each occurrence of WELL_STATION Description: Destination Prop... Each WELL_STATION Sometimes (10%) USES many PUMP Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of PUMP Description: ================================================== Entity Type: REFERENCE_LABEL Subject area: STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 1000000 Max Occ: 2000000 Growth Rate: 5% per year TD Name: TSMRFLBL Relationship Properties: Source Prop... Each REFERENCE_LABEL Always (100%) REFERENCES one EXTERNAL_REFERENCE_SCHEME Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of REFERENCE_LABEL is deleted: Disassociate each occurrence of EXTERNAL_REFERENCE_SCHEME Description: A Station Reference Number is an alternate reference that provides supplemental information to characterize a Sampling Station. This relationship provides the correct context for this reference by identifying the appropriate scheme, method, or plan, i.e., External Reference Number Scheme. For example, the NPDES Permit Program is an External Reference Number Scheme, and individual NPDES permit numbers are Station Reference Numbers. Destination Prop... Each EXTERNAL_REFERENCE_SCHEME Sometimes (10%) REFERENCED_BY many REFERENCE_LABEL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of EXTERNAL_REFERENCE_SCHEME is deleted: Delete each occurrence of REFERENCE_LABEL Description: An External Reference Number Scheme identifies Sampling Stations by using an alternate reference to a permit, another system, etc. An External Reference Number Scheme may have several associated Station Reference Numbers. For example, the FRDS numbering scheme would have a different number for each drinking water station. This relationship is mandatory because a Scheme will not be stored unless it is referenced by a Station Reference Number. ================================================== Source Prop... Each REFERENCE_LABEL Always (100%) REFERENCES one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of REFERENCE_LABEL is deleted: Disassociate each occurrence of STATION Description: A Station Reference Number is an alternate reference that provides supplemental information to characterize a Sampling Station (e.g., FRDS number, permit number.) This relationship identifies the Sampling Station that is described by a particular Station Reference Number. This relationship is mandatory because all alternate references must describe a Sampling Station. Destination Prop... Each STATION Sometimes (10%) REFERENCED_BY many REFERENCE_LABEL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of REFERENCE_LABEL Description: A Station Reference Number is an alternate reference that provides supplemental information to characterize a Sampling Station (e.g., FRDS number, permit number.) This relationship identifies all alternate references for a particular Sampling Station. This relationship is optional because some Sampling Stations may not have alternate references. ================================================== Entity Type: RESULT Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 100000 Max Occ: 1000000 Growth Rate: 10% per year TD Name: TSRRSULT Relationship Properties: Source Prop... Each RESULT Sometimes (40%) IS_FOR one HABITAT_CLASS_SCHEME_CHAR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of HABITAT_CLASS_SCHEME_CHAR Description: Destination Prop... Each HABITAT_CLASS_SCHEME_CHAR Sometimes (10%) HAS many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of HABITAT_CLASS_SCHEME_CHAR is deleted: Disallow deletion of HABITAT_CLASS_SCHEME_CHAR if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (85%) IS_MADE_BY one LAB_SAMPLE_PREP_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of LAB_SAMPLE_PREP_PROCEDURE Description: Destination Prop... Each LAB_SAMPLE_PREP_PROCEDURE Sometimes (50%) IS_USED_TO_MAKE many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_SAMPLE_PREP_PROCEDURE is deleted: Disallow deletion of LAB_SAMPLE_PREP_PROCEDURE if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) IS_SECONDARILY_QUALIFIED_BY one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: Destination Prop... Each CHARACTERISTIC Sometimes (50%) SECONDARILY_QUALIFIES many RESULT Cardinality Min: 1 (est) Max: 5000 (est) Avg: 500 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (85%) IS_CREATED_BY one ANALYTICAL_PROCEDURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of ANALYTICAL_PROCEDURE Description: Destination Prop... Each ANALYTICAL_PROCEDURE Sometimes (50%) IS_USED_TO_CREATE many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ANALYTICAL_PROCEDURE is deleted: Disallow deletion of ANALYTICAL_PROCEDURE if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (10%) DESCRIBES one BIO_RESULT_GROUP_INDIVIDUAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of BIO_RESULT_GROUP_INDIVIDUAL Description: Destination Prop... Each BIO_RESULT_GROUP_INDIVIDUAL Sometimes (90%) IS_DESCRIBED_USING many RESULT Cardinality Min: 1 (est) Max: 10 (est) Avg: 2 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIO_RESULT_GROUP_INDIVIDUAL is deleted: Delete each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) IS_CONTAINED_IN one BIOLOGICAL_RESULT_GROUP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of BIOLOGICAL_RESULT_GROUP Description: Destination Prop... Each BIOLOGICAL_RESULT_GROUP Sometimes (5%) CONTAINS many RESULT Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of BIOLOGICAL_RESULT_GROUP is deleted: Delete each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) HAS_CELL_FORMS_DESCRIBED_BY one CELL_DESCRIPTOR Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of CELL_DESCRIPTOR Description: Destination Prop... Each CELL_DESCRIPTOR Always (100%) DESCRIBES_CELL_FORMS_FOR one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CELL_DESCRIPTOR is deleted: Disassociate each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (100%) IS_QUALIFIED_BY one CHARACTERISTIC Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of CHARACTERISTIC Description: Destination Prop... Each CHARACTERISTIC Sometimes (50%) QUALIFIES many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of CHARACTERISTIC is deleted: Disallow deletion of CHARACTERISTIC if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) IS_QUALIFIED_BY one DETECTION_QUANTITATION_LIMIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of DETECTION_QUANTITATION_LIMIT Description: Destination Prop... Each DETECTION_QUANTITATION_LIMIT Always (100%) QUALIFIES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DETECTION_QUANTITATION_LIMIT is deleted: Disassociate each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (50%) IS_YIELDED_FROM one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (95%) YIELDS many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) IS_FOR one FIELD_QC_SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of FIELD_QC_SAMPLE Description: Destination Prop... Each FIELD_QC_SAMPLE Sometimes (5%) HAS many RESULT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Delete each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (75%) IS_PRODUCED_IN one LABORATORY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of LABORATORY Description: Destination Prop... Each LABORATORY Sometimes (20%) PRODUCES many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LABORATORY is deleted: Disallow deletion of LABORATORY if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (1%) IS_DEFINED_BY many GENERIC_TEXT Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of GENERIC_TEXT Description: Destination Prop... Each GENERIC_TEXT Sometimes (5%) DEFINES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GENERIC_TEXT is deleted: Disassociate each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) IS_DESCRIBED_BY one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: Destination Prop... Each UNIT_OF_MEASURE Sometimes (50%) DESCRIBES many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (50%) IS_QUALIFIED_BY many RESULT_LAB_REMARK_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of RESULT_LAB_REMARK_ASGNMT Description: Destination Prop... Each RESULT_LAB_REMARK_ASGNMT Always (100%) QUALIFIES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_LAB_REMARK_ASGNMT is deleted: Disassociate each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) IS_QUALIFIED_BY many RESULT_QC_ADJUSTMENT_FACTOR Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of RESULT_QC_ADJUSTMENT_FACTOR Description: Destination Prop... Each RESULT_QC_ADJUSTMENT_FACTOR Always (100%) QUALIFIES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_QC_ADJUSTMENT_FACTOR is deleted: Disassociate each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (5%) REPORTS_A_VALUE_WITHIN one RESULT_CLASS_INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of RESULT_CLASS_INTERVAL Description: Destination Prop... Each RESULT_CLASS_INTERVAL Always (100%) INCLUDES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_CLASS_INTERVAL is deleted: Disassociate each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (100%) HAS_SAMPLE_FRACTION_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_SAMPLE_FRACTION_TYPE_FOR many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (100%) DESCRIBES one DATA_LINE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of DATA_LINE Description: Destination Prop... Each DATA_LINE Sometimes (85%) IS_DESCRIBED_USING many RESULT Cardinality Min: 10 (est) Max: 20 (est) Avg: 15 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DATA_LINE is deleted: Delete each occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (50%) HAS_HABIT_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (60%) IS_HABIT_OF many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT Description: ================================================== Source Prop... Each RESULT Sometimes (50%) HAS_VOLTINISM_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (60%) IS_VOLTINISM_FOR many RESULT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT Description: ================================================== Entity Type: RESULT_CLASS_INTERVAL Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 1000 Max Occ: 10000 Growth Rate: 10% per year TD Name: TSRRCI Relationship Properties: Source Prop... Each RESULT_CLASS_INTERVAL Always (100%) INCLUDES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_CLASS_INTERVAL is deleted: Disassociate each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) REPORTS_A_VALUE_WITHIN one RESULT_CLASS_INTERVAL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of RESULT_CLASS_INTERVAL Description: ================================================== Source Prop... Each RESULT_CLASS_INTERVAL Always (100%) IS_MEASURED_BY one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_CLASS_INTERVAL is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: Destination Prop... Each UNIT_OF_MEASURE Sometimes (50%) DEFINES many RESULT_CLASS_INTERVAL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of RESULT_CLASS_INTERVAL Description: ================================================== Entity Type: RESULT_LAB_REMARK_ASGNMT Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 5000 Max Occ: 100000 Growth Rate: 0% per year TD Name: TSRRLRA Relationship Properties: Source Prop... Each RESULT_LAB_REMARK_ASGNMT Always (100%) QUALIFIES_A_RESULT_WITH one LAB_REMARK Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_LAB_REMARK_ASGNMT is deleted: Disassociate each occurrence of LAB_REMARK Description: Destination Prop... Each LAB_REMARK Sometimes (50%) QUALIFIES_A_RESULT_USING many RESULT_LAB_REMARK_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LAB_REMARK is deleted: Disallow deletion of LAB_REMARK if there is one (or more) occurrence of RESULT_LAB_REMARK_ASGNMT Description: ================================================== Source Prop... Each RESULT_LAB_REMARK_ASGNMT Always (100%) QUALIFIES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_LAB_REMARK_ASGNMT is deleted: Disassociate each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (50%) IS_QUALIFIED_BY many RESULT_LAB_REMARK_ASGNMT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of RESULT_LAB_REMARK_ASGNMT Description: ================================================== Entity Type: RESULT_QC_ADJUSTMENT_FACTOR Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 1000 Max Occ: 10000 Growth Rate: 10% per year TD Name: TSRRQCAF Relationship Properties: Source Prop... Each RESULT_QC_ADJUSTMENT_FACTOR Always (100%) QUALIFIES one RESULT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_QC_ADJUSTMENT_FACTOR is deleted: Disassociate each occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) IS_QUALIFIED_BY many RESULT_QC_ADJUSTMENT_FACTOR Cardinality Min: 1 (est) Max: 15 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Delete each occurrence of RESULT_QC_ADJUSTMENT_FACTOR Description: ================================================== Source Prop... Each RESULT_QC_ADJUSTMENT_FACTOR Sometimes (5%) IS_QUALIFIED_BY one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_QC_ADJUSTMENT_FACTOR is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: Destination Prop... Each UNIT_OF_MEASURE Sometimes (50%) QUALIFIES many RESULT_QC_ADJUSTMENT_FACTOR Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of RESULT_QC_ADJUSTMENT_FACTOR Description: ================================================== Source Prop... Each RESULT_QC_ADJUSTMENT_FACTOR Always (100%) HAS_TYPE_NAME_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_QC_ADJUSTMENT_FACTOR is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_TYPE_NAME_FOR many RESULT_QC_ADJUSTMENT_FACTOR Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of RESULT_QC_ADJUSTMENT_FACTOR Description: ================================================== Entity Type: RF1_RIVER_REACH Subject area: GEOGRAPHIC_AREAS Properties:Persistent Open Min Occ: 70000 Avg Occ: 70000 Max Occ: 70000 Growth Rate: 5% per year TD Name: TSMRRR Relationship Properties: Source Prop... Each RF1_RIVER_REACH Sometimes (10%) CHARACTERIZES many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of RF1_RIVER_REACH is deleted: Disallow deletion of RF1_RIVER_REACH if there is one (or more) occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) IS_ASSOCIATED_WITH one RF1_RIVER_REACH Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of RF1_RIVER_REACH Description: ================================================== Entity Type: SAMPLE Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 75000 Avg Occ: 750000 Max Occ: 4000000 Growth Rate: 5% per year TD Name: TSRSMPLE Relationship Properties: Source Prop... Each SAMPLE Sometimes (25%) IS_DESCRIBED_BY one ELECTROSHOCK_OPERATION_DETAIL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Delete each occurrence of ELECTROSHOCK_OPERATION_DETAIL Description: Destination Prop... Each ELECTROSHOCK_OPERATION_DETAIL Always (100%) PROVIDES_DETAIL_ABOUT one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTROSHOCK_OPERATION_DETAIL is deleted: Disassociate each occurrence of SAMPLE Description: ================================================== Source Prop... Each SAMPLE Always (100%) IS_PART_OF one FIELD_ACTIVITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (88%) CONTAINS one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Delete each occurrence of SAMPLE Description: ================================================== Source Prop... Each SAMPLE Sometimes (25%) IS_DESCRIBED_BY one TRAP_NET_OPERATION_DETAIL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Delete each occurrence of TRAP_NET_OPERATION_DETAIL Description: Destination Prop... Each TRAP_NET_OPERATION_DETAIL Always (100%) PROVIDES_DETAIL_ABOUT one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRAP_NET_OPERATION_DETAIL is deleted: Disassociate each occurrence of SAMPLE Description: ================================================== Source Prop... Each SAMPLE Sometimes (25%) IS_DESCRIBED_BY one TRAWL_OPERATION_DETAIL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Delete each occurrence of TRAWL_OPERATION_DETAIL Description: Destination Prop... Each TRAWL_OPERATION_DETAIL Always (100%) PROVIDES_DETAIL_ABOUT one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRAWL_OPERATION_DETAIL is deleted: Disassociate each occurrence of SAMPLE Description: ================================================== Source Prop... Each SAMPLE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLE Description: ================================================== Source Prop... Each SAMPLE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLE Description: ================================================== Source Prop... Each SAMPLE Sometimes (100%) HAS_TEMP_PRESRVTN_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_TEMP_PRESRVTN_TYPE_FOR many SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLE Description: ================================================== Entity Type: SAMPLE_MATRIX Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 2500 Avg Occ: 50000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSRMATRX Relationship Properties: Source Prop... Each SAMPLE_MATRIX Sometimes (95%) USED_TO_DESCRIBE many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE_MATRIX is deleted: Disallow deletion of SAMPLE_MATRIX if there is one (or more) occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (35%) DESCRIBED_BY one SAMPLE_MATRIX Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of SAMPLE_MATRIX Description: ================================================== Source Prop... Each SAMPLE_MATRIX Sometimes (90%) USED_TO_DESCRIBE many AUTOMATED_DATA_LOGGER Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE_MATRIX is deleted: Disallow deletion of SAMPLE_MATRIX if there is one (or more) occurrence of AUTOMATED_DATA_LOGGER Description: Destination Prop... Each AUTOMATED_DATA_LOGGER Sometimes (20%) DESCRIBED_BY one SAMPLE_MATRIX Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of AUTOMATED_DATA_LOGGER is deleted: Disassociate each occurrence of SAMPLE_MATRIX Description: ================================================== Entity Type: SAMPLING_DEFAULT_PROFILE Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 20000 Avg Occ: 100000 Max Occ: 1000000 Growth Rate: 5% per year TD Name: TSRSDP Relationship Properties: Source Prop... Each SAMPLING_DEFAULT_PROFILE Always (100%) IS_OWNED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (90%) DEFINES many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: ================================================== Source Prop... Each SAMPLING_DEFAULT_PROFILE Sometimes (100%) IS_CONTAINED_BY one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_FOR many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: ================================================== Source Prop... Each SAMPLING_DEFAULT_PROFILE Sometimes (100%) HAS_CONTAINER_COLOR_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_CONTAINER_COLOR_FOR many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: ================================================== Source Prop... Each SAMPLING_DEFAULT_PROFILE Sometimes (100%) HAS_TEMP_PRESRVTN_TYPE_OF one PERMITTED_VALUE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLING_DEFAULT_PROFILE is deleted: Disassociate each occurrence of PERMITTED_VALUE Description: Destination Prop... Each PERMITTED_VALUE Sometimes (95%) IS_TEMP_PRESRVTN_TYPE_FOR many SAMPLING_DEFAULT_PROFILE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMITTED_VALUE is deleted: Disallow deletion of PERMITTED_VALUE if there is one (or more) occurrence of SAMPLING_DEFAULT_PROFILE Description: ================================================== Entity Type: SERIAL_ORG_IDENTIFICATION Subject area: REFERENCE_TABLES Properties:Persistent Open Min Occ: 2000 Avg Occ: 10000 Max Occ: 100000 Growth Rate: 5% per year TD Name: TSMSOI Relationship Properties: Entity Type: SPRING_STATION Subject area: SPRING_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 1000 Max Occ: 2000 Growth Rate: 5% per year TD Name: TSMSPRNG Relationship Properties: Source Prop... Each SPRING_STATION Sometimes (15%) IS_DESCRIBED_BY one GEOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SPRING_STATION is deleted: Disassociate each occurrence of GEOLOGIC_UNIT Description: Destination Prop... Each GEOLOGIC_UNIT Sometimes (5%) DESCRIBES many SPRING_STATION Cardinality Min: 1 (est) Max: 10 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of GEOLOGIC_UNIT is deleted: Disallow deletion of GEOLOGIC_UNIT if there is one (or more) occurrence of SPRING_STATION Description: ================================================== Source Prop... Each SPRING_STATION Sometimes (15%) IS_DESCRIBED_BY one LITHOLOGIC_UNIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SPRING_STATION is deleted: Disassociate each occurrence of LITHOLOGIC_UNIT Description: Destination Prop... Each LITHOLOGIC_UNIT Sometimes (5%) DESCRIBES many SPRING_STATION Cardinality Min: 1 (est) Max: 10 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LITHOLOGIC_UNIT is deleted: Disallow deletion of LITHOLOGIC_UNIT if there is one (or more) occurrence of SPRING_STATION Description: ================================================== Source Prop... Each SPRING_STATION Always (100%) IS one STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of SPRING_STATION is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (1%) CONSISTS_OF one SPRING_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of SPRING_STATION Description: ================================================== Entity Type: STANDARD_INDUSTRIAL_CLASS Subject area: FACILITY_STATIONS Properties:Persistent Open Min Occ: 0 Avg Occ: 5000 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSMSIC Relationship Properties: Source Prop... Each STANDARD_INDUSTRIAL_CLASS Sometimes (30%) DESCRIBES many FACILITY_SIC_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STANDARD_INDUSTRIAL_CLASS is deleted: Delete each occurrence of FACILITY_SIC_ASSIGNMENT Description: Destination Prop... Each FACILITY_SIC_ASSIGNMENT Always (100%) IS_DESCRIBED_BY one STANDARD_INDUSTRIAL_CLASS Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FACILITY_SIC_ASSIGNMENT is deleted: Disassociate each occurrence of STANDARD_INDUSTRIAL_CLASS Description: ================================================== Entity Type: STATION Subject area: STATIONS Properties:Persistent Open Min Occ: 100000 Avg Occ: 1000000 Max Occ: 2000000 Growth Rate: 5% per year TD Name: TSMSTATN Relationship Properties: Source Prop... Each STATION Sometimes (10%) CONSISTS one FACILITY_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of FACILITY_STATION Description: Destination Prop... Each FACILITY_STATION Always (100%) IS one STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of FACILITY_STATION is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (1%) IS_ASSIGNED many ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of ADDRESS Description: Destination Prop... Each ADDRESS Sometimes (1%) IS_ASSIGNED_TO one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (1%) HAS many ELECTRONIC_ADDRESS Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of ELECTRONIC_ADDRESS Description: Destination Prop... Each ELECTRONIC_ADDRESS Sometimes (1%) IS_FOR one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ELECTRONIC_ADDRESS is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Always (100%) IS_CLASSIFIED_BY one VALID_STATION_TYPE_COMBINATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Disassociate each occurrence of VALID_STATION_TYPE_COMBINATION Description: Destination Prop... Each VALID_STATION_TYPE_COMBINATION Sometimes (10%) CLASSIFIES many STATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of VALID_STATION_TYPE_COMBINATION is deleted: Disallow deletion of VALID_STATION_TYPE_COMBINATION if there is one (or more) occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (10%) REFERENCED_BY many REFERENCE_LABEL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of REFERENCE_LABEL Description: A Station Reference Number is an alternate reference that provides supplemental information to characterize a Sampling Station (e.g., FRDS number, permit number.) This relationship identifies all alternate references for a particular Sampling Station. This relationship is optional because some Sampling Stations may not have alternate references. Destination Prop... Each REFERENCE_LABEL Always (100%) REFERENCES one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of REFERENCE_LABEL is deleted: Disassociate each occurrence of STATION Description: A Station Reference Number is an alternate reference that provides supplemental information to characterize a Sampling Station (e.g., FRDS number, permit number.) This relationship identifies the Sampling Station that is described by a particular Station Reference Number. This relationship is mandatory because all alternate references must describe a Sampling Station. ================================================== Source Prop... Each STATION Sometimes (80%) HAS many TRIP_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of TRIP_STATION_ASSIGNMENT Description: Destination Prop... Each TRIP_STATION_ASSIGNMENT Always (100%) IS_FOR one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (5%) CONSISTS_OF many WELL_STATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of WELL_STATION Description: Destination Prop... Each WELL_STATION Always (100%) IS one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_STATION is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (1%) CONSISTS_OF one SPRING_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of SPRING_STATION Description: Destination Prop... Each SPRING_STATION Always (100%) IS one STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of SPRING_STATION is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (10%) HAS one PERMANENT_GRID Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of PERMANENT_GRID Description: Destination Prop... Each PERMANENT_GRID Always (100%) BELONGS_TO one STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of PERMANENT_GRID is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (10%) HAS one PERMANENT_TRANSECT Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of PERMANENT_TRANSECT Description: Destination Prop... Each PERMANENT_TRANSECT Always (100%) BELONGS_TO one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PERMANENT_TRANSECT is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (10%) HAS_DATA_GENERATED_BY many AUTOMATED_DATA_LOGGER Cardinality Min: 1 (est) Max: 10 (est) Avg: 5 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of AUTOMATED_DATA_LOGGER Description: Destination Prop... Each AUTOMATED_DATA_LOGGER Always (100%) COLLECTS_DATA_AT one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of AUTOMATED_DATA_LOGGER is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (10%) IS_USED_BY many PROJECT_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of PROJECT_STATION_ASSIGNMENT Description: Destination Prop... Each PROJECT_STATION_ASSIGNMENT Always (100%) USES one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of STATION Description: ================================================== Source Prop... Each STATION Always (100%) IS_ESTABLISHED_BY one ORGANIZATION Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (10%) ESTABLISHES many STATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of STATION Description: ================================================== Source Prop... Each STATION Sometimes (98%) IS_LOCATED_BY many ABSOLUTE_LOCATION_POINT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (90%) IS_LOCATION_OF one STATION Display relationship name Transferable Associate action is Modifying Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of STATION Description: ================================================== Entity Type: STATION_VISIT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 300000 Avg Occ: 8000000 Max Occ: 50000000 Growth Rate: 15% per year TD Name: TSRSTVST Relationship Properties: Source Prop... Each STATION_VISIT Sometimes (50%) RESULTS_IN many FIELD_ACTIVITY Cardinality Min: 1 (est) Max: 100000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION_VISIT is deleted: Delete each occurrence of FIELD_ACTIVITY Description: Destination Prop... Each FIELD_ACTIVITY Sometimes (5%) OCCURS_DURING one STATION_VISIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_ACTIVITY is deleted: Disassociate each occurrence of STATION_VISIT Description: ================================================== Source Prop... Each STATION_VISIT Sometimes (50%) DEFINES many FIELD_SET Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION_VISIT is deleted: Delete each occurrence of FIELD_SET Description: Destination Prop... Each FIELD_SET Always (100%) IS_DEFINED_BY one STATION_VISIT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_SET is deleted: Disassociate each occurrence of STATION_VISIT Description: ================================================== Source Prop... Each STATION_VISIT Always (100%) IS_FOR one TRIP_STATION_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION_VISIT is deleted: Disassociate each occurrence of TRIP_STATION_ASSIGNMENT Description: Destination Prop... Each TRIP_STATION_ASSIGNMENT Sometimes (75%) HAS many STATION_VISIT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_STATION_ASSIGNMENT is deleted: Delete each occurrence of STATION_VISIT Description: ================================================== Entity Type: STORET_CDB_TABLE_SYNCHRONIZATION Subject area: REFERENCE_TABLES Properties:Persistent Open Min Occ: 5 Avg Occ: 100 Max Occ: 10000 Growth Rate: 10% per year TD Name: TSMSCTS Relationship Properties: Entity Type: STORET_USER Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 50 Avg Occ: 100 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSMUSER Relationship Properties: Source Prop... Each STORET_USER Sometimes (90%) HAS_ACCESS_TO many USER_ORGANIZATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 30 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STORET_USER is deleted: Disallow deletion of STORET_USER if there is one (or more) occurrence of USER_ORGANIZATION_ASSIGNMENT Description: Destination Prop... Each USER_ORGANIZATION_ASSIGNMENT Always (100%) PROVIDES_ACCESS_FOR one STORET_USER Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of USER_ORGANIZATION_ASSIGNMENT is deleted: Disassociate each occurrence of STORET_USER Description: ================================================== Entity Type: TABLE_INFO Subject area: REPLICATION Properties:Persistent Open Min Occ: 114 Avg Occ: 114 Max Occ: 200 Growth Rate: 1% per year TD Name: TSMTBINF Relationship Properties: Entity Type: TRAP_NET_OPERATION_DETAIL Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 4000 Avg Occ: 40000 Max Occ: 200000 Growth Rate: 5% per year TD Name: TSRTNOD Relationship Properties: Source Prop... Each TRAP_NET_OPERATION_DETAIL Always (100%) PROVIDES_DETAIL_ABOUT one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRAP_NET_OPERATION_DETAIL is deleted: Disassociate each occurrence of SAMPLE Description: Destination Prop... Each SAMPLE Sometimes (25%) IS_DESCRIBED_BY one TRAP_NET_OPERATION_DETAIL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Delete each occurrence of TRAP_NET_OPERATION_DETAIL Description: ================================================== Entity Type: TRAWL_OPERATION_DETAIL Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 4000 Avg Occ: 40000 Max Occ: 200000 Growth Rate: 5% per year TD Name: TSRTOD Relationship Properties: Source Prop... Each TRAWL_OPERATION_DETAIL Always (100%) PROVIDES_DETAIL_ABOUT one SAMPLE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRAWL_OPERATION_DETAIL is deleted: Disassociate each occurrence of SAMPLE Description: Destination Prop... Each SAMPLE Sometimes (25%) IS_DESCRIBED_BY one TRAWL_OPERATION_DETAIL Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of SAMPLE is deleted: Delete each occurrence of TRAWL_OPERATION_DETAIL Description: ================================================== Entity Type: TRIP Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 300000 Avg Occ: 8000000 Max Occ: 50000000 Growth Rate: 5% per year TD Name: TSRTRIP Relationship Properties: Source Prop... Each TRIP Sometimes (50%) HAS many FIELD_QC_SAMPLE Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Delete each occurrence of FIELD_QC_SAMPLE Description: Destination Prop... Each FIELD_QC_SAMPLE Always (100%) IS_CREATED_FOR one TRIP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of FIELD_QC_SAMPLE is deleted: Disassociate each occurrence of TRIP Description: ================================================== Source Prop... Each TRIP Sometimes (1%) HAS many TRIP_PROJECT_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Delete each occurrence of TRIP_PROJECT_ASSIGNMENT Description: Destination Prop... Each TRIP_PROJECT_ASSIGNMENT Always (100%) IS_FOR one TRIP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_PROJECT_ASSIGNMENT is deleted: Disassociate each occurrence of TRIP Description: ================================================== Source Prop... Each TRIP Sometimes (1%) HAS many TRIP_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Delete each occurrence of TRIP_STATION_ASSIGNMENT Description: Destination Prop... Each TRIP_STATION_ASSIGNMENT Always (100%) IS_FOR one TRIP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of TRIP Description: ================================================== Source Prop... Each TRIP Always (100%) SPONSORED_BY one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (50%) SPONSORS many TRIP Cardinality Min: 1 (est) Max: 1000000 (est) Avg: 1000 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of TRIP Description: ================================================== Entity Type: TRIP_PROJECT_ASSIGNMENT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 300000 Avg Occ: 8000000 Max Occ: 50000000 Growth Rate: 5% per year TD Name: TSRTPA Relationship Properties: Source Prop... Each TRIP_PROJECT_ASSIGNMENT Always (100%) IS_FOR one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_PROJECT_ASSIGNMENT is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (1%) HAS many TRIP_PROJECT_ASSIGNMENT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of TRIP_PROJECT_ASSIGNMENT Description: ================================================== Source Prop... Each TRIP_PROJECT_ASSIGNMENT Always (100%) IS_FOR one TRIP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_PROJECT_ASSIGNMENT is deleted: Disassociate each occurrence of TRIP Description: Destination Prop... Each TRIP Sometimes (1%) HAS many TRIP_PROJECT_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Delete each occurrence of TRIP_PROJECT_ASSIGNMENT Description: ================================================== Entity Type: TRIP_STATION_ASSIGNMENT Subject area: FIELD_ACTIVITIES Properties:Persistent Open Min Occ: 300000 Avg Occ: 8000000 Max Occ: 50000000 Growth Rate: 5% per year TD Name: TSRTSA Relationship Properties: Source Prop... Each TRIP_STATION_ASSIGNMENT Always (100%) IS_FOR one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (80%) HAS many TRIP_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 1000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of TRIP_STATION_ASSIGNMENT Description: ================================================== Source Prop... Each TRIP_STATION_ASSIGNMENT Sometimes (75%) HAS many STATION_VISIT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_STATION_ASSIGNMENT is deleted: Delete each occurrence of STATION_VISIT Description: Destination Prop... Each STATION_VISIT Always (100%) IS_FOR one TRIP_STATION_ASSIGNMENT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION_VISIT is deleted: Disassociate each occurrence of TRIP_STATION_ASSIGNMENT Description: ================================================== Source Prop... Each TRIP_STATION_ASSIGNMENT Always (100%) IS_FOR one TRIP Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP_STATION_ASSIGNMENT is deleted: Disassociate each occurrence of TRIP Description: Destination Prop... Each TRIP Sometimes (1%) HAS many TRIP_STATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 100 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of TRIP is deleted: Delete each occurrence of TRIP_STATION_ASSIGNMENT Description: ================================================== Entity Type: UNIT_OF_MEASURE Subject area: RESULTS Properties:Persistent Open Min Occ: 100 Avg Occ: 200 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSRUOM Relationship Properties: Source Prop... Each UNIT_OF_MEASURE Sometimes (50%) IS_FOR many DETECTION_QUANTITATION_LIMIT Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of DETECTION_QUANTITATION_LIMIT Description: Destination Prop... Each DETECTION_QUANTITATION_LIMIT Always (100%) HAS one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of DETECTION_QUANTITATION_LIMIT is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: ================================================== Source Prop... Each UNIT_OF_MEASURE Sometimes (50%) DESCRIBES many RESULT Cardinality Min: 1 (est) Max: 10000 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of RESULT Description: Destination Prop... Each RESULT Sometimes (5%) IS_DESCRIBED_BY one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: ================================================== Source Prop... Each UNIT_OF_MEASURE Sometimes (50%) DEFINES many RESULT_CLASS_INTERVAL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of RESULT_CLASS_INTERVAL Description: Destination Prop... Each RESULT_CLASS_INTERVAL Always (100%) IS_MEASURED_BY one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_CLASS_INTERVAL is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: ================================================== Source Prop... Each UNIT_OF_MEASURE Sometimes (50%) QUALIFIES many RESULT_QC_ADJUSTMENT_FACTOR Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of UNIT_OF_MEASURE is deleted: Disallow deletion of UNIT_OF_MEASURE if there is one (or more) occurrence of RESULT_QC_ADJUSTMENT_FACTOR Description: Destination Prop... Each RESULT_QC_ADJUSTMENT_FACTOR Sometimes (5%) IS_QUALIFIED_BY one UNIT_OF_MEASURE Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of RESULT_QC_ADJUSTMENT_FACTOR is deleted: Disassociate each occurrence of UNIT_OF_MEASURE Description: ================================================== Entity Type: USER_ORGANIZATION_ASSIGNMENT Subject area: ORGANIZATIONS Properties:Persistent Open Min Occ: 100 Avg Occ: 1000 Max Occ: 2000 Growth Rate: 5% per year TD Name: TSMUOA Relationship Properties: Source Prop... Each USER_ORGANIZATION_ASSIGNMENT Always (100%) PROVIDES_ACCESS_FOR one STORET_USER Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of USER_ORGANIZATION_ASSIGNMENT is deleted: Disassociate each occurrence of STORET_USER Description: Destination Prop... Each STORET_USER Sometimes (90%) HAS_ACCESS_TO many USER_ORGANIZATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 30 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STORET_USER is deleted: Disallow deletion of STORET_USER if there is one (or more) occurrence of USER_ORGANIZATION_ASSIGNMENT Description: ================================================== Source Prop... Each USER_ORGANIZATION_ASSIGNMENT Always (100%) ESTABLISHES_ACCESS_TO one ORGANIZATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of USER_ORGANIZATION_ASSIGNMENT is deleted: Disassociate each occurrence of ORGANIZATION Description: Destination Prop... Each ORGANIZATION Sometimes (5%) IS_ACCESSIBLE_BY many USER_ORGANIZATION_ASSIGNMENT Cardinality Min: 1 (est) Max: 20 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ORGANIZATION is deleted: Disallow deletion of ORGANIZATION if there is one (or more) occurrence of USER_ORGANIZATION_ASSIGNMENT Description: ================================================== Entity Type: VALID_STATION_TYPE_COMBINATION Subject area: STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 100 Max Occ: 10000 Growth Rate: 5% per year TD Name: TSMVSTC Relationship Properties: Source Prop... Each VALID_STATION_TYPE_COMBINATION Sometimes (10%) CLASSIFIES many STATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of VALID_STATION_TYPE_COMBINATION is deleted: Disallow deletion of VALID_STATION_TYPE_COMBINATION if there is one (or more) occurrence of STATION Description: Destination Prop... Each STATION Always (100%) IS_CLASSIFIED_BY one VALID_STATION_TYPE_COMBINATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of STATION is deleted: Disassociate each occurrence of VALID_STATION_TYPE_COMBINATION Description: ================================================== Entity Type: VOUCHER_SPECIMEN_COLLECTION Subject area: PROJECTS Properties:Persistent Open Min Occ: 500 Avg Occ: 1000 Max Occ: 2000 Growth Rate: 10% per year TD Name: TSMVSC Relationship Properties: Source Prop... Each VOUCHER_SPECIMEN_COLLECTION Always (100%) IS_DESIGNATED_BY one PROJECT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of VOUCHER_SPECIMEN_COLLECTION is deleted: Disassociate each occurrence of PROJECT Description: Destination Prop... Each PROJECT Sometimes (1%) DESIGNATES many VOUCHER_SPECIMEN_COLLECTION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PROJECT is deleted: Delete each occurrence of VOUCHER_SPECIMEN_COLLECTION Description: ================================================== Entity Type: WELL_LEGAL_ENTITY Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 100 Max Occ: 1000 Growth Rate: 5% per year TD Name: TSMWLE Relationship Properties: Source Prop... Each WELL_LEGAL_ENTITY Always (100%) IS_FOR one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_LEGAL_ENTITY is deleted: Disassociate each occurrence of WELL_STATION Description: Destination Prop... Each WELL_STATION Sometimes (50%) HAS many WELL_LEGAL_ENTITY Cardinality Min: 1 (est) Max: 3 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of WELL_LEGAL_ENTITY Description: ================================================== Source Prop... Each WELL_LEGAL_ENTITY Sometimes (90%) HAS many ADDRESS Cardinality Min: 1 (est) Max: 3 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_LEGAL_ENTITY is deleted: Delete each occurrence of ADDRESS Description: Destination Prop... Each ADDRESS Sometimes (10%) IS_FOR one WELL_LEGAL_ENTITY Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of ADDRESS is deleted: Disassociate each occurrence of WELL_LEGAL_ENTITY Description: ================================================== Entity Type: WELL_STATION Subject area: WELL_STATIONS Properties:Persistent Open Min Occ: 1 Avg Occ: 150000 Max Occ: 300000 Growth Rate: 5% per year TD Name: TSMWELL Relationship Properties: Source Prop... Each WELL_STATION Sometimes (50%) HAS many WELL_LEGAL_ENTITY Cardinality Min: 1 (est) Max: 3 (est) Avg: 3 Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of WELL_LEGAL_ENTITY Description: Destination Prop... Each WELL_LEGAL_ENTITY Always (100%) IS_FOR one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_LEGAL_ENTITY is deleted: Disassociate each occurrence of WELL_STATION Description: ================================================== Source Prop... Each WELL_STATION Always (100%) IS one STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_STATION is deleted: Disassociate each occurrence of STATION Description: Destination Prop... Each STATION Sometimes (5%) CONSISTS_OF many WELL_STATION Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of STATION is deleted: Delete each occurrence of WELL_STATION Description: ================================================== Source Prop... Each WELL_STATION Sometimes (10%) IS_PARTITIONED_INTO many INTERVAL Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of INTERVAL Description: Destination Prop... Each INTERVAL Always (100%) PARTITIONS one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of INTERVAL is deleted: Disassociate each occurrence of WELL_STATION Description: ================================================== Source Prop... Each WELL_STATION Sometimes (10%) IS_DESCRIBED_BY many LOG Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of LOG Description: Destination Prop... Each LOG Always (100%) DESCRIBES_CONSTRUCTION_OF one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of LOG is deleted: Disassociate each occurrence of WELL_STATION Description: ================================================== Source Prop... Each WELL_STATION Sometimes (10%) USES many PUMP Cardinality Min: 1 (est) Max: 100 (est) Avg: 10 Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of PUMP Description: Destination Prop... Each PUMP Always (100%) DRAWS_WATER_FROM one WELL_STATION Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of PUMP is deleted: Disassociate each occurrence of WELL_STATION Description: ================================================== Source Prop... Each WELL_STATION Sometimes (10%) IS_LOCATED_BY one ABSOLUTE_LOCATION_POINT Display relationship name Not Transferable Associate action is Modifying Deletion Rule: When an occurrence of WELL_STATION is deleted: Delete each occurrence of ABSOLUTE_LOCATION_POINT Description: Destination Prop... Each ABSOLUTE_LOCATION_POINT Sometimes (10%) LOCATES one WELL_STATION Display relationship name Not Transferable Associate action is Referencing Deletion Rule: When an occurrence of ABSOLUTE_LOCATION_POINT is deleted: Disassociate each occurrence of WELL_STATION Description: ================================================== Work Set: ASYNC_REQUEST Subject area: STORET_PROD_DEV_V02.0 Properties:Persistent Open Min Occ: 0 Avg Occ: 0 Max Occ: 0 Growth Rate: 0% per year TD Name: Relationship Properties: Work Set: IEF_SUPPLIED Subject area: STORET_PROD_DEV_V02.0 Properties:Persistent Open Min Occ: 0 Avg Occ: 0 Max Occ: 0 Growth Rate: 0% per year TD Name: Relationship Properties: -End of Report-