Client Model

from sqlalchemy import Column, Integer, String, Text, Date, DateTime, Boolean, ForeignKey
from sqlalchemy.orm import relationship

class Client(Base):
    __tablename__ = "clients"

CREATE TABLE clients (
    id INTEGER PRIMARY KEY,
    name VARCHAR(120) NOT NULL,
    phone VARCHAR(40),
    email VARCHAR(120),
    notes TEXT,
    is_active BOOLEAN NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    
    -- Personal details
    instagram TEXT,
    city TEXT,
    state TEXT,
    gender TEXT,
    birthdate DATE,
    
    -- Consent
    consent_info BOOLEAN,
    consent_image BOOLEAN,
    consent_data BOOLEAN,
    
    -- Emergency contact
    emergency_name TEXT,
    emergency_relation TEXT,
    emergency_phone TEXT,
    
    -- Preferences
    preferred_artist_id INTEGER,
    FOREIGN KEY (preferred_artist_id) REFERENCES artists(id),
    
    -- Health information
    health_allergies BOOLEAN,
    health_diabetes BOOLEAN,
    health_coagulation BOOLEAN,
    health_epilepsy BOOLEAN,
    health_cardiac BOOLEAN,
    health_anticoagulants BOOLEAN,
    health_preg_lact BOOLEAN,
    health_substances BOOLEAN,
    health_derm BOOLEAN,
    health_obs TEXT
);

from data.models.client import Client
from sqlalchemy.orm import Session

# Create a new client
new_client = Client(
    name="John Doe",
    phone="555-0123",
    email="[email protected]",
    city="New York",
    state="NY",
    birthdate="1990-05-15",
    consent_info=True,
    consent_image=True,
    consent_data=True,
    health_allergies=False,
    health_diabetes=False,
    preferred_artist_id=1
)

db.add(new_client)
db.commit()

# Query client with sessions
client = db.query(Client).filter(Client.id == 1).first()
print(f"Client: {client.name}")
print(f"Total sessions: {len(client.sessions)}")
print(f"Preferred artist: {client.preferred_artist.name}")