class ImageFeature(db.Model): __tablename__ = 'imagefeature' image_id = db.Column(db.Integer, db.ForeignKey('image.id'), primary_key=True) feature_id = db.Column(db.Integer, db.ForeignKey('feature.id'), primary_key=True)
class Pod(db.Model): __tablename__ = 'pod' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(256), unique=False) namespace_id = db.Column(db.Integer, db.ForeignKey('namespace.id')) image_id = db.Column(db.Integer, db.ForeignKey('image.id')) token_id = db.Column(db.Integer, db.ForeignKey('token.id'))
class DeploymentValidation(db.Model): __tablename__ = 'deploymentvalidation' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(256), unique=False) token_id = db.Column(db.Integer, db.ForeignKey('token.id')) namespace_id = db.Column(db.Integer, db.ForeignKey('namespace.id')) objectkind_id = db.Column(db.Integer, db.ForeignKey('objectkind.id')) validation_id = db.Column(db.Integer, db.ForeignKey('validation.id'))
class Vulnerability(db.Model): __tablename__ = 'vulnerability' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=False) description = db.Column(db.String(10000), unique=False) fixedby = db.Column(db.String(10000), unique=False) link = db.Column(db.String(10000), unique=False) severity_id = db.Column(db.Integer, db.ForeignKey('severity.id')) feature_id = db.Column(db.Integer, db.ForeignKey('feature.id'))
class Vulnerability(db.Model): __tablename__ = 'vulnerability' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=False, index=True) description = db.Column(db.String(10000), unique=False) fixedby = db.Column(db.String(10000), unique=False) link = db.Column(db.String(10000), unique=False) # No index in severity_id as we have a very small subset of severities severity_id = db.Column(db.Integer, db.ForeignKey('severity.id')) feature_id = db.Column(db.Integer, db.ForeignKey('feature.id'), index=True)
class ServiceSLO(db.Model): __tablename__ = 'serviceslo' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=False) value = db.Column(db.Integer, unique=False) target = db.Column(db.Integer, unique=False) slitype_id = db.Column(db.Integer, db.ForeignKey('slitype.id')) token_id = db.Column(db.Integer, db.ForeignKey('token.id')) service_id = db.Column(db.Integer, db.ForeignKey('service.id')) namespace_id = db.Column(db.Integer, db.ForeignKey('namespace.id'))
class DeploymentValidation(db.Model): __tablename__ = 'deploymentvalidation' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(256), unique=False, index=True) token_id = db.Column(db.Integer, db.ForeignKey('token.id'), index=True) namespace_id = db.Column(db.Integer, db.ForeignKey('namespace.id'), index=True) # No index in objectkind_id as we have a very small subset of them objectkind_id = db.Column(db.Integer, db.ForeignKey('objectkind.id')) validation_id = db.Column(db.Integer, db.ForeignKey('validation.id'), index=True)
class ServiceSLO(db.Model): __tablename__ = 'serviceslo' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=False, index=True) value = db.Column(db.Float, unique=False, nullable=False) target = db.Column(db.Float, unique=False, nullable=False) # no index, slitype is a very small table slitype_id = db.Column(db.Integer, db.ForeignKey('slitype.id')) slodoc_id = db.Column(db.Integer, db.ForeignKey('slodoc.id'), index=True) token_id = db.Column(db.Integer, db.ForeignKey('token.id'), index=True) service_id = db.Column(db.Integer, db.ForeignKey('service.id'), index=True) namespace_id = db.Column(db.Integer, db.ForeignKey('namespace.id'), index=True)
class LatestTokens(db.Model): __tablename__ = 'latesttokens' id = db.Column(db.Integer, primary_key=True) # no index here, this is a very small table that won't almost grow token_id = db.Column(db.Integer, db.ForeignKey('token.id'))
class Namespace(db.Model): __tablename__ = 'namespace' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=False) cluster_id = db.Column(db.Integer, db.ForeignKey('cluster.id')) pods = db.relationship('Pod', backref='namespace')
class Namespace(db.Model): __tablename__ = 'namespace' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=False, index=True) cluster_id = db.Column(db.Integer, db.ForeignKey('cluster.id'), index=True) pods = db.relationship('Pod', backref='namespace') deploymentvalidation = db.relationship('DeploymentValidation', backref='namespace') serviceslo = db.relationship('ServiceSLO', backref='namespace')