fips_srs

798 rows


Description

Records the association between FIPs and SRs. As this can change over time, records are added each db_version_year.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fip_uuid varchar 36 null
fips.uuid fips_srs_fip_uuid_fkeyC

unique identifier of the FIP from SFP systems

sr_id int4 10 null
srs.id fips_srs_sr_id_fkeyC

unique identifier of the Supplier Roundtable (SR) from SFP systems

db_version_year int4 10 null
fips.db_version_year fips_srs_fip_uuid_fkeyC

Indexes

Constraint Name Type Sort Column(s)
fips_srs_pkey Primary key Asc/Asc/Asc fip_uuid + sr_id + db_version_year

Relationships