class FaTaskFlowHandleUser(db.Model):
__tablename__ = 'fa_task_flow_handle_user'
TASK_FLOW_ID = db.Column(db.ForeignKey('fa_task_flow.ID'), primary_key=True, nullable=False)
HANDLE_USER_ID = db.Column(db.Integer, primary_key=True, nullable=False)
fa_task_flow = db.relationship('FaTaskFlow', primaryjoin='FaTaskFlowHandleUser.TASK_FLOW_ID == FaTaskFlow.ID', backref='fa_task_flow_handle_users')
class FaLog(db.Model):
__tablename__ = 'fa_log'
ID = db.Column(db.Integer, primary_key=True)
ADD_TIME = db.Column(db.DateTime, nullable=False)
MODULE_NAME = db.Column(db.String(100), nullable=False)
USER_ID = db.Column(db.Integer, nullable=False)
class FaFlowFlownode(db.Model):
__tablename__ = 'fa_flow_flownode'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(100), nullable=False)
HANDLE_URL = db.Column(db.String(200))
SHOW_URL = db.Column(db.String(200))
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 FaMessageType(db.Model):
__tablename__ = 'fa_message_type'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(50))
TABLE_NAME = db.Column(db.String(50))
IS_USE = db.Column(db.Integer)
REMARK = db.Column(db.String(500))
class FaOauth(db.Model):
__tablename__ = 'fa_oauth'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(50))
REG_URL = db.Column(db.String(500))
LOGIN_URL = db.Column(db.String(500))
REMARK = db.Column(db.String(500))
class FaScriptGroupList(db.Model):
__tablename__ = 'fa_script_group_list'
SCRIPT_ID = db.Column(db.Integer, primary_key=True, nullable=False)
GROUP_ID = db.Column(db.ForeignKey('fa_script.ID'), primary_key=True, nullable=False)
ORDER_INDEX = db.Column(db.Integer, nullable=False)
fa_script = db.relationship('FaScript', primaryjoin='FaScriptGroupList.GROUP_ID == FaScript.ID', backref='fa_script_group_lists')
class FaElder(db.Model):
__tablename__ = 'fa_elder'
ID = db.Column(db.Integer, primary_key=True)
FAMILY_ID = db.Column(db.ForeignKey('fa_family.ID'))
NAME = db.Column(db.String(2), nullable=False)
SORT = db.Column(db.Integer)
fa_family = db.relationship('FaFamily', primaryjoin='FaElder.FAMILY_ID == FaFamily.ID', backref='fa_elders')
class FaBulletinLog(db.Model):
__tablename__ = 'fa_bulletin_log'
ID = db.Column(db.Integer, primary_key=True)
BULLETIN_ID = db.Column(db.ForeignKey('fa_bulletin.ID'), nullable=False)
USER_ID = db.Column(db.Integer, nullable=False)
LOOK_TIME = db.Column(db.DateTime, nullable=False)
fa_bulletin = db.relationship('FaBulletin', primaryjoin='FaBulletinLog.BULLETIN_ID == FaBulletin.ID', backref='fa_bulletin_logs')
class FaRoleQueryAuthority(db.Model):
__tablename__ = 'fa_role_query_authority'
ROLE_ID = db.Column(db.ForeignKey('fa_role.ID'), primary_key=True, nullable=False)
QUERY_ID = db.Column(db.ForeignKey('fa_query.ID'), primary_key=True, nullable=False)
NO_AUTHORITY = db.Column(db.String(200))
fa_query = db.relationship('FaQuery', primaryjoin='FaRoleQueryAuthority.QUERY_ID == FaQuery.ID', backref='fa_role_query_authorities')
fa_role = db.relationship('FaRole', primaryjoin='FaRoleQueryAuthority.ROLE_ID == FaRole.ID', backref='fa_role_query_authorities')
class FaRole(db.Model):
__tablename__ = 'fa_role'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(80))
REMARK = db.Column(db.String(255))
TYPE = db.Column(db.Integer)
fa_user = db.relationship('FaUser', secondary='fa_user_role', backref='fa_roles')
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 FaConfig(db.Model):
__tablename__ = 'fa_config'
ID = db.Column(db.Integer, primary_key=True)
TYPE = db.Column(db.String(10))
CODE = db.Column(db.String(32), nullable=False)
NAME = db.Column(db.String(50))
VALUE = db.Column(db.String(300))
REMARK = db.Column(db.String(500))
REGION = db.Column(db.String(10), nullable=False)
ADD_USER_ID = db.Column(db.Integer)
ADD_TIEM = db.Column(db.DateTime)
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 FaFile(db.Model):
__tablename__ = 'fa_files'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(255), nullable=False)
PATH = db.Column(db.String(200), nullable=False)
USER_ID = db.Column(db.Integer)
LENGTH = db.Column(db.Integer, nullable=False)
UPLOAD_TIME = db.Column(db.DateTime)
REMARK = db.Column(db.String(2000))
URL = db.Column(db.String(254))
FILE_TYPE = db.Column(db.String(50))
fa_task_flow_handle = db.relationship('FaTaskFlowHandle', secondary='fa_task_flow_handle_files', backref='fa_files')
fa_user = db.relationship('FaUser', secondary='fa_user_file', backref='fa_files')
class FaBulletinReview(db.Model):
__tablename__ = 'fa_bulletin_review'
ID = db.Column(db.Integer, primary_key=True)
PARENT_ID = db.Column(db.ForeignKey('fa_bulletin_review.ID'))
BULLETIN_ID = db.Column(db.ForeignKey('fa_bulletin.ID'), nullable=False)
NAME = db.Column(db.String(50))
CONTENT = db.Column(db.Text)
USER_ID = db.Column(db.Integer, nullable=False)
ADD_TIME = db.Column(db.DateTime, nullable=False)
STATUS = db.Column(db.String(10), nullable=False)
STATUS_TIME = db.Column(db.DateTime, nullable=False)
fa_bulletin = db.relationship('FaBulletin', primaryjoin='FaBulletinReview.BULLETIN_ID == FaBulletin.ID', backref='fa_bulletin_reviews')
parent = db.relationship('FaBulletinReview', remote_side=[ID], primaryjoin='FaBulletinReview.PARENT_ID == FaBulletinReview.ID', backref='fa_bulletin_reviews')
class FaFunction(db.Model):
__tablename__ = 'fa_function'
ID = db.Column(db.Integer, primary_key=True)
REMARK = db.Column(db.String(100))
FULL_NAME = db.Column(db.String(100))
NAMESPACE = db.Column(db.String(100))
CLASS_NAME = db.Column(db.String(100))
METHOD_NAME = db.Column(db.String(100))
DLL_NAME = db.Column(db.String(100))
XML_NOTE = db.Column(db.String(254))
fa_role = db.relationship('FaRole', secondary='fa_role_function', backref='fa_functions')
class FaExportLog(db.Model):
__tablename__ = 'fa_export_log'
ID = db.Column(db.Integer, primary_key=True)
USER_ID = db.Column(db.Integer)
LOGIN_NAME = db.Column(db.String(50))
NAME = db.Column(db.String(50))
SQL_CONTENT = db.Column(db.Text)
EXPORT_TIME = db.Column(db.DateTime)
REMARK = db.Column(db.String(100))
class FaLoginHistory(db.Model):
__tablename__ = 'fa_login_history'
ID = db.Column(db.Integer, primary_key=True)
USER_ID = db.Column(db.Integer)
LOGIN_TIME = db.Column(db.DateTime)
LOGIN_HOST = db.Column(db.String(255))
LOGOUT_TIME = db.Column(db.DateTime)
LOGIN_HISTORY_TYPE = db.Column(db.Integer)
MESSAGE = db.Column(db.String(255))
class FaUpdataLog(db.Model):
__tablename__ = 'fa_updata_log'
ID = db.Column(db.Integer, primary_key=True)
CREATE_TIME = db.Column(db.DateTime)
CREATE_USER_NAME = db.Column(db.String(50))
CREATE_USER_ID = db.Column(db.Integer)
OLD_CONTENT = db.Column(db.Text)
NEW_CONTENT = db.Column(db.Text)
TABLE_NAME = db.Column(db.String(50))
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 FaUserMessage(db.Model):
__tablename__ = 'fa_user_message'
MESSAGE_ID = db.Column(db.ForeignKey('fa_message.ID'), primary_key=True, nullable=False)
USER_ID = db.Column(db.Integer, primary_key=True, nullable=False)
PHONE_NO = db.Column(db.String(20))
STATUS = db.Column(db.String(10))
STATUS_TIME = db.Column(db.DateTime, nullable=False)
REPLY = db.Column(db.String(500))
PUSH_TYPE = db.Column(db.String(10))
fa_message = db.relationship('FaMessage', primaryjoin='FaUserMessage.MESSAGE_ID == FaMessage.ID', backref='fa_user_messages')
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 FaFlow(db.Model):
__tablename__ = 'fa_flow'
ID = db.Column(db.Integer, primary_key=True)
NAME = db.Column(db.String(100), nullable=False)
FLOW_TYPE = db.Column(db.String(20), nullable=False)
REMARK = db.Column(db.String(100))
X_Y = db.Column(db.String(500))
REGION = db.Column(db.String(10))
class FaRoleConfig(db.Model):
__tablename__ = 'fa_role_config'
ID = db.Column(db.Integer, primary_key=True)
ROLE_ID = db.Column(db.ForeignKey('fa_role.ID'), nullable=False)
TYPE = db.Column(db.String(10))
NAME = db.Column(db.String(50), nullable=False)
VALUE = db.Column(db.String(300))
REMARK = db.Column(db.String(500))
fa_role = db.relationship('FaRole', primaryjoin='FaRoleConfig.ROLE_ID == FaRole.ID', backref='fa_role_configs')
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 FaTaskFlowHandle(db.Model):
__tablename__ = 'fa_task_flow_handle'
ID = db.Column(db.Integer, primary_key=True)
TASK_FLOW_ID = db.Column(db.ForeignKey('fa_task_flow.ID'), nullable=False)
DEAL_USER_ID = db.Column(db.Integer, nullable=False)
DEAL_USER_NAME = db.Column(db.String(50), nullable=False)
DEAL_TIME = db.Column(db.DateTime, nullable=False)
CONTENT = db.Column(db.String(2000), nullable=False)
fa_task_flow = db.relationship('FaTaskFlow', primaryjoin='FaTaskFlowHandle.TASK_FLOW_ID == FaTaskFlow.ID', backref='fa_task_flow_handles')
class FaUserEvent(db.Model):
__tablename__ = 'fa_user_event'
ID = db.Column(db.Integer, primary_key=True)
USER_ID = db.Column(db.ForeignKey('fa_user_info.ID'))
NAME = db.Column(db.String(50))
HAPPEN_TIME = db.Column(db.DateTime)
CONTENT = db.Column(db.String(500))
ADDRESS = db.Column(db.String(500))
fa_user_info = db.relationship('FaUserInfo', primaryjoin='FaUserEvent.USER_ID == FaUserInfo.ID', backref='fa_user_events')
fa_files = db.relationship('FaFile', secondary='fa_event_files', backref='fa_user_events')
class FaUserInfo(FaUser):
__tablename__ = 'fa_user_info'
ID = db.Column(db.ForeignKey(u'fa_user.ID'), primary_key=True)
LEVEL_ID = db.Column(db.Integer)
FAMILY_ID = db.Column(db.ForeignKey(u'fa_family.ID'))
ELDER_ID = db.Column(db.ForeignKey(u'fa_elder.ID'))
LEVEL_NAME = db.Column(db.String(2))
FATHER_ID = db.Column(db.ForeignKey(u'fa_user_info.ID'))
MOTHER_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())
fa_elder = db.relationship(u'FaElder',
primaryjoin='FaUserInfo.ELDER_ID == FaElder.ID',
backref=u'fa_user_infos')
fa_family = db.relationship(
u'FaFamily',
primaryjoin='FaUserInfo.FAMILY_ID == FaFamily.ID',
backref=u'fa_user_infos')
parent = db.relationship(
u'FaUserInfo',
remote_side=[ID],
primaryjoin='FaUserInfo.FATHER_ID == FaUserInfo.ID',
backref=u'fa_user_infos')
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")