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"))
