| Table Name: | csc_solution |
| Table Number: | 5121 |
| Group: | Exchange Mgr |
| Description: | The CSC solution describes the high level object that contains all objects pertaining to a specific solution document |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| abstract | CHAR | varchar | 255 | Short description of solution | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| server_id | LONG | int | DIRECT | Exchange protocol server ID number | ||||
| solution_id | CHAR | varchar | 80 | Owner's unique identifier for the whole solution | ||||
| solution_type | LONG | smallint | 0 | DIRECT | The standard type of solution; i.e., 0=reference, 1=diagnostic, 2=how_to. Default=0 | |||
| title | CHAR | varchar | 80 | Title for the CSC solution object |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| solution2csc_admin | OTOF | csc_admin | solution2csc_solution | Administrative information | |||
| solution2csc_category | OTM | csc_category | category2csc_solution | High level class for problem | |||
| solution2csc_incident | OTOP | csc_incident | incident2csc_solution | CSC service incident which the problem describes | |||
| solution2csc_problem | OTM | csc_problem | problem2csc_solution | Problem information | |||
| soln2csc_resolution | OTM | csc_resolution | res2csc_solution | Resolution information |
| Index Name | Fields | Flags |
|---|---|---|
| solution_ind | server_id:solution_id | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_solution2csc_incident | solution2csc_incident | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| solution_ind | server_id, solution_id | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| csc_solution | |||