SMS_MT_ABS_CHANNEL

This table will be used to store multiplex channel mapping

Details

• Schema: FUSION

• Object owner: FND

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SMS_MT_ABS_CHANNEL_PK	ABS_CHANNEL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ABS_CHANNEL_ID	VARCHAR2	36		Yes	mapping id
DESCRIPTION	VARCHAR2	100			abstract channel description
REF_CHANNEL_ID	VARCHAR2	36		Yes	reference to channel id
ABS_CHANNEL_NAME	VARCHAR2	100		Yes	abs channel name
TENANT_ID	VARCHAR2	128		Yes	tenant id
CUSTOMER_ID	VARCHAR2	128			customer id
NAMESPACE	VARCHAR2	36		Yes	namespace
PARTITION_KEY	VARCHAR2	36			partition key
REPARTITIONING_TIMESTAMP	TIMESTAMP			Yes	repartioning timestamp
NUM_PARTITION	NUMBER		9		number of partitions
MAX_MESSAGE_SIZE_BYTES	NUMBER		18		maximum message size allowed in bytes
KEY_CONVERTER	VARCHAR2	36			key converter
VALUE_CONVERTER	VARCHAR2	36			value converter
ABS_CHANNEL_STATUS	VARCHAR2	36			absolute channel status
RETENTION_PERIOD_DAYS	NUMBER		10		retention period in days
READ_BANDWIDTH_MBPS	NUMBER		7		read bandwidth in mbps
WRITE_BANDWIDTH_MBPS	NUMBER		7		write bandwidth in mbps
ADDITIONAL_DETAILS	BLOB				this column will be used to store any additional details
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
SMS_MT_ABS_CHANNEL_U1	Unique	Default	ABS_CHANNEL_ID
SMS_MT_ABS_CHANNEL_U2	Unique	Default	ABS_CHANNEL_NAME, REF_CHANNEL_ID, TENANT_ID, CUSTOMER_ID