class AdminDesa(db.Model): id = db.Column(db.Integer, primary_key=True) alamat = db.Column(db.Text, nullable=True) no_hp = db.Column(db.String(30), nullable=True) email = db.Column(db.String(100), nullable=True) def __repr__(self): return f"AdminDesa('{self.alamat}','{self.no_hp}','{self.email}')"
class InfoDesa(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) konten = db.Column(db.Text, nullable=False) ttd = db.Column(db.String(100), nullable=True) def __repr__(self): return f"SejarahDesa('{self.title}','{self.konten}','{self.ttd}')"
class Kades(db.Model): id = db.Column(db.Integer, primary_key=True) nama = db.Column(db.String(100), nullable=False) masa_jabatan = db.Column(db.Text, nullable=False) no_hp = db.Column(db.String(30), nullable=True) def __repr__(self): return f"Kades('{self.nama}','{self.masa_jabatan}','{self.no_hp}')"
class AnggaranDesa(db.Model): id = db.Column(db.Integer, primary_key=True) tahun = db.Column(db.String(30), nullable=True) add = db.Column(db.String(30), nullable=True) dd = db.Column(db.String(30), nullable=True) def __repr__(self): return f"Penduduk('{self.tahun}','{self.add}','{self.dd}')"
class PengurusBumdes(db.Model): id = db.Column(db.Integer, primary_key=True) nama_pengurus = db.Column(db.String(100), nullable=True) masa_jabatan_pengurus = db.Column(db.Text, nullable=True) no_hp_pengurus = db.Column(db.String(30), nullable=True) def __repr__(self): return f"PengurusBumdes('{self.nama_pengurus}','{self.masa_jabatan_pengurus}','{self.no_hp_pengurus}')"
class AdminBumdes(db.Model): id = db.Column(db.Integer, primary_key=True) nama_bumdes = db.Column(db.String(100), nullable=True) alamat_bumdes = db.Column(db.Text, nullable=True) no_hp_bumdes = db.Column(db.String(30), nullable=True) email_bumdes = db.Column(db.String(100), nullable=True) def __repr__(self): return f"AdminBumdes('{self.nama}','{self.alamat}','{self.no_hp}','{self.email}')"
class Penduduk(db.Model): id = db.Column(db.Integer, primary_key=True) jumlah_l = db.Column(db.String(30), nullable=True) jumlah_p = db.Column(db.String(30), nullable=True) total = db.Column(db.String(30), nullable=True) kk = db.Column(db.String(30), nullable=True) tahun = db.Column(db.String(10), nullable=True) def __repr__(self): return f"Penduduk('{self.jumlah_l}','{self.jumlah_p}','{self.total}','{self.kk}','{self.tahun}')"
class User(db.Model, UserMixin ): id= db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='penulis', lazy=True) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}', '{self.password}')"
class Dosen(db.Model): id = db.Column(db.Integer, primary_key=True) nama = db.Column(db.String(30), nullable=False) nidn = db.Column(db.Integer, nullable=False) no_telpon = db.Column(db.Integer, nullable=False) alamat = db.Column(db.String(100), nullable=False) dosens = db.relationship('Jadwal', backref='Dosen', lazy=True) def __repr__(self): return f"Dosen('{self.nama}', '{self.nidn}')"
class Gambar2(db.Model): id = db.Column(db.Integer, primary_key=True) foto_organisasi = db.Column(db.String(20), nullable=False, default='default.jpg') def __repr__(self): return f"Gambar('{self.foto_organisasi}')"
class Umum(db.Model): id = db.Column(db.Integer, primary_key=True) luas_desa = db.Column(db.String(30), nullable=True) jumlah_dusun = db.Column(db.String(30), nullable=True) utara = db.Column(db.String(300), nullable=True) selatan = db.Column(db.String(300), nullable=True) barat = db.Column(db.String(300), nullable=True) timur = db.Column(db.String(300), nullable=True) jarak_dari_kec = db.Column(db.String(30), nullable=True) jarak_dari_kab = db.Column(db.String(30), nullable=True) jarak_dari_prov = db.Column(db.String(30), nullable=True) def __repr__(self): return f"Umum('{self.luas_desa}','{self.jumlah_dusun}','{self.utara}','{self.selatan}','{self.barat}','{self.timur}','{self.jarak_dari_kec}','{self.jarak_dari_kab}','{self.jarak_dari_prov}')"
class Post(db.Model): id= db.Column(db.Integer, primary_key=True) title =db.Column(db.String(100), nullable=False) tgl_post = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) konten = db.Column(db.Text, nullable=False) user_id = db.Column (db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.tgl_post}','{self.konten}')"
class Matakuliah(db.Model): id = db.Column(db.Integer, primary_key=True) matakuliah = db.Column(db.String(20), nullable=False) sks = db.Column(db.Integer, nullable=False) keterangan = db.Column(db.Text, nullable=False) mk = db.relationship('Jadwal', backref='Matakuliah', lazy=True) def __repr__(self): return f"Matakuliah('{self.matakuliah}', '{self.sks}')"
class KeuanganBumdes(db.Model): id = db.Column(db.Integer, primary_key=True) penyertaan_modal = db.Column(db.String(100), nullable=True) penambahan_modal = db.Column(db.String(100), nullable=True)
class UnitUsaha(db.Model): id = db.Column(db.Integer, primary_key=True) nama_unit_usaha = db.Column(db.String(100), nullable=True) def __repr__(self): return f"AdminBumdes('{self.nama}')"
class Admin(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20),nullable=False) password = db.Column(db.String(60), nullable=False)