NoRecentApplicationStatusNotifications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NotificationId uuid 2147483647 null
Notifications.id NoRecentApplicationStatusNotifications_NotificationId_fkey C
dataJson jsonb 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
NoRecentApplicationStatusNotifications_pkey Primary key Asc NotificationId

Check Constraints

Constraint Name Constraint
data_json_company_logo_key_value_check ((((("dataJson")::json -> 'companyLogos'::text) IS NOT NULL) AND (json_array_length((("dataJson")::json -> 'companyLogos'::text)) >= 1)))
data_json_applicationsStatuses_key_value_check ((((("dataJson")::json -> 'applicationsStatuses'::text) IS NOT NULL) AND (json_array_length((("dataJson")::json -> 'applicationsStatuses'::text)) >= 1)))
data_json_job_title_key_value_check (((("dataJson")::json -> 'jobTitle'::text) IS NOT NULL))
data_json_applicationsCreatedUntil_key_value_check (((("dataJson")::json -> 'applicationsCreatedUntil'::text) IS NOT NULL))
data_json_applications_count_value_check (("dataJson" @? '$."applicationsCount"[*]?(@ >= 0)'::jsonpath))
data_json_applicationsCreatedSince_key_value_check (((("dataJson")::json -> 'applicationsCreatedSince'::text) IS NOT NULL))

Relationships

Close relationships within degrees of separation