pggeodb.nancy.inra.fr/db_toff - db_toff on pggeodb.nancy.inra.fr |
|
Table: t_carac_matrice_complete
pggeodb.nancy.inra.fr/db_toff - db_toff on pggeodb.nancy.inra.fr |
|
Table: t_carac_matrice_complete
Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table t_carac_matrice_complete
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
rowid |
integer |
|
|
|
|
|
|
|
Chlorophyll a (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Kind of aquatic environment(Aquatic environment) |
text |
|
|
|
|
|
|
|
Turbidity (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Transparency (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Brackishwater species(Salinity) |
text |
|
|
|
|
|
|
|
Sand(Nature of the substrate) |
text |
|
|
|
|
|
|
|
Conductivity (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Water current (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Chlorophyll a (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Total fish number(Biotic environment) |
text |
|
|
|
|
|
|
|
Temperature (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Rock(Nature of the substrate) |
text |
|
|
|
|
|
|
|
Oxygen (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Conspecific fish number(Biotic environment) |
text |
|
|
|
|
|
|
|
Surface of the water(Depth preference) |
text |
|
|
|
|
|
|
|
Total alkalinity (min)(Water parameters) |
text |
|
|
|
|
|
|
|
Freshwater species(Salinity) |
text |
|
|
|
|
|
|
|
Total Phosphorus (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Total alkalinity (max)(Water parameters) |
text |
|
|
|
|
|
|
|
Total Phosphorus (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Ammonia (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Water discharge rate (mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Depth(Depth preference) |
text |
|
|
|
|
|
|
|
Transparency (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Total Nitrogen (standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Water current (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Chlorophyll a (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Chlorophyll a (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Nitrate (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Oxygen (Median)(Water parameters) |
text |
|
|
|
|
|
|
|
Ammonia (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Latitudes(Geographic occurrence) |
text |
|
|
|
|
|
|
|
Temperature (Median)(Water parameters) |
text |
|
|
|
|
|
|
|
Water discharge rate (min)(Water parameters) |
text |
|
|
|
|
|
|
|
Transparency (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Turbidity (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Food disponiblity ad libitum(Feeding) |
text |
|
|
|
|
|
|
|
Transparency (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Temperature (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Pisciculture(Aquatic environment) |
text |
|
|
|
|
|
|
|
Light (Lux)(Water parameters) |
text |
|
|
|
|
|
|
|
Nitrate (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Gravel / Pebble(Nature of the substrate) |
text |
|
|
|
|
|
|
|
Ammonia (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Total alkalinity (mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Temperature (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Total fish biomass(Biotic environment) |
text |
|
|
|
|
|
|
|
Nitrate (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Experimental environment(Aquatic environment) |
text |
|
|
|
|
|
|
|
pH (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Water discharge rate (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
pH (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
pH (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
pH (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Conspecific fish biomass(Biotic environment) |
text |
|
|
|
|
|
|
|
Oxygen (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Nitrate (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Ammonia (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Oxygen (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Total Phosphorus (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Total alkalinity (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Water discharge rate (standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Nitrate (Median)(Water parameters) |
text |
|
|
|
|
|
|
|
Turbidity (Min)(Water parameters) |
text |
|
|
|
|
|
|
|
Total Phosphorus (Standard deviation)(Water parameters) |
text |
|
|
|
|
|
|
|
Benthic/demersal(Depth preference) |
text |
|
|
|
|
|
|
|
Aquatic vegetation(Substrate cover) |
text |
|
|
|
|
|
|
|
Pelagic(Depth preference) |
text |
|
|
|
|
|
|
|
Temperature (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Longitudes(Geographic occurrence) |
text |
|
|
|
|
|
|
|
Stream order(Aquatic environment) |
text |
|
|
|
|
|
|
|
Species diversity(Biotic environment) |
text |
|
|
|
|
|
|
|
Conductivity (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Oxygen (Max)(Water parameters) |
text |
|
|
|
|
|
|
|
Total Nitrogen (Mean)(Water parameters) |
text |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table t_carac_matrice_complete
Check Constraints
There are no check constraints for table t_carac_matrice_complete
Indices
There are no indices for table t_carac_matrice_complete
Triggers
There are no triggers for table t_carac_matrice_complete
Rules
There are no rules for table t_carac_matrice_complete
Policies
There are no policies for table t_carac_matrice_complete
Referenced
There are no tables referenced by table t_carac_matrice_complete
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
761 |
Pages |
9 |
System |
|
Temporary |
|
With OID |
|
Definition
rowid INTEGER,
"Chlorophyll a (Standard deviation)(Water parameters)" TEXT,
"Kind of aquatic environment(Aquatic environment)" TEXT,
"Turbidity (Max)(Water parameters)" TEXT,
"Transparency (Standard deviation)(Water parameters)" TEXT,
"Brackishwater species(Salinity)" TEXT,
"Sand(Nature of the substrate)" TEXT,
"Conductivity (Standard deviation)(Water parameters)" TEXT,
"Water current (Min)(Water parameters)" TEXT,
"Chlorophyll a (Mean)(Water parameters)" TEXT,
"Total fish number(Biotic environment)" TEXT,
"Temperature (Mean)(Water parameters)" TEXT,
"Rock(Nature of the substrate)" TEXT,
"Oxygen (Standard deviation)(Water parameters)" TEXT,
"Conspecific fish number(Biotic environment)" TEXT,
"Surface of the water(Depth preference)" TEXT,
"Total alkalinity (min)(Water parameters)" TEXT,
"Freshwater species(Salinity)" TEXT,
"Total Phosphorus (Max)(Water parameters)" TEXT,
"Total alkalinity (max)(Water parameters)" TEXT,
"Total Phosphorus (Min)(Water parameters)" TEXT,
"Ammonia (Standard deviation)(Water parameters)" TEXT,
"Water discharge rate (mean)(Water parameters)" TEXT,
"Depth(Depth preference)" TEXT,
"Transparency (Mean)(Water parameters)" TEXT,
"Total Nitrogen (standard deviation)(Water parameters)" TEXT,
"Water current (Mean)(Water parameters)" TEXT,
"Chlorophyll a (Max)(Water parameters)" TEXT,
"Chlorophyll a (Min)(Water parameters)" TEXT,
"Nitrate (Max)(Water parameters)" TEXT,
"Oxygen (Median)(Water parameters)" TEXT,
"Ammonia (Mean)(Water parameters)" TEXT,
"Latitudes(Geographic occurrence)" TEXT,
"Temperature (Median)(Water parameters)" TEXT,
"Water discharge rate (min)(Water parameters)" TEXT,
"Transparency (Max)(Water parameters)" TEXT,
"Turbidity (Mean)(Water parameters)" TEXT,
"Food disponiblity ad libitum(Feeding)" TEXT,
"Transparency (Min)(Water parameters)" TEXT,
"Temperature (Min)(Water parameters)" TEXT,
"Pisciculture(Aquatic environment)" TEXT,
"Light (Lux)(Water parameters)" TEXT,
"Nitrate (Mean)(Water parameters)" TEXT,
"Gravel / Pebble(Nature of the substrate)" TEXT,
"Ammonia (Max)(Water parameters)" TEXT,
"Total alkalinity (mean)(Water parameters)" TEXT,
"Temperature (Standard deviation)(Water parameters)" TEXT,
"Total fish biomass(Biotic environment)" TEXT,
"Nitrate (Standard deviation)(Water parameters)" TEXT,
"Experimental environment(Aquatic environment)" TEXT,
"pH (Min)(Water parameters)" TEXT,
"Water discharge rate (Max)(Water parameters)" TEXT,
"pH (Standard deviation)(Water parameters)" TEXT,
"pH (Mean)(Water parameters)" TEXT,
"pH (Max)(Water parameters)" TEXT,
"Conspecific fish biomass(Biotic environment)" TEXT,
"Oxygen (Min)(Water parameters)" TEXT,
"Nitrate (Min)(Water parameters)" TEXT,
"Ammonia (Min)(Water parameters)" TEXT,
"Oxygen (Mean)(Water parameters)" TEXT,
"Total Phosphorus (Mean)(Water parameters)" TEXT,
"Total alkalinity (Standard deviation)(Water parameters)" TEXT,
"Water discharge rate (standard deviation)(Water parameters)" TEXT,
"Nitrate (Median)(Water parameters)" TEXT,
"Turbidity (Min)(Water parameters)" TEXT,
"Total Phosphorus (Standard deviation)(Water parameters)" TEXT,
"Benthic/demersal(Depth preference)" TEXT,
"Aquatic vegetation(Substrate cover)" TEXT,
"Pelagic(Depth preference)" TEXT,
"Temperature (Max)(Water parameters)" TEXT,
"Longitudes(Geographic occurrence)" TEXT,
"Stream order(Aquatic environment)" TEXT,
"Species diversity(Biotic environment)" TEXT,
"Conductivity (Mean)(Water parameters)" TEXT,
"Oxygen (Max)(Water parameters)" TEXT,
"Total Nitrogen (Mean)(Water parameters)" TEXT
)
WITH (oids = false);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|