class BagBuildingHist(Base):

    __tablename__ = "bag_buildings_hist"

    id = Column("id", String(length=16), primary_key=True)
    index_number = Column('index_number', Integer(), primary_key=True)
    process_date = Column('process_date', Date())
    startdate = Column('startdate', Date())
    enddate = Column('enddate', Date())
    correction = Column('correction', Integer())
    building_year = Column('building_year', Integer())
    status = Column("status", String())
    exterior = Column('exterior', Geography('POLYGON', srid=4326))
    interior = Column('interior', Geography('MULTIPOLYGON', srid=4326))


class BagNumberHist(Base):

    __tablename__ = "bag_numbers_hist"

    id = Column("id", String(length=16), primary_key=True)
    index_number = Column('index_number', Integer(), primary_key=True)
    process_date = Column('process_date', Date())
    startdate = Column('startdate', Date())
    enddate = Column('enddate', Date())
    correction = Column('correction', Integer())
    street_number = Column('street_number', Integer())
    street_number_letter = Column('street_number_letter', String())
    street_number_suffix = Column('street_number_suffix', String())
    postal_code = Column('postal_code', String())
    vbo_type = Column('type', String())
    status = Column('status', String())
    public_space = Column('public_space', String())


class BagObjectHist(Base):

    __tablename__ = "bag_objects_hist"

    id = Column("id", String(length=16), primary_key=True)
    index_number = Column('index_number', Integer(), primary_key=True)
    process_date = Column('process_date', Date())
    startdate = Column('startdate', Date())
    enddate = Column('enddate', Date())
    correction = Column('correction', Integer())
    main_address = Column('main_address', String())
    building_id = Column('building_id', String())
    purpose = Column('purpose', String())
    surface = Column('surface', Integer())
    status = Column('status', String())
    location = Column('location', Geography('POINT', srid=4326))


class BagPublicSpaceHist(Base):

    __tablename__ = "bag_public_space_hist"

    id = Column("id", String(length=16), primary_key=True)
    index_number = Column('index_number', Integer(), primary_key=True)
    process_date = Column('process_date', Date())
    startdate = Column('startdate', Date())
    enddate = Column('enddate', Date())
    correction = Column('correction', Integer())
    public_space_name = Column('public_space_name', String())
    public_space_type = Column('public_space_type', String())
    related_residence = Column('related_residence', String())
    status = Column('status', String())


class BagPlaceHist(Base):

    __tablename__ = "bag_place_hist"

    id = Column("id", String(length=16), primary_key=True)
    index_number = Column('index_number', Integer(), primary_key=True)
    process_date = Column('process_date', Date())
    startdate = Column('startdate', Date())
    enddate = Column('enddate', Date())
    correction = Column('correction', Integer())
    status = Column('status', String())
    place_name = Column('place_name', String())
    exterior = Column('exterior', Geography('POLYGON', srid=4326))