1= Table(
2 "rave_observation",
3 meta,
4 Column("station", Text, nullable=True),
5 Column("country", Text, nullable=True),
6 Column("type", Integer, nullable=True),
7 Column("date", Date, nullable=False),
8 Column("time", Time, nullable=False),
9 Column("longitude", Float, nullable=False),
10 Column("latitude", Float, nullable=False),
11 Column("visibility", Float, nullable=True),
12 Column("windtype", Integer, nullable=True),
13 Column("cloudcover", Integer, nullable=True),
14 Column("winddirection", Float, nullable=True),
15 Column("windspeed", Float, nullable=True),
16 Column("temperature", Float, nullable=True),
17 Column("dewpoint", Float, nullable=True),
18 Column("relativehumidity", Float, nullable=True),
19 Column("pressure", Float, nullable=True),
20 Column("sea_lvl_pressure", Float, nullable=True),
21 Column("pressure_change", Float, nullable=True),
22 Column("liquid_precipitation", Float, nullable=True),
23 Column("accumulation_period", Integer, nullable=True),
24 Column("valid_fields_bitmask", Integer, nullable=True),
25 PrimaryKeyConstraint("station", "date", "time", "accumulation_period"),
26)