UPC_CHANNEL_CAPACITY

This table stores information related to channel capacity allocation for each channel.

Field Type Length Null? Description
Id (Primary Key) INT 64 False Unique ID of the table.
channel_id (Foreign Key) INT 64 False Unique ID of the channel.
capacity INT 20 False Capacity allocated for the channel.
frequency INT 2 False Duration for the allocated capacity:
  • 1 - Daily
  • 7 - Weekly
timezone VARCHAR 250 False The time zone ID.
start_date INT 64 False Epoch seconds representing start day and time based on frequency.
end_date INT 64 False Epoch seconds representing end day and time based on frequency.
enabled INT 1 False Enabled.
available_capacity INT 20 False Capacity available for the channel.
description VARCHAR 1000 False Description.
cc_uid VARCHAR 200 False Unique UID for the capacity.
createdDateEpoch INT 64 False Created date epoch.
lastModifiedDateEpoch INT 64 False Last modified date epoch.
createdby INT 20 False Platform ID of the user who created the entry.
modifiedby INT 20 False Platform ID of the user modifying the entry
version INT 20 False Version information for optimistic locking.