Schema
Owner
ofb
Tablespace
(default)
Descriptions
Table attribuant une permission à un rôle.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
aperm_rol_id |
integer |
|
|
|
Identifiant (postgres) d'un rôle. |
|||
aperm_perm_id |
integer |
|
|
|
Identifiant (postgres) d'une permission. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
aperm_perm_id |
perm_id |
Cascade |
No Action |
|
Immediate |
Association d'une permission à un rôle. |
||
aperm_rol_id |
rol_id |
Cascade |
No Action |
|
Immediate |
Association d'un rôle à une permission. |
Check Constraints
There are no check constraints for table tj_apermission_rol_perm_aperm
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
aperm_rol_id, aperm_perm_id |
|
|||
btree |
|
aperm_perm_id |
|
|
Index sur le rattachement à une permission afin d'optimiser le temps des requètes |
|
btree |
|
aperm_rol_id |
|
|
Index sur le rattachement à un rôle afin d'optimiser le temps des requètes |
Triggers
There are no triggers for table tj_apermission_rol_perm_aperm
Rules
There are no rules for table tj_apermission_rol_perm_aperm
Policies
There are no policies for table tj_apermission_rol_perm_aperm
Referenced
There are no tables referenced by table tj_apermission_rol_perm_aperm
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE application.tj_apermission_rol_perm_aperm (
aperm_rol_id INTEGER NOT NULL,
aperm_perm_id INTEGER NOT NULL,
CONSTRAINT c_pk_tj_apermission_rol_perm_aperm PRIMARY KEY(aperm_rol_id, aperm_perm_id),
CONSTRAINT c_fk_perm_aperm FOREIGN KEY (aperm_perm_id)
REFERENCES application.t_permission_perm(perm_id)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_rol_aperm FOREIGN KEY (aperm_rol_id)
REFERENCES application.t_role_rol(rol_id)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE application.tj_apermission_rol_perm_aperm
IS 'Table attribuant une permission à un rôle.';
COMMENT ON COLUMN application.tj_apermission_rol_perm_aperm.aperm_rol_id
IS 'Identifiant (postgres) d''un rôle.';
COMMENT ON COLUMN application.tj_apermission_rol_perm_aperm.aperm_perm_id
IS 'Identifiant (postgres) d''une permission.';
COMMENT ON CONSTRAINT c_fk_perm_aperm ON application.tj_apermission_rol_perm_aperm
IS 'Association d''une permission à un rôle.';
COMMENT ON CONSTRAINT c_fk_rol_aperm ON application.tj_apermission_rol_perm_aperm
IS 'Association d''un rôle à une permission.';
CREATE INDEX x_btr_perm_id_aperm ON application.tj_apermission_rol_perm_aperm
USING btree (aperm_perm_id);
COMMENT ON INDEX application.x_btr_perm_id_aperm
IS 'Index sur le rattachement à une permission afin d''optimiser le temps des requètes';
CREATE INDEX x_btr_rol_id_aperm ON application.tj_apermission_rol_perm_aperm
USING btree (aperm_rol_id);
COMMENT ON INDEX application.x_btr_rol_id_aperm
IS 'Index sur le rattachement à un rôle afin d''optimiser le temps des requètes';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |