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