db_ecological_db |
|
Table: tr_role_rol
db_ecological_db |
|
Table: tr_role_rol
Schema
Owner
ecological_db
Tablespace
(default)
Descriptions
Table des rôles que peuvent tenir des personnes
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
rol_id |
serial |
|
|
|
nextval('tr_role_rol_rol_id_seq'::regclass) |
Identifiant unique automatique du rôle |
|
|
rol_libelle |
varchar(32) |
|
|
|
|
Libellé unique du rôle |
|
|
rol_description |
text |
|
|
|
|
Descritpion complète du rôle |
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 |
|---|---|---|---|---|---|---|
btree |
|
rol_libelle |
|
|
Le libellé d'un role doit être 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 | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
roz_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
Le champ roz_rol_id correspond obligatoirement à un rôle existant |
||||
ror_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
Le champ ror_rol_id correspond obligatoirement à un rôle existant |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
rol_id SERIAL,
rol_libelle VARCHAR(32) NOT NULL,
rol_description TEXT NOT NULL,
CONSTRAINT c_uni_libelle_rol UNIQUE(rol_libelle),
CONSTRAINT tr_role_rol_pkey PRIMARY KEY(rol_id)
) ;
COMMENT ON TABLE public.tr_role_rol
IS 'Table des rôles que peuvent tenir des personnes';
COMMENT ON COLUMN public.tr_role_rol.rol_id
IS 'Identifiant unique automatique du rôle';
COMMENT ON COLUMN public.tr_role_rol.rol_libelle
IS 'Libellé unique du rôle';
COMMENT ON COLUMN public.tr_role_rol.rol_description
IS 'Descritpion complète du rôle';
COMMENT ON CONSTRAINT c_uni_libelle_rol ON public.tr_role_rol
IS 'Le libellé d''un role doit être unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|