| 12345678910111213141516171819202122232425262728 |
- from sqlalchemy import create_engine, Column, BigInteger, String, Text, DateTime, CHAR,Integer,Float
- from database import Base
- from datetime import datetime
- class CompanyManagementBaseInfo(Base):
- __tablename__ = 'company_management_base_info'
- id = Column(Integer, primary_key=True, nullable=False, autoincrement=True)
- company_code = Column(String(255), default=None, comment='企业统一社会信用代码')
- company_name = Column(String(255), nullable=False, comment='企业名称')
- province = Column(String(255), nullable=False, comment='辖区省')
- province_code = Column(String(255), nullable=False, comment='辖区省区划编码')
- city = Column(String(255), nullable=False, comment='辖区市')
- city_code = Column(String(255), nullable=False, comment='辖区市区划编码')
- district = Column(String(255), nullable=False, comment='辖区区县')
- district_code = Column(String(255), nullable=False, comment='辖区区县区划编码')
- company_address = Column(String(255), nullable=False, comment='企业地址')
- responsible_person = Column(String(255), nullable=False, comment='联系人')
- company_type = Column(String(255), default=None, comment='企业类型')
- phone = Column(String(20), default=None, comment='移动电话')
- del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
- create_dept = Column(BigInteger, default=None, comment='创建部门')
- create_by = Column(BigInteger, default=None, comment='创建者')
- create_time = Column(DateTime, default=datetime.now, comment='创建时间')
- update_by = Column(BigInteger, default=None, comment='更新者')
- update_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间')
- remark = Column(String(500), default=None, comment='备注')
|
