os_sms_provider_configs

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_cp_message_settings.SMS_PROVIDER_CONFIG_ID FK_CP_SMS_PROVIDER_CFGR
os_sms_provider_cfg_props.PROVIDER_ID FK_SMS_PROVIDER_CFG_PROP_IDR
NAME VARCHAR 64 null
PROVIDER_TYPE VARCHAR 32 null
CREATOR_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_SMS_PROVIDER_CFG_CREATORR
CREATION_TIME TIMESTAMP 19 null
UPDATED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_SMS_PROVIDER_CFG_UPDATERR
UPDATE_TIME TIMESTAMP 19 √ null
REPLY_MESSAGE VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SMS_PROVIDER_CFG_CREATOR Performance Asc CREATOR_ID
FK_SMS_PROVIDER_CFG_UPDATER Performance Asc UPDATED_BY
OS_SMS_PROVIDER_CFG_NAME_UQ Must be unique Asc NAME

Relationships

Close relationships within degrees of separation