from sqlalchemy import Column, Integer, String, DateTime, Text, Float, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base
from datetime import datetime

Base = declarative_base()


class SocieteModel(Base):
    __tablename__ = "llx_societe"

    ROWID = Column(Integer, primary_key=True, autoincrement=True, nullable=False)
    NOM = Column(String(128), nullable=True)
    NAME_ALIAS = Column(String(128), nullable=True)
    ENTITY = Column(Integer, nullable=False, default=1)
    REF_EXT = Column(String(255), nullable=True)
    STATUT = Column(Integer, nullable=True, default=0)
    PARENT = Column(Integer, nullable=True)
    STATUS = Column(Integer, nullable=True, default=1)
    CODE_CLIENT = Column(String(24), nullable=True)
    CODE_FOURNISSEUR = Column(String(24), nullable=True)
    CODE_COMPTA = Column(String(24), nullable=True)
    CODE_COMPTA_FOURNISSEUR = Column(String(24), nullable=True)
    ADDRESS = Column(String(255), nullable=True)
    ZIP = Column(String(25), nullable=True)
    TOWN = Column(String(50), nullable=True)
    FK_DEPARTEMENT = Column(Integer, nullable=True, default=0)
    FK_PAYS = Column(Integer, nullable=True, default=0)
    FK_ACCOUNT = Column(Integer, nullable=True, default=0)
    PHONE = Column(String(20), nullable=True)
    FAX = Column(String(20), nullable=True)
    URL = Column(String(255), nullable=True)
    EMAIL = Column(String(128), nullable=True)
    SOCIALNETWORKS = Column(Text, nullable=True)
    FK_EFFECTIF = Column(Integer, nullable=True, default=0)
    FK_TYPENT = Column(Integer, nullable=True)
    FK_FORME_JURIDIQUE = Column(Integer, nullable=True, default=0)
    FK_CURRENCY = Column(String(3), nullable=True)
    SIREN = Column(String(128), nullable=True)
    SIRET = Column(String(128), nullable=True)
    APE = Column(String(128), nullable=True)
    IDPROF4 = Column(String(128), nullable=True)
    IDPROF5 = Column(String(128), nullable=True)
    IDPROF6 = Column(String(128), nullable=True)
    TVA_INTRA = Column(String(20), nullable=True)
    CAPITAL = Column(Float, nullable=True)
    FK_STCOMM = Column(Integer, nullable=False, default=0)
    NOTE_PRIVATE = Column(Text, nullable=True)
    NOTE_PUBLIC = Column(Text, nullable=True)
    MODEL_PDF = Column(String(255), nullable=True)
    LAST_MAIN_DOC = Column(String(255), nullable=True)
    PREFIX_COMM = Column(String(5), nullable=True)
    CLIENT = Column(Integer, nullable=True, default=0)
    FOURNISSEUR = Column(Integer, nullable=True, default=0)
    SUPPLIER_ACCOUNT = Column(String(32), nullable=True)
    FK_PROSPECTLEVEL = Column(String(12), nullable=True)
    FK_INCOTERMS = Column(Integer, nullable=True)
    LOCATION_INCOTERMS = Column(String(255), nullable=True)
    CUSTOMER_BAD = Column(Integer, nullable=True, default=0)
    CUSTOMER_RATE = Column(Float, nullable=True, default=0)
    SUPPLIER_RATE = Column(Float, nullable=True, default=0)
    REMISE_CLIENT = Column(Float, nullable=True, default=0)
    REMISE_SUPPLIER = Column(Float, nullable=True, default=0)
    MODE_REGLEMENT = Column(Integer, nullable=True)
    COND_REGLEMENT = Column(Integer, nullable=True)
    DEPOSIT_PERCENT = Column(String(63), nullable=True)
    TRANSPORT_MODE = Column(Integer, nullable=True)
    MODE_REGLEMENT_SUPPLIER = Column(Integer, nullable=True)
    COND_REGLEMENT_SUPPLIER = Column(Integer, nullable=True)
    TRANSPORT_MODE_SUPPLIER = Column(Integer, nullable=True)
    FK_SHIPPING_METHOD = Column(Integer, nullable=True)
    TVA_ASSUJ = Column(Integer, nullable=True, default=1)
    LOCALTAX1_ASSUJ = Column(Integer, nullable=True, default=0)
    LOCALTAX1_VALUE = Column(Float, nullable=True)
    LOCALTAX2_ASSUJ = Column(Integer, nullable=True, default=0)
    LOCALTAX2_VALUE = Column(Float, nullable=True)
    BARCODE = Column(String(180), nullable=True)
    FK_BARCODE_TYPE = Column(Integer, nullable=True, default=0)
    PRICE_LEVEL = Column(Integer, nullable=True)
    OUTSTANDING_LIMIT = Column(Float, nullable=True)
    ORDER_MIN_AMOUNT = Column(Float, nullable=True)
    SUPPLIER_ORDER_MIN_AMOUNT = Column(Float, nullable=True)
    DEFAULT_LANG = Column(String(6), nullable=True)
    LOGO = Column(String(255), nullable=True)
    LOGO_SQUARRED = Column(String(255), nullable=True)
    CANVAS = Column(String(32), nullable=True)
    FK_WAREHOUSE = Column(Integer, nullable=True)
    WEBSERVICES_URL = Column(String(255), nullable=True)
    WEBSERVICES_KEY = Column(String(128), nullable=True)
    ACCOUNTANCY_CODE_SELL = Column(String(32), nullable=True)
    ACCOUNTANCY_CODE_BUY = Column(String(32), nullable=True)
    TMS = Column(TIMESTAMP, nullable=True)
    DATEC = Column(DateTime, nullable=True)
    FK_USER_CREAT = Column(Integer, nullable=True)
    FK_USER_MODIF = Column(Integer, nullable=True)
    FK_MULTICURRENCY = Column(Integer, nullable=True)
    MULTICURRENCY_CODE = Column(String(3), nullable=True)
    IMPORT_KEY = Column(String(14), nullable=True)
    CREATED_AT = Column(DateTime, default=datetime.utcnow)
    UPDATED_AT = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)