# coding: utf-8
from sqlalchemy import Column, DateTime, Float, Integer, JSON, text
from sqlalchemy.dialects.mysql import VARCHAR
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
metadata = Base.metadata


class FootballMatchZjqOdd(Base):
    __tablename__ = 'football_match_zjq_odds'
    __table_args__ = {'comment': '竞彩足球总进球数赔率表'}

    id = Column(Integer, primary_key=True)
    issue = Column(VARCHAR(255))
    match_id = Column(Integer)
    result = Column(VARCHAR(50))
    odds = Column(Float)
    ball_0 = Column(Float)
    ball_1 = Column(Float)
    ball_2 = Column(Float)
    ball_3 = Column(Float)
    ball_4 = Column(Float)
    ball_5 = Column(Float)
    ball_6 = Column(Float)
    ball_7_plus = Column(Float)
    odds_history = Column(JSON)
    created_at = Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))