Edwin Eames
07865480c7
- Add FastAPI service for managing oil delivery services - Implement service scheduling and management endpoints - Add customer service history tracking - Include database models for services, customers, and auto-delivery - Add authentication and authorization middleware - Configure Docker support for local, dev, and prod environments - Add comprehensive .gitignore for Python projects
29 lines
1.1 KiB
Python
29 lines
1.1 KiB
Python
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)
|