from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, PrimaryKeyConstraint
from sqlalchemy import Sequence
from sqlalchemy.orm import relationship

Base = declarative_base()
class Case(Base):
    __tablename__ = 'cases'

    id = Column(Integer, Sequence('case_id_seq'), primary_key=True)
    name = Column(String, nullable=False)
    case_number = Column(String, nullable=False)
    case_name = Column(String, nullable=False)
    status = Column(String, nullable=False)
    filing_date = Column(String, nullable=False)
    status_date = Column(String, nullable=False)
    url_id = Column(String, unique=True)

    def __repr__(self):
            return "lol"
