from app import db
from .db_abstract import DBAbstract


class StockData(DBAbstract):
    """table: 股票每日數據"""
    __tablename__ = 'stock_data'
    id = db.Column(db.Integer, primary_key=True)
    stock_basic_info_id = db.Column(db.Integer, db.ForeignKey(
        'stock_basic_info.id'), nullable=False)
    opening_price = db.Column(db.Float, nullable=False)
    closing_price = db.Column(db.Float, nullable=False)
    highest_price = db.Column(db.Float, nullable=False)
    lowest_price = db.Column(db.Float, nullable=False)
    volume = db.Column(db.Integer, nullable=False)
    date = db.Column(db.DateTime(), nullable=False)

4891988d421a67f8ef100c1a5af9e2257238d3ef
<mask token>


class StockData(DBAbstract):
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>

<mask token>


class StockData(DBAbstract):
    <mask token>
    __tablename__ = 'stock_data'
    id = db.Column(db.Integer, primary_key=True)
    stock_basic_info_id = db.Column(db.Integer, db.ForeignKey(
        'stock_basic_info.id'), nullable=False)
    opening_price = db.Column(db.Float, nullable=False)
    closing_price = db.Column(db.Float, nullable=False)
    highest_price = db.Column(db.Float, nullable=False)
    lowest_price = db.Column(db.Float, nullable=False)
    volume = db.Column(db.Integer, nullable=False)
    date = db.Column(db.DateTime(), nullable=False)

<mask token>


class StockData(DBAbstract):
    """table: 股票每日數據"""
    __tablename__ = 'stock_data'
    id = db.Column(db.Integer, primary_key=True)
    stock_basic_info_id = db.Column(db.Integer, db.ForeignKey(
        'stock_basic_info.id'), nullable=False)
    opening_price = db.Column(db.Float, nullable=False)
    closing_price = db.Column(db.Float, nullable=False)
    highest_price = db.Column(db.Float, nullable=False)
    lowest_price = db.Column(db.Float, nullable=False)
    volume = db.Column(db.Integer, nullable=False)
    date = db.Column(db.DateTime(), nullable=False)

from app import db
from .db_abstract import DBAbstract


class StockData(DBAbstract):
    """table: 股票每日數據"""
    __tablename__ = 'stock_data'
    id = db.Column(db.Integer, primary_key=True)
    stock_basic_info_id = db.Column(db.Integer, db.ForeignKey(
        'stock_basic_info.id'), nullable=False)
    opening_price = db.Column(db.Float, nullable=False)
    closing_price = db.Column(db.Float, nullable=False)
    highest_price = db.Column(db.Float, nullable=False)
    lowest_price = db.Column(db.Float, nullable=False)
    volume = db.Column(db.Integer, nullable=False)
    date = db.Column(db.DateTime(), nullable=False)
