class FaScriptTask(db.Model): __tablename__ = 'fa_script_task' ID = db.Column(db.Integer, primary_key=True) SCRIPT_ID = db.Column(db.ForeignKey(u'fa_script.ID'), nullable=False) BODY_TEXT = db.Column(db.Text, nullable=False) BODY_HASH = db.Column(db.String(255), nullable=False) RUN_STATE = db.Column(db.String(10), nullable=False, server_default=db.FetchedValue()) RUN_WHEN = db.Column(db.String(30)) RUN_ARGS = db.Column(db.String(255)) RUN_DATA = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) LOG_TYPE = db.Column(db.Numeric(1, 0), server_default=db.FetchedValue()) DSL_TYPE = db.Column(db.String(255)) RETURN_CODE = db.Column(db.String(10), server_default=db.FetchedValue()) START_TIME = db.Column(db.DateTime) END_TIME = db.Column(db.DateTime) DISABLE_DATE = db.Column(db.DateTime) DISABLE_REASON = db.Column(db.String(50)) SERVICE_FLAG = db.Column(db.String(50)) REGION = db.Column(db.String(10)) GROUP_ID = db.Column(db.Integer) fa_script = db.relationship( u'FaScript', primaryjoin='FaScriptTask.SCRIPT_ID == FaScript.ID', backref=u'fa_script_tasks')
class Sequence(db.Model): __tablename__ = 'sequence' seq_name = db.Column(db.String(50), primary_key=True) current_val = db.Column(db.Integer, nullable=False) increment_val = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
class FaSmsSend(db.Model): __tablename__ = 'fa_sms_send' GUID = db.Column(db.String(32), primary_key=True) MESSAGE_ID = db.Column(db.Integer) PHONE_NO = db.Column(db.String(50), nullable=False) ADD_TIME = db.Column(db.DateTime) SEND_TIME = db.Column(db.DateTime) CONTENT = db.Column(db.String(500), nullable=False) STAUTS = db.Column(db.String(15)) TRY_NUM = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
class FaScriptTaskLog(db.Model): __tablename__ = 'fa_script_task_log' ID = db.Column(db.Integer, primary_key=True) SCRIPT_TASK_ID = db.Column(db.ForeignKey('fa_script_task.ID'), nullable=False) LOG_TIME = db.Column(db.DateTime, nullable=False) LOG_TYPE = db.Column(db.Numeric(1, 0), nullable=False, server_default=db.FetchedValue()) MESSAGE = db.Column(db.Text) SQL_TEXT = db.Column(db.Text) fa_script_task = db.relationship('FaScriptTask', primaryjoin='FaScriptTaskLog.SCRIPT_TASK_ID == FaScriptTask.ID', backref='fa_script_task_logs')
class FaUserInfo(FaUser): __tablename__ = 'fa_user_info' ID = db.Column(db.ForeignKey('fa_user.ID'), primary_key=True) LEVEL_ID = db.Column(db.Integer) FAMILY_ID = db.Column(db.ForeignKey('fa_family.ID')) ELDER_ID = db.Column(db.ForeignKey('fa_elder.ID')) LEVEL_NAME = db.Column(db.String(2)) FATHER_ID = db.Column(db.ForeignKey('fa_user_info.ID')) COUPLE_ID = db.Column(db.Integer) BIRTHDAY_TIME = db.Column(db.DateTime) BIRTHDAY_PLACE = db.Column(db.String(500)) IS_LIVE = db.Column(db.Numeric(1, 0)) DIED_TIME = db.Column(db.DateTime) DIED_PLACE = db.Column(db.String(500)) SEX = db.Column(db.String(2)) YEARS_TYPE = db.Column(db.String(10)) CONSORT_ID = db.Column(db.Integer) STATUS = db.Column(db.String(10), nullable=False, server_default=db.FetchedValue()) CREATE_USER_NAME = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) CREATE_USER_ID = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) UPDATE_TIME = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) UPDATE_USER_NAME = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) UPDATE_USER_ID = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) ALIAS = db.Column(db.String(10)) AUTHORITY = db.Column(db.Integer) fa_elder = db.relationship('FaElder', primaryjoin='FaUserInfo.ELDER_ID == FaElder.ID', backref='fa_user_infos') fa_family = db.relationship('FaFamily', primaryjoin='FaUserInfo.FAMILY_ID == FaFamily.ID', backref='fa_user_infos') parent = db.relationship('FaUserInfo', remote_side=[ID], primaryjoin='FaUserInfo.FATHER_ID == FaUserInfo.ID', backref='fa_user_infos')
class FaScript(db.Model): __tablename__ = 'fa_script' ID = db.Column(db.Integer, primary_key=True) CODE = db.Column(db.String(20), nullable=False) NAME = db.Column(db.String(255), nullable=False) BODY_TEXT = db.Column(db.Text, nullable=False) BODY_HASH = db.Column(db.String(255), nullable=False) RUN_WHEN = db.Column(db.String(30)) RUN_ARGS = db.Column(db.String(255)) RUN_DATA = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) STATUS = db.Column(db.String(10)) DISABLE_REASON = db.Column(db.String(50)) SERVICE_FLAG = db.Column(db.String(50)) REGION = db.Column(db.String(10)) IS_GROUP = db.Column(db.Numeric(1, 0), nullable=False)