CONTACT
contact_id
name
address
city
state
zip
email
phone
website
company

HIVE_PARAMETERS
hive_id
contact_id
location (long, lat)
elevation
orientation (N,E,S,W)
hive_type (Langstroth 10 frame, Langstroth 8 frame,Top-Bar, Warré, Dartington Long Deep, WBC)
Screened Bottom Board
Bottom entrance
Top entrance

HIVE_TYPE
Langstrough 10 frame
Langstrough 8 frame
Top Bar
Warré
Dartington Long Deep
WBC

HIVE_DATA
row_id
hive_id
time_stamp
weight
manipulation_change
temp
humidity
wx_temp
wx_humidity
wx_wind_speed
wx_wind_direction
wx_pressure
wx_rain
wx_solar_radiation
comment

MANIPULATION_DATA
row_id
hive_id
entrance (bottom, top)
super1 (deep,medium,shallow) (8,10 frames)
super2
super3
super4
foundation (wax, plastic)
strain ( Italian, Russian, Canolian, Mut)
drug/chemical application (miticides, fungicides, antibiotics)
feeding (type and schedule)
splits/swarms/requeening

SUPER_HEIGHT
deep
medium
shallow

FOUNDATION
wax - crimp wire
plastic - Rite-Cell
plastic - Placti-Cell
Pierco -
Pierco - Drone (Green)

STRAIN
Italian
Russian
Canolian
Mut