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:
|
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. |