FieldsInStoredProc


Description

Field-stored procedure associations that link data fields to stored procedures, enabling dynamic field processing and database operations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AssociationId Unknown 0 null

Primary key - FieldsInStoredProc unique identifier for each field-procedure association

pkID int identity 4 null

Primary key - FieldsInStoredProc unique identifier for each record

fkSPID int 4 null
StoredProc.pkSPID FK_FieldsInStoredProc_StoredProc C

Foreign key reference - Reference to SP table for data relationships

fkFieldID int 4 null
Fields.pkFieldID FK_FieldsInStoredProc_Fields C

Field reference - Reference to the field definition

fkStoredProcID Unknown 0 null

Stored procedure reference - Reference to the stored procedure

ParameterName Unknown 0 null

Parameter name - Name of the parameter in the stored procedure

ParameterOrder Unknown 0 null

Parameter order - Order of the parameter in the procedure call

Indexes

Constraint Name Type Sort Column(s)
PK_FieldsInStoredProc Primary key Asc pkID

Relationships