コード例 #1
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Stock_Update(db.Model):
    __tablename__ = 'Stock_Update'
    update_id = db.Column(db.Integer, primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)
    price_change = db.Column(db.Float, nullable = False)
コード例 #2
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class User_Transaction(db.Model):
    __tablename__ = 'User_Transaction'
    transaction_id = db.Column(db.Integer, db.ForeignKey('Transaction.transaction_id'), primary_key = True, nullable = False)
    type = db.Column(db.Boolean, nullable = False)
    user_id = db.Column(db.String(30), db.ForeignKey('User.user_id'), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)
コード例 #3
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Group_Transaction(db.Model):
    __tablename__ = 'Group_Transaction'
    transaction_id = db.Column(db.Integer, db.ForeignKey('Transaction.transaction_id'), primary_key = True, nullable = False)
    type = db.Column(db.Boolean, nullable = False)
    group_id = db.Column(db.Integer, db.ForeignKey('Group_Info.group_id'), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)
コード例 #4
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Group_Stock(db.Model):
    __tablename__ = 'Group_Stock'
    group_id = db.Column(db.Integer, db.ForeignKey('Group_Info.group_id'), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)
    amount = db.Column(db.Integer, nullable = False)
コード例 #5
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Transaction(db.Model):
    __tablename__ = 'Transaction'
    transaction_id = db.Column(db.Integer, primary_key = True, nullable = False)
    amount = db.Column(db.Integer, nullable = False)
    date = db.Column(db.Integer, nullable = False)
    price = db.Column(db.Float, nullable = False)
コード例 #6
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Group_Info(db.Model):
    __tablename__ = 'Group_Info'
    group_id = db.Column(db.Integer, primary_key = True, nullable = False)
    balance = db.Column(db.Float, nullable = False)
コード例 #7
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Group_Users(db.Model):
    __tablename__ = 'Group_Users'
    group_id = db.Column(db.Integer, db.ForeignKey('Group_Info.group_id'), primary_key = True, nullable = False)
    user_id = db.Column(db.String(30), db.ForeignKey('User.user_id'), primary_key = True, nullable = False)
コード例 #8
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Watchlist(db.Model):
    __tablename__ = 'Watchlist'
    user_id = db.Column(db.String(30), db.ForeignKey('User.user_id'), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)
コード例 #9
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class User_Stock(db.Model):
    __tablename__ = 'User_Stock'
    user_id = db.Column(db.String(30), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)
    amount = db.Column(db.Integer, nullable = False)
コード例 #10
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Stock(db.Model):
    __tablename__ = 'Stock'
    stock_id = db.Column(db.Integer, primary_key = True, nullable = False)
    name = db.Column(db.String(10), nullable = False)
    price = db.Column(db.Float, nullable = False)
    share = db.Column(db.Integer, nullable = False)
コード例 #11
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class User(db.Model):
    __tablename__ = 'User'
    user_id = db.Column(db.String(30), primary_key = True, nullable = False)
    balance = db.Column(db.Float, nullable = False)
    password = db.Column(db.String(15), nullable = False)
コード例 #12
0
ファイル: orm.py プロジェクト: nalinahuja22/peterpan 
class Group_Stock(db.Model):
    __tablename__ = 'Group_Stock'
    group_id = db.Column(db.Integer, db.ForeignKey('Group_Info.group_id'), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)
    amount = db.Column(db.Integer, nullable = False)

class Transaction(db.Model):
    __tablename__ = 'Transaction'
    transaction_id = db.Column(db.Integer, primary_key = True, nullable = False)
    amount = db.Column(db.Integer, nullable = False)
    date = db.Column(db.Integer, nullable = False)
    price = db.Column(db.Float, nullable = False)

class User_Transaction(db.Model):
    __tablename__ = 'User_Transaction'
    transaction_id = db.Column(db.Integer, db.ForeignKey('Transaction.transaction_id'), primary_key = True, nullable = False)
    type = db.Column(db.Boolean, nullable = False)
    user_id = db.Column(db.String(30), db.ForeignKey('User.user_id'), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)

class Group_Transaction(db.Model):
    __tablename__ = 'Group_Transaction'
    transaction_id = db.Column(db.Integer, db.ForeignKey('Transaction.transaction_id'), primary_key = True, nullable = False)
    type = db.Column(db.Boolean, nullable = False)
    group_id = db.Column(db.Integer, db.ForeignKey('Group_Info.group_id'), primary_key = True, nullable = False)
    stock_id = db.Column(db.Integer, db.ForeignKey('Stock.stock_id'), primary_key = True, nullable = False)

# Create All Databases
db.create_all()