Table: dbo.Firm_Electronic_Filing_Information
Columns
NameTypeConstraintsDescription
firm_electronic_filing_information_KEYint (4)NOT NULLKey for the Firm Electronic Filing Information table
firm_KEYint (4)NOT NULLKey into the Firm Table
ste_state_code_KEYnvarchar (4)NOT NULLKey into the STE State Code Table
option_namenvarchar (40)NOT NULLOption name
option_valuenvarchar (40)NOT NULLOption value
Primary key
NameColumnsDescription
PK_Firm_Electronic_Filing_Informationfirm_electronic_filing_information_KEY
Unique constraints
NameColumnsDescription
UK_Firm_Electronic_Filing_Information$option_name$ste_state_code_KEYoption_name, ste_state_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Electronic_Filing_Information__Firm__firm_KEYfirm_KEYFirm (firm_KEY)
FK_Firm_Electronic_Filing_Information__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram