from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy() class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(50), unique=True) password = db.Column(db.String(50)) role = db.Column(db.String(20)) # judge, lawyer, clerk, admin class Case(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(200)) description = db.Column(db.Text) summary = db.Column(db.Text) pdf_filename = db.Column(db.String(200)) court = db.Column(db.String(100))

Create models.py