Database Backup Management Property Area



Total records in the table= 17
ceb1
Field Type Key Default Extra
ceb1id int(11) NO PRI
conname varchar(255) NO
accono varchar(15) NO
area varchar(255) NO
csc varchar(100) NO
address varchar(255) NO
repno varchar(100) NO
testdate date NO
gprs varchar(100) NO
tariff varchar(255) NO
demand varchar(20) NO


Total records in the table= 17
ceb2
Field Type Key Default Extra
ceb2id int(10) NO PRI
make varchar(50) NO
serial varchar(255) NO
constant varchar(50) NO
mf varchar(100) NO
class varchar(10) NO
mfdate year(4) NO
totaltc varchar(255) NO
mdcurrent varchar(20) NO
mdhistory varchar(20) NO
l1 varchar(20) NO
l2 varchar(20) NO
l3 varchar(20) NO
cl1 varchar(20) NO
cl2 varchar(20) NO
cl3 varchar(20) NO
pf varchar(20) NO
punit varchar(5) NO
vunit varchar(5) NO
aunit varchar(5) NO
cunit varchar(5) NO


Total records in the table= 17
ceb3
Field Type Key Default Extra
ceb3id int(10) NO PRI
make_old varchar(50) NO
serial_old varchar(255) NO
constant_old varchar(50) NO
mf_old varchar(100) NO
class_old varchar(10) NO
mfdate_old year(4) NO
totaltc_old varchar(255) NO
mdcurrent_old varchar(20) NO
mdhistory_old varchar(20) NO
l1_old varchar(20) NO
l2_old varchar(20) NO
l3_old varchar(20) NO
cl1_old varchar(20) NO
cl2_old varchar(20) NO
cl3_old varchar(20) NO
pf_old varchar(20) NO
punit varchar(5) NO
vunit varchar(5) NO
aunit varchar(5) NO
cunit varchar(5) NO
accuracy_old varchar(10) NO
wiring_old varchar(10) NO
properness_old varchar(10) NO
error1_old varchar(10) NO
error2_old varchar(10) NO
sequence_old varchar(15) NO


Total records in the table= 17
ceb4
Field Type Key Default Extra
ceb4id int(10) NO PRI
accuracy varchar(10) NO
wiring varchar(10) NO
properness varchar(10) NO
error1 varchar(10) NO
error2 varchar(10) NO
sequence varchar(15) NO
breaker varchar(10) NO
capacity varchar(10) NO
overload varchar(10) NO
enc varchar(10) NO
encfix varchar(10) NO
enccon varchar(15) NO
terold1 varchar(30) NO
terold2 varchar(30) NO
ternew1 varchar(30) NO
ternew2 varchar(30) NO
encold1 varchar(30) NO
encold2 varchar(30) NO
encnew1 varchar(30) NO
encnew2 varchar(30) NO
acttak varchar(255) NO
remarks text NO
recomend varchar(255) NO
team varchar(20) NO


Total records in the table= 1
user
Field Type Key Default Extra
id mediumint(11) NO PRI
username varchar(50) NO
password varchar(255) NO
active varchar(150) NO


Total records in the table= 500000
user_details
Field Type Key Default Extra
user_id int(11) NO PRI
username varchar(255) YES
first_name varchar(50) YES
last_name varchar(50) YES
gender varchar(10) YES
password varchar(50) YES
status tinyint(10) YES