| Table Name: | csc_problem |
| Table Number: | 5120 |
| Group: | Exchange Mgr |
| Description: | The CSC problem is a primary object in a solution document. It contains both structured and freeform information that describe a single problem |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| impact | LONG | smallint | DIRECT | Monitors catastrophic impact | ||||
| likelihood | LONG | smallint | DIRECT | Probability that the problem will occur (gives users a way to rank problems | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| server_id | LONG | int | DIRECT | Exchange protocol server ID number | ||||
| type | CHAR | varchar | 80 | Category of the problem |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| problem2csc_admin | OTOF | csc_admin | problem2csc_problem | CSC service incident which the problem describes | |||
| problem2csc_category | OTM | csc_category | category2csc_problem | High level class for problem | |||
| problem2csc_expression | OTM | csc_expression | text2csc_problem | Statement of the problem | |||
| problem2csc_incident | OTOP | csc_incident | incident2csc_problem | CSC service incident which the problem describes | |||
| problem2csc_solution | MTO | csc_solution | solution2csc_problem | Solution for the problem |
| Index Name | Fields | Flags |
|---|---|---|
| problem_index | server_id:problem2csc_incident | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_problem2csc_incident | problem2csc_incident | nonclustered located on PRIMARY |
| ind_problem2csc_solution | problem2csc_solution | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| problem_index | server_id, problem2csc_incident | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| csc_problem | |||