pggeodb.nancy.inra.fr/db_wood_db - db_wood_db on pggeodb.nancy.inra.fr |
|
Table: tr_solvant_slv
pggeodb.nancy.inra.fr/db_wood_db - db_wood_db on pggeodb.nancy.inra.fr |
|
Table: tr_solvant_slv
Schema
Owner
postgres
Tablespace
(default)
Descriptions
Table des solvants utilisés lors des extractions
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
slv_id |
serial |
|
|
|
nextval('tr_solvant_slv_slv_id_seq'::regclass) |
Identifiant automatique numérique du solvant |
|
|
slv_code |
varchar(64) |
|
|
|
|
Code unique du solvant |
|
|
slv_description |
varchar |
|
|
|
|
Description du solvant |
Foreign Keys
There are no foreign keys for table tr_solvant_slv
Check Constraints
There are no check constraints for table tr_solvant_slv
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
slv_code |
|
|
Le code d'un solvant doit être unique |
|
btree |
|
slv_id |
|
|
|
Triggers
There are no triggers for table tr_solvant_slv
Rules
There are no rules for table tr_solvant_slv
Policies
There are no policies for table tr_solvant_slv
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
proe_slv_id |
slv_id |
No Action |
No Action |
|
Immediate |
Le champ proe_slv_id correspond obligatoirement à un solvant existant |
||||
slve_slv_id |
slv_id |
No Action |
No Action |
|
Immediate |
Le champ slve_slv_id correspond obligatoirement à un solvant existant |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
11 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
slv_id SERIAL,
slv_code VARCHAR(64) NOT NULL,
slv_description VARCHAR,
CONSTRAINT c_uni_code_slv UNIQUE(slv_code),
CONSTRAINT tr_solvant_slv_pkey PRIMARY KEY(slv_id)
) ;
COMMENT ON TABLE public.tr_solvant_slv
IS 'Table des solvants utilisés lors des extractions';
COMMENT ON COLUMN public.tr_solvant_slv.slv_id
IS 'Identifiant automatique numérique du solvant';
COMMENT ON COLUMN public.tr_solvant_slv.slv_code
IS 'Code unique du solvant';
COMMENT ON COLUMN public.tr_solvant_slv.slv_description
IS 'Description du solvant';
COMMENT ON CONSTRAINT c_uni_code_slv ON public.tr_solvant_slv
IS 'Le code d''un solvant doit être unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|