media_types
Table name: media_types
Contains/Role:
- Describes the name for the different media types a call/request might consist of.
- Table call_events holds a foreign key against this table
| Column Name | Datatype | Description |
|---|---|---|
| media_type_id | Integer Primary key. |
The code for the media type. 0 Undefined 1 Phone 3 Email 4 SMS ( not in use) 5 Chat 7 Social |
| descript | nvarchar (255) | Describes the media type id. |