class Service(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(140)) price = db.Column(db.String()) appointments_id = db.Column(db.Integer, db.ForeignKey("appointments.id")) appointment = db.relationship("Appointments") sale_id = db.Column(db.Integer, db.ForeignKey("sale.id"))
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), index=True, unique=True) email = db.Column(db.String(120), index=True, unique=True) password_hash = db.Column(db.String(128)) posts = db.relationship('Post', backref='author', lazy='dynamic') def __repr__(self): return '<User {}>'.format(self.username)
class Client(db.Model): id = db.Column(db.Integer, primary_key=True) names = db.Column(db.String(64)) email = db.Column(db.String()) phone = db.Column(db.String()) appointments_id = db.Column(db.Integer, db.ForeignKey("appointments.id")) appointment = db.relationship("Appointments") sale_id = db.Column(db.Integer, db.ForeignKey("sale.id")) sale = db.relationship("Sale")
class Sale(db.Model): id = db.Column(db.Integer, primary_key=True) date = db.Column(db.DateTime, default=datetime.utcnow()) amount_paid = db.Column(db.String()) balance = db.Column(db.String) employee_com = db.Column(db.String()) payment_mode = db.Column(db.String()) service = db.relationship("Service") employee = db.relationship("Employee", uselist=False) client = db.relationship("Client", uselist=False)
class Employee(db.Model): id = db.Column(db.Integer, primary_key=True) names = db.Column(db.String(64)) email = db.Column(db.String(120)) phone = db.Column(db.String(10)) d_o_b = db.Column(db.DateTime, default=datetime.utcnow()) identification_no = db.Column(db.String(15)) appointments_id = db.Column(db.Integer, db.ForeignKey("appointments.id")) appointment = db.relationship("Appointments") sale_id = db.Column(db.Integer, db.ForeignKey("sale.id")) sale = db.relationship("Sale")
class Book(db.Model): id = db.Column(db.Integer, primary_key=True) isbn = db.Column(db.String(100)) title = db.Column(db.String(100)) author = db.Column(db.String(100)) date = db.Column(db.String(100)) #Constructor def __init__(self, isbn, title, author, date): self.isbn = isbn self.title = title self.author = author self.date = date
class User(db.Model): id = db.Column(db.Integer, primary_key=True) firstName = db.Column(db.String(100)) lastName = db.Column(db.String(100)) email = db.Column(db.String(100)) password = db.Column(db.String(100)) #Constructor def __init__(self, firstName, lastName, email, password): self.firstName = firstName self.lastName = lastName self.email = email self.password = password
class Peneliti(db.Model): __tablename__ = "peneliti" id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(50)) email = db.Column(db.String(50)) password = db.Column(db.String(50)) universitas = db.Column(db.String(50)) kategori_penelitian = db.Column(db.String(50)) jenis_kelamin = db.Column(db.Text) def __init__(self, username, email, password, universitas, jenis_kelamin, kategori_penelitian): self.username = username self.generate_password(password) self.email = email self.universitas = universitas self.kategori_penelitian = kategori_penelitian self.jenis_kelamin = jenis_kelamin self.authenticated = False self.confirmed = False def address(self, address): self.address = address def is_authenticated(self): return True def is_anonymous(self): return True def check_password(self, password): return check_password(self.password, password) def is_confirmed(self): return self.confirmed def confirm_user(self): self.confirmed = True def get_id(self): return str(self.user_id) def generate_password(self, password): self.password = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password, password) def __repr__(self): return "<User %r>" % (self.nama)
class Appointments(db.Model): id = db.Column(db.Integer, primary_key=True) date = db.Column(db.DateTime, default=datetime.utcnow()) status = db.Column(db.String()) client = db.relationship("Client", uselist=False) service = db.relationship("Service", uselist=False) employee = db.relationship("Employee", uselist=False)
class Admin(db.Model): __tablename__ = "admin" id = db.Column(db.Integer, primary_key=True) admin = db.Column(db.String(50), unique=True) password = db.Column(db.String(100)) def __init__(self, admin=admin, password=password): self.admin = admin self.generate_password(password) def generate_password(self, password): self.password = generate_password_hash(password) #def check_password(self, password): # return check_password(self.password, password) def check_password(self, password): return check_password_hash(self.password, password)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(140)) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<Post {}>'.format(self.body)
class Projects(db.Model): id = db.Column(db.Integer, primary_key=True) code = db.Column(db.String(100)) status = db.Column(db.String(50)) project_name = db.Column(db.String(50)) location = db.Column(db.String(50)) project_status = db.Column(db.String(50)) phase_number = db.Column(db.String(50)) photos = db.relationship("Photos")
class Photos(db.Model): id = db.Column(db.Integer, primary_key=True) photo = db.Column(db.String(100)) projects_id = db.Column(db.Integer, db.ForeignKey("projects.id")) projects = db.relationship("Projects", back_populates="photos")