Schema
Owner
postgres
Tablespace
(default)
Descriptions
table des fournisseurs de sources de données
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
ori_id |
serial |
|
nextval('tr_origine_ori_ori_id_seq'::regclass) |
Identifiant automatique numérique de l' origine |
|||
|
|
ori_nom |
varchar(30) |
|
|
nom unique de l' origine |
||
|
|
ori_url_origine |
varchar(150) |
|
|
|
|
url vers le site internet de l' origine |
|
|
ori_description |
varchar(250) |
|
|
|
description de l' origine |
Foreign Keys
There are no foreign keys for table tr_origine_ori
Check Constraints
There are no check constraints for table tr_origine_ori
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
ori_nom |
|
Le nom de l'origine est unique |
||
btree |
|
ori_id |
|
Triggers
There are no triggers for table tr_origine_ori
Rules
There are no rules for table tr_origine_ori
Policies
There are no policies for table tr_origine_ori
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
src_ori_id |
ori_id |
No Action |
No Action |
|
Immediate |
Une source de donnée est rattachée à une et une seule origine |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
7 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tr_origine_ori (
ori_id SERIAL,
ori_nom VARCHAR(30) NOT NULL,
ori_url_origine VARCHAR(150),
ori_description VARCHAR(250) NOT NULL,
CONSTRAINT c_uni_nom_ori UNIQUE(ori_nom),
CONSTRAINT tr_origine_ori_pkey PRIMARY KEY(ori_id)
) ;
COMMENT ON TABLE public.tr_origine_ori
IS 'table des fournisseurs de sources de données';
COMMENT ON COLUMN public.tr_origine_ori.ori_id
IS 'Identifiant automatique numérique de l'' origine';
COMMENT ON COLUMN public.tr_origine_ori.ori_nom
IS 'nom unique de l'' origine';
COMMENT ON COLUMN public.tr_origine_ori.ori_url_origine
IS 'url vers le site internet de l'' origine';
COMMENT ON COLUMN public.tr_origine_ori.ori_description
IS 'description de l'' origine';
COMMENT ON CONSTRAINT c_uni_nom_ori ON public.tr_origine_ori
IS 'Le nom de l''origine est unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |