Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
isinactive | VARCHAR2 | 3 | Item is inactive | ||||
job_type_extid | VARCHAR2 | 255 | Job type external ID | ||||
job_type_id | NUMBER | 39 | 0 | Job type ID | |||
name | VARCHAR2 | 31 | Name | ||||
parent_id | NUMBER | 39 | 0 | Subtype of |
PK Column Name |
---|
job_type_id |
FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
---|---|---|---|---|
Customers_job_types_fk | job_type_id | Customers | job_type_id | 1 |