Table: dbo.Client_Staff_Next_Id_Number
Contains next ID number to use for auto-ID creation for client staff. Only has one record. Used only by SBPR.
Columns
NameTypeConstraintsDescription
client_staff_next_id_number_KEYint (4)NOT NULLPrimary key for the table.
next_id_numberint (4)NOT NULLNumber to use when creating the next client staff ID.
Primary key
NameColumnsDescription
PK_Client_Staff_Next_Id_Numberclient_staff_next_id_number_KEY

Schema diagram