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 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}')"
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}')"