home

db

Data license: MIT

Custom SQL query

Tables

auth_group

id, name

2 rows

auth_group_permissions

id, group_id, permission_id

18 rows

auth_permission

id, content_type_id, codename, name

195 rows

auth_user

id, password, last_login, is_superuser, username, last_name, email, is_staff, is_active, date_joined, first_name

1 row

auth_user_groups

id, user_id, group_id

0 rows

auth_user_user_permissions

id, user_id, permission_id

0 rows

django_admin_log

id, object_id, object_repr, action_flag, change_message, content_type_id, user_id, action_time

0 rows

django_content_type

id, app_label, model

48 rows

django_migrations

id, app, name, applied

223 rows

django_session

session_key, session_data, expire_date

1 row

home_homepage

page_ptr_id, intro, tagline

1 row

home_scaffoldnotepage

page_ptr_id, date, summary, body, source_file

1 row

sqlite_sequence

name, seq

36 rows

taggit_tag

id, name, slug

0 rows

taggit_taggeditem

id, object_id, content_type_id, tag_id

0 rows

wagtailadmin_admin

id

0 rows

wagtailadmin_editingsession

id, object_id, last_seen_at, content_type_id, user_id, is_editing

0 rows

wagtailadmin_formstate

id, data, object_id, parent_object_id, last_updated_at, content_type_id, user_id

0 rows

wagtailcore_apitoken

id, name, key_hash, prefix, created, revoked_at, last_used_at, user_id

0 rows

wagtailcore_collection

id, path, depth, numchild, name

1 row

wagtailcore_collectionviewrestriction

id, restriction_type, password, collection_id

0 rows

wagtailcore_collectionviewrestriction_groups

id, collectionviewrestriction_id, group_id

0 rows

wagtailcore_comment

id, text, contentpath, position, created_at, updated_at, resolved_at, page_id, resolved_by_id, revision_created_id, user_id

0 rows

wagtailcore_commentreply

id, text, created_at, updated_at, comment_id, user_id

0 rows

wagtailcore_groupapprovaltask

task_ptr_id

1 row

wagtailcore_groupapprovaltask_groups

id, groupapprovaltask_id, group_id

1 row

wagtailcore_groupcollectionpermission

id, collection_id, group_id, permission_id

12 rows

wagtailcore_grouppagepermission

id, group_id, page_id, permission_id

7 rows

wagtailcore_groupsitepermission

id, group_id, permission_id, site_id

0 rows

wagtailcore_locale

id, language_code

1 row

wagtailcore_modellogentry

id, label, action, timestamp, content_changed, deleted, object_id, content_type_id, user_id, uuid, revision_id, data

0 rows

wagtailcore_page

id, path, depth, numchild, title, slug, live, has_unpublished_changes, url_path, seo_title, show_in_menus, search_description, go_live_at, expire_at, expired, content_type_id, owner_id, locked, latest_revision_created_at, first_published_at, live_revision_id, last_published_at, draft_title, locked_at, locked_by_id, locale_id, translation_key, alias_of_id, latest_revision_id

3 rows

wagtailcore_pagelogentry

id, label, action, timestamp, content_changed, deleted, content_type_id, page_id, revision_id, user_id, uuid, data

40 rows

wagtailcore_pagesubscription

id, comment_notifications, page_id, user_id

1 row

wagtailcore_pageviewrestriction

id, password, page_id, restriction_type

0 rows

wagtailcore_pageviewrestriction_groups

id, pageviewrestriction_id, group_id

0 rows

wagtailcore_referenceindex

id, object_id, to_object_id, model_path, content_path, content_path_hash, base_content_type_id, content_type_id, to_content_type_id

0 rows

wagtailcore_revision

id, created_at, approved_go_live_at, user_id, content, object_id, content_type_id, base_content_type_id, object_str

2 rows

wagtailcore_site

id, hostname, port, is_default_site, root_page_id, site_name

1 row

wagtailcore_task

id, name, active, content_type_id

1 row

wagtailcore_taskstate

id, status, started_at, finished_at, content_type_id, task_id, workflow_state_id, finished_by_id, comment, revision_id

0 rows

wagtailcore_uploadedfile

id, file, for_content_type_id, uploaded_by_user_id

0 rows

wagtailcore_workflow

id, name, active

1 row

wagtailcore_workflowcontenttype

content_type_id, workflow_id

0 rows

wagtailcore_workflowpage

page_id, workflow_id

1 row

wagtailcore_workflowstate

id, status, created_at, current_task_state_id, requested_by_id, workflow_id, object_id, base_content_type_id, content_type_id

0 rows

wagtailcore_workflowtask

id, sort_order, task_id, workflow_id

1 row

wagtaildocs_document

id, title, file, created_at, uploaded_by_user_id, collection_id, file_hash, file_size

0 rows

wagtailembeds_embed

id, url, max_width, type, html, title, author_name, provider_name, width, height, last_updated, hash, thumbnail_url, cache_until

0 rows

wagtailforms_formsubmission

id, submit_time, page_id, form_data

0 rows

wagtailimages_image

id, title, file, width, height, created_at, focal_point_x, focal_point_y, focal_point_width, focal_point_height, uploaded_by_user_id, file_size, collection_id, file_hash, description

0 rows

wagtailimages_rendition

id, width, height, focal_point_key, filter_spec, image_id, file

0 rows

wagtailredirects_redirect

id, old_path, is_permanent, redirect_link, redirect_page_id, site_id, automatically_created, created_at, redirect_page_route_path

0 rows

wagtailsearch_indexentry

id, object_id, title_norm, content_type_id, autocomplete, body, title

2 rows

wagtailusers_userprofile

id, submitted_notifications, approved_notifications, rejected_notifications, user_id, preferred_language, current_time_zone, avatar, updated_comments_notifications, dismissibles, theme, density, contrast, keyboard_shortcuts

1 row

... and 6 hidden tables

Powered by Datasette · Queries took 70.417ms · Data license: MIT