Case_types
Note: This table contains the same data as the
Casetype table.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| case_type_extid |
VARCHAR2 |
255 |
|
|
|
|
Case type external ID |
| case_type_id |
NUMBER |
|
39 |
0 |
|
|
Case type ID |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
| description |
VARCHAR2 |
200 |
|
|
|
|
Description |
| isinactive |
VARCHAR2 |
3 |
|
|
|
|
Whether the case type is inactive |
| name |
VARCHAR2 |
50 |
|
|
|
|
Name |
Primary key
| PK Column Name |
| case_type_id |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Support_incidents_case_types_fk |
case_type_id |
Support_incidents |
case_type_id |
1 |