home / db

wagtailcore_groupcollectionpermission

Data license: MIT

12 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: group_id, permission_id

id ▼ collection_id group_id permission_id
1 Root 1 Editors 2 Can add document 110
2 Root 1 Moderators 1 Can add document 110
3 Root 1 Editors 2 Can change document 111
4 Root 1 Moderators 1 Can change document 111
5 Root 1 Editors 2 Can choose document 113
6 Root 1 Moderators 1 Can choose document 113
7 Root 1 Editors 2 Can add image 114
8 Root 1 Moderators 1 Can add image 114
9 Root 1 Editors 2 Can change image 115
10 Root 1 Moderators 1 Can change image 115
11 Root 1 Editors 2 Can choose image 117
12 Root 1 Moderators 1 Can choose image 117

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "wagtailcore_groupcollectionpermission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "collection_id" integer NOT NULL REFERENCES "wagtailcore_collection" ("id") DEFERRABLE INITIALLY DEFERRED, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE UNIQUE INDEX "wagtailcore_groupcollectionpermission_group_id_collection_id_permission_id_a21cefe9_uniq" ON "wagtailcore_groupcollectionpermission" ("group_id", "collection_id", "permission_id");
CREATE INDEX "wagtailcore_groupcollectionpermission_collection_id_5423575a" ON "wagtailcore_groupcollectionpermission" ("collection_id");
CREATE INDEX "wagtailcore_groupcollectionpermission_group_id_05d61460" ON "wagtailcore_groupcollectionpermission" ("group_id");
CREATE INDEX "wagtailcore_groupcollectionpermission_permission_id_1b626275" ON "wagtailcore_groupcollectionpermission" ("permission_id");
Powered by Datasette · Queries took 8.864ms · Data license: MIT