class UserRoles(db.Model):
__tablename__ = 'user_roles'
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(db.Integer(),
db.ForeignKey('users.id', ondelete='CASCADE'))
role_id = db.Column(db.Integer(),
db.ForeignKey('roles.id', ondelete='CASCADE'))
class File(db.Model):
id = db.Column(db.Integer(),primary_key=True)
owner = db.Column(db.Integer(),db.ForeignKey('user.id'),index=True)
name = db.Column(db.String(255),index=True)
size = db.Column(db.Integer,index=True)
fext = db.Column(db.String(20),index=True)
datetime = db.Column(db.DateTime)
public = db.Column(db.Boolean,default=False)
public_key = db.Column(db.String(255),index=True)
def __init__(self,owner=None,name=None,size=None,fext=None,public=None,public_key=None):
self.datetime = datetime.utcnow()
self.owner = owner
self.name = name
self.size = size
self.fext = fext
self.public = public
self.public_key = public_key
class Products(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
quantity = db.Column(db.Integer())
price = db.Column(db.Float)
description = db.Column(db.String(120))
status = db.Column(db.String(1))
def __init__(self, name, quantity, price, description):
self.name = name
self.quantity = quantity
self.price = price
self.description = description
self.status = 'A'
class Clients(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30))
address = db.Column(db.String(80))
contact = db.Column(db.String(40))
telephone = db.Column(db.Integer())
status = db.Column(db.String(1))
def __init__(self, name, address, contact, telephone):
self.name = name
self.address = address
self.contact = contact
self.telephone = telephone
self.status = 'A'
class Employees(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50))
email = db.Column(db.String(50))
telephone = db.Column(db.Integer())
job = db.Column(db.String(15))
gender = db.Column(db.String(10))
status = db.Column(db.String(2))
def __init__(self, name, email, telephone, job, gender):
self.name = name
self.email = email
self.telephone = telephone
self.job = job
self.gender = gender
self.status = 'A'
class Points(db.Model):
__tablename__ = 'points'
id = db.Column(db.Integer(), primary_key=True)
point = db.Column(db.Integer(), nullable=True)
class Role(db.Model):
__tablename__ = 'roles'
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(50), unique=True)