class CategoryMovies(db.Model): category_id = db.Column( db.Integer, db.ForeignKey("categories.category_id"), primary_key=True, nullable=False, ) movie_id = db.Column( db.Integer, db.ForeignKey("movies.movie_id"), primary_key=True, nullable=False, )
class ParadeMiis(db.Model): # We need to be able to select by both the Mii's ID and the logo. mii_id = db.Column(db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True) logo_id = db.Column(db.String(5), primary_key=True) logo_bin = db.Column(db.LargeBinary(8000)) news = db.Column(db.String) level = db.Column(db.Integer, default=1)
class ConciergeMiis(db.Model): mii_id = db.Column( db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True, unique=True ) clothes = db.Column(db.Integer, nullable=False) action = db.Column(db.Integer, nullable=False) prof = db.Column(db.String(129), nullable=False) movie_id = db.Column(db.Integer, nullable=False) voice = db.Column(db.Boolean, default=False, nullable=False)
class MiiMsgInfo(db.Model): # We make both the Mii's ID and message type unique, as to allow row # identification for SQLAlchemy. mii_id = db.Column( db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True, nullable=False ) type = db.Column(db.Integer, primary_key=True, nullable=False) seq = db.Column(db.Integer, primary_key=True, nullable=False) msg = db.Column(db.String, nullable=False) face = db.Column(db.Integer, nullable=False)
class Rooms(db.Model): room_id = db.Column( db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True, nullable=False ) bgm = db.Column(db.Enum(RoomBGMTypes)) mascot = db.Column(db.Boolean) contact = db.Column(db.Boolean) intro_msg = db.Column(db.String) mii_msg = db.Column(db.String) # TODO: implement room type specific logic logo2_id = db.Column(db.String)
class ConciergeMiis(db.Model): mii_id = db.Column(db.Integer, db.ForeignKey("mii_data.mii_id"), primary_key=True, unique=True) clothes = db.Column(db.Integer, nullable=False) action = db.Column(db.Integer, nullable=False) prof = db.Column(db.String(129), nullable=False) movie_id = db.Column(db.Integer, nullable=False) update_date = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)