pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: spectre
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: spectre
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table spectre
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_spectre |
serial |
|
|
|
nextval('spectre_id_spectre_seq'::regclass) |
|
|
|
long_onde |
varchar |
|
|
|
|
|
|
|
absorbance |
varchar |
|
|
|
|
|
|
|
spect_echant |
integer |
|
|
|
|
|
|
|
t_spectro |
integer |
|
|
|
|
|
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
spect_echant |
id_echant |
No Action |
No Action |
|
Immediate |
|
||
t_spectro |
id_spectro |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table spectre
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
spect_echant |
|
|
|
|
btree |
|
t_spectro |
|
|
|
|
btree |
|
id_spectre |
|
|
|
Triggers
There are no triggers for table spectre
Rules
There are no rules for table spectre
Policies
There are no policies for table spectre
Referenced
There are no tables referenced by table spectre
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
802323 |
Pages |
5893 |
System |
|
Temporary |
|
With OID |
|
Definition
id_spectre SERIAL,
long_onde VARCHAR,
absorbance VARCHAR,
spect_echant INTEGER,
t_spectro INTEGER,
CONSTRAINT pmk_spectre PRIMARY KEY(id_spectre),
CONSTRAINT st_spe_ech FOREIGN KEY (spect_echant)
REFERENCES public.pedotheque(id_echant)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT st_t_spectro FOREIGN KEY (t_spectro)
REFERENCES public.type_spectro(id_spectro)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
CREATE INDEX fki_st_spe_ech ON public.spectre
USING btree (spect_echant);
CREATE INDEX fki_st_t_spectro ON public.spectre
USING btree (t_spectro);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|