from sqlalchemy import Column, Integer, String
from database import Base
from .CustomBase import CustomBase

class Subscriptions(Base, CustomBase):
    __tablename__ = "subscriptions"
    id = Column(Integer, primary_key=True, index=True)
    # session_id = Column(String(255), index=True)
    customer_id = Column(String,index=True)    
    account_id = Column(String,index=True)  
    total = Column(String)  
    setup_fee = Column(String)
    subscription_fee = Column(String)
    per_call_charge = Column(String)
    subscription_id = Column(String,index=True)
    clinic_id = Column(Integer, index=True)
    status = Column(String)
    current_period_start = Column(String) # unix timestamp
    current_period_end = Column(String) # unix timestamp
    metadata_logs = Column(String)