from app import db

class pubivisaModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    teamname = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))
    phone1 = db.Column(db.String(32))
    email1 = db.Column(db.String(128))
    kilta1 = db.Column(db.String(16))

    etunimi2 = db.Column(db.String(64))
    sukunimi2 = db.Column(db.String(64))
    phone2 = db.Column(db.String(32))
    email2 = db.Column(db.String(128))
    kilta2 = db.Column(db.String(16))

    etunimi3 = db.Column(db.String(64))
    sukunimi3 = db.Column(db.String(64))
    phone3 = db.Column(db.String(32))
    email3 = db.Column(db.String(128))
    kilta3 = db.Column(db.String(16))
    
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

    personcount = db.Column(db.Integer())


class korttijalautapeliiltaModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    phone = db.Column(db.String(32))
    email = db.Column(db.String(128))
    
    kilta = db.Column(db.String(16))
    
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())


class fuksilauluiltaModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    email = db.Column(db.String(128))
    
    consent1 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())


class slumberpartyModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    phone = db.Column(db.String(32))
    email = db.Column(db.String(128))
    
    kilta = db.Column(db.String(16))
    
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())



class pakohuoneModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)

    aika = db.Column(db.String(16))
    huone1800 = db.Column(db.String(128))
    huone1930 = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))

    etunimi2 = db.Column(db.String(64))
    sukunimi2 = db.Column(db.String(64))

    etunimi3 = db.Column(db.String(64))
    sukunimi3 = db.Column(db.String(64))

    etunimi4 = db.Column(db.String(64))
    sukunimi4 = db.Column(db.String(64))

    etunimi5 = db.Column(db.String(64))
    sukunimi5 = db.Column(db.String(64))
    
    consent0 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())


class kysely_arvonta_juttuModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    email = db.Column(db.String(128))
    
    consent0 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())

class ots2021Model(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    email = db.Column(db.String(128))
    kilta =db.Column(db.String(64))
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())


# FOR ILMOS
class fuksisitsitModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)
    membercount = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    vapaavalinta0 = db.Column(db.String(256))


    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

# FOR ILMOS
class tupsufuksisitsitModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)
    membercount = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    vapaavalinta0 = db.Column(db.String(256))


    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())


class fuksibeerpongModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    joukkue = db.Column(db.String(64))
    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))


    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

class beerpongModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    joukkue = db.Column(db.String(64))
    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

class aitiModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    kilta0 = db.Column(db.String(16))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    consent1 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class hvsitsituusiModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    drink0 = db.Column(db.String(16))
    viina0 = db.Column(db.String(16))
    wine0 = db.Column(db.String(16))
    other0 = db.Column(db.String(64))
    consent1 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class syysuitotModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    lakki0 = db.Column(db.String(32))
    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())


class prositsitModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    food0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    drink0 = db.Column(db.String(16))
    drink1 = db.Column(db.String(16))
    drink2 = db.Column(db.String(16))
    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class simailutModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    email0 = db.Column(db.String(128))
    special0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    avec0 = db.Column(db.Boolean())
    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())


class kotiruokakurssi1Model(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    email0 = db.Column(db.String(128))
    phone0 = db.Column(db.String(16))
    food0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    free0 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class kotiruokakurssi2Model(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    email0 = db.Column(db.String(128))
    phone0 = db.Column(db.String(16))
    food0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    free0 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())
from app import db

class pubivisaModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    teamname = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))
    phone1 = db.Column(db.String(32))
    email1 = db.Column(db.String(128))
    kilta1 = db.Column(db.String(16))

    etunimi2 = db.Column(db.String(64))
    sukunimi2 = db.Column(db.String(64))
    phone2 = db.Column(db.String(32))
    email2 = db.Column(db.String(128))
    kilta2 = db.Column(db.String(16))

    etunimi3 = db.Column(db.String(64))
    sukunimi3 = db.Column(db.String(64))
    phone3 = db.Column(db.String(32))
    email3 = db.Column(db.String(128))
    kilta3 = db.Column(db.String(16))
    
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

    personcount = db.Column(db.Integer())


class korttijalautapeliiltaModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    phone = db.Column(db.String(32))
    email = db.Column(db.String(128))
    
    kilta = db.Column(db.String(16))
    
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())


class fuksilauluiltaModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    email = db.Column(db.String(128))
    
    consent1 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())


class slumberpartyModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    phone = db.Column(db.String(32))
    email = db.Column(db.String(128))
    
    kilta = db.Column(db.String(16))
    
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())



class pakohuoneModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)

    aika = db.Column(db.String(16))
    huone1800 = db.Column(db.String(128))
    huone1930 = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))

    etunimi2 = db.Column(db.String(64))
    sukunimi2 = db.Column(db.String(64))

    etunimi3 = db.Column(db.String(64))
    sukunimi3 = db.Column(db.String(64))

    etunimi4 = db.Column(db.String(64))
    sukunimi4 = db.Column(db.String(64))

    etunimi5 = db.Column(db.String(64))
    sukunimi5 = db.Column(db.String(64))
    
    consent0 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())


class kysely_arvonta_juttuModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    email = db.Column(db.String(128))
    
    consent0 = db.Column(db.Boolean())
    
    datetime = db.Column(db.DateTime())

class ots2021Model(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    etunimi = db.Column(db.String(64))
    sukunimi = db.Column(db.String(64))
    email = db.Column(db.String(128))
    kilta =db.Column(db.String(64))
    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())


# FOR ILMOS
class fuksisitsitModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)
    membercount = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    vapaavalinta0 = db.Column(db.String(256))


    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

# FOR ILMOS
class tupsufuksisitsitModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)
    membercount = db.Column(db.String(128))

    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    vapaavalinta0 = db.Column(db.String(256))


    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())


class fuksibeerpongModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    joukkue = db.Column(db.String(64))
    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))


    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

class beerpongModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    joukkue = db.Column(db.String(64))
    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))

    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())
    consent1 = db.Column(db.Boolean())
    consent2 = db.Column(db.Boolean())

    datetime = db.Column(db.DateTime())

class aitiModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    kilta0 = db.Column(db.String(16))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    consent1 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class hvsitsituusiModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    drink0 = db.Column(db.String(16))
    viina0 = db.Column(db.String(16))
    wine0 = db.Column(db.String(16))
    other0 = db.Column(db.String(64))
    consent1 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class syysuitotModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    lakki0 = db.Column(db.String(32))
    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())


class prositsitModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    phone0 = db.Column(db.String(32))
    email0 = db.Column(db.String(128))
    kilta0 = db.Column(db.String(16))
    food0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    drink0 = db.Column(db.String(16))
    drink1 = db.Column(db.String(16))
    drink2 = db.Column(db.String(16))
    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class simailutModel(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    email0 = db.Column(db.String(128))
    special0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    avec0 = db.Column(db.Boolean())
    etunimi1 = db.Column(db.String(64))
    sukunimi1 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())


class kotiruokakurssi1Model(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    email0 = db.Column(db.String(128))
    phone0 = db.Column(db.String(16))
    food0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    free0 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())

class kotiruokakurssi2Model(db.Model):
    '''
    Created 25.3.2021
    '''
    id = db.Column(db.Integer, primary_key=True)

    
    etunimi0 = db.Column(db.String(64))
    sukunimi0 = db.Column(db.String(64))
    email0 = db.Column(db.String(128))
    phone0 = db.Column(db.String(16))
    food0 = db.Column(db.String(16))
    allergies0 = db.Column(db.String(16))
    free0 = db.Column(db.String(64))

    consent0 = db.Column(db.Boolean())


    datetime = db.Column(db.DateTime())
# FOR ILMOS Created 25.3.2021 # FOR ILMOS Created 25.3.2021 Created 25.3.2021 Created 25.3.2021 Created 25.3.2021 Created 25.3.2021 Created 25.3.2021 Created 25.3.2021 Created 25.3.2021 Created 25.3.2021 Created 25.3.2021