[{"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":{"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"},"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"},"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)"},"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)"},"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"}}},"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"},"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"},"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"}},"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"}},"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"}},"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"},"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)"},"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)"}},"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"},"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"},"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"}},"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)"},"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"},"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"}},"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"},"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"}},"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":{"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"},"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"},"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"}},"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"},"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"},"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"},"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"}}},"indices":{"identification2":["client","date"]},"dbname":"mutallco_rental","depth":1,"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"},"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"},"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"},"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"},"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)"},"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"}},"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"},"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)"},"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)"}},"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"},"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"},"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','')"},"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"}},"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":{"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"},"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"},"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"},"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"},"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"}}},"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":{"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)"},"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"},"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)"},"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)"},"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)"},"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)"},"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"},"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)"}},"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":{"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"},"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"}},"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":{"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"}},"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"},"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":{"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"},"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"}},"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"},"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"},"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)"}},"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":{"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"},"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"}},"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"},"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"},"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)"}},"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":{"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)"},"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"},"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"},"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)"},"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)"},"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":{"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"},"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"},"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"}},"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"},"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"}},"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"}}},"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"},"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"}},"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"},"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"},"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"}},"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"},"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"},"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"}},"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":{"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"},"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"},"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"}},"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)"},"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"},"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)"},"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"}},"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)"}},"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":{"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"}},"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"}},"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)"},"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"}},"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":{"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)"},"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"},"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"},"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)"},"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)"},"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)"},"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)"},"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"}},"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":{"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"},"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"}},"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"},"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"}},"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)"},"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"}},"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":{"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"}},"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"},"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"},"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"}}},"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":{"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)"},"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)"},"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)"},"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"},"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)"}},"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":{"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"},"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"},"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":{"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"}},"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)"},"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"},"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)"}},"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":{"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"},"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)"},"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"}},"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":{"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"},"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"}},"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"}},"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":{"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"},"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)"},"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"}},"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"},"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)"},"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"}},"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"},"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)"},"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)"}},"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":{"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"},"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"},"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"}},"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":{"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)"},"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)"},"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"}}},"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":{"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"},"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"}},"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)"},"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)"},"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"},"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"}},"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)"}},"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":{"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"}},"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"},"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"},"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"},"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"}},"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"},"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"},"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)"},"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)"}},"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":{"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"},"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"},"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"}},"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"}},"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"}},"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":{"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"},"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"},"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"},"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)"},"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"},"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"},"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)"},"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)"},"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"},"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)"}},"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":{"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"},"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)"},"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)"},"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"},"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"}},"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":{"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"},"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"}},"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"}},"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":{"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"},"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"},"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"},"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"}},"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"},"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"},"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)"},"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"}}},"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":{"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"},"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"},"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"},"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"},"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"}},"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"},"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"},"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"},"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"}}},"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":{"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"},"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)"},"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)"},"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"}},"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":{"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"},"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"}},"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)"},"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"},"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"}},"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"}},"indices":{"identification31":["wmeter","date"]},"dbname":"mutallco_rental","depth":1,"comment":null,"cx":500,"cy":1800}},"pdo":{},"name":"mutallco_rental","complete":true,"error_report":""},["client","address","contact","email","is_scenic","name","phone","quarterly","title"],"SELECT \n\t\n\tjson_array(`mutallco_rental`.`client`.`client` , concat_ws('\/', `mutallco_rental`.`client`.`name` )) as `client`,\n\t`mutallco_rental`.`client`.`address`  as `address`,\n\t`mutallco_rental`.`client`.`contact`  as `contact`,\n\t`mutallco_rental`.`client`.`email`  as `email`,\n\t`mutallco_rental`.`client`.`is_scenic`  as `is_scenic`,\n\t`mutallco_rental`.`client`.`name`  as `name`,\n\t`mutallco_rental`.`client`.`phone`  as `phone`,\n\t`mutallco_rental`.`client`.`quarterly`  as `quarterly`,\n\t`mutallco_rental`.`client`.`title`  as `title` \nFROM \n\t`mutallco_rental`.`client`\n\n\n",66]