class ParticipantSignupOption(Base):
__tablename__ = 'participant_signup_option'
id = Column(Integer, primary_key=True)
name = Column(String(255))
#metadata_fields
metadata_created = Column(DateTime(), nullable=False, default=datetime.now)
metadata_creator = Column(Integer(), default=getCurrentUserId)
metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now)
metadata_modifier = Column(Integer(), onupdate=getCurrentUserId)
metadata_revision = Column(Integer(), default=1, onupdate=expression_column('metadata_revision')+1)
assoc_participantwishes_participantsignupoption = Table("assoc_participantwishes_participantsignupoption", Base.metadata, foreign_key_column("participantwishes_id", Integer, "participant_wishes.id"), foreign_key_column("participantsignupoption_id", Integer, "participant_signup_option.id"))
class ParticipantMedical(Base):
__tablename__ = 'participant_medicals'
id = Column(Integer, primary_key=True)
participant_id = Column(Integer, ForeignKey('participants.id'), nullable=False, index=True)
#diet = Column(Text) # Erityisruokavaliot
diets = relationship("ParticipantMedicalDiet", secondary="assoc_participantmedical_medicaldiets")
#food_allergy = Column(Text) # Ruoka-aineallergiat
food_allergies = relationship("ParticipantMedicalFoodAllergy", secondary="assoc_participantmedical_medicalfoodallergies")
additional_food = Column(Text) # Lisatiedot, ruoka
drugs_help = Column(Integer, nullable=False, default=0) # Apua laakityksen ottamiseen
illnesses = Column(Text) # Sairaudet
#allergies = Column(Text) # Allergiat
allergies = relationship("ParticipantMedicalAllergy", secondary="assoc_participantmedical_medicalallergies")
additional_health = Column(Text) # Terveydentilan lisatiedot
__tablename__ = 'village_kitchens'
id = Column(Integer, primary_key=True, index=True)
name = Column(String(255), unique=True, index=True)
short_name = Column(String(255), index=True)
subcamp_id = Column(String(255), index=True)
villages = relationship("Village", secondary="assoc_villagekitchens_villages")
leader_id = Column(Integer, index=True)
#metadata_fields
metadata_created = Column(DateTime(), nullable=False, default=datetime.now)
metadata_creator = Column(Integer(), default=getCurrentUserId)
metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now)
metadata_modifier = Column(Integer(), onupdate=getCurrentUserId)
metadata_revision = Column(Integer(), default=1, onupdate=expression_column('metadata_revision')+1)
assoc_villagekitchens_villages = Table("assoc_villagekitchens_villages", Base.metadata, foreign_key_column("village_kitchens_id", Integer, "village_kitchens.id"), foreign_key_column("villages_id", Integer, "villages.id"))
class Subcamp(Base):
__tablename__ = 'subcamps'
id = Column(Integer, primary_key=True, index=True)
name = Column(String(255), unique=True, index=True)
short_name = Column(String(255), index=True)
leader_id = Column(Integer, index=True)
#metadata_fields
metadata_created = Column(DateTime(), nullable=False, default=datetime.now)
metadata_creator = Column(Integer(), default=getCurrentUserId)
metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now)
metadata_modifier = Column(Integer(), onupdate=getCurrentUserId)
metadata_revision = Column(Integer(), default=1, onupdate=expression_column('metadata_revision')+1)
self.name = name
def set_leader_id(self, leader_id):
self.leader_id = leader_id
class Privilege(Base):
__tablename__ = "privileges"
id = Column(Integer, primary_key=True)
name = Column(String(255), unique=True, nullable=False)
def __init__(self, name):
self.name = name
# metadata_fields
metadata_created = Column(DateTime(), nullable=False, default=datetime.now)
metadata_creator = Column(Integer(), default=getCurrentUserId)
metadata_modified = Column(DateTime(), default=datetime.now, onupdate=datetime.now)
metadata_modifier = Column(Integer(), onupdate=getCurrentUserId)
metadata_revision = Column(Integer(), default=1, onupdate=expression_column("metadata_revision") + 1)
assoc_users_groups = Table(
"assoc_users_groups",
Base.metadata,
foreign_key_column("user_id", Integer, "users.id"),
foreign_key_column("group_id", Integer, "groups.id"),
)
# assoc_users_privileges = Table("assoc_users_privileges", Base.metadata, foreign_key_column("user_id", Integer, "users.id"), foreign_key_column("privilege_id", Integer, "privileges.id"))
# assoc_groups_privileges = Table("assoc_groups_privileges", Base.metadata, foreign_key_column("group_id", Integer, "groups.id"), foreign_key_column("privilege_id", Integer, "privileges.id"))
