db_ecological_db

Table: tj_rolepermission_rol_perm_rperm

Schema

application

Owner

ecological_db

Tablespace

(default)

Descriptions

Table granting permission to a role.

Fields

Foreign Keys

Check Constraints

There are no check constraints for table tj_rolepermission_rol_perm_rperm

Indices

Triggers

There are no triggers for table tj_rolepermission_rol_perm_rperm

Rules

There are no rules for table tj_rolepermission_rol_perm_rperm

Policies

There are no policies for table tj_rolepermission_rol_perm_rperm

Referenced

There are no tables referenced by table tj_rolepermission_rol_perm_rperm

Properties

Definition

CREATE TABLE application.tj_rolepermission_rol_perm_rperm (
 rperm_rol_id INTEGER NOT NULL,
 rperm_perm_id INTEGER NOT NULL,
 CONSTRAINT c_pk_tj_rolepermission_rol_perm_rperm PRIMARY KEY(rperm_rol_id, rperm_perm_id),
 CONSTRAINT c_fk_perm_rperm FOREIGN KEY (rperm_perm_id)
   REFERENCES application.t_permission_perm(perm_id)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT c_fk_rol_rperm FOREIGN KEY (rperm_rol_id)
   REFERENCES application.t_role_rol(rol_id)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE application.tj_rolepermission_rol_perm_rperm
IS 'Table granting permission to a role.';

COMMENT ON COLUMN application.tj_rolepermission_rol_perm_rperm.rperm_rol_id
IS 'Identifier (postgres) of a role.';

COMMENT ON COLUMN application.tj_rolepermission_rol_perm_rperm.rperm_perm_id
IS 'Identifier (postgres) of a permission.';

COMMENT ON CONSTRAINT c_fk_perm_rperm ON application.tj_rolepermission_rol_perm_rperm
IS 'Association of a permission to a role.';

COMMENT ON CONSTRAINT c_fk_rol_rperm ON application.tj_rolepermission_rol_perm_rperm
IS 'Association of a role with a permission.';

CREATE INDEX x_btr_perm_id_rperm ON application.tj_rolepermission_rol_perm_rperm
 USING btree (rperm_perm_id);

COMMENT ON INDEX application.x_btr_perm_id_rperm
IS 'Index on the attachment to a permission in order to optimize the time of requests';

CREATE INDEX x_btr_rol_id_rperm ON application.tj_rolepermission_rol_perm_rperm
 USING btree (rperm_rol_id);

COMMENT ON INDEX application.x_btr_rol_id_rperm
IS 'Index on the attachment to a role in order to optimize the time of requests';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)