[{"class_name":"database","ns":"mutall","throw_exception":true,"partial_name":"mutallco_rental","errors":[],"answer":null,"entities":{"accounts":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"accounts","errors":[],"answer":null,"name":"accounts","columns":{"accounts":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"accounts.accounts","errors":[],"answer":null,"name":"accounts","ename":"accounts","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"landlord":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"accounts.landlord","errors":[],"answer":null,"name":"landlord","ename":"accounts","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"landlord","db_name":"mutallco_rental","cname":"landlord"}},"bank_name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"accounts.bank_name","errors":[],"answer":null,"name":"bank_name","ename":"accounts","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":200,"type":"varchar(200)"},"bank_branch":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"accounts.bank_branch","errors":[],"answer":null,"name":"bank_branch","ename":"accounts","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":200,"type":"varchar(200)"},"acc_name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"accounts.acc_name","errors":[],"answer":null,"name":"acc_name","ename":"accounts","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":200,"type":"varchar(200)"},"acc_num":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"accounts.acc_num","errors":[],"answer":null,"name":"acc_num","ename":"accounts","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"}},"indices":[],"dbname":"mutallco_rental","depth":1,"comment":null},"accumulator":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"accumulator","errors":[],"answer":null,"name":"accumulator","columns":{"accumulator":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"accumulator.accumulator","errors":[],"answer":null,"name":"accumulator","ename":"accumulator","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"loan":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"accumulator.loan","errors":[],"answer":null,"name":"loan","ename":"accumulator","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"loan","db_name":"mutallco_rental","cname":"loan"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"accumulator.invoice","errors":[],"answer":null,"name":"invoice","ename":"accumulator","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"total":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"accumulator.total","errors":[],"answer":null,"name":"total","ename":"accumulator","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"NO","length":null,"type":"double"},"charge":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"accumulator.charge","errors":[],"answer":null,"name":"charge","ename":"accumulator","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"NO","length":null,"type":"double"}},"indices":[],"dbname":"mutallco_rental","depth":6,"comment":null},"agent":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"agent","errors":[],"answer":null,"name":"agent","columns":{"agent":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"agent.agent","errors":[],"answer":null,"name":"agent","ename":"agent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"username":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agent.username","errors":[],"answer":null,"name":"username","ename":"agent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":200,"type":"varchar(200)"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agent.name","errors":[],"answer":null,"name":"name","ename":"agent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":100,"type":"varchar(100)"},"title":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agent.title","errors":[],"answer":null,"name":"title","ename":"agent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":100,"type":"varchar(100)"}},"indices":[],"dbname":"mutallco_rental","depth":0,"comment":null},"agreement":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"agreement","errors":[],"answer":null,"name":"agreement","columns":{"agreement":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"agreement.agreement","errors":[],"answer":null,"name":"agreement","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"room":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"agreement.room","errors":[],"answer":null,"name":"room","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"room","db_name":"mutallco_rental","cname":"room"}},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"agreement.client","errors":[],"answer":null,"name":"client","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agreement.amount","errors":[],"answer":null,"name":"amount","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"start_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agreement.start_date","errors":[],"answer":null,"name":"start_date","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"duration":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agreement.duration","errors":[],"answer":null,"name":"duration","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"review":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agreement.review","errors":[],"answer":null,"name":"review","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"terminated":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agreement.terminated","errors":[],"answer":null,"name":"terminated","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"valid":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agreement.valid","errors":[],"answer":null,"name":"valid","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"comment":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"agreement.comment","errors":[],"answer":null,"name":"comment","ename":"agreement","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"}},"indices":{"identification1":["room","client","start_date"]},"dbname":"mutallco_rental","depth":2,"comment":null,"cx":500,"cy":800},"balance_initial":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"balance_initial","errors":[],"answer":null,"name":"balance_initial","columns":{"balance_initial":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.balance_initial","errors":[],"answer":null,"name":"balance_initial","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.client","errors":[],"answer":null,"name":"client","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.invoice","errors":[],"answer":null,"name":"invoice","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"date_g":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.date_g","errors":[],"answer":null,"name":"date_g","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"amount_g":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.amount_g","errors":[],"answer":null,"name":"amount_g","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"amount_v":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.amount_v","errors":[],"answer":null,"name":"amount_v","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.amount","errors":[],"answer":null,"name":"amount","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"date_v":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.date_v","errors":[],"answer":null,"name":"date_v","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"comment":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.comment","errors":[],"answer":null,"name":"comment","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"balance_initial.date","errors":[],"answer":null,"name":"date","ename":"balance_initial","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"}},"indices":{"identification2":["client","date"]},"dbname":"mutallco_rental","depth":1,"comment":null},"bank":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"bank","errors":[],"answer":null,"name":"bank","columns":{"bank":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"bank.bank","errors":[],"answer":null,"name":"bank","ename":"bank","dbname":"mutallco_rental","comment":"{\"name\": \"The Bank Primary Key\"}","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"bank.name","errors":[],"answer":null,"name":"name","ename":"bank","dbname":"mutallco_rental","comment":"{\"name\":\"The bank Name which is either COOPERATIVE bank or KCB\"}","default":null,"data_type":"varchar","is_nullable":"NO","length":30,"type":"varchar(30)"},"account":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"bank.account","errors":[],"answer":null,"name":"account","ename":"bank","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":20,"type":"varchar(20)"},"company":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"bank.company","errors":[],"answer":null,"name":"company","ename":"bank","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":100,"type":"varchar(100)"}},"indices":{"id_1":["account"]},"dbname":"mutallco_rental","depth":0,"comment":null},"business":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"business","errors":[],"answer":null,"name":"business","columns":{"business":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"business.business","errors":[],"answer":null,"name":"business","ename":"business","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"business.name","errors":[],"answer":null,"name":"name","ename":"business","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":255,"type":"varchar(255)"},"ceo":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"business.ceo","errors":[],"answer":null,"name":"ceo","ename":"business","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"consumption":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"business.consumption","errors":[],"answer":null,"name":"consumption","ename":"business","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"market_rent_price":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"business.market_rent_price","errors":[],"answer":null,"name":"market_rent_price","ename":"business","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"water_cost":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"business.water_cost","errors":[],"answer":null,"name":"water_cost","ename":"business","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"is_current":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"business.is_current","errors":[],"answer":null,"name":"is_current","ename":"business","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"}},"indices":{"identification13":["name"],"identification23":["ceo"]},"dbname":"mutallco_rental","depth":0,"comment":null},"caretaker":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"caretaker","errors":[],"answer":null,"name":"caretaker","columns":{"caretaker":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"caretaker.caretaker","errors":[],"answer":null,"name":"caretaker","ename":"caretaker","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"username":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"caretaker.username","errors":[],"answer":null,"name":"username","ename":"caretaker","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":200,"type":"varchar(200)"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"caretaker.name","errors":[],"answer":null,"name":"name","ename":"caretaker","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":100,"type":"varchar(100)"},"title":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"caretaker.title","errors":[],"answer":null,"name":"title","ename":"caretaker","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":100,"type":"varchar(100)"}},"indices":[],"dbname":"mutallco_rental","depth":0,"comment":null},"changes":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"changes","errors":[],"answer":null,"name":"changes","columns":{"changes":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"changes.changes","errors":[],"answer":null,"name":"changes","ename":"changes","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"pk":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"changes.pk","errors":[],"answer":null,"name":"pk","ename":"changes","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"source":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"changes.source","errors":[],"answer":null,"name":"source","ename":"changes","dbname":"mutallco_rental","comment":"","default":null,"data_type":"text","is_nullable":"NO","length":65535,"type":"text"},"operation":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"changes.operation","errors":[],"answer":null,"name":"operation","ename":"changes","dbname":"mutallco_rental","comment":"","default":null,"data_type":"enum","is_nullable":"NO","length":6,"type":"enum('update','insert','delete','')"},"datetime":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"changes.datetime","errors":[],"answer":null,"name":"datetime","ename":"changes","dbname":"mutallco_rental","comment":"","default":"CURRENT_TIMESTAMP","data_type":"datetime","is_nullable":"NO","length":null,"type":"datetime"}},"indices":[],"dbname":"mutallco_rental","depth":0,"comment":null},"charge":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"charge","errors":[],"answer":null,"name":"charge","columns":{"charge":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"charge.charge","errors":[],"answer":null,"name":"charge","ename":"charge","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"service":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"charge.service","errors":[],"answer":null,"name":"service","ename":"charge","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"service","db_name":"mutallco_rental","cname":"service"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"charge.invoice","errors":[],"answer":null,"name":"invoice","ename":"charge","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"charge.name","errors":[],"answer":null,"name":"name","ename":"charge","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"price":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"charge.price","errors":[],"answer":null,"name":"price","ename":"charge","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"factor":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"charge.factor","errors":[],"answer":null,"name":"factor","ename":"charge","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"charge.amount","errors":[],"answer":null,"name":"amount","ename":"charge","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"id4":["service","invoice"]},"dbname":"mutallco_rental","depth":4,"comment":null,"cx":900,"cy":150},"client":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"client","errors":[],"answer":null,"name":"client","columns":{"client":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"client.client","errors":[],"answer":null,"name":"client","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.name","errors":[],"answer":null,"name":"name","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":30,"type":"varchar(30)"},"title":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.title","errors":[],"answer":null,"name":"title","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":100,"type":"varchar(100)"},"quarterly":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.quarterly","errors":[],"answer":null,"name":"quarterly","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"contact":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.contact","errors":[],"answer":null,"name":"contact","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":40,"type":"varchar(40)"},"phone":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.phone","errors":[],"answer":null,"name":"phone","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":50,"type":"varchar(50)"},"address":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.address","errors":[],"answer":null,"name":"address","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":100,"type":"varchar(100)"},"email":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.email","errors":[],"answer":null,"name":"email","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":40,"type":"varchar(40)"},"is_scenic":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"client.is_scenic","errors":[],"answer":null,"name":"is_scenic","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"tinyint","is_nullable":"YES","length":null,"type":"tinyint(1)"},"bank":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"client.bank","errors":[],"answer":null,"name":"bank","ename":"client","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"bank","db_name":"mutallco_rental","cname":"bank"}}},"indices":{"id":["name"]},"dbname":"mutallco_rental","depth":0,"comment":null,"cx":500,"cy":500},"closing_balance":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"closing_balance","errors":[],"answer":null,"name":"closing_balance","columns":{"closing_balance":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"closing_balance.closing_balance","errors":[],"answer":null,"name":"closing_balance","ename":"closing_balance","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"closing_balance.invoice","errors":[],"answer":null,"name":"invoice","ename":"closing_balance","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"closing_balance.amount","errors":[],"answer":null,"name":"amount","ename":"closing_balance","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"posted":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"closing_balance.posted","errors":[],"answer":null,"name":"posted","ename":"closing_balance","dbname":"mutallco_rental","comment":"","default":"0","data_type":"int","is_nullable":"NO","length":null,"type":"int"}},"indices":{"id6":["invoice"]},"dbname":"mutallco_rental","depth":3,"comment":null},"communications":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"communications","errors":[],"answer":null,"name":"communications","columns":{"communications":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"communications.communications","errors":[],"answer":null,"name":"communications","ename":"communications","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"communications.client","errors":[],"answer":null,"name":"client","ename":"communications","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"ref":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"communications.ref","errors":[],"answer":null,"name":"ref","ename":"communications","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":100,"type":"varchar(100)"}},"indices":[],"dbname":"mutallco_rental","depth":1,"comment":null},"credit":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"credit","errors":[],"answer":null,"name":"credit","columns":{"credit":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"credit.credit","errors":[],"answer":null,"name":"credit","ename":"credit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"credit.client","errors":[],"answer":null,"name":"client","ename":"credit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"credit.invoice","errors":[],"answer":null,"name":"invoice","ename":"credit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"reason":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"credit.reason","errors":[],"answer":null,"name":"reason","ename":"credit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":255,"type":"varchar(255)"},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"credit.date","errors":[],"answer":null,"name":"date","ename":"credit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"credit.amount","errors":[],"answer":null,"name":"amount","ename":"credit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"id7":["client","reason","date"]},"dbname":"mutallco_rental","depth":1,"comment":null},"debit":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"debit","errors":[],"answer":null,"name":"debit","columns":{"debit":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"debit.debit","errors":[],"answer":null,"name":"debit","ename":"debit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"debit.client","errors":[],"answer":null,"name":"client","ename":"debit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"debit.invoice","errors":[],"answer":null,"name":"invoice","ename":"debit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"reason":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"debit.reason","errors":[],"answer":null,"name":"reason","ename":"debit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":255,"type":"varchar(255)"},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"debit.date","errors":[],"answer":null,"name":"date","ename":"debit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"debit.amount","errors":[],"answer":null,"name":"amount","ename":"debit","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"id8":["client","reason","date"]},"dbname":"mutallco_rental","depth":1,"comment":null},"eaccount":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"eaccount","errors":[],"answer":null,"name":"eaccount","columns":{"eaccount":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"eaccount.eaccount","errors":[],"answer":null,"name":"eaccount","ename":"eaccount","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"num":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"eaccount.num","errors":[],"answer":null,"name":"num","ename":"eaccount","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":100,"type":"varchar(100)"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"eaccount.name","errors":[],"answer":null,"name":"name","ename":"eaccount","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"is_invalid":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"eaccount.is_invalid","errors":[],"answer":null,"name":"is_invalid","ename":"eaccount","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"comment":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"eaccount.comment","errors":[],"answer":null,"name":"comment","ename":"eaccount","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"source":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"eaccount.source","errors":[],"answer":null,"name":"source","ename":"eaccount","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"}},"indices":{"id9":["num"]},"dbname":"mutallco_rental","depth":0,"comment":null,"cx":1000,"cy":1700},"ebill":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"ebill","errors":[],"answer":null,"name":"ebill","columns":{"ebill":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"ebill.ebill","errors":[],"answer":null,"name":"ebill","ename":"ebill","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"msg":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"ebill.msg","errors":[],"answer":null,"name":"msg","ename":"ebill","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"msg","db_name":"mutallco_rental","cname":"msg"}},"eaccount":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"ebill.eaccount","errors":[],"answer":null,"name":"eaccount","ename":"ebill","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"eaccount","db_name":"mutallco_rental","cname":"eaccount"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"ebill.invoice","errors":[],"answer":null,"name":"invoice","ename":"ebill","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"due_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"ebill.due_date","errors":[],"answer":null,"name":"due_date","ename":"ebill","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"},"current_amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"ebill.current_amount","errors":[],"answer":null,"name":"current_amount","ename":"ebill","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"identification10":["eaccount","due_date"]},"dbname":"mutallco_rental","depth":1,"comment":null,"cx":900,"cy":1800},"econnection":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"econnection","errors":[],"answer":null,"name":"econnection","columns":{"econnection":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"econnection.econnection","errors":[],"answer":null,"name":"econnection","ename":"econnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"room":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"econnection.room","errors":[],"answer":null,"name":"room","ename":"econnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"room","db_name":"mutallco_rental","cname":"room"}},"emeter":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"econnection.emeter","errors":[],"answer":null,"name":"emeter","ename":"econnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"emeter","db_name":"mutallco_rental","cname":"emeter"}},"rate":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"econnection.rate","errors":[],"answer":null,"name":"rate","ename":"econnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"start_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"econnection.start_date","errors":[],"answer":null,"name":"start_date","ename":"econnection","dbname":"mutallco_rental","comment":"","default":"CURRENT_TIMESTAMP","data_type":"datetime","is_nullable":"YES","length":null,"type":"datetime"},"end_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"econnection.end_date","errors":[],"answer":null,"name":"end_date","ename":"econnection","dbname":"mutallco_rental","comment":"","default":"9999-12-31","data_type":"date","is_nullable":"YES","length":null,"type":"date"},"start_reading":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"econnection.start_reading","errors":[],"answer":null,"name":"start_reading","ename":"econnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"share":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"econnection.share","errors":[],"answer":null,"name":"share","ename":"econnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"}},"indices":{"id":["room","emeter","end_date"]},"dbname":"mutallco_rental","depth":2,"comment":null,"cx":1100,"cy":1000},"electricity":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"electricity","errors":[],"answer":null,"name":"electricity","columns":{"electricity":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"electricity.electricity","errors":[],"answer":null,"name":"electricity","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"eaccount":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"electricity.eaccount","errors":[],"answer":null,"name":"eaccount","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"eaccount","db_name":"mutallco_rental","cname":"eaccount"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"electricity.invoice","errors":[],"answer":null,"name":"invoice","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"eaccount_no":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"electricity.eaccount_no","errors":[],"answer":null,"name":"eaccount_no","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":30,"type":"varchar(30)"},"emeter_no":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"electricity.emeter_no","errors":[],"answer":null,"name":"emeter_no","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":30,"type":"varchar(30)"},"due_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"electricity.due_date","errors":[],"answer":null,"name":"due_date","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"payable_to_kplc":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"electricity.payable_to_kplc","errors":[],"answer":null,"name":"payable_to_kplc","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"sharing":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"electricity.sharing","errors":[],"answer":null,"name":"sharing","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":20,"type":"varchar(20)"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"electricity.amount","errors":[],"answer":null,"name":"amount","ename":"electricity","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"id12":["eaccount","invoice"]},"dbname":"mutallco_rental","depth":4,"comment":null,"cx":900,"cy":1200},"elink":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"elink","errors":[],"answer":null,"name":"elink","columns":{"elink":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"elink.elink","errors":[],"answer":null,"name":"elink","ename":"elink","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"emeter":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"elink.emeter","errors":[],"answer":null,"name":"emeter","ename":"elink","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"emeter","db_name":"mutallco_rental","cname":"emeter"}},"eaccount":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"elink.eaccount","errors":[],"answer":null,"name":"eaccount","ename":"elink","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"eaccount","db_name":"mutallco_rental","cname":"eaccount"}},"start_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"elink.start_date","errors":[],"answer":null,"name":"start_date","ename":"elink","dbname":"mutallco_rental","comment":"","default":"CURRENT_TIMESTAMP","data_type":"datetime","is_nullable":"YES","length":null,"type":"datetime"},"end_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"elink.end_date","errors":[],"answer":null,"name":"end_date","ename":"elink","dbname":"mutallco_rental","comment":"{\"title\": \"Date when the link was closed\"}","default":"9999-12-31","data_type":"date","is_nullable":"YES","length":null,"type":"date","title":"Date when the link was closed"},"origin":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"elink.origin","errors":[],"answer":null,"name":"origin","ename":"elink","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"}},"indices":{"id":["emeter","eaccount","end_date"]},"dbname":"mutallco_rental","depth":2,"comment":null,"cx":900,"cy":1400},"emeter":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"emeter","errors":[],"answer":null,"name":"emeter","columns":{"emeter":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"emeter.emeter","errors":[],"answer":null,"name":"emeter","ename":"emeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"num":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"emeter.num","errors":[],"answer":null,"name":"num","ename":"emeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":50,"type":"varchar(50)"},"uid":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"emeter.uid","errors":[],"answer":null,"name":"uid","ename":"emeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"emeter.name","errors":[],"answer":null,"name":"name","ename":"emeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"is_invalid":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"emeter.is_invalid","errors":[],"answer":null,"name":"is_invalid","ename":"emeter","dbname":"mutallco_rental","comment":"","default":"1","data_type":"int","is_nullable":"YES","length":null,"type":"int"},"comment":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"emeter.comment","errors":[],"answer":null,"name":"comment","ename":"emeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"source":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"emeter.source","errors":[],"answer":null,"name":"source","ename":"emeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"new_num_2023_03":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"emeter.new_num_2023_03","errors":[],"answer":null,"name":"new_num_2023_03","ename":"emeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":50,"type":"varchar(50)"}},"indices":{"id":["num"]},"dbname":"mutallco_rental","depth":0,"comment":null,"cx":1400,"cy":1200},"ereading":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"ereading","errors":[],"answer":null,"name":"ereading","columns":{"ereading":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"ereading.ereading","errors":[],"answer":null,"name":"ereading","ename":"ereading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"emeter":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"ereading.emeter","errors":[],"answer":null,"name":"emeter","ename":"ereading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"emeter","db_name":"mutallco_rental","cname":"emeter"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"ereading.invoice","errors":[],"answer":null,"name":"invoice","ename":"ereading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"ereading.date","errors":[],"answer":null,"name":"date","ename":"ereading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"},"value":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"ereading.value","errors":[],"answer":null,"name":"value","ename":"ereading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"remark":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"ereading.remark","errors":[],"answer":null,"name":"remark","ename":"ereading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"}},"indices":{"identification15":["emeter","date"]},"dbname":"mutallco_rental","depth":1,"comment":null,"cx":1400,"cy":1700},"invoice":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"invoice","errors":[],"answer":null,"name":"invoice","columns":{"invoice":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"invoice.invoice","errors":[],"answer":null,"name":"invoice","ename":"invoice","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"invoice.client","errors":[],"answer":null,"name":"client","ename":"invoice","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"period":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"invoice.period","errors":[],"answer":null,"name":"period","ename":"invoice","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"period","db_name":"mutallco_rental","cname":"period"}},"is_valid":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"invoice.is_valid","errors":[],"answer":null,"name":"is_valid","ename":"invoice","dbname":"mutallco_rental","comment":"","default":"0","data_type":"int","is_nullable":"NO","length":null,"type":"int"}},"indices":{"id16":["client","period"]},"dbname":"mutallco_rental","depth":2,"comment":null},"job":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"job","errors":[],"answer":null,"name":"job","columns":{"job":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"job.job","errors":[],"answer":null,"name":"job","ename":"job","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"job.name","errors":[],"answer":null,"name":"name","ename":"job","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":255,"type":"varchar(255)"},"dbname":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"job.dbname","errors":[],"answer":null,"name":"dbname","ename":"job","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"sql":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"job.sql","errors":[],"answer":null,"name":"sql","ename":"job","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"}},"indices":{"id17":["name"]},"dbname":"mutallco_rental","depth":0,"comment":null},"landlord":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"landlord","errors":[],"answer":null,"name":"landlord","columns":{"landlord":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"landlord.landlord","errors":[],"answer":null,"name":"landlord","ename":"landlord","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"landlord.name","errors":[],"answer":null,"name":"name","ename":"landlord","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":100,"type":"varchar(100)"},"title":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"landlord.title","errors":[],"answer":null,"name":"title","ename":"landlord","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"username":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"landlord.username","errors":[],"answer":null,"name":"username","ename":"landlord","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":200,"type":"varchar(200)"},"paybill":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"landlord.paybill","errors":[],"answer":null,"name":"paybill","ename":"landlord","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"}},"indices":[],"dbname":"mutallco_rental","depth":0,"comment":null},"loan":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"loan","errors":[],"answer":null,"name":"loan","columns":{"loan":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"loan.loan","errors":[],"answer":null,"name":"loan","ename":"loan","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"agreement":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"loan.agreement","errors":[],"answer":null,"name":"agreement","ename":"loan","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"agreement","db_name":"mutallco_rental","cname":"agreement"}},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"loan.amount","errors":[],"answer":null,"name":"amount","ename":"loan","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"NO","length":null,"type":"double"},"instalment":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"loan.instalment","errors":[],"answer":null,"name":"instalment","ename":"loan","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"start_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"loan.start_date","errors":[],"answer":null,"name":"start_date","ename":"loan","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"}},"indices":[],"dbname":"mutallco_rental","depth":3,"comment":null},"mobile":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"mobile","errors":[],"answer":null,"name":"mobile","columns":{"mobile":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"mobile.mobile","errors":[],"answer":null,"name":"mobile","ename":"mobile","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"mobile.client","errors":[],"answer":null,"name":"client","ename":"mobile","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"num":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"mobile.num","errors":[],"answer":null,"name":"num","ename":"mobile","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":30,"type":"varchar(30)"},"contact":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"mobile.contact","errors":[],"answer":null,"name":"contact","ename":"mobile","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":30,"type":"varchar(30)"}},"indices":{"id18":["num"]},"dbname":"mutallco_rental","depth":0,"comment":null},"msg":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"msg","errors":[],"answer":null,"name":"msg","columns":{"msg":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"msg.msg","errors":[],"answer":null,"name":"msg","ename":"msg","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"id":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"msg.id","errors":[],"answer":null,"name":"id","ename":"msg","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":32,"type":"varchar(32)"},"body":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"msg.body","errors":[],"answer":null,"name":"body","ename":"msg","dbname":"mutallco_rental","comment":"","default":null,"data_type":"longtext","is_nullable":"YES","length":4294967295,"type":"longtext"},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"msg.date","errors":[],"answer":null,"name":"date","ename":"msg","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"}},"indices":{"id19":["id"]},"dbname":"mutallco_rental","depth":0,"comment":null},"note":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"note","errors":[],"answer":null,"name":"note","columns":{"note":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"note.note","errors":[],"answer":null,"name":"note","ename":"note","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"note.invoice","errors":[],"answer":null,"name":"invoice","ename":"note","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"info":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"note.info","errors":[],"answer":null,"name":"info","ename":"note","dbname":"mutallco_rental","comment":"","default":null,"data_type":"longtext","is_nullable":"YES","length":4294967295,"type":"longtext"}},"indices":{"id20":["invoice"]},"dbname":"mutallco_rental","depth":3,"comment":null},"payment":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"payment","errors":[],"answer":null,"name":"payment","columns":{"payment":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"payment.payment","errors":[],"answer":null,"name":"payment","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"payment.client","errors":[],"answer":null,"name":"client","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"payment.invoice","errors":[],"answer":null,"name":"invoice","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"payment.date","errors":[],"answer":null,"name":"date","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"},"bank":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"payment.bank","errors":[],"answer":null,"name":"bank","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":30,"type":"varchar(30)"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"payment.amount","errors":[],"answer":null,"name":"amount","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"type":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"payment.type","errors":[],"answer":null,"name":"type","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":20,"type":"varchar(20)"},"ref":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"payment.ref","errors":[],"answer":null,"name":"ref","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":30,"type":"varchar(30)"},"description":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"payment.description","errors":[],"answer":null,"name":"description","ename":"payment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":50,"type":"varchar(50)"}},"indices":{"id21":["client","date","description"]},"dbname":"mutallco_rental","depth":1,"comment":null,"cx":500,"cy":100},"period":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"period","errors":[],"answer":null,"name":"period","columns":{"period":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"period.period","errors":[],"answer":null,"name":"period","ename":"period","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"year":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"period.year","errors":[],"answer":null,"name":"year","ename":"period","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"month":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"period.month","errors":[],"answer":null,"name":"month","ename":"period","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"cutoff":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"period.cutoff","errors":[],"answer":null,"name":"cutoff","ename":"period","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"}},"indices":{"identification22":["year","month"]},"dbname":"mutallco_rental","depth":0,"comment":null},"picture":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"picture","errors":[],"answer":null,"name":"picture","columns":{"picture":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"picture.picture","errors":[],"answer":null,"name":"picture","ename":"picture","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"room":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"picture.room","errors":[],"answer":null,"name":"room","ename":"picture","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"room","db_name":"mutallco_rental","cname":"room"}},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"picture.name","errors":[],"answer":null,"name":"name","ename":"picture","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":50,"type":"varchar(50)"},"elevation":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"picture.elevation","errors":[],"answer":null,"name":"elevation","ename":"picture","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":50,"type":"varchar(50)"}},"indices":{"identification23":["room","name"]},"dbname":"mutallco_rental","depth":1,"comment":null,"cx":120,"cy":1200},"property":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"property","errors":[],"answer":null,"name":"property","columns":{"property":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"property.property","errors":[],"answer":null,"name":"property","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"uid":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"property.uid","errors":[],"answer":null,"name":"uid","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":200,"type":"varchar(200)"},"rental_unit":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"property.rental_unit","errors":[],"answer":null,"name":"rental_unit","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"room","db_name":"mutallco_rental","cname":"room"}},"landlord":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"property.landlord","errors":[],"answer":null,"name":"landlord","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"landlord","db_name":"mutallco_rental","cname":"landlord"}},"agent":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"property.agent","errors":[],"answer":null,"name":"agent","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"agent","db_name":"mutallco_rental","cname":"agent"}},"caretaker":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"property.caretaker","errors":[],"answer":null,"name":"caretaker","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"property.name","errors":[],"answer":null,"name":"name","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":100,"type":"varchar(100)"},"location":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"property.location","errors":[],"answer":null,"name":"location","ename":"property","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":100,"type":"varchar(100)"}},"indices":[],"dbname":"mutallco_rental","depth":2,"comment":null},"rent":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"rent","errors":[],"answer":null,"name":"rent","columns":{"rent":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"rent.rent","errors":[],"answer":null,"name":"rent","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"rent.invoice","errors":[],"answer":null,"name":"invoice","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"agreement":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"rent.agreement","errors":[],"answer":null,"name":"agreement","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"agreement","db_name":"mutallco_rental","cname":"agreement"}},"room_no":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"rent.room_no","errors":[],"answer":null,"name":"room_no","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"price":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"rent.price","errors":[],"answer":null,"name":"price","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"agreement_start_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"rent.agreement_start_date","errors":[],"answer":null,"name":"agreement_start_date","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"rental_period":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"rent.rental_period","errors":[],"answer":null,"name":"rental_period","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":30,"type":"varchar(30)"},"factor":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"rent.factor","errors":[],"answer":null,"name":"factor","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"rent.amount","errors":[],"answer":null,"name":"amount","ename":"rent","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"id24":["invoice","agreement"]},"dbname":"mutallco_rental","depth":5,"comment":null,"cx":120,"cy":800},"repayment":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"repayment","errors":[],"answer":null,"name":"repayment","columns":{"repayment":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"repayment.repayment","errors":[],"answer":null,"name":"repayment","ename":"repayment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"loan":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"repayment.loan","errors":[],"answer":null,"name":"loan","ename":"repayment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"loan","db_name":"mutallco_rental","cname":"loan"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"repayment.invoice","errors":[],"answer":null,"name":"invoice","ename":"repayment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"repayment.date","errors":[],"answer":null,"name":"date","ename":"repayment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"repayment.amount","errors":[],"answer":null,"name":"amount","ename":"repayment","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"NO","length":null,"type":"double"}},"indices":{"id_date":["date"]},"dbname":"mutallco_rental","depth":4,"comment":null},"room":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"room","errors":[],"answer":null,"name":"room","columns":{"room":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"room.room","errors":[],"answer":null,"name":"room","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"uid":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.uid","errors":[],"answer":null,"name":"uid","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":15,"type":"varchar(15)"},"is_psuedo":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.is_psuedo","errors":[],"answer":null,"name":"is_psuedo","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"title":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.title","errors":[],"answer":null,"name":"title","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":50,"type":"varchar(50)"},"floor":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.floor","errors":[],"answer":null,"name":"floor","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":10,"type":"varchar(10)"},"wing":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.wing","errors":[],"answer":null,"name":"wing","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":10,"type":"varchar(10)"},"width_ft":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.width_ft","errors":[],"answer":null,"name":"width_ft","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"width_inch":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.width_inch","errors":[],"answer":null,"name":"width_inch","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"breadth_ft":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.breadth_ft","errors":[],"answer":null,"name":"breadth_ft","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"breadth_inch":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.breadth_inch","errors":[],"answer":null,"name":"breadth_inch","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"area_sq_m":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.area_sq_m","errors":[],"answer":null,"name":"area_sq_m","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"area_sq_ft":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"room.area_sq_ft","errors":[],"answer":null,"name":"area_sq_ft","ename":"room","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"}},"indices":{"identification25":["uid"]},"dbname":"mutallco_rental","depth":0,"comment":null,"cx":500,"cy":1000},"service":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"service","errors":[],"answer":null,"name":"service","columns":{"service":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"service.service","errors":[],"answer":null,"name":"service","ename":"service","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"service.name","errors":[],"answer":null,"name":"name","ename":"service","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":255,"type":"varchar(255)"},"description":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"service.description","errors":[],"answer":null,"name":"description","ename":"service","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"price":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"service.price","errors":[],"answer":null,"name":"price","ename":"service","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"auto":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"service.auto","errors":[],"answer":null,"name":"auto","ename":"service","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"}},"indices":{"id26":["name"],"id_serv":["service"]},"dbname":"mutallco_rental","depth":0,"comment":null,"cx":900,"cy":350},"subscription":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"subscription","errors":[],"answer":null,"name":"subscription","columns":{"subscription":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"subscription.subscription","errors":[],"answer":null,"name":"subscription","ename":"subscription","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"client":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"subscription.client","errors":[],"answer":null,"name":"client","ename":"subscription","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"client","db_name":"mutallco_rental","cname":"client"}},"service":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"subscription.service","errors":[],"answer":null,"name":"service","ename":"subscription","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"service","db_name":"mutallco_rental","cname":"service"}},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"subscription.amount","errors":[],"answer":null,"name":"amount","ename":"subscription","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"id27":["client","service"]},"dbname":"mutallco_rental","depth":2,"comment":null,"cx":900,"cy":600},"water":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"water","errors":[],"answer":null,"name":"water","columns":{"water":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"water.water","errors":[],"answer":null,"name":"water","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"wconnection":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"water.wconnection","errors":[],"answer":null,"name":"wconnection","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"wconnection","db_name":"mutallco_rental","cname":"wconnection"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"water.invoice","errors":[],"answer":null,"name":"invoice","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"serial_no":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.serial_no","errors":[],"answer":null,"name":"serial_no","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"prev_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.prev_date","errors":[],"answer":null,"name":"prev_date","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"prev_value":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.prev_value","errors":[],"answer":null,"name":"prev_value","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"curr_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.curr_date","errors":[],"answer":null,"name":"curr_date","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"curr_value":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.curr_value","errors":[],"answer":null,"name":"curr_value","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"consumption":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.consumption","errors":[],"answer":null,"name":"consumption","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"rate":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.rate","errors":[],"answer":null,"name":"rate","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"amount":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"water.amount","errors":[],"answer":null,"name":"amount","ename":"water","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"}},"indices":{"id28":["wconnection","invoice"]},"dbname":"mutallco_rental","depth":6,"comment":null,"cx":120,"cy":1400},"wconnection":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"wconnection","errors":[],"answer":null,"name":"wconnection","columns":{"wconnection":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"wconnection.wconnection","errors":[],"answer":null,"name":"wconnection","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"room":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"wconnection.room","errors":[],"answer":null,"name":"room","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"room","db_name":"mutallco_rental","cname":"room"}},"wmeter":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"wconnection.wmeter","errors":[],"answer":null,"name":"wmeter","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"wmeter","db_name":"mutallco_rental","cname":"wmeter"}},"rate":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wconnection.rate","errors":[],"answer":null,"name":"rate","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"start_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wconnection.start_date","errors":[],"answer":null,"name":"start_date","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"},"end_date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wconnection.end_date","errors":[],"answer":null,"name":"end_date","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":"9999-12-31","data_type":"date","is_nullable":"NO","length":null,"type":"date"},"start_reading":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wconnection.start_reading","errors":[],"answer":null,"name":"start_reading","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"end_reading":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wconnection.end_reading","errors":[],"answer":null,"name":"end_reading","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"},"disconnected":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wconnection.disconnected","errors":[],"answer":null,"name":"disconnected","ename":"wconnection","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"YES","length":null,"type":"date"}},"indices":{"id29":["room","wmeter","end_date"]},"dbname":"mutallco_rental","depth":2,"comment":null,"cx":500,"cy":1300},"wmeter":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"wmeter","errors":[],"answer":null,"name":"wmeter","columns":{"wmeter":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"wmeter.wmeter","errors":[],"answer":null,"name":"wmeter","ename":"wmeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"serial_no":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wmeter.serial_no","errors":[],"answer":null,"name":"serial_no","ename":"wmeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"NO","length":50,"type":"varchar(50)"},"name":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wmeter.name","errors":[],"answer":null,"name":"name","ename":"wmeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"comment":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wmeter.comment","errors":[],"answer":null,"name":"comment","ename":"wmeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"},"is_supply":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wmeter.is_supply","errors":[],"answer":null,"name":"is_supply","ename":"wmeter","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int"}},"indices":{"id30":["serial_no"]},"dbname":"mutallco_rental","depth":0,"comment":null,"cx":500,"cy":1600},"wreading":{"class_name":"table","ns":"mutall","throw_exception":true,"partial_name":"wreading","errors":[],"answer":null,"name":"wreading","columns":{"wreading":{"class_name":"primary","ns":"mutall","throw_exception":true,"partial_name":"wreading.wreading","errors":[],"answer":null,"name":"wreading","ename":"wreading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int"},"wmeter":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"wreading.wmeter","errors":[],"answer":null,"name":"wmeter","ename":"wreading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"NO","length":null,"type":"int","ref":{"table_name":"wmeter","db_name":"mutallco_rental","cname":"wmeter"}},"invoice":{"class_name":"foreign","ns":"mutall","throw_exception":true,"partial_name":"wreading.invoice","errors":[],"answer":null,"name":"invoice","ename":"wreading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"int","is_nullable":"YES","length":null,"type":"int","ref":{"table_name":"invoice","db_name":"mutallco_rental","cname":"invoice"}},"date":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wreading.date","errors":[],"answer":null,"name":"date","ename":"wreading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"date","is_nullable":"NO","length":null,"type":"date"},"value":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wreading.value","errors":[],"answer":null,"name":"value","ename":"wreading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"double","is_nullable":"YES","length":null,"type":"double"},"remark":{"class_name":"attribute","ns":"mutall","throw_exception":true,"partial_name":"wreading.remark","errors":[],"answer":null,"name":"remark","ename":"wreading","dbname":"mutallco_rental","comment":"","default":null,"data_type":"varchar","is_nullable":"YES","length":255,"type":"varchar(255)"}},"indices":{"identification31":["wmeter","date"]},"dbname":"mutallco_rental","depth":1,"comment":null,"cx":500,"cy":1800}},"pdo":{},"name":"mutallco_rental","complete":true,"error_report":""},["client","name","title","quarterly","contact","phone","address","email","is_scenic","bank"],"SELECT \n\t\n\tjson_array(`mutallco_rental`.`client`.`client` , concat_ws('\/', `mutallco_rental`.`client`.`name` )) as `client`,\n\t`mutallco_rental`.`client`.`name`  as `name`,\n\t`mutallco_rental`.`client`.`title`  as `title`,\n\t`mutallco_rental`.`client`.`quarterly`  as `quarterly`,\n\t`mutallco_rental`.`client`.`contact`  as `contact`,\n\t`mutallco_rental`.`client`.`phone`  as `phone`,\n\t`mutallco_rental`.`client`.`address`  as `address`,\n\t`mutallco_rental`.`client`.`email`  as `email`,\n\t`mutallco_rental`.`client`.`is_scenic`  as `is_scenic`,\n\tjson_array(`mutallco_rental`.`client`.`bank` , `bank_selector`.`friend__` ) as `bank` \nFROM \n\t`mutallco_rental`.`client`\nleft join \t (SELECT \n\t\n\t`mutallco_rental`.`bank`.`bank`  as `bank_selector`,\n\tconcat_ws('\/', `mutallco_rental`.`bank`.`account` ) as `friend__` \nFROM \n\t`mutallco_rental`.`bank`\n\n\n) as `bank_selector`  ON  `mutallco_rental`.`client`.`bank`  = `bank_selector`.`bank_selector`\n\n",66]