FilesExpand file tree

 master

/

models.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

93 lines (64 loc) · 3.63 KB

 master

/

models.py

Copy path

Top

File metadata and controls

• Code
• Blame

93 lines (64 loc) · 3.63 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

from datetime import datetime

from sqlalchemy import Column, Integer, String, DateTime, ForeignKey, Float

from sqlalchemy.orm import relationship, Mapped, mapped_column

from app.db import Base

class User(Base):

__tablename__ = "users"

id: Mapped[int] = mapped_column(Integer, primary_key=True, index=True)

username: Mapped[str] = mapped_column(String(50), unique=True, index=True, nullable=False)

password_hash: Mapped[str] = mapped_column(String(255), nullable=False)

is_admin: Mapped[bool] = mapped_column(Integer, default=1)

created_at: Mapped[datetime] = mapped_column(DateTime, default=datetime.utcnow)

class Supplier(Base):

__tablename__ = "suppliers"

id: Mapped[int] = mapped_column(Integer, primary_key=True)

name: Mapped[str] = mapped_column(String(100), nullable=False)

contact: Mapped[str] = mapped_column(String(100), nullable=True)

phone: Mapped[str] = mapped_column(String(30), nullable=True)

address: Mapped[str] = mapped_column(String(255), nullable=True)

created_at: Mapped[datetime] = mapped_column(DateTime, default=datetime.utcnow)

class Product(Base):

__tablename__ = "products"

id: Mapped[int] = mapped_column(Integer, primary_key=True)

sku: Mapped[str] = mapped_column(String(50), unique=True, index=True, nullable=False)

name: Mapped[str] = mapped_column(String(100), nullable=False)

description: Mapped[str] = mapped_column(String(255), nullable=True)

unit_price: Mapped[float] = mapped_column(Float, default=0.0)

created_at: Mapped[datetime] = mapped_column(DateTime, default=datetime.utcnow)

class Inventory(Base):

__tablename__ = "inventory"

id: Mapped[int] = mapped_column(Integer, primary_key=True)

product_id: Mapped[int] = mapped_column(ForeignKey("products.id"), index=True)

quantity: Mapped[float] = mapped_column(Float, default=0.0)

location: Mapped[str] = mapped_column(String(50), default="MAIN")

updated_at: Mapped[datetime] = mapped_column(DateTime, default=datetime.utcnow)

product = relationship("Product")

class PurchaseOrder(Base):

__tablename__ = "purchase_orders"

id: Mapped[int] = mapped_column(Integer, primary_key=True)

supplier_id: Mapped[int] = mapped_column(ForeignKey("suppliers.id"))

created_at: Mapped[datetime] = mapped_column(DateTime, default=datetime.utcnow)

status: Mapped[str] = mapped_column(String(20), default="OPEN")

supplier = relationship("Supplier")

class PurchaseOrderItem(Base):

__tablename__ = "purchase_order_items"

id: Mapped[int] = mapped_column(Integer, primary_key=True)

order_id: Mapped[int] = mapped_column(ForeignKey("purchase_orders.id"))

product_id: Mapped[int] = mapped_column(ForeignKey("products.id"))

quantity: Mapped[float] = mapped_column(Float, default=0.0)

price: Mapped[float] = mapped_column(Float, default=0.0)

product = relationship("Product")

class SalesOrder(Base):

__tablename__ = "sales_orders"

id: Mapped[int] = mapped_column(Integer, primary_key=True)

created_at: Mapped[datetime] = mapped_column(DateTime, default=datetime.utcnow)

status: Mapped[str] = mapped_column(String(20), default="OPEN")

customer_name: Mapped[str] = mapped_column(String(100), nullable=True)

class SalesOrderItem(Base):

__tablename__ = "sales_order_items"

id: Mapped[int] = mapped_column(Integer, primary_key=True)

order_id: Mapped[int] = mapped_column(ForeignKey("sales_orders.id"))

product_id: Mapped[int] = mapped_column(ForeignKey("products.id"))

quantity: Mapped[float] = mapped_column(Float, default=0.0)

price: Mapped[float] = mapped_column(Float, default=0.0)

product = relationship("Product")