Employee_types

Columns

Name Type Length Precision Scale References In Description
employee_type_id NUMBER 39 0 Employee type ID
isinactive VARCHAR2 3 Inactive
name VARCHAR2 99 Name
parent_id NUMBER 39 0 Child of

Primary key

PK Column Name
employee_type_id

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Employees_employee_types_fk employee_type_id Employees employee_type_id 1