Skip to content

public.id_check_applications

Columns

Name Type Default Nullable Children Parents Comment
external_id varchar(255) false
id bigint false public.id_check_documents
status varchar(50) false
user_id bigint false public.users

Constraints

Name Type Definition
id_check_applications_external_id_key UNIQUE UNIQUE (external_id)
id_check_applications_pkey PRIMARY KEY PRIMARY KEY (id)
id_check_applications_user_id_34938c6c_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
id_check_applications_user_id_key UNIQUE UNIQUE (user_id)

Indexes

Name Definition
id_check_ap_externa_ce36d5_idx CREATE INDEX id_check_ap_externa_ce36d5_idx ON public.id_check_applications USING btree (external_id)
id_check_applications_external_id_5025af36_like CREATE INDEX id_check_applications_external_id_5025af36_like ON public.id_check_applications USING btree (external_id varchar_pattern_ops)
id_check_applications_external_id_key CREATE UNIQUE INDEX id_check_applications_external_id_key ON public.id_check_applications USING btree (external_id)
id_check_applications_pkey CREATE UNIQUE INDEX id_check_applications_pkey ON public.id_check_applications USING btree (id)
id_check_applications_user_id_key CREATE UNIQUE INDEX id_check_applications_user_id_key ON public.id_check_applications USING btree (user_id)

Generated by tbls