from sqlalchemy import Column, Integer, String, TIMESTAMP, Boolean
from database import Base


class Customer_Customer(Base):
    """Read-only customer model for reference."""
    __tablename__ = 'customer_customer'
    __table_args__ = {"schema": "public"}

    id = Column(Integer, primary_key=True, autoincrement=True)
    auth_net_profile_id = Column(String, unique=True, index=True, nullable=True)
    account_number = Column(String(25))
    customer_last_name = Column(String(250))
    customer_first_name = Column(String(250))
    customer_town = Column(String(140))
    customer_state = Column(Integer)
    customer_zip = Column(String(25))
    customer_first_call = Column(TIMESTAMP)
    customer_email = Column(String(500))
    customer_automatic = Column(Integer)
    customer_phone_number = Column(String(25))
    customer_home_type = Column(Integer)
    customer_apt = Column(String(140))
    customer_address = Column(String(1000))
    company_id = Column(Integer)
    customer_latitude = Column(String(250))
    customer_longitude = Column(String(250))
    correct_address = Column(Boolean)