| 1234567891011121314151617181920212223242526272829 |
- # -*- coding: utf-8 -*-
- from sqlalchemy import Integer, String, Text, DateTime
- from sqlalchemy.orm import Mapped, mapped_column
- from app.core.base_model import ModelMixin, UserMixin
- class GatewayModel(ModelMixin):
- """
- 网关信息表
- """
- __tablename__: str = 'biz_gateway'
- __table_args__: dict[str, str] = {'comment': '网关信息'}
- __loader_options__: list[str] = ["created_by", "updated_by"]
- crane_no: Mapped[str | None] = mapped_column(String(200), nullable=True, comment='行车编号')
- gateway_name: Mapped[str | None] = mapped_column(String(200), nullable=True, comment='网关名称')
- gateway_type: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='网关类型')
- gateway_ipaddress: Mapped[str | None] = mapped_column(String(200), nullable=True, comment='网关IP地址 ')
- gateway_port: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='网关端口 ')
- plc_brand: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='PLC品牌')
- plc_model: Mapped[str | None] = mapped_column(String(200), nullable=True, comment='PLC型号 ')
- serial_port_name: Mapped[str | None] = mapped_column(String(255), nullable=True, comment='端口号')
- serial_baud_rate: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='波特率 ')
- serial_data_bits: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='数据位 5678')
- serial_stop_bits: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='停止位 ')
- serial_parity: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='检验位 ')
|
