auth_group_permissions

Description

Table Definition

CREATE TABLE `auth_group_permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	int		false	auto_increment
group_id	int		false			auth_group
permission_id	int		false			auth_permission

Constraints

Name	Type	Definition
auth_group_permissio_permission_id_84c5c92e_fk_auth_perm	FOREIGN KEY	FOREIGN KEY (permission_id) REFERENCES auth_permission (id)
auth_group_permissions_group_id_b120cbf9_fk_auth_group_id	FOREIGN KEY	FOREIGN KEY (group_id) REFERENCES auth_group (id)
auth_group_permissions_group_id_permission_id_0cd325b0_uniq	UNIQUE	UNIQUE KEY auth_group_permissions_group_id_permission_id_0cd325b0_uniq (group_id, permission_id)
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
auth_group_permissio_permission_id_84c5c92e_fk_auth_perm	KEY auth_group_permissio_permission_id_84c5c92e_fk_auth_perm (permission_id) USING BTREE
PRIMARY	PRIMARY KEY (id) USING BTREE
auth_group_permissions_group_id_permission_id_0cd325b0_uniq	UNIQUE KEY auth_group_permissions_group_id_permission_id_0cd325b0_uniq (group_id, permission_id) USING BTREE

Relations

Generated by tbls