from sqlalchemy import Table, Column, Integer, String, Float, DateTime, Numeric, Date
from .db import metadata
users = Table(
"users",
metadata,
Column("id", Integer, primary_key=True),
Column("email", String, unique=True, nullable=False),
Column("name", String, nullable=True),
)
accruals = Table(
"accruals",
metadata,
Column("id", Integer, primary_key=True),
Column("id_accrual", String, nullable=False),
Column("accrual_date", DateTime, nullable=False),
Column("service_group", String, nullable=True),
Column("accrual_type", String, nullable=True),
Column("article", String, nullable=True),
Column("sku", String, nullable=True),
Column("product_name", String, nullable=True),
Column("quantity", Integer, nullable=True),
Column("seller_price", Numeric(precision=15, scale=2), nullable=True),
Column("order_received_date", DateTime, nullable=True),
Column("sales_platform", String, nullable=True),
Column("work_scheme", String, nullable=True),
Column("ozon_fee_pct", Float, nullable=True),
Column("localization_index_pct", Float, nullable=True),
Column("avg_delivery_hours", Float, nullable=True),
Column("total_amount_rub", Numeric(precision=15, scale=2), nullable=False),
)