class SchJobsM(db.Model, QueryMixin):
__tablename__ = 'sch_jobs'
id = db.Column(db.Integer, primary_key=True)
sch_task_id = db.Column(db.Integer, index=True)
city = db.Column(db.String(32), index=True)
region_id = db.Column(db.String(10), index=True)
addr = db.Column(db.String(30))
address = db.Column(db.String(50))
sch_date = db.Column(db.String(20), index=True)
order_id = db.Column(db.String(20))
job_type = db.Column(db.String(10))
start_time = db.Column(db.String(20))
end_time = db.Column(db.String(20))
plan_start = db.Column(db.String(20))
plan_end = db.Column(db.String(20))
hrs = db.Column(db.Float)
worker_id = db.Column(db.String(20), index=True, default='0')
status = db.Column(db.String(20), index=True)
dispatch_id = db.Column(db.Integer, index=True)
addr_lon = db.Column(db.Float)
addr_lat = db.Column(db.Float)
class SchWorkersM(db.Model, QueryMixin):
__tablename__ = 'sch_workers'
id = db.Column(db.Integer, primary_key=True)
# sch_task_id = db.Column(db.Integer)
city = db.Column(db.String(32), index=True)
worker_id = db.Column(db.String(10), index=True)
w_region = db.Column(db.String(10), index=True)
sch_date = db.Column(db.String(20), index=True)
w_type = db.Column(db.String(20))
worker_type = db.Column(db.Integer, index=True)
w_hrs = db.Column(db.Float)
w_rank = db.Column(db.Integer, index=True)
max_star_t = db.Column(db.Float)
mdt = db.Column(db.Float)
bdt_hrs = db.Column(db.Float)
adt_hrs = db.Column(db.Float)
min_hrs = db.Column(db.Float)
hrs_assigned = db.Column(db.Float)
hrs_to_assign = db.Column(db.Float)
w_start = db.Column(db.String(20))
w_end = db.Column(db.String(20))
class SubTaskM(db.Model, QueryMixin):
# __bind_key__ = 'sch'
"""
区域派单子任务
"""
__tablename__ = 'sub_tasks'
id = db.Column(db.Integer, primary_key=True)
city = db.Column(db.String(32))
sch_task_id = db.Column(db.Integer, index=True)
sub_task_uid = db.Column(db.String(64), index=True)
sch_date = db.Column(db.DateTime)
status = db.Column(db.String(10))
sub_task_message = db.Column(JSON)
region_id = db.Column(db.String(10))
job_num = db.Column(db.Integer)
job_hrs = db.Column(db.Float)
worker_num = db.Column(db.Integer)
worker_hrs = db.Column(db.Float)
open_job_num = db.Column(db.Integer)
open_job_hrs = db.Column(db.Float)
open_worker_num = db.Column(db.Integer)
open_worker_hrs = db.Column(db.Float)
created_on = db.Column(db.DateTime, default=db.func.current_timestamp())
modified_on = db.Column(db.DateTime, default=db.func.current_timestamp(),
onupdate=db.func.current_timestamp())
class SchTaskM(db.Model, QueryMixin):
# __bind_key__ = 'sch'
__tablename__ = 'sch_tasks'
id = db.Column(db.Integer, primary_key=True)
city = db.Column(db.String(32), index=True)
name = db.Column(db.String(32))
sch_date = db.Column(db.Date, index=True)
sch_regions = db.Column(JSON())
job_num = db.Column(db.Integer)
job_hrs = db.Column(db.Float)
worker_num = db.Column(db.Integer)
worker_hrs = db.Column(db.Float)
created_on = db.Column(db.DateTime, default=db.func.current_timestamp())
status = db.Column(db.String(10), index=True)
class Sch_Test_Log(db.Model, QueryMixin):
__tablename__ = 'sch_test_log'
id = db.Column(db.Integer, primary_key=True)
log_type = db.Column(db.String(50), index=True)
log_data = db.Column(JSON())
created_on = db.Column(db.DateTime, default=db.func.current_timestamp())
class SchDispatchM(db.Model, QueryMixin):
"""
Dispatch by Worker
"""
__tablename__ = 'sch_dispatch'
id = db.Column(db.Integer, primary_key=True)
sch_task_id = db.Column(db.Integer, index=True)
city = db.Column(db.String(32), index=True)
sch_date = db.Column(db.String(20), index=True)
dispatch_date = db.Column(db.String(20), index=True)
deadline = db.Column(db.Integer)
dispatch_info = db.Column(JSON())
worker_id = db.Column(db.Integer, index=True)
status = db.Column(db.String(20), index=True)
dispatch_num = db.Column(db.String(20), index=True)
created_on = db.Column(db.DateTime, default=db.func.current_timestamp())
addr = db.Column(db.String(20))