search_terms_searchtermitem

73 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
slug varchar 30 null
name varchar 60 null
description text 2147483647 √ null
call_to_action_type varchar 20 null
link varchar 200 √ null
order_number int4 10 null
category_id int4 10 null
search_terms_searchtermcategory.id search_terms_searcht_category_id_64649515_fk_search_teR
call_to_action_text varchar 255 √ null
uuid uuid 2147483647 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
search_terms_searchtermitem_uuid_cb8600b2_pk Primary key Asc uuid
search_terms_searchtermitem_category_id_64649515 Performance Asc category_id
search_terms_searchtermitem_order_number_b747fb9d Performance Asc order_number
search_terms_searchtermitem_slug_e7825bc2_like Performance Asc slug
search_terms_searchtermitem_slug_e7825bc2_uniq Must be unique Asc slug
search_terms_searchtermitem_uuid_cb8600b2_uniq Must be unique Asc uuid

Check Constraints

Constraint Name Constraint
search_terms_searchtermitem_order_number_check ((order_number >= 0))

Relationships

Close relationships within degrees of separation