public.users¶

Columns¶

Name	Type	Nullable	Children	Parents
company_id	bigint	true		public.companies
email	varchar(255)	false
first_name	varchar(150)	false
id	bigint	false	public.ai_conversations public.contacts public.conversations public.conversations_participants public.django_admin_log public.document_versions public.fcm_django_fcmdevice public.id_check_applications public.job_applications public.jobs public.manager_conversations public.manager_conversations_participants public.manager_messages public.manager_messages_read_by public.messages public.messages_read_by public.notification_preferences public.notifications public.offers public.placements public.reviews public.user_otps public.user_privacy_settings public.users_groups public.users_user_permissions
id_check_ref	varchar(255)	false
is_active	boolean	false
is_staff	boolean	false
is_superuser	boolean	false
joined_at	timestamp with time zone	false
last_login	timestamp with time zone	true
last_name	varchar(150)	false
password	varchar(128)	false
phone	varchar(128)	false
photo	varchar(100)	true
salesforce_ref	varchar(255)	false
user_type	varchar(20)	false
verified_at	timestamp with time zone	true

Name	Type	Definition
users_company_id_23a5e9c4_fk_companies_id	FOREIGN KEY	FOREIGN KEY (company_id) REFERENCES companies(id) DEFERRABLE INITIALLY DEFERRED
users_email_key	UNIQUE	UNIQUE (email)
users_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
users_company_id_23a5e9c4	CREATE INDEX users_company_id_23a5e9c4 ON public.users USING btree (company_id)
users_email_0ea73cca_like	CREATE INDEX users_email_0ea73cca_like ON public.users USING btree (email varchar_pattern_ops)
users_email_4b85f2_idx	CREATE INDEX users_email_4b85f2_idx ON public.users USING btree (email)
users_email_key	CREATE UNIQUE INDEX users_email_key ON public.users USING btree (email)
users_id_chec_ab48c8_idx	CREATE INDEX users_id_chec_ab48c8_idx ON public.users USING btree (id_check_ref)
users_pkey	CREATE UNIQUE INDEX users_pkey ON public.users USING btree (id)
users_user_ty_578f8f_idx	CREATE INDEX users_user_ty_578f8f_idx ON public.users USING btree (user_type)

Generated by tbls