from sqlalchemy import Column, Integer, String, DateTime, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from databases import Database
import datetime

DATABASE_URL = "sqlite:///./test.db"  # Замени на свою базу данных

database = Database(DATABASE_URL)
Base = declarative_base()

class Auditory(Base):
    __tablename__ = "auditory"
    id = Column(Integer, primary_key=True, autoincrement=True)
    audnazvanie = Column(String)
    oboruds = relationship('Oboruds', back_populates='auditory')

class Oboruds(Base):
    __tablename__ = "oboruds"
    id = Column(Integer, primary_key=True, autoincrement=True)
    invNumber = Column(Integer)
    nazvanie = Column(String(500))
    raspologenie = Column(String(200))
    numberved = Column(String(100))
    numberppasu = Column(String(100))
    kolichestvo = Column(Integer)
    balancenumber = Column(Integer)
    aud_id = Column(Integer, ForeignKey('auditory.id'))
    auditory = relationship('Auditory', back_populates='oboruds')

class Zametki(Base):
    __tablename__ = "zametki"
    id = Column(Integer, primary_key=True, autoincrement=True)
    txtzam = Column(String(10000))
    created_date = Column(DateTime, default=datetime.datetime.utcnow)
    rmdt = Column(DateTime)