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='备注')