|
1 |
Table « authentic_dev_publik_love.a2_rbac_operation »
|
|
2 |
Colonne | Type | Collationnement | NULL-able | Par défaut
|
|
3 |
---------+-----------------------+-----------------+-----------+-----------------------------------------------
|
|
4 |
id | integer | | not null | nextval('a2_rbac_operation_id_seq'::regclass)
|
|
5 |
slug | character varying(32) | | not null |
|
|
6 |
Index :
|
|
7 |
"a2_rbac_operation_pkey" PRIMARY KEY, btree (id)
|
|
8 |
"a2_rbac_operation_slug_23eb4b87_like" btree (slug varchar_pattern_ops)
|
|
9 |
"a2_rbac_operation_slug_key" UNIQUE CONSTRAINT, btree (slug)
|
|
10 |
Référencé par :
|
|
11 |
TABLE "a2_rbac_permission" CONSTRAINT "a2_rbac_permission_operation_id_3ad9aed4_fk_a2_rbac_o" FOREIGN KEY (operation_id) REFERENCES a2_rbac_operation(id) DEFERRABLE INITIALLY DEFERRED
|
|
12 |
|
|
13 |
Séquence « authentic_dev_publik_love.a2_rbac_operation_id_seq »
|
|
14 |
Type | Début | Minimum | Maximum | Incrément | Cycles ? | Cache
|
|
15 |
---------+-------+---------+------------+-----------+----------+-------
|
|
16 |
integer | 1 | 1 | 2147483647 | 1 | no | 1
|
|
17 |
Propriétaire : authentic_dev_publik_love.a2_rbac_operation.id
|
|
18 |
|
|
19 |
Index « authentic_dev_publik_love.a2_rbac_operation_pkey »
|
|
20 |
Colonne | Type | Clé ? | Définition
|
|
21 |
---------+---------+-------+------------
|
|
22 |
id | integer | oui | id
|
|
23 |
clé primaire, btree, pour la table « authentic_dev_publik_love.a2_rbac_operation »
|
|
24 |
|
|
25 |
Index « authentic_dev_publik_love.a2_rbac_operation_slug_23eb4b87_like »
|
|
26 |
Colonne | Type | Clé ? | Définition
|
|
27 |
---------+-----------------------+-------+------------
|
|
28 |
slug | character varying(32) | oui | slug
|
|
29 |
btree, pour la table « authentic_dev_publik_love.a2_rbac_operation »
|
|
30 |
|
|
31 |
Index « authentic_dev_publik_love.a2_rbac_operation_slug_key »
|
|
32 |
Colonne | Type | Clé ? | Définition
|
|
33 |
---------+-----------------------+-------+------------
|
|
34 |
slug | character varying(32) | oui | slug
|
|
35 |
unique, btree, pour la table « authentic_dev_publik_love.a2_rbac_operation »
|
|
36 |
|
| 1 |
37 |
Table « authentic_dev_publik_love.a2_rbac_organizationalunit »
|
| 2 |
38 |
Colonne | Type | Collationnement | NULL-able | Par défaut
|
| 3 |
39 |
------------------------------------+------------------------+-----------------+-----------+--------------------------------------------------------
|
| ... | ... | |
| 98 |
134 |
--------------+---------+-----------------+-----------+------------------------------------------------
|
| 99 |
135 |
id | integer | | not null | nextval('a2_rbac_permission_id_seq'::regclass)
|
| 100 |
136 |
target_id | integer | | not null |
|
| 101 |
|
operation_id | integer | | not null |
|
| 102 |
137 |
ou_id | integer | | |
|
| 103 |
138 |
target_ct_id | integer | | not null |
|
|
139 |
operation_id | integer | | not null |
|
| 104 |
140 |
Index :
|
| 105 |
141 |
"a2_rbac_permission_pkey" PRIMARY KEY, btree (id)
|
| 106 |
|
"a2_rbac_permission_operation_id_3ad9aed4" btree (operation_id)
|
|
142 |
"a2_rbac_permission_operation_new_id_0c34ce1f" btree (operation_id)
|
| 107 |
143 |
"a2_rbac_permission_ou_id_a68ef755" btree (ou_id)
|
| 108 |
144 |
"a2_rbac_permission_target_ct_id_519ab0ca" btree (target_ct_id)
|
| 109 |
|
"null_ou_uniq_idx" UNIQUE, btree (operation_id, target_ct_id, target_id) WHERE ou_id IS NULL
|
| 110 |
145 |
Contraintes de vérification :
|
| 111 |
146 |
"a2_rbac_permission_target_id_check" CHECK (target_id >= 0)
|
| 112 |
147 |
Contraintes de clés étrangères :
|
| 113 |
|
"a2_rbac_permission_operation_id_3ad9aed4_fk_django_rb" FOREIGN KEY (operation_id) REFERENCES django_rbac_operation(id) DEFERRABLE INITIALLY DEFERRED
|
|
148 |
"a2_rbac_permission_operation_id_3ad9aed4_fk_a2_rbac_o" FOREIGN KEY (operation_id) REFERENCES a2_rbac_operation(id) DEFERRABLE INITIALLY DEFERRED
|
| 114 |
149 |
"a2_rbac_permission_ou_id_a68ef755_fk_a2_rbac_o" FOREIGN KEY (ou_id) REFERENCES a2_rbac_organizationalunit(id) DEFERRABLE INITIALLY DEFERRED
|
| 115 |
150 |
"a2_rbac_permission_target_ct_id_519ab0ca_fk_django_co" FOREIGN KEY (target_ct_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED
|
| 116 |
151 |
Référencé par :
|
| ... | ... | |
| 122 |
157 |
integer | 1 | 1 | 2147483647 | 1 | no | 1
|
| 123 |
158 |
Propriétaire : authentic_dev_publik_love.a2_rbac_permission.id
|
| 124 |
159 |
|
| 125 |
|
Index « authentic_dev_publik_love.a2_rbac_permission_operation_id_3ad9aed4 »
|
|
160 |
Index « authentic_dev_publik_love.a2_rbac_permission_operation_new_id_0c34ce1f »
|
| 126 |
161 |
Colonne | Type | Clé ? | Définition
|
| 127 |
|
--------------+---------+-------+--------------
|
| 128 |
|
operation_id | integer | oui | operation_id
|
|
162 |
------------------+---------+-------+--------------
|
|
163 |
operation_new_id | integer | oui | operation_id
|
| 129 |
164 |
btree, pour la table « authentic_dev_publik_love.a2_rbac_permission »
|
| 130 |
165 |
|
| 131 |
166 |
Index « authentic_dev_publik_love.a2_rbac_permission_ou_id_a68ef755 »
|
| ... | ... | |
| 2647 |
2682 |
id | integer | oui | id
|
| 2648 |
2683 |
clé primaire, btree, pour la table « authentic_dev_publik_love.django_migrations »
|
| 2649 |
2684 |
|
| 2650 |
|
Table « authentic_dev_publik_love.django_rbac_operation »
|
| 2651 |
|
Colonne | Type | Collationnement | NULL-able | Par défaut
|
| 2652 |
|
---------+-----------------------+-----------------+-----------+---------------------------------------------------
|
| 2653 |
|
id | integer | | not null | nextval('django_rbac_operation_id_seq'::regclass)
|
| 2654 |
|
slug | character varying(32) | | not null |
|
| 2655 |
|
Index :
|
| 2656 |
|
"django_rbac_operation_pkey" PRIMARY KEY, btree (id)
|
| 2657 |
|
"django_rbac_operation_slug_7a13d203_like" btree (slug varchar_pattern_ops)
|
| 2658 |
|
"django_rbac_operation_slug_key" UNIQUE CONSTRAINT, btree (slug)
|
| 2659 |
|
Référencé par :
|
| 2660 |
|
TABLE "a2_rbac_permission" CONSTRAINT "a2_rbac_permission_operation_id_3ad9aed4_fk_django_rb" FOREIGN KEY (operation_id) REFERENCES django_rbac_operation(id) DEFERRABLE INITIALLY DEFERRED
|
| 2661 |
|
|
| 2662 |
|
Séquence « authentic_dev_publik_love.django_rbac_operation_id_seq »
|
| 2663 |
|
Type | Début | Minimum | Maximum | Incrément | Cycles ? | Cache
|
| 2664 |
|
---------+-------+---------+------------+-----------+----------+-------
|
| 2665 |
|
integer | 1 | 1 | 2147483647 | 1 | no | 1
|
| 2666 |
|
Propriétaire : authentic_dev_publik_love.django_rbac_operation.id
|
| 2667 |
|
|
| 2668 |
|
Index « authentic_dev_publik_love.django_rbac_operation_pkey »
|
| 2669 |
|
Colonne | Type | Clé ? | Définition
|
| 2670 |
|
---------+---------+-------+------------
|
| 2671 |
|
id | integer | oui | id
|
| 2672 |
|
clé primaire, btree, pour la table « authentic_dev_publik_love.django_rbac_operation »
|
| 2673 |
|
|
| 2674 |
|
Index « authentic_dev_publik_love.django_rbac_operation_slug_7a13d203_like »
|
| 2675 |
|
Colonne | Type | Clé ? | Définition
|
| 2676 |
|
---------+-----------------------+-------+------------
|
| 2677 |
|
slug | character varying(32) | oui | slug
|
| 2678 |
|
btree, pour la table « authentic_dev_publik_love.django_rbac_operation »
|
| 2679 |
|
|
| 2680 |
|
Index « authentic_dev_publik_love.django_rbac_operation_slug_key »
|
| 2681 |
|
Colonne | Type | Clé ? | Définition
|
| 2682 |
|
---------+-----------------------+-------+------------
|
| 2683 |
|
slug | character varying(32) | oui | slug
|
| 2684 |
|
unique, btree, pour la table « authentic_dev_publik_love.django_rbac_operation »
|
| 2685 |
|
|
| 2686 |
2685 |
Table « authentic_dev_publik_love.django_session »
|
| 2687 |
2686 |
Colonne | Type | Collationnement | NULL-able | Par défaut
|
| 2688 |
2687 |
--------------+--------------------------+-----------------+-----------+------------
|
| ... | ... | |
| 3040 |
3039 |
slug | character varying(256) | oui | slug
|
| 3041 |
3040 |
unique, btree, pour la table « authentic_dev_publik_love.a2_rbac_role », prédicat (admin_scope_ct_id IS NULL AND ou_id IS NULL)
|
| 3042 |
3041 |
|
| 3043 |
|
Index « authentic_dev_publik_love.null_ou_uniq_idx »
|
| 3044 |
|
Colonne | Type | Clé ? | Définition
|
| 3045 |
|
--------------+---------+-------+--------------
|
| 3046 |
|
operation_id | integer | oui | operation_id
|
| 3047 |
|
target_ct_id | integer | oui | target_ct_id
|
| 3048 |
|
target_id | integer | oui | target_id
|
| 3049 |
|
unique, btree, pour la table « authentic_dev_publik_love.a2_rbac_permission », prédicat (ou_id IS NULL)
|
| 3050 |
|
|
| 3051 |
3042 |
Index « authentic_dev_publik_love.null_service_name_uniq_idx »
|
| 3052 |
3043 |
Colonne | Type | Clé ? | Définition
|
| 3053 |
3044 |
---------+---------+-------+------------
|