21 lines
602 B
Python
21 lines
602 B
Python
|
from sqlalchemy import Column, Integer, String, Index
|
||
|
|
from sqlalchemy.orm import declarative_base
|
||
|
|
|
||
|
|
'''
|
||
|
|
概念板块数据表
|
||
|
|
'''
|
||
|
|
class ConceptSector(declarative_base()):
|
||
|
|
__tablename__ = 'stock_concept_sector'
|
||
|
|
|
||
|
|
id = Column(Integer, primary_key=True, autoincrement=True)
|
||
|
|
trade_date = Column(String, nullable=False)
|
||
|
|
sector_name = Column(String)
|
||
|
|
sector_code = Column(String)
|
||
|
|
pct_change = Column(String)
|
||
|
|
total_market = Column(String)
|
||
|
|
rising_count = Column(String)
|
||
|
|
falling_count = Column(String)
|
||
|
|
new_price = Column(String)
|
||
|
|
leading_stock = Column(String)
|
||
|
|
leading_stock_pct_change = Column(String)
|