| Table Name: | channel |
| Table Number: | 5207 |
| Group: | Mixed Media |
| Description: | Communication channel used for customer interactions. This is a grouping within a medium, for a business purpose: e.g., Sales Department email |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | tinyint | 1 | DIRECT | Indicates whether the channel is active; i.e., 0=no, 1=yes, default=1 | |||
| description | CHAR | varchar | 255 | Description of the channel | ||||
| designation | CHAR | varchar | 80 | Unique (within medium) designator of the channel | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| inbound_ind | LONG | tinyint | 1 | DIRECT | Indicates whether the channel allows inbound communication; i.e., 0=no, 1=yes, default=1 | |||
| location | CHAR | varchar | 255 | Free-form description of the channel's location | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| outbound_ind | LONG | tinyint | 1 | DIRECT | Indicates whether the channel allows outbound communication; i.e., 0=no, 1=yes, default=1 | |||
| title | CHAR | varchar | 2 | 80 | Common name of the channel | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| channel2channel_inst | OTM | channel_inst | channel_inst2channel | The channel instance related to the channel | |||
| channel2communication | OTM | communication | communication2channel | Communications on the channel | |||
| channel2medium | MTO | medium | medium2channel | Communication medium which the channel supports | Search (5) |
| Index Name | Fields | Flags |
|---|---|---|
| channel_ind | designation:channel2medium | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| channel_ind | designation, channel2medium | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| channel | |||