I'll create a comprehensive ChurchTime App with all the requested features. Here's the complete structure and code: import os from dotenv import load_dotenv load_dotenv() class Config: SECRET_KEY = os.getenv('SECRET_KEY', 'your-secret-key-here') SQLALCHEMY_DATABASE_URI = os.getenv('DATABASE_URL', 'mysql+pymysql://user:password@localhost/churchtime') SQLALCHEMY_TRACK_MODIFICATIONS = False SESSION_TYPE = 'filesystem' SOCKETIO_MESSAGE_QUEUE = os.getenv('REDIS_URL', 'redis://localhost:6379/0') # Email configuration MAIL_SERVER = os.getenv('MAIL_SERVER', 'smtp.example.com') MAIL_PORT = int(os.getenv('MAIL_PORT', 587)) MAIL_USE_TLS = os.getenv('MAIL_USE_TLS', 'true').lower() in ['true', 'on', '1'] MAIL_USERNAME = os.getenv('MAIL_USERNAME', 'email@example.com') MAIL_PASSWORD = os.getenv('MAIL_PASSWORD', 'password') MAIL_DEFAULT_SENDER = os.getenv('MAIL_DEFAULT_SENDER', 'noreply@churchtime.com') from datetime import datetime from werkzeug.security import generate_password_hash, check_password_hash from flask_login import UserMixin from . import db, login_manager class User(UserMixin, db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(64), unique=True, index=True) username = db.Column(db.String(64), unique=True, index=True) password_hash = db.Column(db.String(128)) first_name = db.Column(db.String(64)) last_name = db.Column(db.String(64)) phone = db.Column(db.String(20)) profile_image = db.Column(db.String(128)) confirmed = db.Column(db.Boolean, default=False) created_at = db.Column(db.DateTime, default=datetime.utcnow) last_seen = db.Column(db.DateTime, default=datetime.utcnow) # Relationships memberships = db.relationship('Membership', back_populates='user', cascade='all, delete-orphan') messages = db.relationship('Message', back_populates='author', foreign_keys='Message.user_id') @property def password(self): raise AttributeError('password is not a readable attribute') @password.setter def password(self, password): self.password_hash = generate_password_hash(password) def verify_password(self, password): return check_password_hash(self.password_hash, password) def ping(self): self.last_seen = datetime.utcnow() db.session.add(self) db.session.commit() class Ministry(db.Model): __tablename__ = 'ministries' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=True) description = db.Column(db.Text) logo = db.Column(db.String(128)) created_at = db.Column(db.DateTime, default=datetime.utcnow) # Relationships memberships = db.relationship('Membership', back_populates='ministry', cascade='all, delete-orphan') schedules = db.relationship('Schedule', back_populates='ministry', cascade='all, delete-orphan') songs = db.relationship('Song', back_populates='ministry', cascade='all, delete-orphan') class Role(db.Model): __tablename__ = 'roles' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), unique=True) description = db.Column(db.Text) permissions = db.Column(db.Integer) default = db.Column(db.Boolean, default=False, index=True) # Relationships memberships = db.relationship('Membership', back_populates='role') class Membership(db.Model): __tablename__ = 'memberships' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id')) ministry_id = db.Column(db.Integer, db.ForeignKey('ministries.id')) role_id = db.Column(db.Integer, db.ForeignKey('roles.id')) joined_at = db.Column(db.DateTime, default=datetime.utcnow) active = db.Column(db.Boolean, default=True) # Relationships user = db.relationship('User', back_populates='memberships') ministry = db.relationship('Ministry', back_populates='memberships') role = db.relationship('Role', back_populates='memberships') class Schedule(db.Model): __tablename__ = 'schedules' id = db.Column(db.Integer, primary_key=True) ministry_id = db.Column(db.Integer, db.ForeignKey('ministries.id')) title = db.Column(db.String(128)) description = db.Column(db.Text) date = db.Column(db.DateTime) location = db.Column(db.String(128)) status = db.Column(db.String(20), default='planned') created_at = db.Column(db.DateTime, default=datetime.utcnow) # Relationships ministry = db.relationship('Ministry', back_populates='schedules') items = db.relationship('ScheduleItem', back_populates='schedule', cascade='all, delete-orphan') class ScheduleItem(db.Model): __tablename__ = 'schedule_items' id = db.Column(db.Integer, primary_key=True) schedule_id = db.Column(db.Integer, db.ForeignKey('schedules.id')) song_id = db.Column(db.Integer, db.ForeignKey('songs.id')) order = db.Column(db.Integer) notes = db.Column(db.Text) key = db.Column(db.String(10)) tempo = db.Column(db.String(20)) # Relationships schedule = db.relationship('Schedule', back_populates='items') song = db.relationship('Song') participants = db.relationship('ScheduleParticipant', back_populates='item', cascade='all, delete-orphan') class ScheduleParticipant(db.Model): __tablename__ = 'schedule_participants' id = db.Column(db.Integer, primary_key=True) item_id = db.Column(db.Integer, db.ForeignKey('schedule_items.id')) user_id = db.Column(db.Integer, db.ForeignKey('users.id')) role = db.Column(db.String(64)) status = db.Column(db.String(20), default='pending') # Relationships item = db.relationship('ScheduleItem', back_populates='participants') user = db.relationship('User') class Song(db.Model): __tablename__ = 'songs' id = db.Column(db.Integer, primary_key=True) ministry_id = db.Column(db.Integer, db.ForeignKey('ministries.id')) title = db.Column(db.String(128)) artist = db.Column(db.String(128)) lyrics = db.Column(db.Text) chords = db.Column(db.Text) youtube_url = db.Column(db.String(256)) audio_url = db.Column(db.String(256)) key = db.Column(db.String(10)) tempo = db.Column(db.String(20)) created_at = db.Column(db.DateTime, default=datetime.utcnow) # Relationships ministry = db.relationship('Ministry', back_populates='songs') class Message(db.Model): __tablename__ = 'messages' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id')) ministry_id = db.Column(db.Integer, db.ForeignKey('ministries.id')) body = db.Column(db.Text) timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True) # Relationships author = db.relationship('User', back_populates='messages', foreign_keys=[user_id]) ministry = db.relationship('Ministry') @login_manager.user_loader def load_user(user_id): return User.query.get(int(user_id)) from flask_sqlalchemy import SQLAlchemy from flask_login import LoginManager from flask_mail import Mail from flask_socketio import SocketIO from flask_migrate import Migrate db = SQLAlchemy() login_manager = LoginManager() mail = Mail() socketio = SocketIO() migrate = Migrate() from flask import Flask from config import Config from .extensions import db, login_manager, mail, socketio, migrate def create_app(config_class=Config): app = Flask(__name__) app