class Hs07Id(object):
hs07_id_len = db.Column(db.Integer())
@declared_attr
def hs07_id(cls):
return db.Column(db.String(8),
db.ForeignKey(Hs07.id),
primary_key=True)
class SitcId(object):
sitc_id_len = db.Column(db.Integer())
@declared_attr
def sitc_id(cls):
return db.Column(db.String(8),
db.ForeignKey(Sitc.id),
primary_key=True)
class BaseProd(db.Model, AutoSerialize):
__abstract__ = True
year = db.Column(db.Integer(), primary_key=True)
import_val = db.Column(db.Numeric(16, 2))
export_val = db.Column(db.Numeric(16, 2))
export_val_growth_pct = db.Column(db.Float())
export_val_growth_pct_5 = db.Column(db.Float())
export_val_growth_val = db.Column(db.Numeric(16, 2))
export_val_growth_val_5 = db.Column(db.Numeric(16, 2))
import_val_growth_pct = db.Column(db.Float())
import_val_growth_pct_5 = db.Column(db.Float())
import_val_growth_val = db.Column(db.Numeric(16, 2))
import_val_growth_val_5 = db.Column(db.Numeric(16, 2))