vithariumz's picture
Deploy: Initial Backend Release v1.0
52f5a2a
Raw History Blame Contribute Delete
4.59 kB
from sqlalchemy import Column, Integer, String, Float, DateTime, ForeignKey, Text, Boolean
from sqlalchemy.dialects.postgresql import JSON
from sqlalchemy.sql import func
from app.core.database import Base
class Ujianfonem(Base):
__tablename__ = 'ujianfonem'
idujian = Column(Integer, primary_key=True, autoincrement=True)
idmateriujian = Column(Integer, ForeignKey('materiujian.idmateriujian'))
idtalent = Column(Integer, ForeignKey('talent.idtalent'))
kategori = Column(String(255))
nilai = Column(Float)
waktuujian = Column(DateTime)
updated_at = Column(DateTime, server_default=func.now(), onupdate=func.now())
class Detailujianfonem(Base):
__tablename__ = 'detailujianfonem'
iddetail = Column(Integer, primary_key=True, autoincrement=True)
idujian = Column(Integer, ForeignKey('ujianfonem.idujian'))
idsoal = Column(Integer, ForeignKey('materiujiankalimat.idmateriujiankalimat'))
nilai = Column(Float)
updated_at = Column(DateTime, server_default=func.now(), onupdate=func.now())
class Materiujian(Base):
__tablename__ = 'materiujian'
idmateriujian = Column(Integer, primary_key=True, autoincrement=True)
kategori = Column(String(255))
updated_at = Column(DateTime, server_default=func.now(), onupdate=func.now())
class Materiujiankalimat(Base):
__tablename__ = 'materiujiankalimat'
idmateriujiankalimat = Column(Integer, primary_key=True, autoincrement=True)
idmateriujian = Column(Integer, ForeignKey('materiujian.idmateriujian'))
kalimat = Column(String(255))
fonem = Column(String(255))
updated_at = Column(DateTime, server_default=func.now(), onupdate=func.now())
class Hasillatihanfonem(Base):
__tablename__ = 'hasillatihanfonem'
idhasilfonem = Column(Integer, primary_key=True, autoincrement=True)
typelatihan = Column(String(255))
idtalent = Column(Integer, ForeignKey('talent.idtalent'))
idsoal = Column(Integer)
nilai = Column(Float)
waktulatihan = Column(DateTime)
phoneme_comparison = Column(JSON)
class Hasillatihanpercakapan(Base):
__tablename__ = 'hasillatihanpercakapan'
idhasilpercakapan = Column(Integer, primary_key=True, autoincrement=True)
idtalent = Column(Integer, ForeignKey('talent.idtalent'))
idmateripercakapan = Column(Integer, ForeignKey('materipercakapan.idmateripercakapan'))
wpm = Column(Float)
grammar = Column(String(255))
waktulatihan = Column(DateTime)
class Hasillatihaninterview(Base):
__tablename__ = 'hasillatihaninterview'
idhasilinterview = Column(Integer, primary_key=True, autoincrement=True)
idtalent = Column(Integer, ForeignKey('talent.idtalent'))
waktulatihan = Column(DateTime)
feedback = Column(Text)
wpm = Column(Float)
grammar = Column(String(255))
class Manajemen(Base):
__tablename__ = 'manajemen'
idmanajemen = Column(Integer, primary_key=True)
namamanajemen = Column(String(255))
email = Column(String(255))
password = Column(String(255))
class Materifonemkalimat(Base):
__tablename__ = 'materifonemkalimat'
idmaterifonemkalimat = Column(Integer, primary_key=True, autoincrement=True)
kategori = Column(String(255))
kalimat = Column(String(255))
fonem = Column(String(255))
updated_at = Column(DateTime, server_default=func.now(), onupdate=func.now())
class Materifonemkata(Base):
__tablename__ = 'materifonemkata'
idmaterifonemkata = Column(Integer, primary_key=True, autoincrement=True)
kategori = Column(String(255))
kata = Column(String(255))
fonem = Column(String(255))
meaning = Column(String(255))
definition = Column(String(255))
updated_at = Column(DateTime, server_default=func.now(), onupdate=func.now())
class Materipercakapan(Base):
__tablename__ = 'materipercakapan'
idmateripercakapan = Column(Integer, primary_key=True, autoincrement=True)
topic = Column(String(255))
class Materiinterview(Base):
__tablename__ = 'materiinterview'
idmateriinterview = Column(Integer, primary_key=True, autoincrement=True)
question = Column(String(255))
updated_at = Column(DateTime, server_default=func.now(), onupdate=func.now())
is_active = Column(Boolean, nullable=False, server_default='true')
class Talent(Base):
__tablename__ = 'talent'
idtalent = Column(Integer, primary_key=True, autoincrement=True)
nama = Column(String(255))
email = Column(String(255), unique=True)
password = Column(String(255))
pretest_score = Column(Float)
role = Column(String(50), default='talent')