Table t_role

db_ecological_db

Table: t_role_rol

Schema

application

Owner

ecological_db

Tablespace

(default)

Descriptions

Table containing the different roles that can be assigned to users.

Fields

PK	FK	Name	Data type	Not null	Unique	Inherited	Default	Description
		rol_id	serial				nextval('application.t_role_rol_rol_id_seq'::regclass)	Identifier (postgres) of the role.
		rol_label	varchar(25)					Name of the role.

Foreign Keys

There are no foreign keys for table t_role_rol

Check Constraints

There are no check constraints for table t_role_rol

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
c_pk_t_role_rol	btree		rol_id
c_uni_label_rol	btree		rol_label			Uniqueness on the role label.

Triggers

There are no triggers for table t_role_rol

Rules

There are no rules for table t_role_rol

Policies

There are no policies for table t_role_rol

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time	Description
tj_parent_role_rol_rol_prol	application	c_fk_child_role_prol	prol_child_role_id	application.t_role_rol	rol_id	Cascade	No Action	Immediate	Association of a child role.
tj_parent_role_rol_rol_prol	application	c_fk_parent_role_prol	prol_parent_role_id	application.t_role_rol	rol_id	Cascade	No Action	Immediate	Association of a parent role.
tj_rolepermission_rol_perm_rperm	application	c_fk_rol_rperm	rperm_rol_id	application.t_role_rol	rol_id	Cascade	No Action	Immediate	Association of a role with a permission.
tj_userrole_usr_rol_urol	application	c_fk_rol_urol	urol_rol_id	application.t_role_rol	rol_id	Cascade	No Action	Immediate	Associating a role with a user account.

Properties

Property	Value
Inherited From
Rows	0
Pages	0
System
Temporary
With OID

Definition

CREATE TABLE application.t_role_rol ( rol_id SERIAL, rol_label VARCHAR(25) NOT NULL, CONSTRAINT c_pk_t_role_rol PRIMARY KEY(rol_id), CONSTRAINT c_uni_label_rol UNIQUE(rol_label) ) ; COMMENT ON TABLE application.t_role_rol IS 'Table containing the different roles that can be assigned to users.'; COMMENT ON COLUMN application.t_role_rol.rol_id IS 'Identifier (postgres) of the role.'; COMMENT ON COLUMN application.t_role_rol.rol_label IS 'Name of the role.'; COMMENT ON CONSTRAINT c_uni_label_rol ON application.t_role_rol IS 'Uniqueness on the role label.';

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