class Tprofil(db.Model):
id = db.Column(db.Integer, primary_key=True)
sejarah = db.Column(db.Text, nullable=False)
profil_kel = db.Column(db.Text, nullable=False)
visi_misi = db.Column(db.Text, nullable=False)
def __repr__(self):
return f"Tprofil('{self.sejarah}', '{self.profil_kel}', '{self.visi_misi}')"
class Tadmin(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
nama = db.Column(db.String(100), nullable=False)
username = db.Column(db.String(100), nullable=False)
password = db.Column(db.String(100), nullable=False)
def __repr__(self):
return f"Tprofil('{self.nama}', '{self.username}', '{self.password}')"
class Tsurat_ket(db.Model):
id = db.Column(db.Integer, primary_key=True)
kategori = db.Column(db.String(50), nullable=False)
keterangan = db.Column(db.String(300), nullable=False)
tgl_post = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
penduduk_id = db.Column(db.Integer, db.ForeignKey('tpenduduk.id'))
def __repr__(self):
return f"Tsurat_ket('{self.kategori}', '{self.keterangan}', '{self.tgl_post}')"
class Data(db.Model):
id = db.Column(db.Integer, primary_key=True)
subjek = db.Column(db.String(100), nullable=False)
katagori = db.Column(db.String(50), nullable=False)
detail_pengaduan = db.Column(db.String(300), nullable=False)
def __init__(self, subjek, katagori, detail_pengaduan):
self.subjek = subjek
self.katagori = katagori
self.detail_pengaduan = detail_pengaduan
class Tmahasiswa(db.Model, UserMixin): #tambahkan
id = db.Column(db.Integer, primary_key=True)
npm = db.Column(db.String(15), unique=True, nullable=False)
nama = db.Column(db.String(100), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(80), nullable=False)
kelas = db.Column(db.String(20), nullable=False)
alamat = db.Column(db.String(100), nullable=False)
foto = db.Column(db.String(30), nullable=False, default='default.jpg')
pengaduans = db.relationship('Tpengaduan', backref='mahasiswa', lazy=True)
def __repr__(self):
return f"Tmahasiswa('{self.npm}','{self.nama}','{self.email}','{self.password}','{self.kelas}','{self.alamat}','{self.foto}')"
class Tpenduduk(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
nik = db.Column(db.String(25), nullable=False)
nama = db.Column(db.String(100), nullable=False)
tgl_lahir = db.Column(db.String(50), nullable=False)
email = db.Column(db.String(100), nullable=False)
password = db.Column(db.String(200), nullable=False)
alamat = db.Column(db.String(50), nullable=False)
tlp = db.Column(db.String(12), nullable=False)
surat = db.relationship('Tsurat_ket', backref='penduduk', lazy=True)
def __repr__(self):
return f"Tpenduduk('{self.nik}','{self.nama}','{self.tgl_lahir}','{self.email}','{self.password}','{self.alamat}', '{self.tlp}')"
class DataDemog(db.Model):
id = db.Column(db.Integer, primary_key=True)
rt = db.Column(db.String(3), nullable=False)
nama_rt = db.Column(db.String(100), nullable=False, default='Nama')
jumlah_kk = db.Column(db.String(5), nullable=False)
jumlah_p = db.Column(db.String(5), nullable=False)
jumlah_l = db.Column(db.String(5), nullable=False)
jumlah_jiwa = db.Column(db.String(5), nullable=False)
def __repr__(self):
return f"DataDomog('{self.rt}','{self.nama_rt}','{self.jumlah_kk}','{self.jumlah_p}','{self.jumlah_l}','{self.jumlah_jiwa}')"
class Tpengaduan(db.Model):
id = db.Column(db.Integer, primary_key=True)
subjek = db.Column(db.String(100), nullable=False)
katagori = db.Column(db.String(50), nullable=False)
detail_pengaduan = db.Column(db.String(300), nullable=False)
tgl_post = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
mahasiswa_id = db.Column(db.Integer, db.ForeignKey('tmahasiswa.id'))
def __repr__(self):
return f"Tpengaduan('{self.subjek}','{self.katagori}','{self.detail_pengaduan}','{self.tgl_post}')"
