FieldsInStoredProc


Description

Stored procedure field associations - Junction table linking fields to stored procedures for dynamic form and report generation. This table manages the relationship between data fields and stored procedures, enabling dynamic field mapping, parameterized queries, and flexible data retrieval for custom forms and reports.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PKID int identity 4 √ null

Association primary key - Unique identifier for each field-stored procedure association
FKSPID int 4 √ null
StoredProc.pkSPID FK__FieldsInS__FKSPI__4E6BDD9F R

Stored procedure reference - Links to StoredProc table for the associated procedure
FKFieldID int 4 √ null
Fields.PKFieldID FK__FieldsInS__FKFie__4D77B966 R

Field reference - Links to Fields table for the associated field

Indexes

Constraint Name Type Sort Column(s)
PK__FieldsInStoredPr__4C83952D Primary key Asc PKID

Relationships

Close relationships within degrees of separation