master_data.py 738 B

1234567891011121314151617181920212223
  1. from __future__ import annotations
  2. from sqlmodel import Field, SQLModel
  3. class Company(SQLModel, table=True):
  4. __tablename__ = "companies"
  5. id: int | None = Field(default=None, primary_key=True)
  6. name: str = Field(index=True, unique=True, max_length=255)
  7. remarks: str | None = Field(default=None)
  8. is_deleted: int = Field(default=0, index=True)
  9. created_at: str = Field(max_length=255)
  10. class Cargo(SQLModel, table=True):
  11. __tablename__ = "cargos"
  12. id: int | None = Field(default=None, primary_key=True)
  13. name: str = Field(index=True, unique=True, max_length=255)
  14. remarks: str | None = Field(default=None)
  15. is_deleted: int = Field(default=0, index=True)
  16. created_at: str = Field(max_length=255)