LeBauer:BETYdb/tables

From OpenWetWare
Jump to: navigation, search
citations
id author year title journal vol pg url pdf 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


citations_sites
citation_id site_id created_at updated_at
Type int(11) int(11) datetime datetime
Null YES YES YES YES
Default
Extra


citations_treatments
citation_id treatment_id created_at updated_at
Type int(11) int(11) datetime datetime
Null YES YES YES YES
Default
Extra


covariates
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


cultivars
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


error_logs
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


managements
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


managements_treatments
treatment_id management_id created_at updated_at
Type int(11) int(11) datetime datetime
Null YES YES YES YES
Default
Extra


pfts
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


pfts_priors
pft_id prior_id created_at updated_at
Type int(11) int(11) datetime datetime
Null YES YES YES YES
Default
Extra


pfts_species
pft_id specie_id created_at updated_at
Type int(11) int(11) datetime datetime
Null YES YES YES YES
Default
Extra


plants
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


priors
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


schema_migrations
version
Type varchar(255)
Null NO
Default
Extra


sites
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


species
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


traits
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


treatments
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


users
id login name email 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


variables
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


yields
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