30 lines
1.1 KiB
Python
30 lines
1.1 KiB
Python
from flask_sqlalchemy import SQLAlchemy
|
|
|
|
db = SQLAlchemy()
|
|
|
|
class AimeCard(db.Model):
|
|
__tablename__ = 'aime_card'
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
access_code = db.Column(db.String(50), unique=True)
|
|
user = db.Column(db.String(50))
|
|
|
|
class Mai2ProfileDetail(db.Model):
|
|
__tablename__ = 'mai2_profile_detail'
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
user = db.Column(db.Integer, nullable=False)
|
|
userName = db.Column(db.String, nullable=False)
|
|
playerRating = db.Column(db.Integer, nullable=False)
|
|
playCount = db.Column(db.Integer, nullable=False)
|
|
lastRomVersion = db.Column(db.String, nullable=True)
|
|
lastDataVersion = db.Column(db.String, nullable=True)
|
|
banstate = db.Column(db.Integer, nullable=False)
|
|
|
|
class Mai2ItemCard(db.Model):
|
|
__tablename__ = 'mai2_item_card'
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
cardId = db.Column(db.String, nullable=False)
|
|
cardTypeId = db.Column(db.Integer, nullable=False)
|
|
startDate = db.Column(db.String, nullable=False)
|
|
endDate = db.Column(db.String, nullable=False)
|
|
user = db.Column(db.Integer, nullable=False)
|