SLC 3.2 Entity Relationship Diagram

The relationship between the files that accompany the SLC polygons is shown below. Fields shown in italics are internal database fields or contain information duplicated in other key fields found in the same table.

Polygon Attribute (PAT) Landscape Area (LAT) Ecological Framework (EFT) Component (CMP) Component Rating (CRT) Soil Name (SNT) Soil Layer (SLT) Landform Extent (LET) Landscape Segmentation (LST) Landform Definition (LDT)
Select each table to get its description.

SLC 3.2 Entity Relationship Diagram contains 10 tables as follows:

  • Polygon Attribute Table (PAT) with POLY-ID and ECO_ID as Foreign Keys
  • Landscape Area (LAT) with POLY-ID as Primary Key
  • Ecological Framework (EFT) with ECO_ID as Primary Key
  • Component (CMP) with POLY_ID and CMP as Primary Keys and SOIL_ID and CMP_ID as Foreign Keys
  • Component Rating (CRT) with CMP-ID as Primary Key
  • Soil Name (SNT) with SOIL_ID as Concatenated Key and PROVINCE, SOIL_CODE, MODIFIER and PROFILE as Primary Keys.
  • Soil Layer (SLT) with SOIL_ID as Concatenated Key and PROVINCE, SOIL_CODE, MODIFIER, PROFILE and LAYER_NO as Primary Keys.
  • Landform Extent (LET) with LF_ID as Concatenated Key and POLY-ID, LF_TYPE and LF_SLOPE as Primary Keys.
  • Landscape Segmentation (LST) with POLY-ID, LF_TYPE, LF_SLOPE and LF_SEGMENT as Primary Keys and LF_ID, LFS_ID and SOIL_ID as foreign Keys.
  • Landform Definition (LDT) with LFS_ID as Primary Keys and LF_TYPE, LF_SLOPE and LF_SEGMENT as foreign Keys.

The following fields in each table are internal database fields or contain information duplicated in other key fields found in the same table.

  • AREA and PERIMETER in Polygon Table (PAT).
  • ECODISTRICT in Ecological Framework (EFT).
  • PROVINCE, SOIL_CODE, MODIFIER and PROFILE in Component (CMP).
  • PROVINCE, SOIL_CODE, MODIFIER and PROFILE in Soil Name (SNT).
  • PROVINCE, SOIL_CODE, MODIFIER and PROFILE in Soil Layer (SLT).
  • POLY-ID, LF_TYPE and LF_SLOPE in Landform Extent (LET).
  • PROVINCE, SOIL_CODE, MODIFIER and PROFILE in Landscape Segmentation (LST).
  • LF_TYPE, LF_SLOPE and LF_SEGMENT in Landform Definition (LDT).

These statements describe the relationships among the tables:

  • Landscape Area (LAT) has one to one relationship with Polygon Table (PAT).
  • Ecological Framework (EFT) has one to one relationship with Polygon Table (PAT).
  • Landscape Segmentation (LST) has many to one relationship with Polygon Table (PAT).
  • Component (CMP) has many to one relationship with Polygon Table (PAT).
  • Component Rating (CRT) has one to one relationship with Component (CMP).
  • Soil Name (SNT) has one to many relationship with Landscape Segmentation (LST) and many to many relationship with Component (CMP).
  • Soil Layer (SLT) has many to one relationship with Soil Name (SNT).
  • Landform Extent (LET) has one to many relationship with Landscape Segmentation (LST).
  • Landform Definition (LDT) has one to many relationship with Landscape Segmentation (LST)