UserJobOrderSearchConditions


Description

Saves the user job search condition which has keyword and filters

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
userId uuid 2147483647 null
Users.id UserJobOrderSearchConditions_userId_fkey C

Foreign key, referencing public.Users

searchCondition jsonb 2147483647 null

json consisting of keywords and filter conditions for searching job

createdAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
UserJobOrderSearchConditions_pkey Primary key Asc id
UserJobOrderSearchConditions_userId_idx Performance Asc userId

Relationships