class PenguinIgloo(db.Model): __tablename__ = 'penguin_igloo' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) igloo_id = db.Column(db.ForeignKey('igloo.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class PenguinLocation(db.Model): __tablename__ = 'penguin_location' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) location_id = db.Column(db.ForeignKey('location.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class PenguinFlooring(db.Model): __tablename__ = 'penguin_flooring' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) flooring_id = db.Column(db.ForeignKey('flooring.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class QuestAwardItem(db.Model): __tablename__ = 'quest_award_item' quest_id = db.Column(db.ForeignKey('quest.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) item_id = db.Column(db.ForeignKey('item.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class PenguinPostcard(db.Model): __tablename__ = 'penguin_postcard' id = db.Column(db.Integer, primary_key=True, server_default=db.text( "nextval('\"penguin_postcard_id_seq\"'::regclass)")) penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False, index=True) sender_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), index=True) postcard_id = db.Column(db.ForeignKey('postcard.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False) send_date = db.Column(db.DateTime, nullable=False, server_default=db.text("now()")) details = db.Column(db.String(255), nullable=False, server_default=db.text("''::character varying")) has_read = db.Column(db.Boolean, nullable=False, server_default=db.text("false"))
class QuestAwardPuffleItem(db.Model): __tablename__ = 'quest_award_puffle_item' quest_id = db.Column(db.ForeignKey('quest.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) puffle_item_id = db.Column(db.ForeignKey('puffle_item.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) quantity = db.Column(db.SmallInteger, nullable=False, server_default=db.text("1"))
class QuestAwardFurniture(db.Model): __tablename__ = 'quest_award_furniture' quest_id = db.Column(db.ForeignKey('quest.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) furniture_id = db.Column(db.ForeignKey('furniture.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) quantity = db.Column(db.SmallInteger, nullable=False, server_default=db.text("1"))
class QuestTask(db.Model): __tablename__ = 'quest_task' id = db.Column(db.Integer, primary_key=True, server_default=db.text("nextval('\"quest_id_seq\"'::regclass)")) quest_id = db.Column(db.ForeignKey('quest.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False) description = db.Column(db.String(50), nullable=False) room_id = db.Column(db.ForeignKey('room.id', ondelete='CASCADE', onupdate='CASCADE')) data = db.Column(db.String(50))
class PenguinQuestTask(db.Model): __tablename__ = 'penguin_quest_task' task_id = db.Column(db.ForeignKey('quest_task.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False, primary_key=True) penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False, primary_key=True) complete = db.Column(db.Boolean, nullable=False, server_default=db.text("false"))
class IglooLike(db.Model): __tablename__ = 'igloo_like' igloo_id = db.Column(db.ForeignKey('penguin_igloo_room.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) player_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) count = db.Column(db.SmallInteger, nullable=False, server_default=db.text("1")) date = db.Column(db.DateTime, nullable=False, server_default=db.text("now()"))
class PenguinGameData(db.Model): __tablename__ = 'penguin_game_data' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='RESTRICT', onupdate='CASCADE'), primary_key=True, nullable=False) room_id = db.Column(db.ForeignKey('room.id', ondelete='RESTRICT', onupdate='CASCADE'), primary_key=True, nullable=False, index=True) index = db.Column(db.Integer, primary_key=True, index=True) data = db.Column(db.Text, nullable=False, server_default=db.text("''"))
class Character(db.Model): __tablename__ = 'character' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), nullable=False) gift_id = db.Column( db.ForeignKey('item.id', ondelete='CASCADE', onupdate='CASCADE')) stamp_id = db.Column( db.ForeignKey('stamp.id', ondelete='CASCADE', onupdate='CASCADE'))
class IglooFurniture(db.Model): __tablename__ = 'igloo_furniture' igloo_id = db.Column(db.ForeignKey('penguin_igloo_room.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False, index=True) furniture_id = db.Column(db.ForeignKey('furniture.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) x = db.Column(db.SmallInteger, primary_key=True, nullable=False, server_default=db.text("0")) y = db.Column(db.SmallInteger, primary_key=True, nullable=False, server_default=db.text("0")) frame = db.Column(db.SmallInteger, primary_key=True, nullable=False, server_default=db.text("0")) rotation = db.Column(db.SmallInteger, primary_key=True, nullable=False, server_default=db.text("0"))
class PenguinPermission(db.Model): __tablename__ = 'penguin_permission' penguin_id = db.Column(db.ForeignKey(u'penguin.id', ondelete=u'CASCADE', onupdate=u'CASCADE'), primary_key=True) permission_name = db.Column(db.ForeignKey(u'permission.name', ondelete=u'CASCADE', onupdate=u'CASCADE'), nullable=False, primary_key=True)
class RedemptionAwardFurniture(db.Model): __tablename__ = 'redemption_award_furniture' code_id = db.Column(db.ForeignKey('redemption_code.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) furniture_id = db.Column(db.ForeignKey('furniture.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class RedemptionAwardIgloo(db.Model): __tablename__ = 'redemption_award_igloo' code_id = db.Column(db.ForeignKey('redemption_code.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) igloo_id = db.Column(db.ForeignKey('igloo.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class RedemptionAwardLocation(db.Model): __tablename__ = 'redemption_award_location' code_id = db.Column(db.ForeignKey('redemption_code.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) location_id = db.Column(db.ForeignKey('location.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class BuddyRequest(db.Model): __tablename__ = 'buddy_request' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) requester_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class RedemptionAwardFlooring(db.Model): __tablename__ = 'redemption_award_flooring' code_id = db.Column(db.ForeignKey('redemption_code.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) flooring_id = db.Column(db.ForeignKey('flooring.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class RedemptionAwardPuffleItem(db.Model): __tablename__ = 'redemption_award_puffle_item' code_id = db.Column(db.ForeignKey('redemption_code.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) puffle_item_id = db.Column(db.ForeignKey('puffle_item.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class PuffleTreasurePuffleItem(db.Model): __tablename__ = 'puffle_treasure_puffle_item' puffle_id = db.Column(db.ForeignKey('puffle.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) puffle_item_id = db.Column(db.ForeignKey('puffle_item.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class PuffleTreasureFurniture(db.Model): __tablename__ = 'puffle_treasure_furniture' puffle_id = db.Column(db.ForeignKey('puffle.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) furniture_id = db.Column(db.ForeignKey('furniture.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False)
class IgnoreList(db.Model): __tablename__ = 'ignore_list' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) ignore_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False, index=True)
class PenguinRedemptionBook(db.Model): __tablename__ = 'penguin_redemption_book' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) book_id = db.Column(db.ForeignKey('redemption_book.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False, index=True)
class CharacterBuddy(db.Model): __tablename__ = 'character_buddy' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) character_id = db.Column(db.ForeignKey('character.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) best_buddy = db.Column(db.Boolean, nullable=False, server_default=db.text("false"))
class PenguinTrack(db.Model): __tablename__ = 'penguin_track' id = db.Column(db.Integer, primary_key=True, server_default=db.text( "nextval('\"penguin_track_id_seq\"'::regclass)")) name = db.Column(db.String(12), nullable=False, server_default=db.text("''::character varying")) owner_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False) sharing = db.Column(db.Boolean, nullable=False, server_default=db.text("false")) pattern = db.Column(db.Text, nullable=False) def __init__(self, **kwargs): super().__init__(**kwargs) self._likes = 0 @property def likes(self): return self._likes @likes.setter def likes(self, like_count): self._likes = like_count
class RedemptionBookWord(db.Model): __tablename__ = 'redemption_book_word' question_id = db.Column( db.Integer, primary_key=True, server_default=db.text( "nextval('\"redemption_book_word_question_id_seq\"'::regclass)")) book_id = db.Column(db.ForeignKey('redemption_book.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) page = db.Column(db.SmallInteger, primary_key=True, nullable=False, server_default=db.text("1")) line = db.Column(db.SmallInteger, primary_key=True, nullable=False, server_default=db.text("1")) word_number = db.Column(db.SmallInteger, primary_key=True, nullable=False, server_default=db.text("1")) answer = db.Column(db.String(20), nullable=False)
class PenguinPuffleItem(db.Model): __tablename__ = 'penguin_puffle_item' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) item_id = db.Column(db.ForeignKey('puffle_item.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) quantity = db.Column(db.SmallInteger, nullable=False, server_default=db.text("1"))
class PenguinStamp(db.Model): __tablename__ = 'penguin_stamp' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) stamp_id = db.Column(db.ForeignKey('stamp.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) recent = db.Column(db.Boolean, nullable=False, server_default=db.text("true"))
class BuddyList(db.Model): __tablename__ = 'buddy_list' penguin_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False) buddy_id = db.Column(db.ForeignKey('penguin.id', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False, index=True) best_buddy = db.Column(db.Boolean, nullable=False, server_default=db.text("false"))