smart_hr_employees

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.smart_hr_employees_id_seq'::regclass)
smart_hr_employee_change_histories.smart_hr_employee_id fk_smart_hr_employee_change_histories_smart_hr_employeesR
organization_id int8 19 null
organizations.id fk_smart_hr_employees_organizationsR
smart_hr_employee_id text 2147483647 null
user_id int8 19 √ null
users.id fk_smart_hr_employees_usersR
last_name varchar 255 null
first_name varchar 255 null
email varchar 255 ''::character varying
usage_start_date timestamptz 35,6 √ null
disabled_at timestamptz 35,6 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
employment_type text 2147483647 ''::text

Indexes

Constraint Name Type Sort Column(s)
smart_hr_employees_pkey Primary key Asc id
idex_smart_hr_employess_on_organization_id Performance Asc organization_id
idex_smart_hr_employess_on_smart_hr_employee_id Must be unique Asc smart_hr_employee_id
idex_smart_hr_employess_on_user_id Must be unique Asc user_id

Relationships

Close relationships within degrees of separation