crowdfunding_db_ERD.pgerd

{"version":"61900","data":{"id":"53bbe661-8614-4ce2-8a03-c0b753589d52","offsetX":0,"offsetY":0,"zoom":100,"gridSize":15,"layers":[{"id":"d5f22a0e-12b0-485b-affa-d2c4874fe5ac","type":"diagram-links","isSvg":true,"transformed":true,"models":{"34a491e5-bd13-4067-9604-446e197e0787":{"id":"34a491e5-bd13-4067-9604-446e197e0787","locked":true,"type":"onetomany","selected":false,"source":"d64b73d9-1bc3-48aa-bc21-884058100c99","sourcePort":"740cb79a-4899-4e8b-bc92-d32f282936fb","target":"a8c8b940-dc22-42fb-92e9-1503d52b99df","targetPort":"a2c9813f-d116-49bd-bbca-8ba76b2f5b40","points":[{"id":"e866d8c0-50a2-4094-81c4-97a2b6a42b4f","type":"point","x":410,"y":473},{"id":"d7fa2889-3f35-447f-b392-e5f6bc7e3a1d","type":"point","x":275,"y":473},{"id":"5af0c494-03f0-4392-ac9b-70d160348bab","type":"point","x":275,"y":683}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"a8c8b940-dc22-42fb-92e9-1503d52b99df","local_column_attnum":13,"referenced_table_uid":"d64b73d9-1bc3-48aa-bc21-884058100c99","referenced_column_attnum":1}},"51eba7da-5618-4e4b-bd29-7ccbd458de0d":{"id":"51eba7da-5618-4e4b-bd29-7ccbd458de0d","locked":true,"type":"onetomany","selected":false,"source":"00719586-476b-442b-89ca-f90fd23b75f0","sourcePort":"112e0d55-165b-4e12-8113-5a7e4acfff9d","target":"a8c8b940-dc22-42fb-92e9-1503d52b99df","targetPort":"bcd3b298-6051-4b05-8469-7d4c71fa54fd","points":[{"id":"d4cb972b-595e-4081-bb03-b4a323a17650","type":"point","x":410,"y":242},{"id":"d57f6724-4ab7-495e-89e6-a0f2ede84c4d","type":"point","x":275,"y":242},{"id":"4685c622-9658-4804-8e30-13caae06b3a0","type":"point","x":275,"y":342}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"a8c8b940-dc22-42fb-92e9-1503d52b99df","local_column_attnum":2,"referenced_table_uid":"00719586-476b-442b-89ca-f90fd23b75f0","referenced_column_attnum":1}},"43ba4590-76f6-472c-8016-ecae4ad207c0":{"id":"43ba4590-76f6-472c-8016-ecae4ad207c0","locked":true,"type":"onetomany","selected":false,"source":"6a9d4a1f-a1bf-4255-a021-2974a26ef7eb","sourcePort":"e3e099bd-65e5-490a-aeda-f616a0c0521f","target":"a8c8b940-dc22-42fb-92e9-1503d52b99df","targetPort":"9f7c36a4-8e7a-4088-98a2-ad733b1cb9d4","points":[{"id":"3ccb04e0-c398-42c1-9909-db65dfcf2e97","type":"point","x":410,"y":638},{"id":"c4981bdb-5964-4153-9a45-2fdb1e648e41","type":"point","x":391,"y":638},{"id":"bc1d22a1-9c03-4af6-ab15-df993deaf7e2","type":"point","x":391,"y":720},{"id":"4a36f54c-aa1c-494d-8802-63518e5f38a5","type":"point","x":275,"y":720}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"a8c8b940-dc22-42fb-92e9-1503d52b99df","local_column_attnum":14,"referenced_table_uid":"6a9d4a1f-a1bf-4255-a021-2974a26ef7eb","referenced_column_attnum":1}}}},{"id":"c7dca255-86e6-41c0-a09a-1299586a0750","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"a8c8b940-dc22-42fb-92e9-1503d52b99df":{"id":"a8c8b940-dc22-42fb-92e9-1503d52b99df","type":"table","selected":false,"x":75,"y":225,"ports":[{"id":"b08e68df-1205-4acf-b167-7b18998ef89d","type":"onetomany","x":80,"y":683,"name":"coll-port-13-left","alignment":"left","parentNode":"a8c8b940-dc22-42fb-92e9-1503d52b99df","links":[]},{"id":"a2c9813f-d116-49bd-bbca-8ba76b2f5b40","type":"onetomany","x":245,"y":683,"name":"coll-port-13-right","alignment":"right","parentNode":"a8c8b940-dc22-42fb-92e9-1503d52b99df","links":["34a491e5-bd13-4067-9604-446e197e0787"]},{"id":"cc3ca6ae-dd7f-4126-88d6-4b7708e7447a","type":"onetomany","x":80,"y":342,"name":"coll-port-2-left","alignment":"left","parentNode":"a8c8b940-dc22-42fb-92e9-1503d52b99df","links":[]},{"id":"bcd3b298-6051-4b05-8469-7d4c71fa54fd","type":"onetomany","x":245,"y":342,"name":"coll-port-2-right","alignment":"right","parentNode":"a8c8b940-dc22-42fb-92e9-1503d52b99df","links":["51eba7da-5618-4e4b-bd29-7ccbd458de0d"]},{"id":"289418c1-cbfe-4e47-99bd-574dbe003442","type":"onetomany","x":80,"y":720,"name":"coll-port-14-left","alignment":"left","parentNode":"a8c8b940-dc22-42fb-92e9-1503d52b99df","links":[]},{"id":"9f7c36a4-8e7a-4088-98a2-ad733b1cb9d4","type":"onetomany","x":245,"y":720,"name":"coll-port-14-right","alignment":"right","parentNode":"a8c8b940-dc22-42fb-92e9-1503d52b99df","links":["43ba4590-76f6-472c-8016-ecae4ad207c0"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["b08e68df-1205-4acf-b167-7b18998ef89d","a2c9813f-d116-49bd-bbca-8ba76b2f5b40","cc3ca6ae-dd7f-4126-88d6-4b7708e7447a","bcd3b298-6051-4b05-8469-7d4c71fa54fd","289418c1-cbfe-4e47-99bd-574dbe003442","9f7c36a4-8e7a-4088-98a2-ad733b1cb9d4"],"otherInfo":{"data":{"columns":[{"name":"cf_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"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":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"contact_id","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","relname":"campaign","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","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_name","atttypid":1043,"attlen":"40","attnum":3,"attndims":0,"atttypmod":44,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(40)","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","relname":"campaign","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.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"description","atttypid":1043,"attlen":"75","attnum":4,"attndims":0,"atttypmod":79,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(75)","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","relname":"campaign","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.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"goal","atttypid":701,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"double precision","displaytypname":"double precision","cltype":"double precision","elemoid":701,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","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","integer","numeric","real","smallint"]},{"name":"pledged","atttypid":701,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"double precision","displaytypname":"double precision","cltype":"double precision","elemoid":701,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","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","double precision","integer","numeric","real","smallint"]},{"name":"outcome","atttypid":1043,"attlen":"15","attnum":7,"attndims":0,"atttypmod":19,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(15)","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","relname":"campaign","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","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"backers_count","atttypid":23,"attlen":null,"attnum":8,"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":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","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","integer","money","numeric","oid","real","regclass","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"country","atttypid":1043,"attlen":"2","attnum":9,"attndims":0,"atttypmod":6,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(2)","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","relname":"campaign","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","character varying","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"currency","atttypid":1043,"attlen":"3","attnum":10,"attndims":0,"atttypmod":7,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(3)","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","relname":"campaign","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","character varying","character varying","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"launched_date","atttypid":1082,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","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","timestamp with time zone","timestamp without time zone"]},{"name":"end_date","atttypid":1082,"attlen":null,"attnum":12,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","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","date","timestamp with time zone","timestamp without time zone"]},{"name":"category_id","atttypid":1043,"attlen":"5","attnum":13,"attndims":0,"atttypmod":9,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(5)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","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","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"subcategory_id","atttypid":1043,"attlen":"10","attnum":14,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"campaign","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","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]}],"name":"campaign","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relhasoids":false,"relpersistence":false,"primary_key":[{"oid":17245,"name":"campaign_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"cf_id"}],"include":[]}],"foreign_key":[{"name":"campaign_category_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[13],"confkey":[1],"confrelid":17237,"fknsp":"public","fktab":"campaign","refnspoid":2200,"refnsp":"public","reftab":"category","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"category_id","references":"d64b73d9-1bc3-48aa-bc21-884058100c99","referenced":"category_id","references_table_name":"public.category"}],"remote_schema":"public","remote_table":"category","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"campaign_contact_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":17232,"fknsp":"public","fktab":"campaign","refnspoid":2200,"refnsp":"public","reftab":"contacts","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"contact_id","references":"00719586-476b-442b-89ca-f90fd23b75f0","referenced":"contact_id","references_table_name":"public.contacts"}],"remote_schema":"public","remote_table":"contacts","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"campaign_subcategory_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[14],"confkey":[1],"confrelid":17225,"fknsp":"public","fktab":"campaign","refnspoid":2200,"refnsp":"public","reftab":"subcategory","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"subcategory_id","references":"6a9d4a1f-a1bf-4255-a021-2974a26ef7eb","referenced":"subcategory_id","references_table_name":"public.subcategory"}],"remote_schema":"public","remote_table":"subcategory","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"d64b73d9-1bc3-48aa-bc21-884058100c99":{"id":"d64b73d9-1bc3-48aa-bc21-884058100c99","type":"table","selected":false,"x":435,"y":375,"ports":[{"id":"740cb79a-4899-4e8b-bc92-d32f282936fb","type":"onetomany","x":440,"y":473,"name":"coll-port-1-left","alignment":"left","parentNode":"d64b73d9-1bc3-48aa-bc21-884058100c99","links":["34a491e5-bd13-4067-9604-446e197e0787"]},{"id":"7e425f18-6b1a-4958-9d0b-641e6d10c410","type":"onetomany","x":605,"y":473,"name":"coll-port-1-right","alignment":"right","parentNode":"d64b73d9-1bc3-48aa-bc21-884058100c99","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["740cb79a-4899-4e8b-bc92-d32f282936fb","7e425f18-6b1a-4958-9d0b-641e6d10c410"],"otherInfo":{"data":{"columns":[{"name":"category_id","atttypid":1043,"attlen":"5","attnum":1,"attndims":0,"atttypmod":9,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(5)","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","relname":"category","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"category","atttypid":1043,"attlen":"25","attnum":2,"attndims":0,"atttypmod":29,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(25)","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","relname":"category","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.sql_identifier","information_schema.yes_or_no","name","regclass","text"]}],"name":"category","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relhasoids":false,"relpersistence":false,"primary_key":[{"oid":17240,"name":"category_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"category_id"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"00719586-476b-442b-89ca-f90fd23b75f0":{"id":"00719586-476b-442b-89ca-f90fd23b75f0","type":"table","selected":false,"x":435,"y":150,"ports":[{"id":"112e0d55-165b-4e12-8113-5a7e4acfff9d","type":"onetomany","x":440,"y":242,"name":"coll-port-1-left","alignment":"left","parentNode":"00719586-476b-442b-89ca-f90fd23b75f0","links":["51eba7da-5618-4e4b-bd29-7ccbd458de0d"]},{"id":"697a10ba-ab44-4f08-bef5-5844b7cf77fb","type":"onetomany","x":605,"y":242,"name":"coll-port-1-right","alignment":"right","parentNode":"00719586-476b-442b-89ca-f90fd23b75f0","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["112e0d55-165b-4e12-8113-5a7e4acfff9d","697a10ba-ab44-4f08-bef5-5844b7cf77fb"],"otherInfo":{"data":{"columns":[{"name":"contact_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"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":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","relname":"contacts","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"first_name","atttypid":1043,"attlen":"20","attnum":2,"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","relname":"contacts","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.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"last_name","atttypid":1043,"attlen":"20","attnum":3,"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","relname":"contacts","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.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"email","atttypid":1043,"attlen":"60","attnum":4,"attndims":0,"atttypmod":64,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(60)","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","relname":"contacts","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","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]}],"name":"contacts","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relhasoids":false,"relpersistence":false,"primary_key":[{"oid":17235,"name":"contacts_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"contact_id"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"6a9d4a1f-a1bf-4255-a021-2974a26ef7eb":{"id":"6a9d4a1f-a1bf-4255-a021-2974a26ef7eb","type":"table","selected":false,"x":435,"y":540,"ports":[{"id":"e3e099bd-65e5-490a-aeda-f616a0c0521f","type":"onetomany","x":440,"y":638,"name":"coll-port-1-left","alignment":"left","parentNode":"6a9d4a1f-a1bf-4255-a021-2974a26ef7eb","links":["43ba4590-76f6-472c-8016-ecae4ad207c0"]},{"id":"91bf564d-9c52-46d4-a070-7d31cacb14c9","type":"onetomany","x":605,"y":638,"name":"coll-port-1-right","alignment":"right","parentNode":"6a9d4a1f-a1bf-4255-a021-2974a26ef7eb","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["e3e099bd-65e5-490a-aeda-f616a0c0521f","91bf564d-9c52-46d4-a070-7d31cacb14c9"],"otherInfo":{"data":{"columns":[{"name":"subcategory_id","atttypid":1043,"attlen":"10","attnum":1,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","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","relname":"subcategory","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.sql_identifier","information_schema.yes_or_no","name","regclass","text"]},{"name":"subcategory","atttypid":1043,"attlen":"25","attnum":2,"attndims":0,"atttypmod":29,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(25)","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","relname":"subcategory","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.sql_identifier","information_schema.yes_or_no","name","regclass","text"]}],"name":"subcategory","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relhasoids":false,"relpersistence":false,"primary_key":[{"oid":17228,"name":"subcategory_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"subcategory_id"}],"include":[]}],"unique_constraint":[{"oid":17230,"name":"subcategory_subcategory_key","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"subcategory"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}