class FieldPeriod(db.Model):
# uncomment the tables args for SQL Server schemas
# __table_args__ = {"schema": "dbo"}
id = db.Column(db.Integer(), primary_key=True)
stage = db.Column(db.String(4))
live_start_date = db.Column(db.Date())
live_end_date = db.Column(db.Date())
interview_start_date = db.Column(db.Date())
interview_end_date = db.Column(db.Date())
allocation_date = db.Column(db.Date())
edit_start_date = db.Column(db.Date())
data_delivery_start_date = db.Column(db.Date())
scatter_date = db.Column(db.Date())
class Survey(db.Model):
# uncomment the tables args for SQL Server schemas
# __table_args__ = {"schema": "dbo"}
id = db.Column(db.Integer(), primary_key=True)
tla = db.Column(db.String(3))
survey_name = db.Column(db.String(255))
start_date = db.Column(db.Date())
end_date = db.Column(db.Date())
allocation_req = db.Column(db.Boolean())
editing_req = db.Column(db.Boolean())
allocation_lookup = db.Column(db.String(255))
class ApiKey(db.Model, UserMixin):
# uncomment the tables args for SQL Server schemas
# __table_args__ = {"schema": "dbo"}
id = db.Column(db.Integer(), primary_key=True)
user = db.Column(db.String(255))
api_key = db.Column(db.String(255))
class Instrument(db.Model):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(255))
survey_id = db.Column(db.Integer())
field_period_id = db.Column(db.Integer())
phase = db.Column(db.String(255))
description = db.Column(db.String(255))
questionnaire_deployment_status = db.Column(db.String(255))
case_deployment_status = db.Column(db.String(255))
collection_start_date = db.Column(db.DATETIME())
collection_end_date = db.Column(db.DATETIME())
validation_rules = db.Column(db.TEXT())
MI_spec = db.Column(db.TEXT())
class Case(db.Model, DictMixin):
id = db.Column(db.Integer(), primary_key=True)
survey_id = db.Column(db.Integer())
field_period_id = db.Column(db.Integer())
sample_id = db.Column(db.Integer())
primary_key = db.Column(db.Integer())
issue_number = db.Column(db.Integer())
mode = db.Column(db.String(255))
phase = db.Column(db.String())
case_status = db.Column(db.String(255))
allocation_status = db.Column(db.String(255))
deployment_status = db.Column(db.String(255))
interviewer_id = db.Column(db.Integer())
manager_id = db.Column(db.Integer())
serial_number = db.Column(db.String(255))
quota = db.Column(db.Integer())
address = db.Column(db.Integer())
hhold = db.Column(db.Integer())
outcome_code = db.Column(db.Integer())
server_park_id = db.Column(db.Integer())
instrument_id = db.Column(db.Integer())
worth_reissue = db.Column(db.Boolean())
date_created = db.Column(db.DATETIME())
fed_forward_data = db.Column(db.TEXT())