class FieldType(db.Model):
__bind_key__ = 'lac'
__tablename__ = 'fieldtype'
id = db.Column(db.Integer, primary_key=True)
type = db.Column(db.String(80))
fields = db.relationship('Field', backref='fieldtype', lazy='dynamic')
class LDAPAttribute(db.Model):
__bind_key__ = 'lac'
__tablename__ = 'ldapattribute'
id = db.Column(db.Integer, primary_key=True)
label = db.Column(db.String(50), unique=True)
ldapobjectclassattributes = db.relationship("LDAPObjectClassAttribute",
backref="ldapattribute",
lazy='dynamic')
fields = db.relationship('Field', backref='ldapattribute', lazy='dynamic')
def __init__(self, label):
self.label = label
def __repr__(self):
return '<LDAPAttribute %r>' % self.label
class C4Qualite(db.Model):
__bind_key__ = 'gescli'
__tablename__ = 'QUALITE'
code_qualite = db.Column(db.String(8), primary_key=True)
libelle_qualite = db.Column(db.String(50))
personnes = db.relationship('C4Personne',
backref='qualite',
lazy='dynamic')
class C4Comite(db.Model):
__bind_key__ = 'gescli'
__tablename__ = 'COMITE'
code_comite = db.Column(db.Integer, primary_key=True)
ct = db.Column(db.String(8))
intitule_comite = db.Column(db.String(80))
ressources = db.relationship('C4Ressource',
backref='comite',
lazy='dynamic')
class Page(db.Model):
__bind_key__ = 'lac'
__tablename__ = 'page'
id = db.Column(db.Integer, primary_key=True)
label = db.Column(db.String(50), unique=True)
description = db.Column(db.String(80))
fields = db.relationship("Field", backref="page", lazy='dynamic')
pageobjectclasses = db.relationship("PageObjectClass",
backref="page",
lazy='dynamic')
def __init__(self, label, description):
self.label = label
self.description = description
def __repr__(self):
return '<Page %r>' % self.label
class C4Adresse(db.Model):
__bind_key__ = 'gescli'
__tablename__ = 'ADRESSE'
code_adresse = db.Column(db.Integer, primary_key=True)
laboratoire_adresse = db.Column(db.String(50))
organisme_adresse = db.Column(db.String(50))
adresse1_adresse = db.Column(db.String(50))
adresse2_adresse = db.Column(db.String(50))
cdpostal_adresse = db.Column(db.String(10))
ville_adresse = db.Column(db.String(50))
pays_adresse = db.Column(db.String(20))
personnes = db.relationship('C4Personne',
backref='adresse',
lazy='dynamic')
class C4Personne(db.Model):
__bind_key__ = 'gescli'
__tablename__ = 'PERSONNE'
code_personne = db.Column(db.Integer, primary_key=True)
nom_personne = db.Column(db.String(30))
prenom_personne = db.Column(db.String(30))
code_adresse = db.Column(db.Integer, db.ForeignKey('ADRESSE.code_adresse'))
code_qualite = db.Column(db.String(8),
db.ForeignKey('QUALITE.code_qualite'))
code_profil = db.Column(db.String(15), db.ForeignKey('PROFIL.code_profil'))
telephone_personne = db.Column(db.String(20))
fax_personne = db.Column(db.String(20))
bal_personne = db.Column(db.String(50))
projets = db.relationship('C4Projet', backref='personne', lazy='dynamic')
class LDAPObjectType(db.Model):
__bind_key__ = 'lac'
__tablename__ = 'ldapobjecttype'
id = db.Column(db.Integer, primary_key=True)
label = db.Column(db.String(50), unique=True)
description = db.Column(db.String(50))
ranges = db.Column(db.String(200))
apply_to = db.Column(db.String(20))
last_used_id = db.Column(db.Integer)
ppolicy = db.Column(db.String(50))
ldapobjecttypeobjectclasses = db.relationship("LDAPObjectTypeObjectClass",
backref="ldapobjecttype",
lazy='dynamic')
class User(db.Model):
__bind_key__ = 'lac'
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.String(200))
uid_number = db.Column(db.Integer, unique=True)
firstname = db.Column(db.String(200))
lastname = db.Column(db.String(200))
email = db.Column(db.String(200))
phone_number = db.Column(db.String(20))
deletion_timestamp = db.Column(db.Date())
binds = db.relationship('UserBind',
backref="user",
lazy='dynamic',
order_by='desc(UserBind.time)')
class C4Profil(db.Model):
__bind_key__ = 'gescli'
__tablename__ = 'PROFIL'
code_profil = db.Column(db.String(15), primary_key=True)
libelle_profil = db.Column(db.String(50))
personnes = db.relationship('C4Personne', backref='profil', lazy='dynamic')