from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import declarative_base

Base = declarative_base()


class Account(Base):  # type: ignore
    __tablename__ = 'account'

    account_id = Column(Integer, primary_key=True)
    account_name = Column(String)
    created_at = Column(String)
    sap_created_at = Column(String)
    last_modified = Column(String)
    created_by = Column(String)
    last_modified_by = Column(String)


class AccountContract(Base):  # type: ignore
    __tablename__ = 'account_contracts'

    id = Column(Integer, primary_key=True)
    account_id = Column(Integer)
    contract_id = Column(Integer)