Schema
Owner
postgres
Tablespace
(default)
Descriptions
Table des publications.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
pub_id |
serial |
|
nextval('tr_publication_pub_pub_id_seq'::regclass) |
Identifiant unique numérique de la publication |
|||
|
|
pub_code |
varchar(64) |
|
|
Code de la publication |
||
|
|
pub_description |
varchar(255) |
|
|
|
|
Description de la publication |
|
|
pub_annee |
integer |
|
|
|
|
année de la publication |
|
|
pub_reference |
varchar(255) |
|
|
|
|
Référence de la publication (DOI, URL ...) |
|
|
pub_auteurs |
varchar |
|
|
|
|
Auteurs de la publication |
|
|
pub_citation_ris |
text |
|
|
|
|
Lien vers fichier au format ris pour les citations |
Foreign Keys
There are no foreign keys for table tr_publication_pub
Check Constraints
There are no check constraints for table tr_publication_pub
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
pub_code |
|
Le code d'une publication doit être unique |
||
btree |
|
pub_id |
|
Triggers
There are no triggers for table tr_publication_pub
Rules
There are no rules for table tr_publication_pub
Policies
There are no policies for table tr_publication_pub
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
ext_second_pub_id |
pub_id |
No Action |
No Action |
|
Immediate |
Un extrait peut être rattaché (données bilbio) à une et une seule seconde publication |
||||
ext_pub_id |
pub_id |
No Action |
No Action |
|
Immediate |
Un extrait peut être rattaché (données bilbio) à une et une seule publication |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
9 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tr_publication_pub (
pub_id SERIAL,
pub_code VARCHAR(64) NOT NULL,
pub_description VARCHAR(255),
pub_annee INTEGER,
pub_reference VARCHAR(255),
pub_auteurs VARCHAR,
pub_citation_ris TEXT,
CONSTRAINT c_uni_code_pub UNIQUE(pub_code),
CONSTRAINT tr_publication_pub_pkey PRIMARY KEY(pub_id)
) ;
COMMENT ON TABLE public.tr_publication_pub
IS 'Table des publications.';
COMMENT ON COLUMN public.tr_publication_pub.pub_id
IS 'Identifiant unique numérique de la publication';
COMMENT ON COLUMN public.tr_publication_pub.pub_code
IS 'Code de la publication';
COMMENT ON COLUMN public.tr_publication_pub.pub_description
IS 'Description de la publication';
COMMENT ON COLUMN public.tr_publication_pub.pub_annee
IS 'année de la publication';
COMMENT ON COLUMN public.tr_publication_pub.pub_reference
IS 'Référence de la publication (DOI, URL ...)';
COMMENT ON COLUMN public.tr_publication_pub.pub_auteurs
IS 'Auteurs de la publication';
COMMENT ON COLUMN public.tr_publication_pub.pub_citation_ris
IS 'Lien vers fichier au format ris pour les citations';
COMMENT ON CONSTRAINT c_uni_code_pub ON public.tr_publication_pub
IS 'Le code d''une publication doit être unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |