class FaFlowFlownodeFlow(db.Model):
__tablename__ = 'fa_flow_flownode_flow'
ID = db.Column(db.Integer, primary_key=True)
FLOW_ID = db.Column(db.ForeignKey(u'fa_flow.ID'), nullable=False)
FROM_FLOWNODE_ID = db.Column(db.ForeignKey(u'fa_flow_flownode.ID'),
nullable=False)
TO_FLOWNODE_ID = db.Column(db.Integer, nullable=False)
HANDLE = db.Column(db.Numeric(1, 0), nullable=False)
ASSIGNER = db.Column(db.Numeric(1, 0), nullable=False)
STATUS = db.Column(db.String(20))
REMARK = db.Column(db.String(20))
EXPIRE_HOUR = db.Column(db.Integer, nullable=False)
fa_flow = db.relationship(
u'FaFlow',
primaryjoin='FaFlowFlownodeFlow.FLOW_ID == FaFlow.ID',
backref=u'fa_flow_flownode_flows')
fa_flow_flownode = db.relationship(
u'FaFlowFlownode',
primaryjoin='FaFlowFlownodeFlow.FROM_FLOWNODE_ID == FaFlowFlownode.ID',
backref=u'fa_flow_flownode_flows')
fa_role = db.relationship(u'FaRole',
secondary=u'fa_flow_flownode_role',
backref=u'fa_flow_flownode_flows')
class FaModule(db.Model):
__tablename__ = 'fa_module'
ID = db.Column(db.Integer, primary_key=True)
PARENT_ID = db.Column(db.ForeignKey(u'fa_module.ID'))
NAME = db.Column(db.String(60))
LOCATION = db.Column(db.String(2000))
CODE = db.Column(db.String(20))
IS_DEBUG = db.Column(db.Numeric(1, 0), nullable=False)
IS_HIDE = db.Column(db.Numeric(1, 0), nullable=False)
SHOW_ORDER = db.Column(db.Numeric(2, 0), nullable=False)
DESCRIPTION = db.Column(db.String(2000))
IMAGE_URL = db.Column(db.String(2000))
DESKTOP_ROLE = db.Column(db.String(200))
W = db.Column(db.Integer)
H = db.Column(db.Integer)
parent = db.relationship(u'FaModule',
remote_side=[ID],
primaryjoin='FaModule.PARENT_ID == FaModule.ID',
backref=u'fa_modules')
fa_role = db.relationship(u'FaRole',
secondary=u'fa_role_module',
backref=u'fa_modules')
fa_user = db.relationship(u'FaUser',
secondary=u'fa_user_module',
backref=u'fa_modules')
class FaBulletin(db.Model):
__tablename__ = 'fa_bulletin'
ID = db.Column(db.Integer, primary_key=True)
TITLE = db.Column(db.String(255), nullable=False)
PIC = db.Column(db.String(255))
TYPE_CODE = db.Column(db.String(50))
CONTENT = db.Column(db.Text)
USER_ID = db.Column(db.Integer)
PUBLISHER = db.Column(db.String(255), nullable=False)
ISSUE_DATE = db.Column(db.DateTime, nullable=False)
IS_SHOW = db.Column(db.Numeric(1, 0), nullable=False)
IS_IMPORT = db.Column(db.Numeric(1, 0), nullable=False)
IS_URGENT = db.Column(db.Numeric(1, 0), nullable=False)
AUTO_PEN = db.Column(db.Numeric(1, 0), nullable=False)
CREATE_TIME = db.Column(db.DateTime, nullable=False)
UPDATE_TIME = db.Column(db.DateTime, nullable=False)
REGION = db.Column(db.String(10), nullable=False)
fa_files = db.relationship(u'FaFile',
secondary=u'fa_bulletin_file',
backref=u'fa_bulletins')
fa_role = db.relationship(u'FaRole',
secondary=u'fa_bulletin_role',
backref=u'fa_bulletins')
class FaUser(db.Model):
__tablename__ = 'fa_user'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(80))
LOGIN_NAME = db.Column(db.String(20))
ICON_FILES_ID = db.Column(db.Integer)
DISTRICT_ID = db.Column(db.ForeignKey(u'fa_district.ID'), nullable=False)
IS_LOCKED = db.Column(db.Numeric(1, 0))
CREATE_TIME = db.Column(db.DateTime)
LOGIN_COUNT = db.Column(db.Integer)
LAST_LOGIN_TIME = db.Column(db.DateTime)
LAST_LOGOUT_TIME = db.Column(db.DateTime)
LAST_ACTIVE_TIME = db.Column(db.DateTime)
REMARK = db.Column(db.String(2000))
REGION = db.Column(db.String(10), nullable=False)
fa_district = db.relationship(
u'FaDistrict',
primaryjoin='FaUser.DISTRICT_ID == FaDistrict.ID',
backref=u'fa_users')
fa_user_info = db.relationship(u'FaUserInfo',
secondary=u'fa_user_friend',
backref=u'fa_users',
lazy="select")
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 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 FaAppVersion(db.Model):
__tablename__ = 'fa_app_version'
ID = db.Column(db.Integer, primary_key=True)
IS_NEW = db.Column(db.Numeric(1, 0), nullable=False)
TYPE = db.Column(db.String(20), nullable=False)
REMARK = db.Column(db.String(1000))
UPDATE_TIME = db.Column(db.DateTime)
UPDATE_URL = db.Column(db.String(200))
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 FaDistrict(db.Model):
__tablename__ = 'fa_district'
ID = db.Column(db.Integer, primary_key=True)
PARENT_ID = db.Column(db.ForeignKey('fa_district.ID'))
NAME = db.Column(db.String(255), nullable=False)
CODE = db.Column(db.String(50))
IN_USE = db.Column(db.Numeric(1, 0), nullable=False)
LEVEL_ID = db.Column(db.Integer, nullable=False)
ID_PATH = db.Column(db.String(200))
REGION = db.Column(db.String(10), nullable=False)
parent = db.relationship('FaDistrict', remote_side=[ID], primaryjoin='FaDistrict.PARENT_ID == FaDistrict.ID', backref='fa_districts')
fa_user = db.relationship('FaUser', secondary='fa_user_district', backref='fa_districts')
class FaQuery(db.Model):
__tablename__ = 'fa_query'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(50), nullable=False)
CODE = db.Column(db.String(20), nullable=False)
AUTO_LOAD = db.Column(db.Numeric(1, 0), nullable=False)
PAGE_SIZE = db.Column(db.Integer, nullable=False)
SHOW_CHECKBOX = db.Column(db.Numeric(1, 0), nullable=False)
IS_DEBUG = db.Column(db.Numeric(1, 0), nullable=False)
FILTR_LEVEL = db.Column(db.Numeric(1, 0))
DB_SERVER_ID = db.Column(db.Integer)
QUERY_CONF = db.Column(db.Text)
QUERY_CFG_JSON = db.Column(db.Text)
IN_PARA_JSON = db.Column(db.Text)
JS_STR = db.Column(db.Text)
ROWS_BTN = db.Column(db.Text)
HEARD_BTN = db.Column(db.Text)
REPORT_SCRIPT = db.Column(db.Text)
CHARTS_CFG = db.Column(db.Text)
CHARTS_TYPE = db.Column(db.String(50))
FILTR_STR = db.Column(db.Text)
REMARK = db.Column(db.Text)
NEW_DATA = db.Column(db.String(50))
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)