Job_types

Columns

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

Primary key

PK Column Name
job_type_id

Foreign keys referencing this table

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