from sqlalchemy import Column,Integer,String,Date,DateTime,ForeignKey
from sqlalchemy.ext.declarative import declarative_base

Base=declarative_base()

class User(Base):
    __tablename__="users2"
    id=Column(Integer,primary_key=True,index=True)
    name=Column(String(50),nullable=False)
    age=Column(Integer)

    def __repr__(self):
        return f"<User(id={self.id}, name={self.name}, age={self.age})>"
    

class Image(Base):
    __tablename__="images"
    id=Column(Integer,primary_key=True,autoincrement=True)
    image_path=Column(String)

##javbus
class Actress:
    __tablename__="actresses"
    id=Column(Integer,primary_key=True,autoincrement=True)
    name=Column(String(10),nullable=False)
    short_url=Column(String(10))
    birth=Column(Date)
    cup=Column(String(2),default='A')
    heigh=Column(Integer,default=100)
    iid=Column(Integer,ForeignKey("image.id"))