erd_pgadmin.pgerd

{"version":"70200","data":{"id":"e89e5ccc-e6bf-4776-be1e-edc0cfb96c52","offsetX":-4.20955056335182,"offsetY":157.8785243650186,"zoom":81.61111166477208,"gridSize":15,"layers":[{"id":"242b4a4f-1aab-4d23-8d0b-3dbeefa693ed","type":"diagram-links","isSvg":true,"transformed":true,"models":{"2d6b558d-f7c7-47e3-aec2-211cf9776459":{"id":"2d6b558d-f7c7-47e3-aec2-211cf9776459","locked":true,"type":"onetomany","source":"a5e0e8c3-4808-4ffb-b0f7-0872baad117f","sourcePort":"088fad45-4f34-4842-ba2d-2211e1353ce2","target":"d594925f-5e0c-4b11-b918-662d00476c91","targetPort":"ddae41c9-2013-4f10-82d6-4e0b30cc5810","points":[{"id":"85f297c0-c446-434a-9d64-189d3f9682b0","type":"point","x":339,"y":2},{"id":"8e15d9ea-dd92-4c6b-bbe2-c0003fa337d2","type":"point","x":406,"y":346},{"id":"e721f4e3-b74a-4b19-8c3d-cd459ceeaca8","type":"point","x":406,"y":87}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"d594925f-5e0c-4b11-b918-662d00476c91","local_column_attnum":2,"referenced_table_uid":"a5e0e8c3-4808-4ffb-b0f7-0872baad117f","referenced_column_attnum":1}},"932077ca-f780-44d7-875d-e24f8e198a8d":{"id":"932077ca-f780-44d7-875d-e24f8e198a8d","locked":true,"type":"onetomany","source":"d594925f-5e0c-4b11-b918-662d00476c91","sourcePort":"205f2e5f-8d99-4c75-a810-02b0f4cc8623","target":"cfe14967-5f58-45fa-a583-4471821d5e54","targetPort":"16e7c871-4b78-4c55-bf70-047c05a1be0f","points":[{"id":"e4404673-3e3e-4a67-a17e-55d883b86324","type":"point","x":639,"y":62},{"id":"a762def3-4e0a-47bc-aeea-c98899309cd8","type":"point","x":676,"y":700},{"id":"dbcf71dd-d531-42d0-a99d-e8451c840715","type":"point","x":676,"y":132}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"cfe14967-5f58-45fa-a583-4471821d5e54","local_column_attnum":2,"referenced_table_uid":"d594925f-5e0c-4b11-b918-662d00476c91","referenced_column_attnum":1}}}},{"id":"bac5bb9f-a097-4809-95b8-ab1e39125df0","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"d594925f-5e0c-4b11-b918-662d00476c91":{"id":"d594925f-5e0c-4b11-b918-662d00476c91","type":"table","selected":true,"x":435,"y":-30,"ports":[{"id":"ddae41c9-2013-4f10-82d6-4e0b30cc5810","type":"onetomany","x":436,"y":87,"name":"coll-port-2-left","alignment":"left","parentNode":"d594925f-5e0c-4b11-b918-662d00476c91","links":["2d6b558d-f7c7-47e3-aec2-211cf9776459"]},{"id":"4cf33b77-ff61-4caa-b3e1-a4edc8f061a0","type":"onetomany","x":609,"y":87,"name":"coll-port-2-right","alignment":"right","parentNode":"d594925f-5e0c-4b11-b918-662d00476c91","links":[]},{"id":"3973cf6c-aa4a-4d13-b98c-140d9b72e6ec","type":"onetomany","x":436,"y":62,"name":"coll-port-1-left","alignment":"left","parentNode":"d594925f-5e0c-4b11-b918-662d00476c91","links":[]},{"id":"205f2e5f-8d99-4c75-a810-02b0f4cc8623","type":"onetomany","x":609,"y":62,"name":"coll-port-1-right","alignment":"right","parentNode":"d594925f-5e0c-4b11-b918-662d00476c91","links":["932077ca-f780-44d7-875d-e24f8e198a8d"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["ddae41c9-2013-4f10-82d6-4e0b30cc5810","4cf33b77-ff61-4caa-b3e1-a4edc8f061a0","3973cf6c-aa4a-4d13-b98c-140d9b72e6ec","205f2e5f-8d99-4c75-a810-02b0f4cc8623"],"otherInfo":{"data":{"columns":[{"name":"id_akun","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('akun_id_akun_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"akun","is_view_only":false,"seqrelid":17444,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"id_nasabah","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"akun","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"jenis_akun","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"akun","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"saldo","atttypid":1700,"attlen":"12","attnum":4,"attndims":0,"atttypmod":786438,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":"0.00","typname":"numeric","displaytypname":"numeric(12,2)","cltype":"numeric","elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"akun","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"createdat","atttypid":1114,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"akun","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone"]},{"name":"updatedat","atttypid":1114,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"akun","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone"]},{"name":"deletedat","atttypid":1114,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"akun","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone"]}],"name":"akun","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":17452,"name":"akun_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_akun"}],"include":[]}],"foreign_key":[{"name":"akun_id_nasabah_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":17434,"fknsp":"public","fktab":"akun","refnspoid":2200,"refnsp":"public","reftab":"nasabah","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"id_nasabah","references":"a5e0e8c3-4808-4ffb-b0f7-0872baad117f","referenced":"id_nasabah","references_table_name":"public.nasabah"}],"remote_schema":"public","remote_table":"nasabah","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"a5e0e8c3-4808-4ffb-b0f7-0872baad117f":{"id":"a5e0e8c3-4808-4ffb-b0f7-0872baad117f","type":"table","selected":false,"x":135,"y":-90,"ports":[{"id":"483aa495-226b-4073-9956-bbf2a5857cf6","type":"onetomany","x":136,"y":2,"name":"coll-port-1-left","alignment":"left","parentNode":"a5e0e8c3-4808-4ffb-b0f7-0872baad117f","links":[]},{"id":"088fad45-4f34-4842-ba2d-2211e1353ce2","type":"onetomany","x":309,"y":2,"name":"coll-port-1-right","alignment":"right","parentNode":"a5e0e8c3-4808-4ffb-b0f7-0872baad117f","links":["2d6b558d-f7c7-47e3-aec2-211cf9776459"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["483aa495-226b-4073-9956-bbf2a5857cf6","088fad45-4f34-4842-ba2d-2211e1353ce2"],"otherInfo":{"data":{"columns":[{"name":"id_nasabah","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('nasabah_id_nasabah_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"nasabah","is_view_only":false,"seqrelid":17433,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"nama","atttypid":1043,"attlen":"255","attnum":2,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(255)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"nasabah","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"alamat","atttypid":25,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"nasabah","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"no_telp","atttypid":1043,"attlen":"20","attnum":4,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"nasabah","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"createdat","atttypid":1114,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"nasabah","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone"]},{"name":"updatedat","atttypid":1114,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"nasabah","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone"]},{"name":"deletedat","atttypid":1114,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"nasabah","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone"]}],"name":"nasabah","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":17442,"name":"nasabah_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_nasabah"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"cfe14967-5f58-45fa-a583-4471821d5e54":{"id":"cfe14967-5f58-45fa-a583-4471821d5e54","type":"table","selected":false,"x":705,"y":15,"ports":[{"id":"16e7c871-4b78-4c55-bf70-047c05a1be0f","type":"onetomany","x":706,"y":132,"name":"coll-port-2-left","alignment":"left","parentNode":"cfe14967-5f58-45fa-a583-4471821d5e54","links":["932077ca-f780-44d7-875d-e24f8e198a8d"]},{"id":"11e963ab-b548-4800-af22-381235878b0b","type":"onetomany","x":879,"y":132,"name":"coll-port-2-right","alignment":"right","parentNode":"cfe14967-5f58-45fa-a583-4471821d5e54","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["16e7c871-4b78-4c55-bf70-047c05a1be0f","11e963ab-b548-4800-af22-381235878b0b"],"otherInfo":{"data":{"columns":[{"name":"id_transaksi","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('transaksi_id_transaksi_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"transaksi","is_view_only":false,"seqrelid":17459,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"id_akun","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"transaksi","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"jenis_transaksi","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"transaksi","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"jumlah","atttypid":1700,"attlen":"12","attnum":4,"attndims":0,"atttypmod":786438,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(12,2)","cltype":"numeric","elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"transaksi","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"createdat","atttypid":1114,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"transaksi","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone"]},{"name":"updatedat","atttypid":1114,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"transaksi","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone"]},{"name":"deletedat","atttypid":1114,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp without time zone","displaytypname":"timestamp without time zone","cltype":"timestamp without time zone","elemoid":1114,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"transaksi","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","time without time zone","timestamp with time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone","timestamp without time zone"]}],"name":"transaksi","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":17466,"name":"transaksi_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_transaksi"}],"include":[]}],"foreign_key":[{"name":"transaksi_id_akun_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":17445,"fknsp":"public","fktab":"transaksi","refnspoid":2200,"refnsp":"public","reftab":"akun","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"id_akun","references":"d594925f-5e0c-4b11-b918-662d00476c91","referenced":"id_akun","references_table_name":"public.akun"}],"remote_schema":"public","remote_table":"akun","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}