api_employee


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('api_employee_id_seq'::regclass)
api_clientbinnacle.employee_id api_clientbinnacle_employee_id_cbae5b3b_fk_api_employee_id R
api_crew.assistant2_id api_crew_assistant2_id_7b196e69_fk_api_employee_id R
api_crew.assistant_id api_crew_assistant_id_a2b410e4_fk_api_employee_id R
api_crew.driver_id api_crew_driver_id_cb2bc17e_fk_api_employee_id R
api_depositform.employee_who_counts_id api_depositform_employee_who_counts__fcfd6fcf_fk_api_emplo R
api_depositform.supervisor_extra_id api_depositform_supervisor_extra_id_23c99ad4_fk_api_employee_id R
api_depositform.supervisor_id api_depositform_supervisor_id_35c9a6ac_fk_api_employee_id R
api_division_employees.employee_id api_division_employees_employee_id_1b382743_fk_api_employee_id R
api_guide.employee_destination_id api_guide_employee_destination_id_7dcfe7e4_fk_api_employee_id R
api_guide.employee_origin_id api_guide_employee_origin_id_dd264510_fk_api_employee_id R
api_headinvoice.employee_id api_headinvoice_employee_id_114c1b3a_fk_api_employee_id R
api_notification.employee_destination_id api_notification_employee_destination_f08a8359_fk_api_emplo R
api_notification.employee_origin_id api_notification_employee_origin_id_abe0fbb3_fk_api_employee_id R
api_reportoperation_employees_close.employee_id api_reportoperation__employee_id_845c81a0_fk_api_emplo R
api_reportoperation_employees_open.employee_id api_reportoperation__employee_id_dba1068c_fk_api_emplo R
api_reportrequest.employee_id api_reportrequest_employee_id_7b4393c4_fk_api_employee_id R
api_serviceorder.employee_id api_serviceorder_employee_id_184dff2c_fk_api_employee_id R
api_stocktransaction.employee_id api_stocktransaction_employee_id_81af381f_fk_api_employee_id R
api_voucher.cashier_id api_voucher_cashier_id_2d4cf1c0_fk_api_employee_id R
api_voucher.checkin_received_by_id api_voucher_checkin_received_by_id_ffb1db37_fk_api_employee_id R
api_voucher.route_received_by_id api_voucher_route_received_by_id_2d004fee_fk_api_employee_id R
deleted timestamptz 35,6 null
name varchar 255 null
description text 2147483647 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
position_id int4 10 null
api_position.id api_employee_position_id_52ce9e36_fk_api_position_id R
user_id int4 10 null
auth_user.id api_employee_user_id_ed8ba4e1_fk_auth_user_id R
employee_number int4 10 null

Indexes

Constraint Name Type Sort Column(s)
api_employee_pkey Primary key Asc id
api_employee_employee_number_key Must be unique Asc employee_number
api_employee_name_ffc32721_like Performance Asc name
api_employee_name_key Must be unique Asc name
api_employee_position_id_52ce9e36 Performance Asc position_id
api_employee_user_id_ed8ba4e1 Performance Asc user_id

Relationships