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 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 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 FaTaskFlow(db.Model): __tablename__ = 'fa_task_flow' ID = db.Column(db.Integer, primary_key=True) PARENT_ID = db.Column(db.ForeignKey(u'fa_task_flow.ID')) TASK_ID = db.Column(db.ForeignKey(u'fa_task.ID'), nullable=False) LEVEL_ID = db.Column(db.Integer) FLOWNODE_ID = db.Column(db.Integer) EQUAL_ID = db.Column(db.Integer) IS_HANDLE = db.Column(db.Integer, nullable=False) NAME = db.Column(db.String(100)) HANDLE_URL = db.Column(db.String(200)) SHOW_URL = db.Column(db.String(200)) EXPIRE_TIME = db.Column(db.DateTime) START_TIME = db.Column(db.DateTime, nullable=False) DEAL_STATUS = db.Column(db.String(50)) ROLE_ID_STR = db.Column(db.String(200)) HANDLE_USER_ID = db.Column(db.Integer) DEAL_TIME = db.Column(db.DateTime) ACCEPT_TIME = db.Column(db.DateTime) parent = db.relationship( u'FaTaskFlow', remote_side=[ID], primaryjoin='FaTaskFlow.PARENT_ID == FaTaskFlow.ID', backref=u'fa_task_flows') fa_task = db.relationship(u'FaTask', primaryjoin='FaTaskFlow.TASK_ID == FaTask.ID', backref=u'fa_task_flows')
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 FaLogin(db.Model): __tablename__ = 'fa_login' ID = db.Column(db.Integer, primary_key=True) LOGIN_NAME = db.Column(db.String(20)) PASSWORD = db.Column(db.String(255)) PHONE_NO = db.Column(db.String(20)) EMAIL_ADDR = db.Column(db.String(255)) VERIFY_CODE = db.Column(db.String(10)) VERIFY_TIME = db.Column(db.DateTime) IS_LOCKED = db.Column(db.Integer) PASS_UPDATE_DATE = db.Column(db.DateTime) LOCKED_REASON = db.Column(db.String(255)) FAIL_COUNT = db.Column(db.Integer) fa_oauth = db.relationship('FaOauth', secondary='fa_oauth_login', backref='fa_logins')
class FaMessage(db.Model): __tablename__ = 'fa_message' ID = db.Column(db.Integer, primary_key=True) MESSAGE_TYPE_ID = db.Column(db.ForeignKey('fa_message_type.ID')) KEY_ID = db.Column(db.Integer) TITLE = db.Column(db.String(100)) CONTENT = db.Column(db.String(500)) CREATE_TIME = db.Column(db.DateTime) CREATE_USERNAME = db.Column(db.String(50)) CREATE_USERID = db.Column(db.Integer) STATUS = db.Column(db.String(10)) PUSH_TYPE = db.Column(db.String(10)) DISTRICT_ID = db.Column(db.Integer) ALL_ROLE_ID = db.Column(db.String(500)) fa_message_type = db.relationship('FaMessageType', primaryjoin='FaMessage.MESSAGE_TYPE_ID == FaMessageType.ID', backref='fa_messages')
class FaDbServer(db.Model): __tablename__ = 'fa_db_server' ID = db.Column(db.Integer, primary_key=True) DB_TYPE_ID = db.Column(db.ForeignKey('fa_db_server_type.ID'), nullable=False) TYPE = db.Column(db.String(10), nullable=False) IP = db.Column(db.String(20), nullable=False) PORT = db.Column(db.Integer, nullable=False) DBNAME = db.Column(db.String(20)) DBUID = db.Column(db.String(20), nullable=False) PASSWORD = db.Column(db.String(32), nullable=False) REMARK = db.Column(db.String(500)) DB_LINK = db.Column(db.String(200)) NICKNAME = db.Column(db.String(32)) TO_PATH_M = db.Column(db.String(300)) TO_PATH_D = db.Column(db.String(300)) fa_db_server_type = db.relationship('FaDbServerType', primaryjoin='FaDbServer.DB_TYPE_ID == FaDbServerType.ID', backref='fa_db_servers')
class FaTask(db.Model): __tablename__ = 'fa_task' ID = db.Column(db.Integer, primary_key=True) FLOW_ID = db.Column(db.ForeignKey('fa_flow.ID')) TASK_NAME = db.Column(db.String(50)) CREATE_TIME = db.Column(db.DateTime) CREATE_USER = db.Column(db.Integer) CREATE_USER_NAME = db.Column(db.String(50)) STATUS = db.Column(db.String(50)) STATUS_TIME = db.Column(db.DateTime) REMARK = db.Column(db.Text) REGION = db.Column(db.String(10)) KEY_ID = db.Column(db.String(32)) START_TIME = db.Column(db.DateTime) END_TIME = db.Column(db.DateTime) DEAL_TIME = db.Column(db.DateTime) ROLE_ID_STR = db.Column(db.String(200)) fa_flow = db.relationship('FaFlow', primaryjoin='FaTask.FLOW_ID == FaFlow.ID', backref='fa_tasks')