class EmployeeAppAuthorization(db.Model, JsonSerializer): __tablename__ = 'empAppAuthorization' recId = db.Column(db.Integer, primary_key=True) person_id = db.Column(db.Integer, db.ForeignKey('empView.person_id')) app_id = db.Column(db.Integer, db.ForeignKey('app.recId')) person = relationship("EmployeeView", backref=backref('empView', uselist=False)) app = relationship("App", backref=backref('App', uselist=False))
class EmployeeView(db.Model, JsonSerializer): __tablename__ = 'empView' person_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(150)) department_name = db.Column(db.String(150)) department_id = db.Column(db.Integer) email_address = db.Column(db.String(50)) phone_number = db.Column(db.String(50))
class AppCategory(db.Model, JsonSerializer): __tablename__ = 'app_category' recId = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100)) apps = relationship("App", backref=backref("app", order_by=recId))
class CrDecision(db.Model, JsonSerializer): __tablename__ = 'decision' recId = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) desc = db.Column(db.String(100))
class CrPirority(db.Model, JsonSerializer): __tablename__ = 'pirority' recId = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) desc = db.Column(db.String(100))
class CrType(db.Model, JsonSerializer): __tablename__ = 'cr_type' recId = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) desc = db.Column(db.String(100))
class App(db.Model, JsonSerializer): __tablename__ = 'app' recId = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100)) categoryId = db.Column(db.Integer, db.ForeignKey('app_category.recId'))