-
Notifications
You must be signed in to change notification settings - Fork 0
/
ERD.pgerd
1 lines (1 loc) · 72.3 KB
/
ERD.pgerd
1
{"version":"70500","data":{"id":"7f061412-cdc1-47c4-a3db-8f8cf7b4b0f0","offsetX":551.3943683408631,"offsetY":-224.83358491972788,"zoom":75.92592592592595,"gridSize":15,"layers":[{"id":"983e405a-2679-4d2e-a840-d5c898046f62","type":"diagram-links","isSvg":true,"transformed":true,"models":{"09d9007a-490c-44fd-a3ff-c792df02a510":{"id":"09d9007a-490c-44fd-a3ff-c792df02a510","locked":true,"type":"onetomany","selected":false,"source":"960da489-8e14-45d1-8fc4-74440e6de235","sourcePort":"ba93b814-6e56-4688-b4e5-66522ac937c3","target":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","targetPort":"685cffd0-1a00-4a10-b1cb-a1b8b65e1cc5","points":[{"id":"2bd63b9b-fd93-4343-8e3d-281c41f29b03","type":"point","x":-155.79995038053463,"y":1066.200089747791},{"id":"a3e5c476-e0bf-450c-b473-fe2a188facdc","type":"point","x":-155.79995038053463,"y":1115.7019613204068},{"id":"0fff1e9a-44fb-4fea-9bf5-eb617c6c50f1","type":"point","x":105.8000728425979,"y":1115.7019613204068},{"id":"471351f5-a95d-473b-8e84-7956afec62ff","type":"point","x":105.8000728425979,"y":1115.8000653337285}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","local_column_attnum":3,"referenced_table_uid":"960da489-8e14-45d1-8fc4-74440e6de235","referenced_column_attnum":1}},"f96f7e3c-3bcc-4241-9113-ce985c71f84b":{"id":"f96f7e3c-3bcc-4241-9113-ce985c71f84b","locked":true,"type":"onetomany","selected":false,"source":"3b17f126-e48d-4388-bf8a-96c87d90d965","sourcePort":"997b8218-d828-4a99-b20e-9c3128921eb1","target":"99bdb675-d535-408a-a57d-97d9cd2f092b","targetPort":"c3ca41be-54e9-4dc6-81e7-7c98b42a4ca1","points":[{"id":"bdc5c772-f1af-4915-bbe5-f7968741223f","type":"point","x":135.8000639106238,"y":751.2000227579854},{"id":"d6c74947-1907-43e6-ae56-df521b0fd33c","type":"point","x":99.20001389156896,"y":751.2000227579854},{"id":"f554b350-c89e-4f68-aedc-54af2b768729","type":"point","x":99.20001389156896,"y":751.2000227579854}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"99bdb675-d535-408a-a57d-97d9cd2f092b","local_column_attnum":1,"referenced_table_uid":"3b17f126-e48d-4388-bf8a-96c87d90d965","referenced_column_attnum":1}},"24812b54-8c21-4f20-b4a0-4ec69e421b03":{"id":"24812b54-8c21-4f20-b4a0-4ec69e421b03","locked":true,"type":"onetomany","selected":false,"source":"ed31ac29-b477-48ba-a31d-7069d64003d6","sourcePort":"350e1b23-7b14-4658-8d51-40d46af65399","target":"99bdb675-d535-408a-a57d-97d9cd2f092b","targetPort":"4405dd33-dfe0-4f1a-b525-78931a158aac","points":[{"id":"4441b51c-5e63-4362-b4e3-ba6210305f2f","type":"point","x":84.20005855143938,"y":406.2000249909791},{"id":"4aeeb951-7b52-490b-9505-78a40918b1be","type":"point","x":102.5,"y":406.2000249909791},{"id":"0c5b99a1-a14b-4490-a2b6-8d22981bf742","type":"point","x":104.79227206010812,"y":403.6159184242429},{"id":"a6f8f84b-3eb3-4e3f-ac0f-2d30bc2fc1c0","type":"point","x":104.79227206010812,"y":800.8000385378064},{"id":"b4fdffd8-10d9-4a26-a527-e00af9f5b1db","type":"point","x":99.20001389156896,"y":800.8000385378064}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"99bdb675-d535-408a-a57d-97d9cd2f092b","local_column_attnum":3,"referenced_table_uid":"ed31ac29-b477-48ba-a31d-7069d64003d6","referenced_column_attnum":1}},"b96c2fc0-0a37-4ec5-9fe6-395163a31f31":{"id":"b96c2fc0-0a37-4ec5-9fe6-395163a31f31","locked":true,"type":"onetomany","selected":false,"source":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","sourcePort":"b3cdde8a-4081-47ae-a8e3-6e8ee22d3dda","target":"99bdb675-d535-408a-a57d-97d9cd2f092b","targetPort":"e35e81a2-37a0-4fb6-b653-f673ec4e0dd4","points":[{"id":"63555de3-549d-4eda-933f-7e2db612c666","type":"point","x":-155.79995038053463,"y":811.2000048940372},{"id":"9891a4b8-c9af-4d81-9691-00666d14b256","type":"point","x":-136.59569369421857,"y":811.2000048940372},{"id":"a5b2f24c-42ab-41f4-a783-98797a1ef2ac","type":"point","x":-136.59569369421857,"y":825.600026330775},{"id":"8e168d3d-f10c-4297-9b82-26ee37bae91b","type":"point","x":-134.1999360893761,"y":825.600026330775}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"99bdb675-d535-408a-a57d-97d9cd2f092b","local_column_attnum":4,"referenced_table_uid":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","referenced_column_attnum":1}},"2de55bb1-e43c-4201-9259-cec727a1750b":{"id":"2de55bb1-e43c-4201-9259-cec727a1750b","locked":true,"type":"onetomany","selected":false,"source":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","sourcePort":"86605bee-68f2-4454-87ec-ca5699a4291c","target":"3b17f126-e48d-4388-bf8a-96c87d90d965","targetPort":"9b05ac5f-5574-4c64-9b2b-fd01c98c3b3a","points":[{"id":"b833132b-71b7-40a5-9dec-2c5111c67d02","type":"point","x":339.20002282354295,"y":1066.200089747791},{"id":"d4dd3b6c-5809-4db4-b76f-f24723808823","type":"point","x":368.36813782233594,"y":1066.200089747791},{"id":"d3067538-b584-47f2-bc42-b2d445e6cd02","type":"point","x":368.36813782233594,"y":776.0000105509541},{"id":"e8964e21-6b46-42a0-ae7c-e0daa3f9bf32","type":"point","x":369.20009427933564,"y":776.0000105509541}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"3b17f126-e48d-4388-bf8a-96c87d90d965","local_column_attnum":2,"referenced_table_uid":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","referenced_column_attnum":1}},"6649bbce-5fd5-4ce0-968f-12f33ddcb8b0":{"id":"6649bbce-5fd5-4ce0-968f-12f33ddcb8b0","locked":true,"type":"onetomany","selected":false,"source":"3b17f126-e48d-4388-bf8a-96c87d90d965","sourcePort":"1904842d-c6cd-470f-9480-f7cc61197882","target":"0d063719-bc46-4ab2-8bfb-3b272f9eccff","targetPort":"3a2965b3-921d-4b77-9c9b-0ceec6f698f0","points":[{"id":"0424feb5-372c-4b0a-b1f4-c44cbb67dc60","type":"point","x":369.20009427933564,"y":751.2000227579854},{"id":"9a6ca547-45b2-4895-afb3-ccebb53b5274","type":"point","x":372.79798430573476,"y":751.2000227579854},{"id":"ef0aeb04-1f73-4970-a4e0-9128f60041b5","type":"point","x":372.79798430573476,"y":496.19999819505676},{"id":"8d957530-0227-45bf-ba48-aefcd682590d","type":"point","x":354.20005855143927,"y":496.19999819505676}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"0d063719-bc46-4ab2-8bfb-3b272f9eccff","local_column_attnum":1,"referenced_table_uid":"3b17f126-e48d-4388-bf8a-96c87d90d965","referenced_column_attnum":1}},"7adfe613-5f58-4e61-937e-a49ac9cb4974":{"id":"7adfe613-5f58-4e61-937e-a49ac9cb4974","locked":true,"type":"onetomany","selected":false,"source":"3b17f126-e48d-4388-bf8a-96c87d90d965","sourcePort":"1904842d-c6cd-470f-9480-f7cc61197882","target":"47a020d7-8225-4360-8a48-9b4ec2f9a19a","targetPort":"e77459cc-a175-4494-9ed9-28076480e59f","points":[{"id":"90f3db57-dc30-4408-8211-96d98e42475f","type":"point","x":369.20009427933564,"y":751.2000227579854},{"id":"0c362aea-7f70-48f2-a2e3-b581db2aed23","type":"point","x":369.20009427933564,"y":750.6506485130164},{"id":"bf05bd35-df6e-4779-a739-195a7db04bb2","type":"point","x":405.8000639106237,"y":750.6506485130164},{"id":"c683fc55-8cc4-40bb-91bf-579e2e6a04a1","type":"point","x":405.8000639106237,"y":761.0000552108246}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"47a020d7-8225-4360-8a48-9b4ec2f9a19a","local_column_attnum":2,"referenced_table_uid":"3b17f126-e48d-4388-bf8a-96c87d90d965","referenced_column_attnum":1}},"73de5c3b-f999-4c43-8e70-dfcd32d72d21":{"id":"73de5c3b-f999-4c43-8e70-dfcd32d72d21","locked":true,"type":"onetomany","selected":false,"source":"960da489-8e14-45d1-8fc4-74440e6de235","sourcePort":"ba93b814-6e56-4688-b4e5-66522ac937c3","target":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","targetPort":"53dcb1fe-bcac-47fc-ad61-dcbda838b6ca","points":[{"id":"623da32d-ef19-4ae2-b567-f94416f90c4c","type":"point","x":-155.79995038053463,"y":1066.200089747791},{"id":"fddbad61-bcd4-4754-b8b9-3741887004be","type":"point","x":-138.84928452682516,"y":1066.200089747791},{"id":"82c036cf-0403-46b0-add6-d528977b9b65","type":"point","x":-138.84928452682516,"y":836.0000328808894},{"id":"30a81a8c-c1ef-40d3-b695-b4011cc69bd8","type":"point","x":-155.79995038053463,"y":836.0000328808894}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","local_column_attnum":2,"referenced_table_uid":"960da489-8e14-45d1-8fc4-74440e6de235","referenced_column_attnum":1}}}},{"id":"c7e9d2dc-a458-45c5-bc08-d2ee7a39ce7b","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"cae393e5-b406-44e3-94d0-ba4d38e4aa62":{"id":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","type":"table","selected":false,"x":135,"y":975,"ports":[{"id":"685cffd0-1a00-4a10-b1cb-a1b8b65e1cc5","type":"onetomany","x":135.8000728425979,"y":1115.8000653337285,"name":"coll-port-3-left","alignment":"left","parentNode":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","links":["09d9007a-490c-44fd-a3ff-c792df02a510"]},{"id":"01ab7497-725c-45fa-9aa2-135c20a5533f","type":"onetomany","x":309.20002282354295,"y":1115.8000653337285,"name":"coll-port-3-right","alignment":"right","parentNode":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","links":[]},{"id":"72769055-d4a2-4422-b1dc-e05b46fb8bfa","type":"onetomany","x":135.8000728425979,"y":1066.200089747791,"name":"coll-port-1-left","alignment":"left","parentNode":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","links":[]},{"id":"86605bee-68f2-4454-87ec-ca5699a4291c","type":"onetomany","x":309.20002282354295,"y":1066.200089747791,"name":"coll-port-1-right","alignment":"right","parentNode":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","links":["2de55bb1-e43c-4201-9259-cec727a1750b"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["685cffd0-1a00-4a10-b1cb-a1b8b65e1cc5","01ab7497-725c-45fa-9aa2-135c20a5533f","72769055-d4a2-4422-b1dc-e05b46fb8bfa","86605bee-68f2-4454-87ec-ca5699a4291c"],"otherInfo":{"data":{"columns":[{"name":"customer_id","atttypid":1043,"attlen":"32","attnum":1,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","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":"customers","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.yes_or_no","name","regclass","text"]},{"name":"customer_unique_id","atttypid":1043,"attlen":"32","attnum":2,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","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":"customers","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":"zip_code_prefix","atttypid":23,"attlen":null,"attnum":3,"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":"customers","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"customer_city","atttypid":1043,"attlen":"255","attnum":4,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":false,"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":"customers","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.yes_or_no","name","regclass","text"]},{"name":"customer_state","atttypid":1043,"attlen":"2","attnum":5,"attndims":0,"atttypmod":6,"attacl":[],"attnotnull":false,"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","genexpr":null,"relname":"customers","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.yes_or_no","name","regclass","text"]}],"name":"customers","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16974,"name":"customers_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"customer_id"}],"include":[]}],"foreign_key":[{"name":"fk_zip_code_prefix","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16937,"fknsp":"public","fktab":"customers","refnspoid":2200,"refnsp":"public","reftab":"geolocations","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"zip_code_prefix","references":"960da489-8e14-45d1-8fc4-74440e6de235","referenced":"zip_code_prefix","references_table_name":"public.geolocations"}],"remote_schema":"public","remote_table":"geolocations","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"960da489-8e14-45d1-8fc4-74440e6de235":{"id":"960da489-8e14-45d1-8fc4-74440e6de235","type":"table","selected":false,"x":-360,"y":975,"ports":[{"id":"a52d00dc-ba1b-4d4c-b260-f2cb9c67c52f","type":"onetomany","x":-359.19998074924644,"y":1066.200089747791,"name":"coll-port-1-left","alignment":"left","parentNode":"960da489-8e14-45d1-8fc4-74440e6de235","links":[]},{"id":"ba93b814-6e56-4688-b4e5-66522ac937c3","type":"onetomany","x":-185.79995038053463,"y":1066.200089747791,"name":"coll-port-1-right","alignment":"right","parentNode":"960da489-8e14-45d1-8fc4-74440e6de235","links":["09d9007a-490c-44fd-a3ff-c792df02a510","73de5c3b-f999-4c43-8e70-dfcd32d72d21"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["a52d00dc-ba1b-4d4c-b260-f2cb9c67c52f","ba93b814-6e56-4688-b4e5-66522ac937c3"],"otherInfo":{"data":{"columns":[{"name":"zip_code_prefix","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","genexpr":null,"relname":"geolocations","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","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"lat","atttypid":1700,"attlen":"10","attnum":2,"attndims":0,"atttypmod":655372,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,8)","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":"geolocations","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":"8","edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"lng","atttypid":1700,"attlen":"11","attnum":3,"attndims":0,"atttypmod":720908,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(11,8)","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":"geolocations","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":"8","edit_types":["bigint","double precision","integer","money","numeric","numeric","numeric","real","smallint"]},{"name":"city","atttypid":1043,"attlen":"255","attnum":4,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":false,"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":"geolocations","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":"state","atttypid":1043,"attlen":"2","attnum":5,"attndims":0,"atttypmod":6,"attacl":[],"attnotnull":false,"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","genexpr":null,"relname":"geolocations","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":"geolocations","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":17023,"name":"geolocations_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"zip_code_prefix"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"99bdb675-d535-408a-a57d-97d9cd2f092b":{"id":"99bdb675-d535-408a-a57d-97d9cd2f092b","type":"table","selected":false,"x":-105,"y":660,"ports":[{"id":"5897dc1f-ec72-4daf-8a38-d28753eee259","type":"onetomany","x":-104.19993608937611,"y":751.2000227579854,"name":"coll-port-1-left","alignment":"left","parentNode":"99bdb675-d535-408a-a57d-97d9cd2f092b","links":[]},{"id":"c3ca41be-54e9-4dc6-81e7-7c98b42a4ca1","type":"onetomany","x":69.20001389156896,"y":751.2000227579854,"name":"coll-port-1-right","alignment":"right","parentNode":"99bdb675-d535-408a-a57d-97d9cd2f092b","links":["f96f7e3c-3bcc-4241-9113-ce985c71f84b"]},{"id":"83acefff-b67e-4015-a76a-4897f0f6fc89","type":"onetomany","x":-104.19993608937611,"y":800.8000385378064,"name":"coll-port-3-left","alignment":"left","parentNode":"99bdb675-d535-408a-a57d-97d9cd2f092b","links":[]},{"id":"4405dd33-dfe0-4f1a-b525-78931a158aac","type":"onetomany","x":69.20001389156896,"y":800.8000385378064,"name":"coll-port-3-right","alignment":"right","parentNode":"99bdb675-d535-408a-a57d-97d9cd2f092b","links":["24812b54-8c21-4f20-b4a0-4ec69e421b03"]},{"id":"e35e81a2-37a0-4fb6-b653-f673ec4e0dd4","type":"onetomany","x":-104.19993608937611,"y":825.600026330775,"name":"coll-port-4-left","alignment":"left","parentNode":"99bdb675-d535-408a-a57d-97d9cd2f092b","links":["b96c2fc0-0a37-4ec5-9fe6-395163a31f31"]},{"id":"b5589203-0da3-4a5d-8eea-1dee34d9ff47","type":"onetomany","x":69.20001389156896,"y":825.600026330775,"name":"coll-port-4-right","alignment":"right","parentNode":"99bdb675-d535-408a-a57d-97d9cd2f092b","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["5897dc1f-ec72-4daf-8a38-d28753eee259","c3ca41be-54e9-4dc6-81e7-7c98b42a4ca1","83acefff-b67e-4015-a76a-4897f0f6fc89","4405dd33-dfe0-4f1a-b525-78931a158aac","e35e81a2-37a0-4fb6-b653-f673ec4e0dd4","b5589203-0da3-4a5d-8eea-1dee34d9ff47"],"otherInfo":{"data":{"columns":[{"name":"order_id","atttypid":1043,"attlen":"32","attnum":1,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_items","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":"order_item_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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_items","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"product_id","atttypid":1043,"attlen":"32","attnum":3,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_items","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":"seller_id","atttypid":1043,"attlen":"32","attnum":4,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_items","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.yes_or_no","name","regclass","text"]},{"name":"shipping_limit_date","atttypid":1114,"attlen":null,"attnum":5,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_items","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":"price","atttypid":1700,"attlen":"10","attnum":6,"attndims":0,"atttypmod":655366,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,2)","cltype":"numeric","elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_items","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":"freight_value","atttypid":1700,"attlen":"10","attnum":7,"attndims":0,"atttypmod":655366,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,2)","cltype":"numeric","elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_items","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","numeric","real","smallint"]}],"name":"order_items","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"foreign_key":[{"name":"fk_order_id","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":16955,"fknsp":"public","fktab":"order_items","refnspoid":2200,"refnsp":"public","reftab":"orders","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"order_id","references":"3b17f126-e48d-4388-bf8a-96c87d90d965","referenced":"order_id","references_table_name":"public.orders"}],"remote_schema":"public","remote_table":"orders","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_product_id","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16958,"fknsp":"public","fktab":"order_items","refnspoid":2200,"refnsp":"public","reftab":"products","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"product_id","references":"ed31ac29-b477-48ba-a31d-7069d64003d6","referenced":"product_id","references_table_name":"public.products"}],"remote_schema":"public","remote_table":"products","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_seller_id","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[4],"confkey":[1],"confrelid":16961,"fknsp":"public","fktab":"order_items","refnspoid":2200,"refnsp":"public","reftab":"sellers","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"seller_id","references":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","referenced":"seller_id","references_table_name":"public.sellers"}],"remote_schema":"public","remote_table":"sellers","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"3b17f126-e48d-4388-bf8a-96c87d90d965":{"id":"3b17f126-e48d-4388-bf8a-96c87d90d965","type":"table","selected":false,"x":165,"y":660,"ports":[{"id":"997b8218-d828-4a99-b20e-9c3128921eb1","type":"onetomany","x":165.8000639106238,"y":751.2000227579854,"name":"coll-port-1-left","alignment":"left","parentNode":"3b17f126-e48d-4388-bf8a-96c87d90d965","links":["f96f7e3c-3bcc-4241-9113-ce985c71f84b"]},{"id":"1904842d-c6cd-470f-9480-f7cc61197882","type":"onetomany","x":339.20009427933564,"y":751.2000227579854,"name":"coll-port-1-right","alignment":"right","parentNode":"3b17f126-e48d-4388-bf8a-96c87d90d965","links":["7adfe613-5f58-4e61-937e-a49ac9cb4974","6649bbce-5fd5-4ce0-968f-12f33ddcb8b0"]},{"id":"4334f207-48cb-4601-90db-0428aaa5e99a","type":"onetomany","x":165.8000639106238,"y":776.0000105509541,"name":"coll-port-2-left","alignment":"left","parentNode":"3b17f126-e48d-4388-bf8a-96c87d90d965","links":[]},{"id":"9b05ac5f-5574-4c64-9b2b-fd01c98c3b3a","type":"onetomany","x":339.20009427933564,"y":776.0000105509541,"name":"coll-port-2-right","alignment":"right","parentNode":"3b17f126-e48d-4388-bf8a-96c87d90d965","links":["2de55bb1-e43c-4201-9259-cec727a1750b"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["997b8218-d828-4a99-b20e-9c3128921eb1","1904842d-c6cd-470f-9480-f7cc61197882","4334f207-48cb-4601-90db-0428aaa5e99a","9b05ac5f-5574-4c64-9b2b-fd01c98c3b3a"],"otherInfo":{"data":{"columns":[{"name":"order_id","atttypid":1043,"attlen":"32","attnum":1,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","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":"orders","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.yes_or_no","name","regclass","text"]},{"name":"customer_id","atttypid":1043,"attlen":"32","attnum":2,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","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","genexpr":null,"relname":"orders","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":"status","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"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":"orders","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.yes_or_no","name","regclass","text"]},{"name":"purchase_timestamp","atttypid":1114,"attlen":null,"attnum":4,"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":"orders","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":"approved_at","atttypid":1114,"attlen":null,"attnum":5,"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":"orders","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":"delivered_carrier_date","atttypid":1114,"attlen":null,"attnum":6,"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":"orders","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":"delivered_customer_date","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":"orders","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","timestamp without time zone"]},{"name":"estimated_delivery_date","atttypid":1114,"attlen":null,"attnum":8,"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":"orders","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","timestamp without time zone","timestamp without time zone"]}],"name":"orders","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16976,"name":"orders_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"order_id"}],"include":[]}],"foreign_key":[{"name":"fk_customer_id","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16934,"fknsp":"public","fktab":"orders","refnspoid":2200,"refnsp":"public","reftab":"customers","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"customer_id","references":"cae393e5-b406-44e3-94d0-ba4d38e4aa62","referenced":"customer_id","references_table_name":"public.customers"}],"remote_schema":"public","remote_table":"customers","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"0d063719-bc46-4ab2-8bfb-3b272f9eccff":{"id":"0d063719-bc46-4ab2-8bfb-3b272f9eccff","type":"table","selected":false,"x":150,"y":405,"ports":[{"id":"3ffd946a-a304-48f9-8afa-85e6e0ce8e32","type":"onetomany","x":150.80002818272746,"y":496.19999819505676,"name":"coll-port-1-left","alignment":"left","parentNode":"0d063719-bc46-4ab2-8bfb-3b272f9eccff","links":[]},{"id":"3a2965b3-921d-4b77-9c9b-0ceec6f698f0","type":"onetomany","x":324.20005855143927,"y":496.19999819505676,"name":"coll-port-1-right","alignment":"right","parentNode":"0d063719-bc46-4ab2-8bfb-3b272f9eccff","links":["6649bbce-5fd5-4ce0-968f-12f33ddcb8b0"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["3ffd946a-a304-48f9-8afa-85e6e0ce8e32","3a2965b3-921d-4b77-9c9b-0ceec6f698f0"],"otherInfo":{"data":{"columns":[{"name":"order_id","atttypid":1043,"attlen":"32","attnum":1,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"payments","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":"sequential","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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"payments","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"type","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"payments","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":"installments","atttypid":23,"attlen":null,"attnum":4,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"payments","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":"value","atttypid":1700,"attlen":"10","attnum":5,"attndims":0,"atttypmod":655366,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,2)","cltype":"numeric","elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"payments","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":"payments","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"foreign_key":[{"name":"fk_order_id","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":16955,"fknsp":"public","fktab":"payments","refnspoid":2200,"refnsp":"public","reftab":"orders","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"order_id","references":"3b17f126-e48d-4388-bf8a-96c87d90d965","referenced":"order_id","references_table_name":"public.orders"}],"remote_schema":"public","remote_table":"orders","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"ed31ac29-b477-48ba-a31d-7069d64003d6":{"id":"ed31ac29-b477-48ba-a31d-7069d64003d6","type":"table","selected":false,"x":-120,"y":315,"ports":[{"id":"3216c870-b490-40cd-a6d1-c0b67d156e5a","type":"onetomany","x":-119.19997181727244,"y":406.2000249909791,"name":"coll-port-1-left","alignment":"left","parentNode":"ed31ac29-b477-48ba-a31d-7069d64003d6","links":[]},{"id":"350e1b23-7b14-4658-8d51-40d46af65399","type":"onetomany","x":54.20005855143938,"y":406.2000249909791,"name":"coll-port-1-right","alignment":"right","parentNode":"ed31ac29-b477-48ba-a31d-7069d64003d6","links":["24812b54-8c21-4f20-b4a0-4ec69e421b03"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["3216c870-b490-40cd-a6d1-c0b67d156e5a","350e1b23-7b14-4658-8d51-40d46af65399"],"otherInfo":{"data":{"columns":[{"name":"product_id","atttypid":1043,"attlen":"32","attnum":1,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","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":"products","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.yes_or_no","name","regclass","text"]},{"name":"category_name","atttypid":1043,"attlen":"255","attnum":2,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":false,"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":"products","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":"name_length","atttypid":23,"attlen":null,"attnum":3,"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","genexpr":null,"relname":"products","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"description_length","atttypid":23,"attlen":null,"attnum":4,"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","genexpr":null,"relname":"products","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":"photos_qty","atttypid":23,"attlen":null,"attnum":5,"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","genexpr":null,"relname":"products","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","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"weight_g","atttypid":23,"attlen":null,"attnum":6,"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","genexpr":null,"relname":"products","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"length_cm","atttypid":23,"attlen":null,"attnum":7,"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","genexpr":null,"relname":"products","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"height_cm","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","genexpr":null,"relname":"products","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","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"width_cm","atttypid":23,"attlen":null,"attnum":9,"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","genexpr":null,"relname":"products","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","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"products","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16985,"name":"products_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"product_id"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"47a020d7-8225-4360-8a48-9b4ec2f9a19a":{"id":"47a020d7-8225-4360-8a48-9b4ec2f9a19a","type":"table","selected":false,"x":435,"y":645,"ports":[{"id":"e77459cc-a175-4494-9ed9-28076480e59f","type":"onetomany","x":435.8000639106237,"y":761.0000552108246,"name":"coll-port-2-left","alignment":"left","parentNode":"47a020d7-8225-4360-8a48-9b4ec2f9a19a","links":["7adfe613-5f58-4e61-937e-a49ac9cb4974"]},{"id":"59f40543-eee0-4a0e-95bf-a9e80f1cc6c0","type":"onetomany","x":609.2000942793355,"y":761.0000552108246,"name":"coll-port-2-right","alignment":"right","parentNode":"47a020d7-8225-4360-8a48-9b4ec2f9a19a","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["e77459cc-a175-4494-9ed9-28076480e59f","59f40543-eee0-4a0e-95bf-a9e80f1cc6c0"],"otherInfo":{"data":{"columns":[{"name":"review_id","atttypid":1043,"attlen":"32","attnum":1,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"reviews","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"],"cid":"c53"},{"name":"order_id","atttypid":1043,"attlen":"32","attnum":2,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"reviews","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"],"cid":"c54"},{"name":"score","atttypid":23,"attlen":null,"attnum":3,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"reviews","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c55"},{"name":"comment_title","atttypid":1043,"attlen":"255","attnum":4,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"reviews","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.yes_or_no","name","regclass","text"],"cid":"c56"},{"name":"comment_message","atttypid":25,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"reviews","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"],"cid":"c57"},{"name":"creation_date","atttypid":1114,"attlen":null,"attnum":6,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"reviews","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"],"cid":"c58"},{"name":"answer_timestamp","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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"reviews","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"],"cid":"c59"}],"name":"reviews","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"foreign_key":[{"name":"fk_order_id","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16955,"fknsp":"public","fktab":"reviews","refnspoid":2200,"refnsp":"public","reftab":"orders","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"order_id","references":"3b17f126-e48d-4388-bf8a-96c87d90d965","referenced":"order_id","references_table_name":"public.orders","cid":"c52"}],"remote_schema":"public","remote_table":"orders","coveringindex":null,"autoindex":false,"hasindex":false,"cid":"c51"}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"42fa85db-dbfc-480c-8278-5b8a512f9b4d":{"id":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","type":"table","selected":false,"x":-360,"y":720,"ports":[{"id":"4bb55b9d-a78e-4526-93bf-32736e4aaaa4","type":"onetomany","x":-359.19998074924644,"y":811.2000048940372,"name":"coll-port-1-left","alignment":"left","parentNode":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","links":[]},{"id":"b3cdde8a-4081-47ae-a8e3-6e8ee22d3dda","type":"onetomany","x":-185.79995038053463,"y":811.2000048940372,"name":"coll-port-1-right","alignment":"right","parentNode":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","links":["b96c2fc0-0a37-4ec5-9fe6-395163a31f31"]},{"id":"a55b0289-0bc5-4cf5-8c8a-5730da9f40ac","type":"onetomany","x":-359.19998074924644,"y":836.0000328808894,"name":"coll-port-2-left","alignment":"left","parentNode":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","links":[]},{"id":"53dcb1fe-bcac-47fc-ad61-dcbda838b6ca","type":"onetomany","x":-185.79995038053463,"y":836.0000328808894,"name":"coll-port-2-right","alignment":"right","parentNode":"42fa85db-dbfc-480c-8278-5b8a512f9b4d","links":["73de5c3b-f999-4c43-8e70-dfcd32d72d21"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["4bb55b9d-a78e-4526-93bf-32736e4aaaa4","b3cdde8a-4081-47ae-a8e3-6e8ee22d3dda","a55b0289-0bc5-4cf5-8c8a-5730da9f40ac","53dcb1fe-bcac-47fc-ad61-dcbda838b6ca"],"otherInfo":{"data":{"columns":[{"name":"seller_id","atttypid":1043,"attlen":"32","attnum":1,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","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":"sellers","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.yes_or_no","name","regclass","text"]},{"name":"zip_code_prefix","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":"sellers","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"city","atttypid":1043,"attlen":"255","attnum":3,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":false,"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":"sellers","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":"state","atttypid":1043,"attlen":"2","attnum":4,"attndims":0,"atttypmod":6,"attacl":[],"attnotnull":false,"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","genexpr":null,"relname":"sellers","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.yes_or_no","name","regclass","text"]}],"name":"sellers","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16989,"name":"sellers_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"seller_id"}],"include":[]}],"foreign_key":[{"name":"fk_zip_code_prefix","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16937,"fknsp":"public","fktab":"sellers","refnspoid":2200,"refnsp":"public","reftab":"geolocations","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"zip_code_prefix","references":"960da489-8e14-45d1-8fc4-74440e6de235","referenced":"zip_code_prefix","references_table_name":"public.geolocations"}],"remote_schema":"public","remote_table":"geolocations","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}