class Attachments(db.Model): __tablename__ = dbtableprefix + "attachments" id = db.Column(db.Integer(), primary_key=True) key = db.Column(db.String(250)) dictionary = db.Column(db.Text()) question = db.Column(db.Integer()) filename = db.Column(db.Text())
class UserDictKeys(db.Model): __tablename__ = dbtableprefix + "userdictkeys" indexno = db.Column(db.Integer(), primary_key=True) filename = db.Column(db.Text()) key = db.Column(db.String(250)) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
class Attachments(db.Model): __tablename__ = dbtableprefix + "attachments" id = db.Column(db.Integer(), primary_key=True) key = db.Column(db.String(250)) dictionary = db.Column(db.Text()) question = db.Column(db.Integer()) filename = db.Column(db.Text()) encrypted = db.Column(db.Boolean(), nullable=False, server_default='1')
class UserRoles(db.Model): __tablename__ = dbtableprefix + 'user_roles' id = db.Column(db.Integer(), primary_key=True) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) role_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'role.id', ondelete='CASCADE'))
class Install(db.Model): __tablename__ = dbtableprefix + "install" id = db.Column(db.Integer(), primary_key=True) hostname = db.Column(db.Text()) version = db.Column(db.Integer()) packageversion = db.Column(db.Text()) package_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'package.id', ondelete='CASCADE'))
class UserDict(db.Model): __tablename__ = dbtableprefix + "userdict" indexno = db.Column(db.Integer(), primary_key=True) filename = db.Column(db.Text()) key = db.Column(db.String(250)) dictionary = db.Column(db.Text()) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) encrypted = db.Column(db.Boolean(), nullable=False, server_default='1')
class PackageAuth(db.Model): __tablename__ = dbtableprefix + 'package_auth' id = db.Column(db.Integer, primary_key=True) package_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'package.id', ondelete='CASCADE')) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) authtype = db.Column(db.String(255), server_default='owner')
class TicketNote(db.Model): __tablename__ = dbtableprefix + "ticketnote" id = db.Column(db.Integer(), primary_key=True) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) note_type = db.Column(db.String(50), nullable=False) ticket_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'ticket.id', ondelete='CASCADE')) create_time = db.Column(db.DateTime(), server_default=db.func.now()) description = db.Column(db.Text())
class SpeakList(db.Model): __tablename__ = dbtableprefix + "speaklist" id = db.Column(db.Integer(), primary_key=True) filename = db.Column(db.Text()) key = db.Column(db.String(250)) phrase = db.Column(db.Text()) question = db.Column(db.Integer()) type = db.Column(db.String(20)) language = db.Column(db.String(10)) dialect = db.Column(db.String(10)) upload = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'))
class Messages(db.Model): __tablename__ = dbtableprefix + "messages" id = db.Column(db.Integer(), db.Sequence(dbtableprefix + 'messages_id_seq'), primary_key=True) message = db.Column(db.Text()) create_time = db.Column(db.DateTime(), server_default=db.func.now())
class Ticket(db.Model): __tablename__ = dbtableprefix + 'ticket' id = db.Column(db.Integer(), primary_key=True) filename = db.Column(db.String(255)) request_type = db.Column(db.String(50), nullable=False) description = db.Column(db.Text()) opened_by = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) open_time = db.Column(db.DateTime(), server_default=db.func.now()) close_time = db.Column(db.DateTime()) closed_by = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) close_type = db.Column(db.String(50)) close_description = db.Column(db.Text()) status = db.Column(db.String(50))
class Package(db.Model): __tablename__ = dbtableprefix + 'package' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False) type = db.Column(db.Text()) #github, zip, pip giturl = db.Column(db.String(255), nullable=True) gitsubdir = db.Column(db.Text(), nullable=True) upload = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE')) package_auth = db.relationship( 'PackageAuth', uselist=False, primaryjoin="PackageAuth.package_id==Package.id") version = db.Column(db.Integer(), server_default='1') packageversion = db.Column(db.Text()) limitation = db.Column(db.Text()) dependency = db.Column(db.Boolean(), nullable=False, server_default='0') core = db.Column(db.Boolean(), nullable=False, server_default='0') active = db.Column(db.Boolean(), nullable=False, server_default='1')
class UserAuth(db.Model, UserMixin): __tablename__ = dbtableprefix + 'user_auth' id = db.Column(db.Integer, primary_key=True) user_id = db.Column( db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE')) password = db.Column(db.String(255), nullable=False, server_default='') reset_password_token = db.Column(db.String(100), nullable=False, server_default='') #active = db.Column(db.Boolean(), nullable=False, server_default='0') user = db.relationship('User', uselist=False, primaryjoin="User.id==UserAuth.user_id")
class UserDictLock(db.Model): __tablename__ = dbtableprefix + "userdictlock" indexno = db.Column(db.Integer(), primary_key=True) filename = db.Column(db.Text()) key = db.Column(db.String(250)) locktime = db.Column(db.DateTime(), server_default=db.func.now())
class Uploads(db.Model): __tablename__ = dbtableprefix + "uploads" indexno = db.Column(db.Integer(), primary_key=True) key = db.Column(db.String(250)) filename = db.Column(db.Text()) yamlfile = db.Column(db.Text())
class Role(db.Model): __tablename__ = dbtableprefix + 'role' id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(50), unique=True) description = db.Column(db.String(255))
class Supervisors(db.Model): __tablename__ = dbtableprefix + "supervisors" id = db.Column(db.Integer(), primary_key=True) hostname = db.Column(db.Text()) url = db.Column(db.Text()) start_time = db.Column(db.DateTime(), server_default=db.func.now())