Table tr_role

pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr

Table: tr_role_rol

Schema

public

Owner

woodseer

Tablespace

(default)

Descriptions

Table of roles that people can play

Fields

Name	Data type	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	Fields	Primary Key	Unique	Description
c_uni_label_rol	btree		rol_label			The label of a role must be unique
tr_role_rol_pkey	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	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time	Description
tj_rol_ope_macq_romacq	public	c_fk_rol_romacq	romacq_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The rom_rol_id field necessarily corresponds to an existing role
tj_rol_ope_mdet_romdet	public	c_fk_rol_romdet	romdet_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The rom_rol_id field necessarily corresponds to an existing role
tj_rol_ope_mobj_romobj	public	c_fk_rol_romobj	romobj_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The rom_rol_id field necessarily corresponds to an existing role
tj_rol_ope_mzon_romzon	public	c_fk_rol_romzon	romzon_rol_id	public.tr_role_rol	rol_id	No Action	No Action	Immediate	The rom_rol_id field necessarily corresponds to an existing role

Properties

Property	Value
Inherited From
Rows	0
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) at 07/12/2018 13:23