class EventAttendUser(db.Model):
__tablename__ = 'event_attend_user'
__table_args__ = (db.UniqueConstraint(
'user_id', 'event_id', name='event_attend_uix_user_id_event_id'), {})
id = db.Column(db.Integer,
db.Sequence('event_attend_user_id_seq'),
primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
event_id = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
attend_date = db.Column(db.ARRAY(db.DateTime), nullable=True)
expect_papers = db.Column(db.Boolean, nullable=True, default=False)
attend_social_gathering = db.Column(db.Boolean,
nullable=True,
default=False)
payment_status = db.Column(db.TEXT, nullable=True)
cancel = db.Column(db.Boolean, nullable=True, default=False)
created_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST))
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST),
onupdate=datetime.now(JST))
event = db.relationship('Event', backref='event_attend_user')
def __init__(self, user_id, event_id, attend_date, expect_papers,
attend_social_gathering, payment_status):
self.user_id = user_id
self.event_id = event_id
self.attend_date = attend_date
self.expect_papers = expect_papers
self.attend_social_gathering = attend_social_gathering
self.payment_status = payment_status
class Event(db.Model):
__tablename__ = 'event'
id = db.Column(db.Integer, db.Sequence('event_id_seq'), primary_key=True)
name = db.Column(db.TEXT, nullable=False)
english_name = db.Column(db.TEXT, nullable=True)
url = db.Column(db.TEXT, nullable=True)
event_form_id = db.Column(db.Integer,
db.ForeignKey('event_form.id'),
nullable=True)
has_papers = db.Column(db.Boolean, nullable=True)
has_social_gathering = db.Column(db.Boolean, nullable=True)
date = db.Column(db.ARRAY(db.DateTime), nullable=True)
attend_period = db.Column(db.DateTime, nullable=True)
presenting_papers_period = db.Column(db.DateTime, nullable=True)
created_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST))
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST),
onupdate=datetime.now(JST))
event_form = db.relationship('EventForm', backref='event')
event_fee = db.relationship('EventFee', backref='event')
class EventForm(db.Model):
__tablename__ = 'event_form'
id = db.Column(db.Integer,
db.Sequence('event_form_id_seq'),
primary_key=True)
name = db.Column(db.TEXT, nullable=False)
label = db.Column(db.TEXT, nullable=False)
class AddressType(db.Model):
__tablename__ = 'address_type'
id = db.Column(db.Integer,
db.Sequence('address_type_id_seq'),
primary_key=True)
name = db.Column(db.TEXT, nullable=False)
label = db.Column(db.TEXT, nullable=False)
class Society(db.Model):
__tablename__ = 'society'
id = db.Column(db.Integer, db.Sequence('society_id_seq'), primary_key=True)
name = db.Column(db.TEXT, nullable=False)
english_name = db.Column(db.TEXT, nullable=True)
abbreviation = db.Column(db.TEXT, nullable=True)
url = db.Column(db.TEXT, nullable=True)
created_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST))
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST),
onupdate=datetime.now(JST))
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, db.Sequence('user_id_seq'), primary_key=True)
name = db.Column(db.TEXT, nullable=True)
email = db.Column(db.TEXT, nullable=False)
password = db.Column(db.TEXT, nullable=False)
member_id = db.Column(db.TEXT, nullable=True)
member_type_id = db.Column(db.Integer,
db.ForeignKey('member_type.id'),
nullable=True)
member_validate = db.Column(db.Boolean, nullable=False, default=False)
salt = db.Column(db.TEXT, nullable=False)
role = db.Column(db.Integer, db.ForeignKey('role.id'), nullable=False)
state = db.Column(db.Integer, db.ForeignKey('state.id'), nullable=False)
token = db.Column(db.TEXT, nullable=True)
token_period = db.Column(db.DateTime, nullable=True)
created_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST))
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now(JST),
onupdate=datetime.now(JST))
user_profile = db.relation('UserProfile',
uselist=False,
backref='user',
cascade='all, delete-orphan')
member_type = db.relation('MemberType', backref='user_profile')
def __init__(self, name, email, password, member_id, member_type_id,
member_validate, salt, role, state, token, token_period):
self.name = name
self.email = email
self.password = password
self.member_id = member_id
self.member_type_id = member_type_id
self.member_validate = member_validate
self.salt = salt
self.role = role
self.state = state
self.token = token
self.token_period = token_period
class EventFee(db.Model):
__tablename__ = 'event_fee'
__table_args__ = (db.UniqueConstraint(
'event_id',
'member_type_id',
name='event_fee_uix_event_id_member_type_id'), {})
id = db.Column(db.Integer,
db.Sequence('event_fee_id_seq'),
primary_key=True)
event_id = db.Column(db.Integer, db.ForeignKey('event.id'), nullable=False)
member_type_id = db.Column(db.Integer,
db.ForeignKey('member_type.id'),
nullable=False)
participation = db.Column(db.Integer, nullable=False, default=0)
papers = db.Column(db.Integer, nullable=False, default=0)
social_gathering = db.Column(db.Integer, nullable=False, default=0)
corporate_exhibition = db.Column(db.Integer, nullable=False, default=0)
web_advertising_banner = db.Column(db.Integer, nullable=False, default=0)
web_advertising_small = db.Column(db.Integer, nullable=False, default=0)
web_advertising_medium = db.Column(db.Integer, nullable=False, default=0)
web_advertising_large = db.Column(db.Integer, nullable=False, default=0)
class State(db.Model):
__tablename__ = 'state'
id = db.Column(db.Integer, db.Sequence('state_id_seq'), primary_key=True)
name = db.Column(db.TEXT, nullable=False)