class Makanan(db.Model):
__tablename__ = "ListMakanan"
id = db.Column(db.Integer, primary_key=True, autoincrement=True, unique=True, nullable=False)
berat_badan = db.Column(db.Integer)
tinggi_badan = db.Column(db.Integer)
angka_imt = db.Column(db.Integer)
kategori_imt = db.Column(db.String(255))
response_field = {
'id' = fields.Integer,
'berat_badan' = fields.Integer,
'tinggi_badan' = fields.Integer,
'angka_imt' = fields.Integer,
'kategori_imt' = fields.String
}
def __init__(self, id, berat_badan, tinggi_badan, angka_imt, kategori_imt):
self.id = id
self.berat_badan = berat_badan
self.tinggi_badan = tinggi_badan
self.angka_imt = angka_imt
self.kategori_imt = kategori_imt
def __repr__(self):
return '<Makanan %r>' % self.id
class Company(db.Model, EntityMixin):
__tablename__ = 'company'
id = db.Column(db.Integer, primary_key=True)
company_token = db.Column(db.String(255))
name = db.Column(db.String(255))
positions = db.relationship('Position', lazy='dynamic')
applicants = db.relationship('Application', lazy='dynamic')
users = db.relationship('User', lazy='dynamic')
def __init__(self, company_token, name):
self.company_token = company_token
self.name = name
class Cart(db.Model):
__tablename__ = 'cart'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
item_id = db.Column(db.Integer, db.ForeignKey('item.id'), nullable=False)
date = db.Column(db.Date, nullable=False)
duration = db.Column(db.Integer, nullable=False)
qty = db.Column(db.Integer, nullable=False)
status = db.Column(db.Boolean, nullable=False)
price = db.Column(db.Integer, nullable=False)
response_fields = {
'id': fields.Integer,
'user_id': fields.Integer,
'item_id': fields.Integer,
'date': fields.String,
'duration': fields.Integer,
'qty': fields.Integer,
'status': fields.Boolean,
'price': fields.Integer
}
def __init__(self, user_id, item_id, date, duration, qty, status, price):
self.user_id = user_id
self.item_id = item_id
self.date = date
self.duration = duration
self.qty = qty
self.status = status
self.price = price
def __repr__(self):
return '<cart %r>' % self.id
class Community(db.Model, EntityMixin):
__tablename__ = 'community'
id = db.Column(db.Integer, primary_key=True)
company_id = db.Column(
db.Integer,
db.ForeignKey('company.id',
name='community_ibfk_1',
ondelete="CASCADE"))
name = db.Column(db.String(255))
def __init__(self, name, company_id):
self.name = name
self.company_id = company_id
def serialize(self):
return {"id": self.id, "name": self.name}
class ApplicationEvent(db.Model, EntityMixin):
__tablename__ = 'application_event'
id = db.Column(db.Integer, primary_key=True)
applicant_id = db.Column(db.Integer, db.ForeignKey('application.id'))
application = db.relationship('Application')
application_event_token = db.Column(db.String(255))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
user = db.relationship('User')
status = db.Column(db.Integer)
step = db.Column(db.String(255))
time = db.Column(db.DateTime, default=datetime.datetime.utcnow)
note = db.Column(db.String(255))
duration = db.Column(db.Integer, nullable=True)
class Shop(db.Model):
__tablename__ = 'shop'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
name = db.Column(db.String(100), nullable=False)
address = db.Column(db.String(100), nullable=False)
city = db.Column(db.String(30), nullable=False)
province = db.Column(db.String(30), nullable=False)
telephone = db.Column(db.String(15), nullable=False)
photo = db.Column(db.Text, nullable=True)
status = db.Column(db.Boolean, nullable=False)
response_fields = {
'id': fields.Integer,
'user_id': fields.Integer,
'name': fields.String,
'address': fields.String,
'city': fields.String,
'province': fields.String,
'telephone': fields.String,
'photo': fields.String,
'status': fields.Boolean,
}
transaction_response_fields = {
'id': fields.Integer,
'name': fields.String,
'address': fields.String,
'city': fields.String,
'province': fields.String,
'telephone': fields.String,
}
name_response_fields = {
'id': fields.Integer,
'name': fields.String,
}
def __init__(self, user_id, name, address, city, province, telephone,
photo, status):
self.user_id = user_id
self.name = name
self.address = address
self.city = city
self.province = province
self.telephone = telephone
self.photo = photo
self.status = status
def __repr__(self):
return '<Shop %r>' % self.id
class Item(db.Model):
__tablename__ = 'item'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
shop_id = db.Column(db.Integer, db.ForeignKey('shop.id'), nullable=False)
name = db.Column(db.String(100), nullable=False)
qty = db.Column(db.Integer, nullable=False)
price = db.Column(db.Integer, nullable=False)
status = db.Column(db.String(10), nullable=False)
category = db.Column(db.String(30), nullable=False)
description = db.Column(db.Text, nullable=True)
detail = db.Column(db.Text, nullable=True)
photo = db.Column(db.Text, nullable=True)
response_fields = {
'id': fields.Integer,
'shop_id': fields.Integer,
'name': fields.String,
'qty': fields.Integer,
'price': fields.Integer,
'status': fields.String,
'category': fields.String,
'description': fields.String,
'detail': fields.String,
'photo': fields.String,
}
name_response_fields = {
'id': fields.Integer,
'name': fields.String,
}
def __init__(self, shop_id, name, qty, price, status, category,
description, detail, photo):
self.shop_id = shop_id
self.name = name
self.qty = qty
self.price = price
self.status = status
self.category = category
self.description = description
self.detail = detail
self.photo = photo
def __repr__(self):
return '<Item %r>' % self.id
class EventGuest(db.Model):
__tablename__ = 'eventguest'
id = db.Column(db.Integer, primary_key=True, autoincrement=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)
response_fields={
'id': fields.Integer,
'user_id': fields.Integer,
'event_id': fields.Integer,
}
def __init__(self, user_id, event_id):
self.user_id = user_id
self.event_id = event_id
def __repr__(self):
return str(self.id) + str(self.user_id) + str(self.event_id)
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
nama = db.Column(db.String(100))
status = db.Column(db.String(10), default='non-internal', nullable=False)
response_fields = {
'id': fields.Integer,
'nama': fields.String,
'status': fields.String,
}
def __init__(self, nama, status):
self.nama = nama
self.status = status
def __repr__(self):
return str(self.id) + self.nama
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(100), nullable=False)
username = db.Column(db.String(15), unique=True, nullable=False)
password = db.Column(db.String(15), nullable=False)
status = db.Column(db.Boolean, nullable=False)
response_fields = {
'id': fields.Integer,
'name': fields.String,
'username': fields.String,
'password': fields.String,
'status': fields.Boolean,
}
transaction_response_fields = {
'id': fields.Integer,
'name': fields.String,
'username': fields.String,
}
def __init__(self, name, username, password, status):
self.name = name
self.username = username
self.password = password
self.status = status
def __repr__(self):
return '<User %r>' % self.id
@classmethod
def is_exists(cls, data):
all_data = cls.query.all()
existing_username = [item.username for item in all_data]
if data in existing_username:
return True
return False
class PositionRights(db.Model, EntityMixin):
__tablename__ = 'position_rights'
id = db.Column(db.Integer, primary_key=True)
position_id = db.Column(
db.Integer,
db.ForeignKey('position.id', name='position_right_position_fk'))
position = relationship("Position",
backref=backref("rights",
cascade="all, delete-orphan",
viewonly=True))
user_id = db.Column(
db.Integer, db.ForeignKey('user.id', name='position_right_user_fk1'))
user = relationship("User",
backref=backref("jobs_has_rights_to",
cascade="all, delete-orphan",
viewonly=True))
role = db.Column(db.String(64))
json_data, data = json_property('json_data',
db.Column(MEDIUMTEXT),
default={})
class TalentCommunities(db.Model, EntityMixin):
__tablename__ = 'talent_communities'
talent_id = db.Column(db.Integer,
db.ForeignKey('talent.id',
name="talent_communities_talent_fk",
ondelete="CASCADE"),
primary_key=True)
community_id = db.Column(db.Integer,
db.ForeignKey(
'community.id',
name="talent_communities_community_fk",
ondelete="CASCADE"),
primary_key=True)
talent = db.relationship("Talent")
community = db.relationship("Community")
def __init__(self, talent_id, community_id):
self.talent_id = talent_id
self.community_id = community_id
class ListKontakKami(db.Model):
__tablename__ = "ListKontakKami"
id = db.Column(db.Integer,
primary_key=True,
autoincrement=True,
unique=True,
nullable=False)
nama = db.Column(db.String(255), nullable=True)
email = db.Column(db.String(255), nullable=True)
nomor_telpon = db.Column(db.String(255), nullable=True)
pesan = db.Column(db.Text, nullable=True)
created_at = db.Column(db.String(255))
response_field = {
'id': fields.Integer,
'nama': fields.String,
'email': fields.String,
'nomor_telpon': fields.String,
'pesan': fields.String,
'created_at': fields.String
}
def __init__(self, id, nama, email, nomor_telpon, pesan, created_at):
self.id = id
self.nama = nama
self.email = email
self.nomor_telpon = nomor_telpon
self.pesan = pesan
self.created_at = created_at
def __repr__(self):
return '<KontakKami %r>' % self.id
class ListUser(db.Model):
__tablename__ = "ListUser"
id = db.Column(db.Integer,
primary_key=True,
autoincrement=True,
unique=True,
nullable=False)
name = db.Column(db.String(255), nullable=False)
email = db.Column(db.String(255), nullable=False)
phone_number = db.Column(db.String(255), nullable=False)
username = db.Column(db.String(255), unique=True, nullable=False)
password = db.Column(db.String(255), nullable=False)
mode = db.Column(db.String(10), nullable=False)
created_at = db.Column(db.String(255))
updated_at = db.Column(db.String(255))
response_field = {
'id': fields.Integer,
'name': fields.String,
'email': fields.String,
'phone_number': fields.String,
'username': fields.String,
'password': fields.String,
'mode': fields.String,
'created_at': fields.String,
'updated_at': fields.String
}
def __init__(self, id, name, email, phone_number, username, password, mode,
created_at, updated_at):
self.id = id
self.name = name
self.email = email
self.phone_number = phone_number
self.username = username
self.password = password
self.mode = mode
self.created_at = created_at
self.updated_at = updated_at
def __repr__(self):
return '<User %r>' % self.id
class Model(db.Model):
__abstract__ = True
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
def save(self):
session = db.session()
session.add(self)
session.commit()
def delete(self):
session = db.session()
session.delete(self)
session.commit()
class Course(Model):
c_name = db.Column(db.String(32))
description = db.Column(db.Text)
picture = db.Column(db.String(32))
show_number = db.Column(db.Integer)
c_time_number = db.Column(db.Integer)
state = db.Column(db.Integer, default=1) # 课程状态 0 即将上线, 1 上线,默认上线
c_type = db.Column(db.Integer, default=0) # 课程类型 0 免费, 1 限时免费, 2 VIP会员
def __repr__(self):
return self.c_name
class ListClient(db.Model):
__tablename__ = "ListClient"
id = db.Column(db.Integer, primary_key=True, autoincrement=True, unique=True, nullable=False)
client_key = db.Column(db.String(255))
client_secret = db.Column(db.String(255))
mode = db.Column(db.String(10))
response_field = {
'id' : fields.Integer,
'client_key' : fields.String,
'client_secret' : fields.String,
'mode' : fields.String
}
def __init__(self, id, client_key, client_secret, mode):
print(client_key)
self.id = id
self.client_key = client_key
self.client_secret = client_secret
self.mode = mode
def __repr__(self):
return '<Client %r>' % self.id
class Event(db.Model):
__tablename__ = 'event'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
nama = db.Column(db.String(30), nullable=False)
ip = db.Column(db.String(20), nullable=False)
waktu = db.Column(db.String(30), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
response_fields = {
'id': fields.Integer,
'nama': fields.String,
'ip': fields.String,
'waktu': fields.String,
'user_id': fields.Integer
}
def __init__(self, nama, ip, waktu, user_id):
self.nama = nama
self.ip = ip
self.waktu = waktu
self.user_id = user_id
def __repr__(self):
return '<Event %r>' % self.id
class Talent(db.Model, EntityMixin):
__tablename__ = 'talent'
id = db.Column(db.Integer, primary_key=True)
company_id = db.Column(
db.Integer, db.ForeignKey('company.id', name='company_talent_fk'))
talent_token = db.Column(db.String(255), nullable=False)
company = db.relationship('Company')
talent_community = db.Column(db.Boolean, default=False, server_default='0')
confirmed_talent_community = db.Column(db.Boolean,
default=False,
server_default='0')
applications = db.relationship('Application', cascade="all, delete-orphan")
talent_communities = db.relationship('TalentCommunities',
cascade="all, delete-orphan")
communities = association_proxy('talent_communities', 'community')
time_confirmed_membership = db.Column(db.DateTime)
time_added_to_talent_community = db.Column(db.DateTime, default=None)
language = db.Column(db.Integer)
image = db.Column(db.String(255))
class ApplicationFeedback(db.Model, EntityMixin):
__tablename__ = 'application_feedback'
id = db.Column(db.Integer, primary_key=True)
application_feedback_token = db.Column(db.String(255))
application_id = db.Column(db.Integer,
db.ForeignKey('application.id'),
nullable=False)
application = db.relationship('Application')
rating = db.Column(db.Integer)
rating_time = db.Column(db.DateTime())
rating_message = db.Column(db.Text)
class BusinessUnit(db.Model, EntityMixin):
__tablename__ = 'business_unit'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
business_unit_token = db.Column(db.String(255))
parent_id = db.Column(
db.Integer,
db.ForeignKey('business_unit.id', name='business_unit_parent_fk'))
parent = relationship('BusinessUnit', remote_side=[id])
company_id = db.Column(db.Integer,
db.ForeignKey('company.id',
name='business_unit_ibfk_1'),
nullable=False)
company = db.relationship('Company')
json_data = db.Column(db.Text)
class ListForum(db.Model):
__tablename__ = "ListForum"
id = db.Column(db.Integer,
primary_key=True,
autoincrement=True,
unique=True,
nullable=False)
user_id = db.Column(db.Integer, nullable=False)
posted_by = db.Column(db.String(255))
judul_post = db.Column(db.String(255))
isi_post = db.Column(db.Text, nullable=True)
created_at = db.Column(db.String(255))
updated_at = db.Column(db.String(255))
response_field = {
'id': fields.Integer,
'user_id': fields.Integer,
'posted_by': fields.String,
'judul_post': fields.String,
'isi_post': fields.String,
'created_at': fields.String,
'updated_at': fields.String
}
def __init__(self, id, user_id, posted_by, judul_post, isi_post,
created_at, updated_at):
self.id = id
self.user_id = user_id
self.posted_by = posted_by
self.judul_post = judul_post
self.isi_post = isi_post
self.created_at = created_at
self.updated_at = updated_at
def __repr__(self):
return '<Forum %r>' % self.id
class Configuration(db.Model):
__tablename__ = "configuration"
id = db.Column(db.Integer, primary_key=True)
last_fetch_date = db.Column(db.DateTime())
class User(db.Model, EntityMixin):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(255), default="")
last_name = db.Column(db.String(255), default="")
title = db.Column(db.String(255), default="")
user_token = db.Column(db.String(255))
company_id = db.Column(db.Integer, db.ForeignKey('company.id', name='company_userfk_1'))
company = db.relationship('Company')
photoname = db.Column(db.String(255))
language = db.Column(db.Integer)
confirmed_at = db.Column(db.DateTime())
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
login_count = db.Column(db.Integer)
roles = db.Column(db.Text)
password = db.Column(db.String(255))
email = db.Column(db.String(255))
class Position(db.Model, EntityMixin):
__tablename__ = 'position'
id = db.Column(db.Integer, primary_key=True)
position_token = db.Column(db.String(255))
name = db.Column(db.String(255))
internal_name = db.Column(db.String(255))
language = db.Column(db.Integer)
company_id = db.Column(db.Integer,
db.ForeignKey('company.id', name='position_ibfk_1'))
company = db.relationship('Company')
user_id = db.Column(db.Integer,
db.ForeignKey('user.id', name="position_user_fk"))
user = db.relationship('User')
expiration_date = db.Column(db.DateTime)
description = db.Column(db.Text)
template_id = db.Column(db.String(255))
link = db.Column(db.String(2047))
starting_date = db.Column(db.DateTime)
employment_type = db.Column(db.String(255))
reason_for_vacancy = db.Column(db.String(255))
business_unit_id = db.Column(
db.Integer,
db.ForeignKey('business_unit.id', name="job_business_unit_fk"))
business_unit = db.relationship('BusinessUnit',
backref=backref('jobs', lazy='dynamic'))
status = db.Column(db.Integer, default=INACTIVE)
approval_time = db.Column(db.DateTime)
active_applications = db.relationship(
"Application",
primaryjoin='and_(Application.position_id==Position.id)',
viewonly=True)
class ListMobil(db.Model):
__tablename__ = "ListMobil"
id = db.Column(db.Integer, primary_key=True, autoincrement=True, unique=True, nullable=False)
client_id = db.Column(db.Integer, nullable=False)
created_at = db.Column(db.String(255))
updated_at = db.Column(db.String(255))
merk_mobil = db.Column(db.String(255), nullable=False)
model_mobil = db.Column(db.String(255), nullable=False)
transmisi = db.Column(db.String(255), nullable=False)
jarak_tempuh = db.Column(db.Integer, nullable=False)
tahun = db.Column(db.Integer, nullable=False)
tipe_bahan_bakar = db.Column(db.String(255), nullable=False)
warna_mobil = db.Column(db.String(255), nullable=False)
harga = db.Column(db.Integer, nullable=False)
judul_lapak = db.Column(db.Text, nullable=True)
deskripsi_lapak = db.Column(db.Text, nullable=True)
# gambar =
response_field = {
'id' : fields.Integer,
'client_id' : fields.Integer,
'created_at' : fields.String,
'updated_at' : fields.String,
'merk_mobil' : fields.String,
'model_mobil' : fields.String,
'transmisi' : fields.String,
'jarak_tempuh' : fields.Integer,
'tahun' : fields.Integer,
'tipe_bahan_bakar' : fields.String,
'warna_mobil' : fields.String,
'harga' : fields.Integer,
'judul_lapak' : fields.String,
'deskripsi_lapak' : fields.String
}
def __init__(self, id, client_id, created_at, updated_at, merk_mobil, model_mobil, transmisi, jarak_tempuh, tahun, tipe_bahan_bakar, warna_mobil, harga, judul_lapak, deskripsi_lapak):
self.id = id
self.client_id = client_id
self.created_at = created_at
self.updated_at = updated_at
self.merk_mobil = merk_mobil
self.model_mobil = model_mobil
self.transmisi = transmisi
self.jarak_tempuh = jarak_tempuh
self.tahun = tahun
self.tipe_bahan_bakar = tipe_bahan_bakar
self.warna_mobil = warna_mobil
self.harga = harga
self.judul_lapak = judul_lapak
self.deskripsi_lapak = deskripsi_lapak
def __repr__(self):
return '<Mobil %r>' % self.id
class User(Model):
u_name = db.Column(db.String(32))
u_email = db.Column(db.Text)
u_password = db.Column(db.String(32))
class PositionViewCounter(db.Model, EntityMixin):
__tablename__ = 'ad_view_counters'
id = db.Column(db.Integer, primary_key=True)
position_id = db.Column(db.Integer)
time = db.Column(db.DateTime)
class Application(db.Model, EntityMixin):
__tablename__ = 'application'
id = db.Column(db.Integer, primary_key=True)
application_token = db.Column(db.String(255))
position_id = db.Column(
db.Integer, db.ForeignKey('position.id',
name='application_position_fk'))
position = db.relationship('Position')
company_id = db.Column(
db.Integer, db.ForeignKey('company.id', name='application_company_fk'))
company = db.relationship('Company')
talent_id = db.Column(
db.Integer, db.ForeignKey('talent.id', name='application_talent_fk'))
talent = db.relationship('Talent')
status = db.Column(db.Integer, default=0)
step = db.Column(db.String(255))
language = db.Column(db.Integer)
application_date = db.Column(db.DateTime)
outcome_status = db.Column(db.Integer)
outcome_email_status = db.Column(db.String(255))
want_feedback = db.Column(db.Boolean, default=True, server_default='1')
average_rating = db.Column(db.Float, default=None)
feedback_score = db.Column(db.Float, default=None)
feedback_rating = db.Column(db.Float, default=None)
recommendation_similarity = db.Column(db.Float, default=None)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
