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 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 User(UserMixin, db.Model):
__tablename__ = dbtableprefix + 'user'
id = db.Column(db.Integer, primary_key=True)
social_id = db.Column(db.String(64), nullable=False, unique=True)
nickname = db.Column(db.String(64), nullable=False)
email = db.Column(db.String(64), nullable=True, unique=True)
confirmed_at = db.Column(db.DateTime())
active = db.Column('active',
db.Boolean(),
nullable=False,
server_default='0')
first_name = db.Column(db.String(50), nullable=False, server_default='')
last_name = db.Column(db.String(50), nullable=False, server_default='')
country = db.Column(db.String(2))
subdivisionfirst = db.Column(db.String(2))
subdivisionsecond = db.Column(db.String(50))
subdivisionthird = db.Column(db.String(50))
organization = db.Column(db.String(64))
user_auth = db.relationship('UserAuth',
uselist=False,
primaryjoin="UserAuth.user_id==User.id")
roles = db.relationship('Role',
secondary='user_roles',
backref=db.backref('user', lazy='dynamic'))
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 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())