class GIModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
ULTG = db.Column(db.String(100))
STATUS_OPERASI = db.Column(db.String(100))
ID_FUNCTLOC = db.Column(db.String(100))
NM_LOKASI = db.Column(db.String(100))
NM_LOKASI_URL = db.Column(db.String(100))
TEGANGAN = db.Column(db.Integer)
TGL_OPRS = db.Column(db.String(100))
ALAMAT = db.Column(db.TEXT)
LATITUDE = db.Column(db.Float(100))
LONGITUDE = db.Column(db.Float(100))
class ExchangeRate(db.Model):
__tablename__ = 'exchange_rates'
id = db.Column(db.Integer, primary_key=True)
currency_id = db.Column(db.Integer,
db.ForeignKey('exchange_currencies.id'),
nullable=False)
date = db.Column(db.Date)
rate = db.Column(db.Float(asdecimal=True))
def __init__(self, date, rate):
self.date = date
self.rate = rate
def __repr__(self):
return '%d %d %s %f' % (self.id, self.currency_id, self.date,
self.rate)
class PMTModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
NMTRAGI = db.Column(db.String(100))
NAMAGI = db.Column(db.String(100))
NAMABAY = db.Column(db.String(100))
STATUS_ALAT = db.Column(db.String(100))
TECHIDENTNO = db.Column(db.String(100))
EQ_NUMBER = db.Column(db.String(100))
EQUIPMENT_NUMBER = db.Column(db.String(100))
SERIAL_ID = db.Column(db.String(100))
ID_BAY = db.Column(db.String(100))
ID_FUNCTLOC = db.Column(db.String(100))
KODE_PST = db.Column(db.Integer)
KD_STATUS = db.Column(db.Integer)
TEG_OPRS = db.Column(db.Integer)
PHASA = db.Column(db.String(100))
TGL_OPRS = db.Column(db.String(100))
THN_BUAT = db.Column(db.Integer)
BUATAN = db.Column(db.String(100))
PENEMPATAN = db.Column(db.String(100))
KETERANGAN = db.Column(db.String(100))
FLAG = db.Column(db.Float(100))
MERK = db.Column(db.String(100))
TIPE = db.Column(db.String(100))
ASSET = db.Column(db.String(100))
CONS_TYPE = db.Column(db.Float(100))
DESCRIPTION = db.Column(db.String(100))
RATING_ARUS = db.Column(db.Float(100))
BREAKING_CURRENT = db.Column(db.Float(100))
MKNK_PGRK = db.Column(db.String(100))
MEDIA_PMDM = db.Column(db.String(100))
JENIS = db.Column(db.String(100))
RATING_TEG = db.Column(db.Float(100))
MAKING_CURRENT = db.Column(db.Float(100))
BIL = db.Column(db.Float(100))
SIL = db.Column(db.Float(100))
PFW = db.Column(db.Float(100))
WKT_BUKA = db.Column(db.Float(100))
WKT_TUTUP = db.Column(db.Float(100))
WKT_BREAK = db.Column(db.Float(100))
DUR_HUB_SING = db.Column(db.Float(100))
SEKUENSIAL = db.Column(db.String(100))
TEKANAN = db.Column(db.Float(100))
THN_KTK = db.Column(db.Float(100))
THN_ISO = db.Column(db.Float(100))
BERAT = db.Column(db.Float(100))
STANDARD = db.Column(db.String(100))
PASANGAN = db.Column(db.String(100))
TOLERANSI = db.Column(db.Float(100))
HOUSING = db.Column(db.String(100))
JML_TRIP_COIL = db.Column(db.Float(100))
TYPE_ID = db.Column(db.Float(100))
ID_KOMPARTEMEN = db.Column(db.Float(100))
EQ_NUMBER_REF = db.Column(db.String(100))
CCODE = db.Column(db.Integer)
class LAModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
NMTRAGI = db.Column(db.String(100))
NAMAGI = db.Column(db.String(100))
NAMABAY = db.Column(db.String(100))
STATUS_ALAT = db.Column(db.String(100))
TECHIDENTNO = db.Column(db.String(100))
EQ_NUMBER = db.Column(db.String(100))
EQUIPMENT_NUMBER = db.Column(db.Float(100))
SERIAL_ID = db.Column(db.String(100))
ID_BAY = db.Column(db.String(100))
ID_FUNCTLOC = db.Column(db.String(100))
KODE_PST = db.Column(db.Integer)
KD_STATUS = db.Column(db.Integer)
TEG_OPRS = db.Column(db.Integer)
PHASA = db.Column(db.String(100))
MERK = db.Column(db.String(100))
TIPE = db.Column(db.String(100))
BUATAN = db.Column(db.String(100))
THN_BUAT = db.Column(db.Integer)
TGL_OPRS = db.Column(db.String(100))
PENEMPATAN = db.Column(db.String(100))
KETERANGAN = db.Column(db.String(100))
FLAG = db.Column(db.Integer)
ID_KOMPARTEMEN = db.Column(db.Float(100))
ASSET = db.Column(db.String(100))
CONS_TYPE = db.Column(db.String(100))
ARUS_NOM_DISCH = db.Column(db.Float(100))
GAP_TYPE = db.Column(db.String(100))
CLASS_DISCH = db.Column(db.Float(100))
MCOV = db.Column(db.Float(100))
JENIS = db.Column(db.String(100))
MTRL_OKSIDA = db.Column(db.String(100))
TEG_NOM = db.Column(db.Float(100))
TEG_RATING = db.Column(db.Float(100))
ARUS_DISCH_MAX = db.Column(db.Float(100))
BIL = db.Column(db.Float(100))
RESIDUAL_5KA = db.Column(db.Float(100))
RESIDUAL_10KA = db.Column(db.Float(100))
RESIDUAL_20KA = db.Column(db.Float(100))
TINGGI = db.Column(db.Float(100))
BERAT = db.Column(db.Float(100))
STANDART = db.Column(db.String(100))
PASANGAN = db.Column(db.String(100))
STACK = db.Column(db.Float(100))
TYPE_ID = db.Column(db.String(100))
CCODE = db.Column(db.Integer)
class BayModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
# id_gi_detail = db.Column(db.Integer, db.ForeignKey('gimodel.id'))
ULTG = db.Column(db.String(100))
GI = db.Column(db.String(100))
BAY = db.Column(db.String(100))
FUNGSI = db.Column(db.String(100))
ID_FUNCTLOC = db.Column(db.String(100))
SUP_FUNCTLOC = db.Column(db.String(100))
NM_LOKASI = db.Column(db.String(100))
DESKRIPSI = db.Column(db.String(100))
ID_LOCATION = db.Column(db.Float(100))
ID_PARENT = db.Column(db.String(100))
TEGANGAN = db.Column(db.Float(100))
KD_FUNGSI = db.Column(db.String(100))
KD_WILAYAH = db.Column(db.Float(100))
TGL_OPRS = db.Column(db.String(100))
TGL_TDK_OPRS = db.Column(db.String(100))
FLAG = db.Column(db.Float(100))
WORKCENTER = db.Column(db.String(100))
ID_PLANT = db.Column(db.Float(100))
ID_TRAGI = db.Column(db.Float(100))
NOMORGI = db.Column(db.Float(100))
KD_GROUPLOKASI = db.Column(db.Float(100))
ID_SECTION = db.Column(db.String(100))
BOUND = db.Column(db.String(100))
BA_CODE = db.Column(db.Float(100))
ASSET_LOKASI = db.Column(db.Float(100))
BAYGROUP = db.Column(db.Float(100))
MVA = db.Column(db.Float(100))
NOSIRKIT = db.Column(db.Float(100))
COSTCENTER = db.Column(db.Float(100))
BC_FLC = db.Column(db.String(100))
class PTModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
NMTRAGI = db.Column(db.String(100))
NAMAGI = db.Column(db.String(100))
NAMABAY = db.Column(db.String(100))
STATUS_ALAT = db.Column(db.String(100))
SERIAL_ID = db.Column(db.String(100))
TYPE_ID = db.Column(db.String(100))
ID_BAY = db.Column(db.String(100))
KODE_PST = db.Column(db.Integer)
KD_STATUS = db.Column(db.Integer)
TEG_OPRS = db.Column(db.Float(100))
PHASA = db.Column(db.String(100))
BUATAN = db.Column(db.String(100))
THN_BUAT = db.Column(db.Integer)
TGL_OPRS = db.Column(db.String(100))
KETERANGAN = db.Column(db.String(100))
ID_KOMPARTEMEN = db.Column(db.String(100))
FLAG = db.Column(db.Float(100))
MERK = db.Column(db.String(100))
TIPE = db.Column(db.String(100))
JENIS = db.Column(db.String(100))
TEG_MAKS = db.Column(db.String(100))
TEG_PRIM = db.Column(db.String(100))
TEG_SEC = db.Column(db.String(100))
JML_CORE = db.Column(db.Float(100))
CLASS_CORE_1 = db.Column(db.String(100))
CLASS_CORE_2 = db.Column(db.String(100))
CLASS_CORE_3 = db.Column(db.String(100))
BURDEN_CORE_1 = db.Column(db.Float(100))
BURDEN_CORE_2 = db.Column(db.Float(100))
BURDEN_CORE_3 = db.Column(db.Float(100))
C1 = db.Column(db.Float(100))
C2 = db.Column(db.Float(100))
C3 = db.Column(db.Float(100))
BIL = db.Column(db.Float(100))
SIL = db.Column(db.Float(100))
PFW = db.Column(db.Float(100))
RVF_CONT = db.Column(db.Float(100))
RVF_30S = db.Column(db.Float(100))
ISOLASI = db.Column(db.String(100))
CREEP_DIST = db.Column(db.Float(100))
HOUSING = db.Column(db.String(100))
TOLERANSI = db.Column(db.String(100))
TAN_DELTA = db.Column(db.Float(100))
BERAT_TOTAL = db.Column(db.Float(100))
STANDARD = db.Column(db.String(100))
PASANGAN = db.Column(db.String(100))
RATED_FREQ = db.Column(db.Float(100))
PENEMPATAN = db.Column(db.String(100))
WAVE_TRAP = db.Column(db.String(100))
CONS_TYPE = db.Column(db.Float(100))
# TECHIDENTNO=db.Column(db.String(100))
ASSET = db.Column(db.String(100))
EQ_NUMBER = db.Column(db.String(100))
EQUIPMENT_NUMBER = db.Column(db.Float(100))
ID_FUNCTLOC = db.Column(db.String(100))
THERM_BURDEN = db.Column(db.Float(100))
CCODE = db.Column(db.String(100))
class CTModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
NMTRAGI = db.Column(db.String(100))
NAMAGI = db.Column(db.String(100))
NAMABAY = db.Column(db.String(100))
STATUS_ALAT = db.Column(db.String(100))
# TECHIDENTNO=db.Column(db.)
EQ_NUMBER = db.Column(db.String(100))
EQUIPMENT_NUMBER = db.Column(db.Float(100))
SERIAL_ID = db.Column(db.String(100))
ID_BAY = db.Column(db.String(100))
ID_FUNCTLOC = db.Column(db.String(100))
KODE_PST = db.Column(db.Integer)
KD_STATUS = db.Column(db.Integer)
TEG_OPRS = db.Column(db.Integer)
MERK = db.Column(db.String(100))
TIPE = db.Column(db.String(100))
PHASA = db.Column(db.String(100))
BUATAN = db.Column(db.String(100))
THN_BUAT = db.Column(db.Integer)
TGL_OPRS = db.Column(db.String(100))
PENEMPATAN = db.Column(db.String(100))
KETERANGAN = db.Column(db.String(100))
ASSET = db.Column(db.String(100))
CONS_TYPE = db.Column(db.String(100))
FLAG = db.Column(db.Float(100))
ID_KOMPARTEMEN = db.Column(db.Float(100))
JENIS = db.Column(db.String(100))
TEG_MAKS = db.Column(db.String(100))
ISOLASI = db.Column(db.String(100))
ISC_1S = db.Column(db.Float(100))
ISC_3S = db.Column(db.Float(100))
BIL = db.Column(db.Float(100))
SIL = db.Column(db.Float(100))
PFW = db.Column(db.Float(100))
TAP_CT = db.Column(db.String(100))
I_RATED_PRI = db.Column(db.String(100))
I_RATED_SEC = db.Column(db.String(100))
RATING_ARUS = db.Column(db.String(100))
I_THERM_CONT = db.Column(db.Float(100))
I_DYN = db.Column(db.Float(100))
BURDEN = db.Column(db.String(100))
CLASS = db.Column(db.String(100))
FUNGSI = db.Column(db.String(100))
HOUSING = db.Column(db.String(100))
CREEP_DIST = db.Column(db.Float(100))
HEAD_HOUSING = db.Column(db.String(100))
BASE_HOUSING = db.Column(db.String(100))
BERAT_TOT = db.Column(db.Float(100))
STANDARD = db.Column(db.String(100))
JML_CORE = db.Column(db.Float(100))
RATIO_CORE_1 = db.Column(db.String(100))
CLASS_CORE_1 = db.Column(db.String(100))
BURDEN_CORE_1 = db.Column(db.String(100))
RATIO_CORE_2 = db.Column(db.String(100))
CLASS_CORE_2 = db.Column(db.String(100))
BURDEN_CORE_2 = db.Column(db.String(100))
RATIO_CORE_3 = db.Column(db.String(100))
CLASS_CORE_3 = db.Column(db.String(100))
BURDEN_CORE_3 = db.Column(db.String(100))
RATIO_CORE_4 = db.Column(db.String(100))
CLASS_CORE_4 = db.Column(db.String(100))
BURDEN_CORE_4 = db.Column(db.String(100))
RATIO_CORE_5 = db.Column(db.String(100))
CLASS_CORE_5 = db.Column(db.String(100))
BURDEN_CORE_5 = db.Column(db.String(100))
RATIO_CORE_6 = db.Column(db.String(100))
CLASS_CORE_6 = db.Column(db.String(100))
BURDEN_CORE_6 = db.Column(db.String(100))
PASANGAN = db.Column(db.String(100))
TYPE_ID = db.Column(db.Float(100))
CCODE = db.Column(db.Integer)
class PMSModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
NMTRAGI = db.Column(db.String(100))
NAMAGI = db.Column(db.String(100))
NAMABAY = db.Column(db.String(100))
STATUS_ALAT = db.Column(db.String(100))
# TECHIDENTNO=db.Column(db.String(100))
EQ_NUMBER = db.Column(db.String(100))
SERIAL_ID = db.Column(db.String(100))
ID_BAY = db.Column(db.String(100))
KODE_PST = db.Column(db.Integer)
KD_STATUS = db.Column(db.Integer)
TEG_OPRS = db.Column(db.Integer)
MERK = db.Column(db.String(100))
TIPE = db.Column(db.String(100))
PHASA = db.Column(db.String(100))
BUATAN = db.Column(db.String(100))
THN_BUAT = db.Column(db.Integer)
TGL_OPRS = db.Column(db.String(100))
PENEMPATAN = db.Column(db.String(100))
KETERANGAN = db.Column(db.String(100))
FLAG = db.Column(db.Float(100))
ID_KOMPARTEMEN = db.Column(db.Float(100))
KELENGKAPAN = db.Column(db.String(100))
ASSET = db.Column(db.String(100))
CONS_TYPE = db.Column(db.Float(100))
JENIS = db.Column(db.String(100))
TEG_NOM = db.Column(db.Float(100))
ARUS_NOM = db.Column(db.Float(100))
MKNK_PGRK = db.Column(db.String(100))
SHORT_TIME_SCC = db.Column(db.Float(100))
PEAK_SCC = db.Column(db.Float(100))
BIL = db.Column(db.Float(100))
SIL = db.Column(db.Float(100))
PFW = db.Column(db.Float(100))
BERAT = db.Column(db.Float(100))
STANDART = db.Column(db.String(100))
PASANGAN = db.Column(db.String(100))
WKT_BUKA = db.Column(db.Float(100))
WKT_TUTUP = db.Column(db.Float(100))
THN_KTK = db.Column(db.Float(100))
ARUS_HS_PEAK = db.Column(db.Float(100))
CREEP_DIST_SUPPORT = db.Column(db.Float(100))
DUR_HUB_SING = db.Column(db.Float(100))
TEG_AC_MOTOR = db.Column(db.Float(100))
TEG_DC_MOTOR = db.Column(db.Float(100))
MATERIAL_INSULATOR = db.Column(db.String(100))
TYPE_ID = db.Column(db.String(100))
EQUIPMENT_NUMBER = db.Column(db.Float(100))
ID_FUNCTLOC = db.Column(db.String(100))
CCODE = db.Column(db.Integer)