class Contact(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200)) email = db.Column(db.String(200)) mobileno = db.Column(db.Integer) message = db.Column(db.String) usertype = db.Column(db.String(100))
class Adddocter(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200)) age = db.Column(db.Integer) Qualification = db.Column(db.String) specilizedarea = db.Column(db.String) doctertype = db.Column(db.String) email = db.Column(db.String) img = db.Column(db.String(30), nullable=False, default="default.jpg")
class Addstaff(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200)) age = db.Column(db.Integer) address = db.Column(db.String) qualification = db.Column(db.String) experience = db.Column(db.String) email = db.Column(db.String) img = db.Column(db.String(30), nullable=False, default="img.jpg")
class Addevent(db.Model): id = db.Column(db.Integer, primary_key=True) ownerid = db.Column(db.String(100)) eventname = db.Column(db.String(200)) eventdate = db.Column(db.String) eventtime = db.Column(db.Integer) eventtype = db.Column(db.String) staffid = db.Column(db.Integer) staffname = db.Column(db.String) status = db.Column(db.String)
class Pay(db.Model): id = db.Column(db.Integer, primary_key=True) userid = db.Column(db.String) admission = db.Column(db.String) admissionid = db.Column(db.String) name = db.Column(db.String(200)) card = db.Column(db.String(200)) cvv = db.Column(db.String(200)) validdate = db.Column(db.String(200)) amount = db.Column(db.String(200))
class Member(db.Model): id = db.Column(db.Integer, primary_key=True) ownerid = db.Column(db.String) name = db.Column(db.String(200)) address = db.Column(db.String(200)) course = db.Column(db.String) time = db.Column(db.Integer) img = db.Column(db.String(30), nullable=False, default="img7.jpg") amount = db.Column(db.String) payment = db.Column(db.String) paymentstatus = db.Column(db.String)
class Addelder(db.Model): id = db.Column(db.Integer, primary_key=True) ownerid = db.Column(db.String) name = db.Column(db.String(200)) age = db.Column(db.Integer) gender = db.Column(db.String) mobilenoofguardian = db.Column(db.Integer) guardianname = db.Column(db.String) img = db.Column(db.String(30), nullable=False, default="img2.jpg") amount = db.Column(db.String) payment = db.Column(db.String) paymentstatus = db.Column(db.String)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class Kids(db.Model): id = db.Column(db.Integer, primary_key=True) ownerid = db.Column(db.String) kidname = db.Column(db.String(200)) address = db.Column(db.String(200)) guadianname = db.Column(db.String) mobileno = db.Column(db.Integer) age = db.Column(db.Integer) img = db.Column(db.String(30), nullable=False, default="img5.jpg") status = db.Column(db.String) amount = db.Column(db.String) payment = db.Column(db.String) paymentstatus = db.Column(db.String)
class Chat(db.Model): id = db.Column(db.Integer, primary_key=True) userid = db.Column(db.String) staffid = db.Column(db.String) message = db.Column(db.String(200)) sid = db.Column(db.String) rid = db.Column(db.String) date = db.Column(db.String) time = db.Column(db.String) status = db.Column(db.String)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class Donation(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200)) email = db.Column(db.String(200)) donation = db.Column(db.String) message = db.Column(db.String)
class Gallery(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.VARCHAR) img = db.Column(db.String(20), nullable=False, default='default.jpg')
class Patientdetails(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200)) age = db.Column(db.Integer) checkingdate = db.Column(db.String) details = db.Column(db.String)
class Schedule(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200)) section = db.Column(db.String(200)) time = db.Column(db.Integer) date = db.Column(db.Date)