LeBauer:BETYdb/tables
From OpenWetWare
Jump to navigationJump to search
id | author | year | title | journal | vol | pg | url | created_at | updated_at | doi | ||
Type | int(11) | varchar(255) | int(11) | varchar(255) | varchar(255) | int(11) | varchar(255) | varchar(512) | varchar(255) | datetime | datetime | varchar(255) |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | ||||||||||||
Extra | auto_increment |
citation_id | site_id | created_at | updated_at | |
Type | int(11) | int(11) | datetime | datetime |
Null | YES | YES | YES | YES |
Default | ||||
Extra |
citation_id | treatment_id | created_at | updated_at | |
Type | int(11) | int(11) | datetime | datetime |
Null | YES | YES | YES | YES |
Default | ||||
Extra |
id | trait_id | variable_id | level | created_at | updated_at | |
Type | int(11) | int(11) | int(11) | decimal(16,4) | datetime | datetime |
Null | NO | YES | YES | YES | YES | YES |
Default | ||||||
Extra | auto_increment |
id | specie_id | name | ecotype | notes | created_at | updated_at | previous_id | |
Type | int(11) | int(11) | varchar(255) | varchar(255) | text | datetime | datetime | varchar(255) |
Null | NO | YES | YES | YES | YES | YES | YES | YES |
Default | ||||||||
Extra | auto_increment |
id | record_id | description | relationship | user_id | fixed | created_at | updated_at | |
Type | int(11) | int(11) | varchar(255) | varchar(255) | int(11) | int(11) | datetime | datetime |
Null | NO | YES | YES | YES | YES | YES | YES | YES |
Default | 0 | |||||||
Extra | auto_increment |
id | citation_id | date | dateloc | mgmttype | level | units | notes | created_at | updated_at | |
Type | int(11) | int(11) | date | decimal(4,2) | varchar(255) | decimal(16,4) | varchar(255) | text | datetime | datetime |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | ||||||||||
Extra | auto_increment |
treatment_id | management_id | created_at | updated_at | |
Type | int(11) | int(11) | datetime | datetime |
Null | YES | YES | YES | YES |
Default | ||||
Extra |
id | definition | created_at | updated_at | name | |
Type | int(11) | text | datetime | datetime | varchar(255) |
Null | NO | YES | YES | YES | YES |
Default | |||||
Extra | auto_increment |
pft_id | prior_id | created_at | updated_at | |
Type | int(11) | int(11) | datetime | datetime |
Null | YES | YES | YES | YES |
Default | ||||
Extra |
pft_id | specie_id | created_at | updated_at | |
Type | int(11) | int(11) | datetime | datetime |
Null | YES | YES | YES | YES |
Default | ||||
Extra |
id | AcceptedSymbol | SynonymSymbol | ScientificName | Symbol | CommonName | PLANTS_Floristic_Area | State | Category | Genus | Family | FamilySymbol | FamilyCommonName | xOrder | SubClass | Class | SubDivision | Division | SuperDivision | SubKingdom | Kingdom | ITIS_TSN | Duration | GrowthHabit | NativeStatus | FederalNoxiousStatus | FederalNoxiousCommonName | StateNoxiousStatus | StateNoxiousCommonName | Invasive | Federal_TE_Status | State_TE_Status | State_TE_Common_Name | NationalWetlandIndicatorStatus | RegionalWetlandIndicatorStatus | ActiveGrowthPeriod | AfterHarvestRegrowthRate | Bloat | C2N_Ratio | CoppicePotential | FallConspicuous | FireResistance | FlowerColor | FlowerConspicuous | FoliageColor | FoliagePorositySummer | FoliagePorosityWinter | FoliageTexture | FruitColor | FruitConspicuous | GrowthForm | GrowthRate | MaxHeight20Yrs | MatureHeight | KnownAllelopath | LeafRetention | Lifespan | LowGrowingGrass | NitrogenFixation | ResproutAbility | Shape_and_Orientation | Toxicity | AdaptedCoarseSoils | AdaptedMediumSoils | AdaptedFineSoils | AnaerobicTolerance | CaCO3Tolerance | ColdStratification | DroughtTolerance | FertilityRequirement | FireTolerance | MinFrostFreeDays | HedgeTolerance | MoistureUse | pH_Minimum | pH_Maximum | Min_PlantingDensity | Max_PlantingDensity | Precipitation_Minimum | Precipitation_Maximum | RootDepthMinimum | SalinityTolerance | ShadeTolerance | TemperatureMinimum | BloomPeriod | CommercialAvailability | FruitSeedAbundance | FruitSeedPeriodBegin | FruitSeedPeriodEnd | FruitSeedPersistence | Propogated_by_BareRoot | Propogated_by_Bulbs | Propogated_by_Container | Propogated_by_Corms | Propogated_by_Cuttings | Propogated_by_Seed | Propogated_by_Sod | Propogated_by_Sprigs | Propogated_by_Tubers | Seeds_per_Pound | SeedSpreadRate | SeedlingVigor | SmallGrain | VegetativeSpreadRate | Berry_Nut_Seed_Product | ChristmasTreeProduct | FodderProduct | FuelwoodProduct | LumberProduct | NavalStoreProduct | NurseryStockProduct | PalatableBrowseAnimal | PalatableGrazeAnimal | PalatableHuman | PostProduct | ProteinPotential | PulpwoodProduct | VeneerProduct | created_at | updated_at | |
Type | int(11) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | text | text | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | int(11) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | text | text | varchar(255) | varchar(255) | varchar(255) | text | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | int(11) | int(11) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | int(11) | varchar(255) | varchar(255) | decimal(5,2) | decimal(5,2) | int(11) | int(11) | int(11) | int(11) | int(11) | varchar(255) | varchar(255) | int(11) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | int(11) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | datetime | datetime |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Extra | auto_increment |
id | citation_id | variable_id | phylogeny | distn | parama | paramb | paramc | n | notes | created_at | updated_at | |
Type | int(11) | int(11) | varchar(255) | varchar(255) | varchar(255) | decimal(16,4) | decimal(16,4) | decimal(16,4) | int(11) | text | datetime | datetime |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | ||||||||||||
Extra | auto_increment |
version | |
Type | varchar(255) |
Null | NO |
Default | |
Extra |
id | usgsmuid | city | state | country | lat | lon | gdd | firstkillingfrost | mat | map | masl | soil | zrt | zh2o | som | notes | soilnotes | created_at | updated_at | sitename | greenhouse | |
Type | int(11) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | decimal(9,6) | decimal(9,6) | int(11) | date | int(11) | int(11) | int(11) | varchar(255) | decimal(4,2) | decimal(4,1) | decimal(4,2) | text | text | datetime | datetime | varchar(255) | tinyint(1) |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | ||||||||||||||||||||||
Extra | auto_increment |
id | plant_id | spcd | pft | genus | species | scientificname | commonname | notes | created_at | updated_at | |
Type | int(11) | int(11) | int(11) | int(11) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | datetime | datetime |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | |||||||||||
Extra | auto_increment |
id | site_id | specie_id | citation_id | cultivar_id | treatment_id | date | dateloc | time | timeloc | mean | n | statname | stat | notes | created_at | updated_at | variable_id | user_id | checked | access_level | |
Type | int(11) | int(11) | int(11) | int(11) | int(11) | int(11) | datetime | decimal(4,2) | time | decimal(4,2) | decimal(16,4) | int(11) | varchar(255) | decimal(16,4) | text | datetime | datetime | int(11) | int(11) | tinyint(1) | int(11) |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | 0 | ||||||||||||||||||||
Extra | auto_increment |
id | name | definition | created_at | updated_at | control | |
Type | int(11) | varchar(255) | varchar(255) | datetime | datetime | tinyint(1) |
Null | NO | YES | YES | YES | YES | YES |
Default | ||||||
Extra | auto_increment |
id | login | name | city | country | field | crypted_password | salt | created_at | updated_at | remember_token | remember_token_expires_at | access_level | page_access_level | ||
Type | int(11) | varchar(40) | varchar(100) | varchar(100) | varchar(255) | varchar(255) | varchar(255) | varchar(40) | varchar(40) | datetime | datetime | varchar(40) | datetime | int(11) | int(11) |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | |||||||||||||||
Extra | auto_increment |
id | description | units | notes | created_at | updated_at | name | |
Type | int(11) | varchar(255) | varchar(255) | text | datetime | datetime | varchar(255) |
Null | NO | YES | YES | YES | YES | YES | YES |
Default | |||||||
Extra | auto_increment |
id | citation_id | site_id | specie_id | treatment_id | cultivar_id | date | dateloc | statname | stat | mean | n | notes | created_at | updated_at | user_id | checked | access_level | |
Type | int(11) | int(11) | int(11) | int(11) | int(11) | int(11) | date | decimal(4,2) | varchar(255) | decimal(16,4) | decimal(16,4) | int(11) | text | datetime | datetime | int(11) | tinyint(1) | int(11) |
Null | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
Default | 0 | |||||||||||||||||
Extra | auto_increment |