Skip to content

public.contacts

Columns

Name Type Default Nullable Extra Definition Children Parents Comment
already_in_nl boolean false
availability varchar(255) false
available_from date true
bc_resource_number varchar(25) false
bsn_saved boolean false
candidate_status varchar(255) false
commute_distance_km double precision true
company_id bigint true public.companies
date_of_birth date true
department varchar(255) false
dutch_government_money_details text false
email varchar(255) false
emergency_contact_name varchar(255) false
emergency_contact_phone varchar(128) false
et_uitruil_years text false
first_name varchar(150) false
full_name varchar(301) true GENERATED ALWAYS AS ((COALESCE(first_name, ''::character varying))::text || COALESCE((COALESCE(' '::text, ''::text) || (COALESCE(last_name, ''::character varying))::text), ''::text)) STORED
gender varchar(10) false
geocoded_at timestamp with time zone true
has_bank_account boolean true
has_bsn boolean true
has_driving_license boolean true
has_used_et_uitruil boolean true
has_vehicle_in_nl boolean true
health_insurance boolean true
housing varchar(50) false
iban_saved boolean false
id bigint false public.contact_documents public.contact_skills public.contacts_preferred_positions public.contacts_saved_jobs public.docusign_envelopes public.education public.employment_contracts public.generated_arrival_contact_documents public.generated_contact_documents public.generated_employment_declaration_documents public.job_applications public.jobs public.placements public.work_experiences public.worker_interviews public.worker_job_distances
industry_preferences varchar(20)[] false
initials varchar(3) true GENERATED ALWAYS AS (COALESCE("left"((first_name)::text, 1), ''::text) || COALESCE('.'::text, ''::text)) STORED
is_live_in_cruits_housing boolean true
is_receiving_dutch_government_money boolean true
last_name varchar(150) false
latitude numeric(9,6) true
location jsonb true
longitude numeric(9,6) true
max_hours_per_week integer true
min_hours_per_week integer true
nationality varchar(255) false
needs_housing_assistance boolean true
phone varchar(128) false
photo varchar(100) true
place_of_birth varchar(255) false
position varchar(255) false
preferred_shifts varchar(20)[] false
professional_summary text false
residential_address jsonb true
salesforce_ref varchar(255) false
salutation varchar(20) false
tax_discount boolean true
type varchar(20) false
use_whatsapp boolean false
user_id bigint true public.users
variable_shifts_ok boolean true
vehicles_owned varchar(20)[] false
willing_to_relocate boolean true

Constraints

Name Type Definition
contacts_company_id_a1c53412_fk_companies_id FOREIGN KEY FOREIGN KEY (company_id) REFERENCES companies(id) DEFERRABLE INITIALLY DEFERRED
contacts_max_hours_per_week_check CHECK CHECK ((max_hours_per_week >= 0))
contacts_min_hours_per_week_check CHECK CHECK ((min_hours_per_week >= 0))
contacts_pkey PRIMARY KEY PRIMARY KEY (id)
contacts_user_id_7a55ae84_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
contacts_user_id_key UNIQUE UNIQUE (user_id)

Indexes

Name Definition
contacts_company_5f69c0_idx CREATE INDEX contacts_company_5f69c0_idx ON public.contacts USING btree (company_id)
contacts_company_id_a1c53412 CREATE INDEX contacts_company_id_a1c53412 ON public.contacts USING btree (company_id)
contacts_pkey CREATE UNIQUE INDEX contacts_pkey ON public.contacts USING btree (id)
contacts_salesfo_314a64_idx CREATE INDEX contacts_salesfo_314a64_idx ON public.contacts USING btree (salesforce_ref)
contacts_user_id_key CREATE UNIQUE INDEX contacts_user_id_key ON public.contacts USING btree (user_id)
uniq_worker_profile_per_user CREATE UNIQUE INDEX uniq_worker_profile_per_user ON public.contacts USING btree (user_id) WHERE ((type)::text = 'WORKER'::text)

Generated by tbls