db_toff on pggeodb.nancy.inra.fr |
|
Table: t_person_per
db_toff on pggeodb.nancy.inra.fr |
|
Table: t_person_per
Schema
Owner
postgres
Tablespace
(default)
Descriptions
Table displaying the people / Table contenant des personnes
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
per_id |
serial |
|
|
|
nextval('t_person_per_per_id_seq'::regclass) |
Automatic ID of the recorder / Identifiant automatique de la personne qui entre la donnée |
|
|
per_last_name |
varchar(36) |
|
|
|
|
Person last name / Nom de la personne |
|
|
per_first_name |
varchar(32) |
|
|
|
|
Person first name / Prénom de la personne |
|
|
per_email |
varchar(320) |
|
|
|
|
Person email / Adresse mail unique de la personne. |
Foreign Keys
There are no foreign keys for table t_person_per
Check Constraints
There are no check constraints for table t_person_per
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
per_email |
|
|
Person email is unique / L'adresse mail d'une personne est unique |
|
btree |
|
per_last_name, per_first_name |
|
|
uniqueness of last_name + first_name / unicite du couple nom - prenom d'une personne |
|
btree |
|
per_id |
|
|
|
Triggers
There are no triggers for table t_person_per
Rules
There are no rules for table t_person_per
Policies
There are no policies for table t_person_per
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
mea_assessor_per_id |
per_id |
No Action |
No Action |
|
Immediate |
A measure is related to only one assessor / Une mesure est associée à une et une seule personne (valideur) |
||||
mea_recorder_per_id |
per_id |
No Action |
No Action |
|
Immediate |
A measure is related to only one recorder / Une mesure est associée à une et une seule personne (encodeur) |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
per_id SERIAL,
per_last_name VARCHAR(36) NOT NULL,
per_first_name VARCHAR(32) NOT NULL,
per_email VARCHAR(320) NOT NULL,
CONSTRAINT c_uni_email_per UNIQUE(per_email),
CONSTRAINT c_uni_last_name_first_name_per UNIQUE(per_last_name, per_first_name),
CONSTRAINT t_person_per_pkey PRIMARY KEY(per_id)
)
WITH (oids = false);
COMMENT ON TABLE public.t_person_per
IS 'Table displaying the people / Table contenant des personnes';
COMMENT ON COLUMN public.t_person_per.per_id
IS 'Automatic ID of the recorder / Identifiant automatique de la personne qui entre la donnée';
COMMENT ON COLUMN public.t_person_per.per_last_name
IS 'Person last name / Nom de la personne';
COMMENT ON COLUMN public.t_person_per.per_first_name
IS 'Person first name / Prénom de la personne';
COMMENT ON COLUMN public.t_person_per.per_email
IS 'Person email / Adresse mail unique de la personne.';
COMMENT ON CONSTRAINT c_uni_email_per ON public.t_person_per
IS 'Person email is unique / L''adresse mail d''une personne est unique';
COMMENT ON CONSTRAINT c_uni_last_name_first_name_per ON public.t_person_per
IS 'uniqueness of last_name + first_name / unicite du couple nom - prenom d''une personne';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |
|