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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Transaction(db.Model): __tablename__ = 'transaction' id = db.Column(db.Integer, primary_key=True, autoincrement=True) cart_id = db.Column(db.Integer, db.ForeignKey('cart.id'), nullable=False) 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.String(10), nullable=False) price = db.Column(db.Integer, nullable=False) response_fields = { 'id': fields.Integer, 'cart_id': fields.Integer, 'user_id': fields.Integer, 'item_id': fields.Integer, 'date': fields.String, 'duration': fields.Integer, 'qty': fields.Integer, 'status': fields.String, 'price': fields.Integer } def __init__(self, cart_id, user_id, item_id, date, duration, qty, status, price): self.cart_id = cart_id 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 '<Transaction %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))