Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table t_trait_matrice_complete
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
|
rowid |
integer |
|
|
|
|
|
|
|
Run and kill (Hunting strategy) |
text |
|
|
|
|
|
|
|
Gregarious strategy (Relation inter individuals) |
text |
|
|
|
|
|
|
|
Egg diameter (Standard deviation) (Reproduction) |
text |
|
|
|
|
|
|
|
Detritivore (Diet) |
text |
|
|
|
|
|
|
|
Fish weight (max) (Growth and development ) |
text |
|
|
|
|
|
|
|
Fork length (mean) (Growth and development ) |
text |
|
|
|
|
|
|
|
Total length (max) (Growth and development ) |
text |
|
|
|
|
|
|
|
Nocturnal (Activity period) |
text |
|
|
|
|
|
|
|
Flattened vertically (Body shape) |
text |
|
|
|
|
|
|
|
Filter feeders (Hunting strategy) |
text |
|
|
|
|
|
|
|
Fish weight (Standard deviation) (Growth and development ) |
text |
|
|
|
|
|
|
|
Gill raker length (Growth and development ) |
text |
|
|
|
|
|
|
|
Sit and wait (Hunting strategy) |
text |
|
|
|
|
|
|
|
Inferior (Mouth position) |
text |
|
|
|
|
|
|
|
Growth rate (Standard deviation) (Growth rate) |
text |
|
|
|
|
|
|
|
Grazing and/or Scraping (Hunting strategy) |
text |
|
|
|
|
|
|
|
Body width (Standard deviation) (Growth and development ) |
text |
|
|
|
|
|
|
|
Egg diameter (min) (Reproduction) |
text |
|
|
|
|
|
|
|
Clutch size (mean) (Reproduction) |
text |
|
|
|
|
|
|
|
Egg diameter (max) (Reproduction) |
text |
|
|
|
|
|
|
|
Diurnal (Activity period) |
text |
|
|
|
|
|
|
|
Standard length (Standard deviation) (Growth and development ) |
text |
|
|
|
|
|
|
|
Sexual dimorphism (Reproduction) |
text |
|
|
|
|
|
|
|
Eye diameter (Standard deviation) (Eye characteristic) |
text |
|
|
|
|
|
|
|
Phytoplanktivore (Diet) |
text |
|
|
|
|
|
|
|
Fusiform (Body shape) |
text |
|
|
|
|
|
|
|
Fish weight (mean) (Growth and development ) |
text |
|
|
|
|
|
|
|
Mean life span (Lifespan) |
text |
|
|
|
|
|
|
|
Insectivore (Diet) |
text |
|
|
|
|
|
|
|
Piscivore (Diet) |
text |
|
|
|
|
|
|
|
Eye diameter (max) (Eye characteristic) |
text |
|
|
|
|
|
|
|
Heterogeneous colour (Colour) |
text |
|
|
|
|
|
|
|
Fish weight (median) (Growth and development ) |
text |
|
|
|
|
|
|
|
Clutch size (Standard deviation) (Reproduction) |
text |
|
|
|
|
|
|
|
Growth rate (Mean) (Growth rate) |
text |
|
|
|
|
|
|
|
Eye diameter (mean) (Eye characteristic) |
text |
|
|
|
|
|
|
|
Periphytivorous (Diet) |
text |
|
|
|
|
|
|
|
Egg diameter (mean) (Reproduction) |
text |
|
|
|
|
|
|
|
Algivore (Diet) |
text |
|
|
|
|
|
|
|
Fish weight (min) (Growth and development ) |
text |
|
|
|
|
|
|
|
Condition index (or Fish condition factor) (Growth and developm |
text |
|
|
|
|
|
|
|
Pelagic feeding (Feeding location) |
text |
|
|
|
|
|
|
|
Omnivore (Diet) |
text |
|
|
|
|
|
|
|
Body width (mean) (Growth and development ) |
text |
|
|
|
|
|
|
|
Phytivorous (including macrophytes) = herbivorous (Diet) |
text |
|
|
|
|
|
|
|
Ratio prey size/fish size (Prey eaten) |
text |
|
|
|
|
|
|
|
Clutch size (min) (Reproduction) |
text |
|
|
|
|
|
|
|
Benthic feeding (Feeding location) |
text |
|
|
|
|
|
|
|
Carnivore (Diet) |
text |
|
|
|
|
|
|
|
Fork length (max) (Growth and development ) |
text |
|
|
|
|
|
|
|
Total length (mean) (Growth and development ) |
text |
|
|
|
|
|
|
|
Standard length (mean) (Growth and development ) |
text |
|
|
|
|
|
|
|
Fork length (min) (Growth and development ) |
text |
|
|
|
|
|
|
|
Fork length (Standard deviation) (Growth and development ) |
text |
|
|
|
|
|
|
|
Total length (median) (Growth and development ) |
text |
|
|
|
|
|
|
|
Standard length (min) (Growth and development ) |
text |
|
|
|
|
|
|
|
Terminal (Mouth position) |
text |
|
|
|
|
|
|
|
Clutch size (max) (Reproduction) |
text |
|
|
|
|
|
|
|
Standard length (max) (Growth and development ) |
text |
|
|
|
|
|
|
|
Total length (Standard deviation) (Growth and development ) |
text |
|
|
|
|
|
|
|
Superior (Mouth position) |
text |
|
|
|
|
|
|
|
Zooplanctivore (Diet) |
text |
|
|
|
|
|
|
|
Oophagous (Diet) |
text |
|
|
|
|
|
|
|
Invertivore (Diet) |
text |
|
|
|
|
|
|
|
Total length (min) (Growth and development ) |
text |
|
|
|
|
|
|
|
Uniform colour (Colour) |
text |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table t_trait_matrice_complete
Check Constraints
There are no check constraints for table t_trait_matrice_complete
Indices
There are no indices for table t_trait_matrice_complete
Triggers
There are no triggers for table t_trait_matrice_complete
Rules
There are no rules for table t_trait_matrice_complete
Policies
There are no policies for table t_trait_matrice_complete
Referenced
There are no tables referenced by table t_trait_matrice_complete
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
736 |
Pages |
6 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE support.t_trait_matrice_complete (
rowid INTEGER,
"Run and kill (Hunting strategy)" TEXT,
"Gregarious strategy (Relation inter individuals)" TEXT,
"Egg diameter (Standard deviation) (Reproduction)" TEXT,
"Detritivore (Diet)" TEXT,
"Fish weight (max) (Growth and development )" TEXT,
"Fork length (mean) (Growth and development )" TEXT,
"Total length (max) (Growth and development )" TEXT,
"Nocturnal (Activity period)" TEXT,
"Flattened vertically (Body shape)" TEXT,
"Filter feeders (Hunting strategy)" TEXT,
"Fish weight (Standard deviation) (Growth and development )" TEXT,
"Gill raker length (Growth and development )" TEXT,
"Sit and wait (Hunting strategy)" TEXT,
"Inferior (Mouth position)" TEXT,
"Growth rate (Standard deviation) (Growth rate)" TEXT,
"Grazing and/or Scraping (Hunting strategy)" TEXT,
"Body width (Standard deviation) (Growth and development )" TEXT,
"Egg diameter (min) (Reproduction)" TEXT,
"Clutch size (mean) (Reproduction)" TEXT,
"Egg diameter (max) (Reproduction)" TEXT,
"Diurnal (Activity period)" TEXT,
"Standard length (Standard deviation) (Growth and development )" TEXT,
"Sexual dimorphism (Reproduction)" TEXT,
"Eye diameter (Standard deviation) (Eye characteristic)" TEXT,
"Phytoplanktivore (Diet)" TEXT,
"Fusiform (Body shape)" TEXT,
"Fish weight (mean) (Growth and development )" TEXT,
"Mean life span (Lifespan)" TEXT,
"Insectivore (Diet)" TEXT,
"Piscivore (Diet)" TEXT,
"Eye diameter (max) (Eye characteristic)" TEXT,
"Heterogeneous colour (Colour)" TEXT,
"Fish weight (median) (Growth and development )" TEXT,
"Clutch size (Standard deviation) (Reproduction)" TEXT,
"Growth rate (Mean) (Growth rate)" TEXT,
"Eye diameter (mean) (Eye characteristic)" TEXT,
"Periphytivorous (Diet)" TEXT,
"Egg diameter (mean) (Reproduction)" TEXT,
"Algivore (Diet)" TEXT,
"Fish weight (min) (Growth and development )" TEXT,
"Condition index (or Fish condition factor) (Growth and developm" TEXT,
"Pelagic feeding (Feeding location)" TEXT,
"Omnivore (Diet)" TEXT,
"Body width (mean) (Growth and development )" TEXT,
"Phytivorous (including macrophytes) = herbivorous (Diet)" TEXT,
"Ratio prey size/fish size (Prey eaten)" TEXT,
"Clutch size (min) (Reproduction)" TEXT,
"Benthic feeding (Feeding location)" TEXT,
"Carnivore (Diet)" TEXT,
"Fork length (max) (Growth and development )" TEXT,
"Total length (mean) (Growth and development )" TEXT,
"Standard length (mean) (Growth and development )" TEXT,
"Fork length (min) (Growth and development )" TEXT,
"Fork length (Standard deviation) (Growth and development )" TEXT,
"Total length (median) (Growth and development )" TEXT,
"Standard length (min) (Growth and development )" TEXT,
"Terminal (Mouth position)" TEXT,
"Clutch size (max) (Reproduction)" TEXT,
"Standard length (max) (Growth and development )" TEXT,
"Total length (Standard deviation) (Growth and development )" TEXT,
"Superior (Mouth position)" TEXT,
"Zooplanctivore (Diet)" TEXT,
"Oophagous (Diet)" TEXT,
"Invertivore (Diet)" TEXT,
"Total length (min) (Growth and development )" TEXT,
"Uniform colour (Colour)" TEXT
)
WITH (oids = false);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |