models.py

from pydantic import BaseModel
from sqlmodel import Field, SQLModel
from datetime import datetime

class Settings(SQLModel, table=True):
    servo_id: int | None = Field(default=None, primary_key=True)
    madication_name: str
    madication_properties: str | None
    exp: datetime

class Medication_schedule(SQLModel, table=True):
    medication_id: int | None = Field(default=None, primary_key=True)
    date: datetime
    quantity_servo1: int
    quantity_servo2: int
    quantity_servo3: int
    quantity_servo4: int

class Storage(SQLModel, table=True):
    storage_id: int | None = Field(default=None, primary_key=True)
    servo_id: int
    quantity: int
    action_date: datetime

class Work_schedule(SQLModel, table=True):
    work_id: int | None = Field(default=None, primary_key=True)
    medication_id: int
    work_date: datetime