wagtailcore_page

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('wagtailcore_page_id_seq'::regclass)
wagtailcore_grouppagepermission.page_id wagtailcore_grouppagepe_page_id_710b114a_fk_wagtailcore_page_idR
wagtailcore_pagerevision.page_id wagtailcore_pagerevisio_page_id_d421cc1d_fk_wagtailcore_page_idR
wagtailcore_pageviewrestriction.page_id wagtailcore_pageviewres_page_id_15a8bea6_fk_wagtailcore_page_idR
wagtailcore_site.root_page_id wagtailcore_site_root_page_id_e02fb95c_fk_wagtailcore_page_idR
wagtailforms_formsubmission.page_id wagtailforms_formsubmis_page_id_e48e93e7_fk_wagtailcore_page_idR
wagtailredirects_redirect.redirect_page_id wagtailredirec_redirect_page_id_b5728a8f_fk_wagtailcore_page_idR
wagtailsearch_editorspick.page_id wagtailsearch_editorspi_page_id_28cbc274_fk_wagtailcore_page_idR
path varchar 255 null
depth int4 10 null
numchild int4 10 null
title varchar 255 null
slug varchar 255 null
cms_slugpage.slug Implied ConstraintR
live bool 1 null
has_unpublished_changes bool 1 null
url_path text 2147483647 null
seo_title varchar 255 null
show_in_menus bool 1 null
search_description text 2147483647 null
go_live_at timestamptz 35,6 √ null
expire_at timestamptz 35,6 √ null
expired bool 1 null
content_type_id int4 10 null
django_content_type.id wagtailcore__content_type_id_c28424df_fk_django_content_type_idR
owner_id int4 10 √ null
auth_user.id wagtailcore_page_owner_id_fbf7c332_fk_auth_user_idR
locked bool 1 null
latest_revision_created_at timestamptz 35,6 √ null
first_published_at timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
wagtailcore_page_pkey Primary key Asc id
wagtailcore_page_2dbcba41 Performance Asc slug
wagtailcore_page_417f1b1c Performance Asc content_type_id
wagtailcore_page_5e7b1936 Performance Asc owner_id
wagtailcore_page_first_published_at_2b5dd637_uniq Performance Asc first_published_at
wagtailcore_page_path_98eba2c8_like Performance Asc path
wagtailcore_page_path_key Must be unique Asc path
wagtailcore_page_slug_e7c11b8f_like Performance Asc slug

Check Constraints

Constraint Name Constraint
wagtailcore_page_numchild_check ((numchild >= 0))
wagtailcore_page_depth_check ((depth >= 0))

Relationships

Close relationships within degrees of separation