db_ecological_db |
|
Table: tj_userrole_usr_rol_urol
db_ecological_db |
|
Table: tj_userrole_usr_rol_urol
Schema
Owner
ecological_db
Tablespace
(default)
Descriptions
Table assigning a role to a user account.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
urol_usr_id |
integer |
|
|
|
|
User ID (postgres). |
|
|
urol_rol_id |
integer |
|
|
|
|
Role ID (postgres). |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
urol_rol_id |
rol_id |
Cascade |
No Action |
|
Immediate |
Associating a role with a user account. |
||
urol_usr_id |
usr_id |
Cascade |
No Action |
|
Immediate |
Associating a user account with a role. |
Check Constraints
There are no check constraints for table tj_userrole_usr_rol_urol
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
urol_usr_id, urol_rol_id |
|
|
|
|
btree |
|
urol_rol_id |
|
|
Index on the attachment to a role in order to optimize the time of requests |
|
btree |
|
urol_usr_id |
|
|
Index on the attachment to a user account in order to optimize the time of requests |
Triggers
There are no triggers for table tj_userrole_usr_rol_urol
Rules
There are no rules for table tj_userrole_usr_rol_urol
Policies
There are no policies for table tj_userrole_usr_rol_urol
Referenced
There are no tables referenced by table tj_userrole_usr_rol_urol
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
urol_usr_id INTEGER NOT NULL,
urol_rol_id INTEGER NOT NULL,
CONSTRAINT c_pk_tj_urol_usr_rol_arol PRIMARY KEY(urol_usr_id, urol_rol_id),
CONSTRAINT c_fk_rol_urol FOREIGN KEY (urol_rol_id)
REFERENCES application.t_role_rol(rol_id)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_usr_urol FOREIGN KEY (urol_usr_id)
REFERENCES application.t_user_usr(usr_id)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE application.tj_userrole_usr_rol_urol
IS 'Table assigning a role to a user account.';
COMMENT ON COLUMN application.tj_userrole_usr_rol_urol.urol_usr_id
IS 'User ID (postgres).';
COMMENT ON COLUMN application.tj_userrole_usr_rol_urol.urol_rol_id
IS 'Role ID (postgres).';
COMMENT ON CONSTRAINT c_fk_rol_urol ON application.tj_userrole_usr_rol_urol
IS 'Associating a role with a user account.';
COMMENT ON CONSTRAINT c_fk_usr_urol ON application.tj_userrole_usr_rol_urol
IS 'Associating a user account with a role.';
CREATE INDEX x_btr_rol_id_urol ON application.tj_userrole_usr_rol_urol
USING btree (urol_rol_id);
COMMENT ON INDEX application.x_btr_rol_id_urol
IS 'Index on the attachment to a role in order to optimize the time of requests';
CREATE INDEX x_btr_usr_id_urol ON application.tj_userrole_usr_rol_urol
USING btree (urol_usr_id);
COMMENT ON INDEX application.x_btr_usr_id_urol
IS 'Index on the attachment to a user account in order to optimize the time of requests';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|