-
Notifications
You must be signed in to change notification settings - Fork 0
/
ERD Final.pgerd
1 lines (1 loc) · 82.8 KB
/
ERD Final.pgerd
1
{"version":"61900","data":{"id":"63e8acc9-f680-4a47-963b-b8e676c0ee6d","offsetX":660.8948489013943,"offsetY":-157.0050928040621,"zoom":63.54276546522835,"gridSize":15,"layers":[{"id":"7dfca466-14ce-44ef-9cf0-21d3c14570d6","type":"diagram-links","isSvg":true,"transformed":true,"models":{"a0c25825-e71d-4142-9cfa-3f6648d218d2":{"id":"a0c25825-e71d-4142-9cfa-3f6648d218d2","locked":true,"type":"onetomany","selected":false,"source":"fe6080ca-4200-4368-9602-8ad72c801655","sourcePort":"aae94548-b462-4ab4-a2b6-080b51773f05","target":"190baa3e-472d-481d-b8f2-f0a98aa546a7","targetPort":"5762b5fa-41b4-496d-8b13-ccb898a0625c","points":[{"id":"8bf10776-0dd1-40a6-b6c2-5ceb6284631d","type":"point","x":-205.00000742882955,"y":922.9999795456962},{"id":"0bcc2672-2e3b-467b-8ec3-9b7dd2c734e6","type":"point","x":-197.7045549954774,"y":922.9999795456962},{"id":"e36a5df0-98b3-4042-bb65-53917ab74f94","type":"point","x":-197.7045549954774,"y":861.8929215092846},{"id":"390b4d9c-b2dc-4c3f-9452-4abda17a2a20","type":"point","x":-170.1858890565892,"y":861.8929215092846},{"id":"d9b97d59-5ddc-4195-b00e-42239981aef2","type":"point","x":-170.1858890565892,"y":861.9999835028773},{"id":"cd5222f2-28b7-49d3-a9e3-899df3076339","type":"point","x":-174.99997481355314,"y":861.9999835028773}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"190baa3e-472d-481d-b8f2-f0a98aa546a7","local_column_attnum":3,"referenced_table_uid":"fe6080ca-4200-4368-9602-8ad72c801655","referenced_column_attnum":1}},"b19a5b30-181d-4b7f-a495-1bd9bc68a1fb":{"id":"b19a5b30-181d-4b7f-a495-1bd9bc68a1fb","locked":true,"type":"onetomany","selected":false,"source":"a829c4e9-5a2c-48bf-8448-25b855575db9","sourcePort":"cdce9635-455b-4727-a8fa-d68aa3c96d9a","target":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","targetPort":"2ddcda71-cf5e-452b-8228-1e8242ba6cfc","points":[{"id":"26eb6575-56ec-4af8-8b30-5f70903d7975","type":"point","x":80.00008126826859,"y":646.9999718751342},{"id":"efd98ca9-c1d4-465a-8f56-959bbabe1322","type":"point","x":71.7970275137643,"y":646.9999718751342},{"id":"9c77815c-44a2-4e46-b49d-0fa38b601ebd","type":"point","x":71.7970275137643,"y":526.9999787594298},{"id":"7c587dd2-45e2-47a0-8d72-f29b56a1f3c7","type":"point","x":50.00008471041632,"y":526.9999787594298}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","local_column_attnum":1,"referenced_table_uid":"a829c4e9-5a2c-48bf-8448-25b855575db9","referenced_column_attnum":1}},"8463fb59-a4b9-42e5-9f0f-5a0a597c51d8":{"id":"8463fb59-a4b9-42e5-9f0f-5a0a597c51d8","locked":true,"type":"onetomany","selected":false,"source":"d26b5fcb-9ef8-441f-a797-e8f92eb44940","sourcePort":"603de383-17d5-4a6e-abac-0a200f7b2e0a","target":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","targetPort":"21480ec6-babf-4612-ab12-b5fdc804e2b0","points":[{"id":"f2bd766c-44b4-46fd-b61f-d4e676d1f065","type":"point","x":-204.9999713714054,"y":386.9999994752823},{"id":"22d6b3c6-8ad9-45d3-88c6-b7c3c1de1577","type":"point","x":-194.98672548594686,"y":386.9999994752823},{"id":"19b32e19-fd72-47cc-bfdc-ffa259f05cb5","type":"point","x":-194.98672548594686,"y":577.0000207368413},{"id":"393cbe63-d180-4e29-8796-839013dc1d0b","type":"point","x":-174.99997481355314,"y":577.0000207368413}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","local_column_attnum":3,"referenced_table_uid":"d26b5fcb-9ef8-441f-a797-e8f92eb44940","referenced_column_attnum":2}},"5679f28c-7160-4a9e-b79d-7356db9f5d79":{"id":"5679f28c-7160-4a9e-b79d-7356db9f5d79","locked":true,"type":"onetomany","selected":false,"source":"b0a249de-2c05-44f2-ab30-18932294f82a","sourcePort":"69ad1510-4acf-4bab-96e0-ed5e231be257","target":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","targetPort":"b3156264-6a6a-45e6-8c19-e6fa1a07459d","points":[{"id":"580ad906-c32d-472e-9400-f811a799e19a","type":"point","x":-205.00000742882958,"y":721.9999931117275},{"id":"bb9f7de2-7322-4a2b-9e3f-14e024f5a982","type":"point","x":-202.95712278082905,"y":721.9999931117275},{"id":"ef7cda09-5ac3-462b-b396-690854728061","type":"point","x":-202.95712278082905,"y":602.0000022248028},{"id":"126ecfd8-a7f4-4ce3-b608-0d7cc08dcdbb","type":"point","x":-174.99997481355314,"y":602.0000022248028}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","local_column_attnum":4,"referenced_table_uid":"b0a249de-2c05-44f2-ab30-18932294f82a","referenced_column_attnum":1}},"ada17c4a-ffd6-4caa-845e-9fc726f06a55":{"id":"ada17c4a-ffd6-4caa-845e-9fc726f06a55","locked":true,"type":"onetomany","selected":false,"source":"a829c4e9-5a2c-48bf-8448-25b855575db9","sourcePort":"675bffa2-6219-44f4-b460-e4a79cafdd84","target":"1f664c00-00f1-48e4-815d-621745a95cf5","targetPort":"54d62039-b7e9-4f5d-b9fd-76ed261b830a","points":[{"id":"b493bcf5-f6ac-426c-a9dc-14fa655959c1","type":"point","x":305.00006179074967,"y":646.9999718751342},{"id":"371eb7af-36c9-4fdc-a335-37e2dd48ad26","type":"point","x":316.0067706442691,"y":646.9999718751342},{"id":"35438ead-e149-462f-a1a7-708b5c421ff1","type":"point","x":316.0067706442691,"y":991.9999724208408},{"id":"c0aaf18a-e0cd-487f-b529-1689cf598cc1","type":"point","x":305.00006179074967,"y":991.9999724208408}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"1f664c00-00f1-48e4-815d-621745a95cf5","local_column_attnum":1,"referenced_table_uid":"a829c4e9-5a2c-48bf-8448-25b855575db9","referenced_column_attnum":1}},"b3e3a30e-2567-4e03-a652-821ea9132081":{"id":"b3e3a30e-2567-4e03-a652-821ea9132081","locked":true,"type":"onetomany","selected":false,"source":"a829c4e9-5a2c-48bf-8448-25b855575db9","sourcePort":"675bffa2-6219-44f4-b460-e4a79cafdd84","target":"49ec9f86-3b10-40ce-88b8-2daf7575b537","targetPort":"ea696a99-38c2-469e-a992-d30c97a0e3b8","points":[{"id":"5a505fd9-cf01-458e-a6c9-ebfa0bd91f56","type":"point","x":305.00006179074967,"y":646.9999718751342},{"id":"cd565c76-4b5c-4a5a-92ee-5069b2654927","type":"point","x":313.9545879288867,"y":646.9999718751342},{"id":"062b53d7-39d1-4697-b03f-b2fd75b31708","type":"point","x":313.9545879288867,"y":386.9999636895391},{"id":"15c4d8e6-4945-437e-b267-f93dfd9d7575","type":"point","x":305.00006179074967,"y":386.9999636895391}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"49ec9f86-3b10-40ce-88b8-2daf7575b537","local_column_attnum":2,"referenced_table_uid":"a829c4e9-5a2c-48bf-8448-25b855575db9","referenced_column_attnum":1}},"f086f595-f882-4ac2-93dc-8388834c3926":{"id":"f086f595-f882-4ac2-93dc-8388834c3926","locked":true,"type":"onetomany","selected":false,"source":"190baa3e-472d-481d-b8f2-f0a98aa546a7","sourcePort":"e28dc185-f81c-4d09-9202-f5a44c3e1fef","target":"a829c4e9-5a2c-48bf-8448-25b855575db9","targetPort":"e37fbe7e-db21-42ff-8757-2abf53dd3db4","points":[{"id":"ef0ee280-6234-4e32-8909-feda66d0a872","type":"point","x":50.00008471041632,"y":812.0000205269542},{"id":"2471d3f5-5101-45fe-943c-dc2acc76c735","type":"point","x":67.69266208299952,"y":812.0000205269542},{"id":"0492814e-e9f2-45dc-8a9b-f66cbd81cfb6","type":"point","x":67.69266208299952,"y":671.9999928638399},{"id":"a1daecdb-c6f5-4466-b0de-f900ecfc85c3","type":"point","x":80.00008126826859,"y":671.9999928638399}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"a829c4e9-5a2c-48bf-8448-25b855575db9","local_column_attnum":2,"referenced_table_uid":"190baa3e-472d-481d-b8f2-f0a98aa546a7","referenced_column_attnum":1}},"bf0ccbc5-4b4a-45b2-ad3d-282e609add89":{"id":"bf0ccbc5-4b4a-45b2-ad3d-282e609add89","locked":true,"type":"onetomany","selected":false,"source":"fe6080ca-4200-4368-9602-8ad72c801655","sourcePort":"aae94548-b462-4ab4-a2b6-080b51773f05","target":"b0a249de-2c05-44f2-ab30-18932294f82a","targetPort":"b9596e9b-302c-4880-8ff6-19fba2cde879","points":[{"id":"8411a42c-ddd7-46e2-ac8a-a86df0944824","type":"point","x":-205.00000742882955,"y":922.9999795456962},{"id":"6483a4f7-2238-4060-bfae-ecda31a8b93d","type":"point","x":-198.95540344724506,"y":922.9999795456962},{"id":"06d750ee-84a2-49cf-af7c-1bc48c5b6353","type":"point","x":-198.95540344724506,"y":747.0000197140505},{"id":"ac1b23c0-b2b2-4f62-ac6a-80e9686f6b34","type":"point","x":-205.00000742882958,"y":747.0000197140505}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"b0a249de-2c05-44f2-ab30-18932294f82a","local_column_attnum":2,"referenced_table_uid":"fe6080ca-4200-4368-9602-8ad72c801655","referenced_column_attnum":1}}}},{"id":"0e90250c-dda6-4769-84ce-1e1af33a79be","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"190baa3e-472d-481d-b8f2-f0a98aa546a7":{"id":"190baa3e-472d-481d-b8f2-f0a98aa546a7","type":"table","selected":false,"x":-150,"y":720,"ports":[{"id":"5762b5fa-41b4-496d-8b13-ccb898a0625c","type":"onetomany","x":-144.99997481355314,"y":861.9999835028773,"name":"coll-port-3-left","alignment":"left","parentNode":"190baa3e-472d-481d-b8f2-f0a98aa546a7","links":["a0c25825-e71d-4142-9cfa-3f6648d218d2"]},{"id":"ec010d24-005b-4c64-ad62-93dfadeba373","type":"onetomany","x":20.00008471041632,"y":861.9999835028773,"name":"coll-port-3-right","alignment":"right","parentNode":"190baa3e-472d-481d-b8f2-f0a98aa546a7","links":[]},{"id":"04d4884a-aa95-42bb-a15d-859a840f45c0","type":"onetomany","x":-144.99997481355314,"y":812.0000205269542,"name":"coll-port-1-left","alignment":"left","parentNode":"190baa3e-472d-481d-b8f2-f0a98aa546a7","links":[]},{"id":"e28dc185-f81c-4d09-9202-f5a44c3e1fef","type":"onetomany","x":20.00008471041632,"y":812.0000205269542,"name":"coll-port-1-right","alignment":"right","parentNode":"190baa3e-472d-481d-b8f2-f0a98aa546a7","links":["f086f595-f882-4ac2-93dc-8388834c3926"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["5762b5fa-41b4-496d-8b13-ccb898a0625c","ec010d24-005b-4c64-ad62-93dfadeba373","04d4884a-aa95-42bb-a15d-859a840f45c0","e28dc185-f81c-4d09-9202-f5a44c3e1fef"],"otherInfo":{"data":{"columns":[{"name":"customer_id","atttypid":1043,"attlen":"50","attnum":1,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"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":"50","attnum":2,"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":"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":"customer_zip_code_prefix","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":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":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"customer_city","atttypid":1043,"attlen":"50","attnum":4,"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":"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":"customer_state","atttypid":1043,"attlen":"50","attnum":5,"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":"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","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":33341,"name":"customers_pk","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"customer_id"}],"include":[]}],"foreign_key":[{"name":"customers_fk","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":33505,"fknsp":"public","fktab":"customers","refnspoid":2200,"refnsp":"public","reftab":"geolocation","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"customer_zip_code_prefix","references":"fe6080ca-4200-4368-9602-8ad72c801655","referenced":"geolocation_zip_code_prefix","references_table_name":"public.geolocation"}],"remote_schema":"public","remote_table":"geolocation","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"fe6080ca-4200-4368-9602-8ad72c801655":{"id":"fe6080ca-4200-4368-9602-8ad72c801655","type":"table","selected":false,"x":-405,"y":825,"ports":[{"id":"2b7be703-cf1b-4a41-add4-285ac7871624","type":"onetomany","x":-399.99998564461924,"y":922.9999795456962,"name":"coll-port-1-left","alignment":"left","parentNode":"fe6080ca-4200-4368-9602-8ad72c801655","links":[]},{"id":"aae94548-b462-4ab4-a2b6-080b51773f05","type":"onetomany","x":-235.00000742882955,"y":922.9999795456962,"name":"coll-port-1-right","alignment":"right","parentNode":"fe6080ca-4200-4368-9602-8ad72c801655","links":["a0c25825-e71d-4142-9cfa-3f6648d218d2","bf0ccbc5-4b4a-45b2-ad3d-282e609add89"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["2b7be703-cf1b-4a41-add4-285ac7871624","aae94548-b462-4ab4-a2b6-080b51773f05"],"otherInfo":{"data":{"columns":[{"name":"geolocation_zip_code_prefix","atttypid":1043,"attlen":"50","attnum":1,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"geolocation","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":"geolocation_lat","atttypid":701,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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","genexpr":null,"relname":"geolocation","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":"geolocation_lng","atttypid":701,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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","genexpr":null,"relname":"geolocation","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":"geolocation_city","atttypid":25,"attlen":null,"attnum":4,"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":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"geolocation","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"geolocation_state","atttypid":1043,"attlen":"50","attnum":5,"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":"geolocation","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":"geolocation","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":33511,"name":"geolocation_pk","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"geolocation_zip_code_prefix"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"b2abd010-6ed0-4232-957a-baa66677d105":{"id":"b2abd010-6ed0-4232-957a-baa66677d105","type":"table","selected":false,"x":-630,"y":585,"ports":[],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":[],"otherInfo":{"data":{"columns":[{"name":"geolocation_zip_code_prefix","atttypid":1043,"attlen":"50","attnum":1,"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":"geolocation_dirty","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":"geolocation_lat","atttypid":701,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"geolocation_dirty","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":"geolocation_lng","atttypid":701,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"geolocation_dirty","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":"geolocation_city","atttypid":1043,"attlen":"50","attnum":4,"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":"geolocation_dirty","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":"geolocation_state","atttypid":1043,"attlen":"50","attnum":5,"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":"geolocation_dirty","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":"geolocation_dirty","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"424173f0-1bfc-4da8-a0fe-0cf8c049897c":{"id":"424173f0-1bfc-4da8-a0fe-0cf8c049897c","type":"table","selected":false,"x":-630,"y":825,"ports":[],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":[],"otherInfo":{"data":{"columns":[{"name":"geolocation_zip_code_prefix","atttypid":1043,"attlen":"50","attnum":1,"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":"geolocation_dirty2","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":"geolocation_lat","atttypid":701,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"geolocation_dirty2","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":"geolocation_lng","atttypid":701,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"geolocation_dirty2","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":"geolocation_city","atttypid":25,"attlen":null,"attnum":4,"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":"geolocation_dirty2","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"geolocation_state","atttypid":1043,"attlen":"50","attnum":5,"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":"geolocation_dirty2","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":"geolocation_dirty2","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6":{"id":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","type":"table","selected":false,"x":-150,"y":435,"ports":[{"id":"5c96f2c8-2153-48b9-90f0-843574980226","type":"onetomany","x":-144.99997481355314,"y":526.9999787594298,"name":"coll-port-1-left","alignment":"left","parentNode":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","links":[]},{"id":"2ddcda71-cf5e-452b-8228-1e8242ba6cfc","type":"onetomany","x":20.00008471041632,"y":526.9999787594298,"name":"coll-port-1-right","alignment":"right","parentNode":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","links":["b19a5b30-181d-4b7f-a495-1bd9bc68a1fb"]},{"id":"21480ec6-babf-4612-ab12-b5fdc804e2b0","type":"onetomany","x":-144.99997481355314,"y":577.0000207368413,"name":"coll-port-3-left","alignment":"left","parentNode":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","links":["8463fb59-a4b9-42e5-9f0f-5a0a597c51d8"]},{"id":"6f3a04b9-50d2-422a-8394-1fbe3884ac5d","type":"onetomany","x":20.00008471041632,"y":577.0000207368413,"name":"coll-port-3-right","alignment":"right","parentNode":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","links":[]},{"id":"b3156264-6a6a-45e6-8c19-e6fa1a07459d","type":"onetomany","x":-144.99997481355314,"y":602.0000022248028,"name":"coll-port-4-left","alignment":"left","parentNode":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","links":["5679f28c-7160-4a9e-b79d-7356db9f5d79"]},{"id":"19c7a4c7-c146-4627-b818-c507352137bf","type":"onetomany","x":20.00008471041632,"y":602.0000022248028,"name":"coll-port-4-right","alignment":"right","parentNode":"a7f5b2d1-846b-47ea-bb1d-5c30d950e1b6","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["5c96f2c8-2153-48b9-90f0-843574980226","2ddcda71-cf5e-452b-8228-1e8242ba6cfc","21480ec6-babf-4612-ab12-b5fdc804e2b0","6f3a04b9-50d2-422a-8394-1fbe3884ac5d","b3156264-6a6a-45e6-8c19-e6fa1a07459d","19c7a4c7-c146-4627-b818-c507352137bf"],"otherInfo":{"data":{"columns":[{"name":"order_id","atttypid":1043,"attlen":"50","attnum":1,"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":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":"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":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":"50","attnum":4,"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":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":701,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":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","integer","numeric","real","smallint"]},{"name":"freight_value","atttypid":701,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":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","double precision","integer","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":"order_items_fk_order","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":33391,"fknsp":"public","fktab":"order_items","refnspoid":2200,"refnsp":"public","reftab":"orders","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"order_id","references":"a829c4e9-5a2c-48bf-8448-25b855575db9","referenced":"order_id","references_table_name":"public.orders"}],"remote_schema":"public","remote_table":"orders","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"order_items_fk_product","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[2],"confrelid":33425,"fknsp":"public","fktab":"order_items","refnspoid":2200,"refnsp":"public","reftab":"products","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"product_id","references":"d26b5fcb-9ef8-441f-a797-e8f92eb44940","referenced":"product_id","references_table_name":"public.products"}],"remote_schema":"public","remote_table":"products","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"order_items_fk_seller","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[4],"confkey":[1],"confrelid":33410,"fknsp":"public","fktab":"order_items","refnspoid":2200,"refnsp":"public","reftab":"sellers","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"seller_id","references":"b0a249de-2c05-44f2-ab30-18932294f82a","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}}},"1f664c00-00f1-48e4-815d-621745a95cf5":{"id":"1f664c00-00f1-48e4-815d-621745a95cf5","type":"table","selected":false,"x":105,"y":900,"ports":[{"id":"a8fe6883-e3c5-4ca9-bc40-2209d263653e","type":"onetomany","x":110.00008126826859,"y":991.9999724208408,"name":"coll-port-1-left","alignment":"left","parentNode":"1f664c00-00f1-48e4-815d-621745a95cf5","links":[]},{"id":"54d62039-b7e9-4f5d-b9fd-76ed261b830a","type":"onetomany","x":275.00006179074967,"y":991.9999724208408,"name":"coll-port-1-right","alignment":"right","parentNode":"1f664c00-00f1-48e4-815d-621745a95cf5","links":["ada17c4a-ffd6-4caa-845e-9fc726f06a55"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["a8fe6883-e3c5-4ca9-bc40-2209d263653e","54d62039-b7e9-4f5d-b9fd-76ed261b830a"],"otherInfo":{"data":{"columns":[{"name":"order_id","atttypid":1043,"attlen":"50","attnum":1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_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":"payment_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":"order_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":"payment_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":"order_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":"payment_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":"order_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":"payment_value","atttypid":701,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"order_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","integer","numeric","real","smallint"]}],"name":"order_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":"order_payments_fk","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":33391,"fknsp":"public","fktab":"order_payments","refnspoid":2200,"refnsp":"public","reftab":"orders","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"order_id","references":"a829c4e9-5a2c-48bf-8448-25b855575db9","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}}},"49ec9f86-3b10-40ce-88b8-2daf7575b537":{"id":"49ec9f86-3b10-40ce-88b8-2daf7575b537","type":"table","selected":false,"x":105,"y":270,"ports":[{"id":"da6ab3d6-bd81-40dd-b745-a603a14520d9","type":"onetomany","x":110.00008126826859,"y":386.9999636895391,"name":"coll-port-2-left","alignment":"left","parentNode":"49ec9f86-3b10-40ce-88b8-2daf7575b537","links":[]},{"id":"ea696a99-38c2-469e-a992-d30c97a0e3b8","type":"onetomany","x":275.00006179074967,"y":386.9999636895391,"name":"coll-port-2-right","alignment":"right","parentNode":"49ec9f86-3b10-40ce-88b8-2daf7575b537","links":["b3e3a30e-2567-4e03-a652-821ea9132081"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["da6ab3d6-bd81-40dd-b745-a603a14520d9","ea696a99-38c2-469e-a992-d30c97a0e3b8"],"otherInfo":{"data":{"columns":[{"name":"review_id","atttypid":1043,"attlen":"100","attnum":1,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","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":"order_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"]},{"name":"order_id","atttypid":1043,"attlen":"100","attnum":2,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","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_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"]},{"name":"review_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":"order_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"]},{"name":"review_comment_title","atttypid":1043,"attlen":"100","attnum":4,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","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":"order_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"]},{"name":"review_comment_message","atttypid":1043,"attlen":"400","attnum":5,"attndims":0,"atttypmod":404,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(400)","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":"order_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","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"review_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":"order_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"]},{"name":"review_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":"order_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"]}],"name":"order_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":"order_reviews_fk","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":33391,"fknsp":"public","fktab":"order_reviews","refnspoid":2200,"refnsp":"public","reftab":"orders","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"order_id","references":"a829c4e9-5a2c-48bf-8448-25b855575db9","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}}},"a829c4e9-5a2c-48bf-8448-25b855575db9":{"id":"a829c4e9-5a2c-48bf-8448-25b855575db9","type":"table","selected":false,"x":105,"y":555,"ports":[{"id":"cdce9635-455b-4727-a8fa-d68aa3c96d9a","type":"onetomany","x":110.00008126826859,"y":646.9999718751342,"name":"coll-port-1-left","alignment":"left","parentNode":"a829c4e9-5a2c-48bf-8448-25b855575db9","links":["b19a5b30-181d-4b7f-a495-1bd9bc68a1fb"]},{"id":"675bffa2-6219-44f4-b460-e4a79cafdd84","type":"onetomany","x":275.00006179074967,"y":646.9999718751342,"name":"coll-port-1-right","alignment":"right","parentNode":"a829c4e9-5a2c-48bf-8448-25b855575db9","links":["ada17c4a-ffd6-4caa-845e-9fc726f06a55","b3e3a30e-2567-4e03-a652-821ea9132081"]},{"id":"e37fbe7e-db21-42ff-8757-2abf53dd3db4","type":"onetomany","x":110.00008126826859,"y":671.9999928638399,"name":"coll-port-2-left","alignment":"left","parentNode":"a829c4e9-5a2c-48bf-8448-25b855575db9","links":["f086f595-f882-4ac2-93dc-8388834c3926"]},{"id":"fcdedafa-2942-4326-9a80-decdac7928a4","type":"onetomany","x":275.00006179074967,"y":671.9999928638399,"name":"coll-port-2-right","alignment":"right","parentNode":"a829c4e9-5a2c-48bf-8448-25b855575db9","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["cdce9635-455b-4727-a8fa-d68aa3c96d9a","675bffa2-6219-44f4-b460-e4a79cafdd84","e37fbe7e-db21-42ff-8757-2abf53dd3db4","fcdedafa-2942-4326-9a80-decdac7928a4"],"otherInfo":{"data":{"columns":[{"name":"order_id","atttypid":1043,"attlen":"50","attnum":1,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"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":"50","attnum":2,"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":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":"order_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":"order_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":"order_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":"order_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":"order_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":"order_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":33397,"name":"orders_pk","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"order_id"}],"include":[]}],"foreign_key":[{"name":"orders_fk","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":33335,"fknsp":"public","fktab":"orders","refnspoid":2200,"refnsp":"public","reftab":"customers","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"customer_id","references":"190baa3e-472d-481d-b8f2-f0a98aa546a7","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}}},"d26b5fcb-9ef8-441f-a797-e8f92eb44940":{"id":"d26b5fcb-9ef8-441f-a797-e8f92eb44940","type":"table","selected":false,"x":-405,"y":270,"ports":[{"id":"6dcebde8-07d8-47d4-b774-54d541b9563e","type":"onetomany","x":-399.9999518938865,"y":386.9999994752823,"name":"coll-port-2-left","alignment":"left","parentNode":"d26b5fcb-9ef8-441f-a797-e8f92eb44940","links":[]},{"id":"603de383-17d5-4a6e-abac-0a200f7b2e0a","type":"onetomany","x":-234.9999713714054,"y":386.9999994752823,"name":"coll-port-2-right","alignment":"right","parentNode":"d26b5fcb-9ef8-441f-a797-e8f92eb44940","links":["8463fb59-a4b9-42e5-9f0f-5a0a597c51d8"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["6dcebde8-07d8-47d4-b774-54d541b9563e","603de383-17d5-4a6e-abac-0a200f7b2e0a"],"otherInfo":{"data":{"columns":[{"name":"column1","atttypid":23,"attlen":null,"attnum":1,"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":"2","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":"product_id","atttypid":1043,"attlen":"50","attnum":2,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"2","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":"product_category_name","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":"2","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":"product_name_lenght","atttypid":701,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":"2","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","integer","numeric","real","smallint"]},{"name":"product_description_lenght","atttypid":701,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":"2","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","double precision","integer","numeric","real","smallint"]},{"name":"product_photos_qty","atttypid":701,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":"2","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","double precision","double precision","integer","numeric","real","smallint"]},{"name":"product_weight_g","atttypid":701,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":"2","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","double precision","double precision","double precision","integer","numeric","real","smallint"]},{"name":"product_length_cm","atttypid":701,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":"2","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","double precision","double precision","double precision","double precision","integer","numeric","real","smallint"]},{"name":"product_height_cm","atttypid":701,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":"2","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","double precision","double precision","double precision","double precision","double precision","integer","numeric","real","smallint"]},{"name":"product_width_cm","atttypid":701,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"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":"2","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","double precision","double precision","double precision","double precision","double precision","double precision","integer","numeric","real","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":33428,"name":"products_pk","col_count":1,"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}}},"b0a249de-2c05-44f2-ab30-18932294f82a":{"id":"b0a249de-2c05-44f2-ab30-18932294f82a","type":"table","selected":false,"x":-405,"y":630,"ports":[{"id":"e96c840b-fdf5-4e4a-a64c-d66f2e513e90","type":"onetomany","x":-399.9999856446193,"y":721.9999931117275,"name":"coll-port-1-left","alignment":"left","parentNode":"b0a249de-2c05-44f2-ab30-18932294f82a","links":[]},{"id":"69ad1510-4acf-4bab-96e0-ed5e231be257","type":"onetomany","x":-235.00000742882958,"y":721.9999931117275,"name":"coll-port-1-right","alignment":"right","parentNode":"b0a249de-2c05-44f2-ab30-18932294f82a","links":["5679f28c-7160-4a9e-b79d-7356db9f5d79"]},{"id":"dc43e3ae-14fc-4201-9a5f-379c76e9f6b1","type":"onetomany","x":-399.9999856446193,"y":747.0000197140505,"name":"coll-port-2-left","alignment":"left","parentNode":"b0a249de-2c05-44f2-ab30-18932294f82a","links":[]},{"id":"b9596e9b-302c-4880-8ff6-19fba2cde879","type":"onetomany","x":-235.00000742882958,"y":747.0000197140505,"name":"coll-port-2-right","alignment":"right","parentNode":"b0a249de-2c05-44f2-ab30-18932294f82a","links":["bf0ccbc5-4b4a-45b2-ad3d-282e609add89"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["e96c840b-fdf5-4e4a-a64c-d66f2e513e90","69ad1510-4acf-4bab-96e0-ed5e231be257","dc43e3ae-14fc-4201-9a5f-379c76e9f6b1","b9596e9b-302c-4880-8ff6-19fba2cde879"],"otherInfo":{"data":{"columns":[{"name":"seller_id","atttypid":1043,"attlen":"50","attnum":1,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"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":"seller_zip_code_prefix","atttypid":1043,"attlen":"50","attnum":2,"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":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":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"seller_city","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":"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":"seller_state","atttypid":1043,"attlen":"50","attnum":4,"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":"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","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":33413,"name":"sellers_pk","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"seller_id"}],"include":[]}],"foreign_key":[{"name":"sellers_fk","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":33505,"fknsp":"public","fktab":"sellers","refnspoid":2200,"refnsp":"public","reftab":"geolocation","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"seller_zip_code_prefix","references":"fe6080ca-4200-4368-9602-8ad72c801655","referenced":"geolocation_zip_code_prefix","references_table_name":"public.geolocation"}],"remote_schema":"public","remote_table":"geolocation","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}