Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table t_carac_matrice_abiotic
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 |
|
|
|
|
|
|
|
Temperature (Mean)(Water parameters) |
text |
|
|
|
|
|
|
|
Rock(Nature of the substrate) |
text |
|
|
|
|
|
|
|
Oxygen (Standard deviation)(Water parameters) |
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 |
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
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_abiotic
Check Constraints
There are no check constraints for table t_carac_matrice_abiotic
Indices
There are no indices for table t_carac_matrice_abiotic
Triggers
There are no triggers for table t_carac_matrice_abiotic
Rules
There are no rules for table t_carac_matrice_abiotic
Policies
There are no policies for table t_carac_matrice_abiotic
Referenced
There are no tables referenced by table t_carac_matrice_abiotic
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
761 |
Pages |
8 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE support.t_carac_matrice_abiotic (
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,
"Temperature (Mean)(Water parameters)" TEXT,
"Rock(Nature of the substrate)" TEXT,
"Oxygen (Standard deviation)(Water parameters)" 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,
"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,
"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,
"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,
"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 |