manufacturing_sql/mes_tables.py at main · dapomeranz/manufacturing_sql · GitHub

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
# models.py
from sqlalchemy import Column, DateTime, Float, Integer, String
from sqlalchemy.ext.declarative import declarative_base

MesBase = declarative_base()


class Operation(MesBase):
    __tablename__ = "mes_operations"

    id = Column(Integer, primary_key=True)
    operation_name = Column(String)


class Resource(MesBase):
    __tablename__ = "mes_resources"

    id = Column(Integer, primary_key=True)
    operation_id = Column(Integer)
    resource_name = Column(String)


class Operator(MesBase):
    __tablename__ = "mes_operators"

    id = Column(Integer, primary_key=True)
    operator_name = Column(String)


class CompleteLog(MesBase):
    __tablename__ = "mes_complete_logs"

    id = Column(Integer, primary_key=True)
    resource_id = Column(Integer)
    operator_id = Column(Integer)
    work_order_id = Column(Integer)
    timestamp = Column(DateTime)
    quantity = Column(Float)


class ScrapLog(MesBase):
    __tablename__ = "mes_scrap_logs"

    id = Column(Integer, primary_key=True)
    resource_id = Column(Integer)
    operator_id = Column(Integer)
    work_order_id = Column(Integer)
    timestamp = Column(DateTime)
    quantity = Column(Float)