Table tr_role

pggeodb-preprod.nancy.inra.fr/db_onf_gde - db_onf_gde on pggeodb-preprod.nancy.inra.fr

Table: tr_role_rol

Schema

public

Owner

postgres

Tablespace

(default)

Descriptions

Table des roles. Informations relatives aux roles (Onglet GDE)

Fields

PK	FK	Name	Data type	Not null	Unique	Inherited	Default	Description
		rol_id	serial				nextval('tr_role_rol_rol_id_seq'::regclass)	Identifiant automatique numérique du role
		rol_libelle	varchar(50)					Libelle du role

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_libelle_rol	btree		rol_libelle			Le libelle d'un role doit être 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	Deferrable	Check Time	Description
tj_pole_role_dispositif_prd	public	c_fk_rol_prd	prd_rol_id	public.tr_role_rol	rol_id	No Action	No Action		Immediate	Le champ prd_rol_id correspond obligatoirement à un role existant

Properties

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

Definition

CREATE TABLE public.tr_role_rol ( rol_id SERIAL, rol_libelle VARCHAR(50) NOT NULL, CONSTRAINT c_uni_libelle_rol UNIQUE(rol_libelle), CONSTRAINT tr_role_rol_pkey PRIMARY KEY(rol_id) ) WITH (oids = false); COMMENT ON TABLE public.tr_role_rol IS 'Table des roles. Informations relatives aux roles (Onglet GDE)'; COMMENT ON COLUMN public.tr_role_rol.rol_id IS 'Identifiant automatique numérique du role'; COMMENT ON COLUMN public.tr_role_rol.rol_libelle IS 'Libelle du role'; COMMENT ON CONSTRAINT c_uni_libelle_rol ON public.tr_role_rol IS 'Le libelle d''un role doit être unique';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23