hr_employee

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
code varchar 1 √ null
name varchar 30 √ null
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_hremployee R
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_hremployee R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
enddate timestamp 29,6 √ null
hr_department_id numeric 10 null
hr_department.hr_department_id hrdepartment_hremployee R
hr_employee_id numeric 10 null
hr_attribute.hr_employee_id hremployee_hrattribute R
hr_list.hr_employee_id hremployee_hrlist R
hr_process.hr_employee_id hremployee_hrprocess R
hr_job_id numeric 10 null
hr_job.hr_job_id hrjob_hremployee R
hr_payroll_id numeric 10 √ null
hr_payroll.hr_payroll_id hrpayroll_hremployee R
isactive bpchar 1 null
name2 varchar 30 √ null
nationalcode varchar 60 √ null
sscode varchar 60 √ null
startdate timestamp 29,6 null
updated timestamp 29,6 statement_timestamp()
ad_client_id numeric 10 null
updatedby numeric 10 null
ad_org_id numeric 10 null
imageurl varchar 120 √ NULL::character varying
hr_employee_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
hr_employee_key Primary key Asc hr_employee_id
hr_employee_uu_idx Must be unique Asc hr_employee_uu

Check Constraints

Constraint Name Constraint
hr_employee_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation