Schema
Owner
globoxylo
Tablespace
(default)
Descriptions
Table of roles that people can play
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
rol_id |
serial |
|
nextval('tr_role_rol_rol_id_seq'::regclass) |
Automatic unique identifier of the role |
|||
|
|
rol_label |
varchar(32) |
|
|
Unique role label |
||
|
|
rol_description |
text |
|
|
|
Full role description |
Foreign Keys
There are no foreign keys for table tr_role_rol
Check Constraints
There are no check constraints for table tr_role_rol
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
rol_label |
|
The label of a role must be unique |
||
btree |
|
rol_id |
|
Triggers
There are no triggers for table tr_role_rol
Rules
There are no rules for table tr_role_rol
Policies
There are no policies for table tr_role_rol
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
rog_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
The rog_rol_id field must correspond to an existing role |
||||
ros_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
The ros_rol_id field necessarily corresponds to an existing role |
||||
rot_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
The rot_rol_id field necessarily corresponds to an existing role |
||||
roz_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
The roz_rol_id field must correspond to an existing role |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
-1 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tr_role_rol (
rol_id SERIAL,
rol_label VARCHAR(32) NOT NULL,
rol_description TEXT NOT NULL,
CONSTRAINT c_uni_label_rol UNIQUE(rol_label),
CONSTRAINT tr_role_rol_pkey PRIMARY KEY(rol_id)
) ;
COMMENT ON TABLE public.tr_role_rol
IS 'Table of roles that people can play';
COMMENT ON COLUMN public.tr_role_rol.rol_id
IS 'Automatic unique identifier of the role';
COMMENT ON COLUMN public.tr_role_rol.rol_label
IS 'Unique role label';
COMMENT ON COLUMN public.tr_role_rol.rol_description
IS 'Full role description';
COMMENT ON CONSTRAINT c_uni_label_rol ON public.tr_role_rol
IS 'The label of a role must be unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |