DB Tables

[app-generator]

Hello @koladev32,

The goal is to super simple correlated tables.

Here is a definition copied from a Flask project. Please adapt the types.

class Product(db.Model):

    __tablename__ = 'products'

    id            = db.Column(db.Integer,      primary_key=True)
    user_id       = db.Column(db.Integer,      default=1)
    name          = db.Column(db.String(128),  nullable=False)
    information   = db.Column(db.String(128),  nullable=False)
    description   = db.Column(db.Text,         nullable=True)
    price         = db.Column(db.Integer,      nullable=False)
    currency      = db.Column(db.String(10),   default=Currency['usd'], nullable=False)
    date_created  = db.Column(db.DateTime,     default=dt.datetime.utcnow())

class Sale(db.Model):
    
    __tablename__ = 'sales'

    id            = db.Column(db.Integer,     primary_key=True)
    product       = db.Column(db.Integer,     db.ForeignKey("products.id", ondelete="cascade"), nullable=False)
    product_id    = relationship(Product,     uselist=False, backref="sales")
    state         = db.Column(db.Integer,     nullable=False)
    value         = db.Column(db.Integer,     nullable=False)
    fee           = db.Column(db.Integer,     default=0)
    currency      = db.Column(db.String(10),  default=Currency['usd'], nullable=False)
    client        = db.Column(db.String(128), nullable=True)
    payment_type  = db.Column(db.Integer(),   default=PAYMENT_TYPE['cc'], nullable=False)
    purchase_date = db.Column(db.DateTime,    default=dt.datetime.utcnow())