database_erd.pgerd

{"version":"70600","data":{"id":"2af805e4-4601-41bf-9010-324d73e163f7","offsetX":157.1864197662798,"offsetY":108.10086169076916,"zoom":36.266523590850525,"gridSize":15,"layers":[{"id":"bc5af68c-d45d-4495-a2c0-7fd305b2183e","type":"diagram-links","isSvg":true,"transformed":true,"models":{"66d4d8bb-a763-4d05-b060-69b55631afe2":{"id":"66d4d8bb-a763-4d05-b060-69b55631afe2","locked":true,"type":"onetomany","selected":false,"source":"59b14db6-8eb9-4820-8d01-77b10a254c11","sourcePort":"9b55b9f3-e2f3-48b3-a6a7-567d53e270a3","target":"039ba4ed-38ba-474a-9321-f196c79870bf","targetPort":"bb28caaf-37fc-422a-9cb8-6749f6f8fd02","points":[{"id":"1b7aeb37-8d61-45ef-a365-11fef4df46a3","type":"point","x":368.9308776855469,"y":773.1151275634766},{"id":"b74ce0d8-602e-4575-b31c-908fea32f482","type":"point","x":409.5610737287731,"y":773.1151275634766},{"id":"6303ced7-fcac-486a-aa92-d73f8db0a7c1","type":"point","x":409.5610737287731,"y":638.1914520263672},{"id":"a86f5e11-8162-40a1-9ef0-41de03a16461","type":"point","x":421.0367851257324,"y":638.1914520263672}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"039ba4ed-38ba-474a-9321-f196c79870bf","local_column_attnum":4,"referenced_table_uid":"59b14db6-8eb9-4820-8d01-77b10a254c11","referenced_column_attnum":1}},"931692f3-3e91-48e7-a3a5-34f0fd9bcbc9":{"id":"931692f3-3e91-48e7-a3a5-34f0fd9bcbc9","locked":true,"type":"onetomany","selected":false,"source":"1ed44a5f-ee62-4e83-a109-2f9298f94f88","sourcePort":"d23cde9e-ad05-4412-a765-9c2f9836a50e","target":"039ba4ed-38ba-474a-9321-f196c79870bf","targetPort":"fd3b837e-fa92-456f-9bc6-58d2de20c3e6","points":[{"id":"48bc6e76-b4eb-4f10-872e-4dccda53b36a","type":"point","x":653.9308776855469,"y":424.25633239746094},{"id":"bcf1a0a5-78d5-44cd-84d1-7bde2a310533","type":"point","x":678.36388440031,"y":424.25633239746094},{"id":"18d856a8-24a7-4971-ac75-a38140bad2a7","type":"point","x":678.36388440031,"y":465.9217798621823},{"id":"09a85882-1085-4799-840e-05a3f032196f","type":"point","x":678.36388440031,"y":582.1101531982422},{"id":"60aa5918-7e8d-4e0b-8f4a-3ca9bf5dce89","type":"point","x":653.9308776855469,"y":582.1101531982422}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"039ba4ed-38ba-474a-9321-f196c79870bf","local_column_attnum":2,"referenced_table_uid":"1ed44a5f-ee62-4e83-a109-2f9298f94f88","referenced_column_attnum":6}},"3754833d-c2c4-44dd-864e-a3e34956de2a":{"id":"3754833d-c2c4-44dd-864e-a3e34956de2a","locked":true,"type":"onetomany","selected":false,"source":"8611fa86-4820-4891-b3c4-c528ca3343fb","sourcePort":"cf170b37-194f-4e74-a579-4121089698ba","target":"039ba4ed-38ba-474a-9321-f196c79870bf","targetPort":"dccaab36-0d34-40d8-91a5-94a39b321a53","points":[{"id":"489aab83-22e5-42a9-927d-29856bb51e40","type":"point","x":721.0367851257324,"y":1022.4329681396484},{"id":"a20ac45a-5b58-42b1-b6f2-171a4fa0e5f9","type":"point","x":721.0367851257324,"y":712.3311920166016},{"id":"1b311440-2f5d-441f-8488-f91fa721fa3f","type":"point","x":653.9308776855469,"y":712.3311920166016}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"039ba4ed-38ba-474a-9321-f196c79870bf","local_column_attnum":6,"referenced_table_uid":"8611fa86-4820-4891-b3c4-c528ca3343fb","referenced_column_attnum":10}},"3bf4bef9-ba7e-4f82-bf68-8d8263a1eb73":{"id":"3bf4bef9-ba7e-4f82-bf68-8d8263a1eb73","locked":true,"type":"onetomany","selected":false,"source":"f5705309-d83d-486e-a00a-9805585bfb35","sourcePort":"0e5b6f98-5096-4393-81c5-1617a7d96abf","target":"039ba4ed-38ba-474a-9321-f196c79870bf","targetPort":"11b99e3f-0f18-41e4-b865-e5efb9e962f0","points":[{"id":"387afc6d-b47b-4cf0-aa61-2445fca7fc28","type":"point","x":721.0367851257324,"y":435.26133728027344},{"id":"51eed461-c17e-4e8a-949f-35a76c4945a3","type":"point","x":721.0367851257324,"y":675.2613372802734},{"id":"727bf43f-a5c6-49d5-bc2d-cf814632163c","type":"point","x":653.9308776855469,"y":675.2613372802734}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"039ba4ed-38ba-474a-9321-f196c79870bf","local_column_attnum":5,"referenced_table_uid":"f5705309-d83d-486e-a00a-9805585bfb35","referenced_column_attnum":5}},"f6eb9f4d-bc24-4dac-9304-533968f4878e":{"id":"f6eb9f4d-bc24-4dac-9304-533968f4878e","locked":true,"type":"onetomany","selected":false,"source":"b399750f-f357-4f9a-a206-19d515198253","sourcePort":"d7fd17a4-8d7a-4d8e-a18a-82aca3a793f3","target":"039ba4ed-38ba-474a-9321-f196c79870bf","targetPort":"3cfaf086-eba4-43aa-a523-280fb8edd819","points":[{"id":"6e2cd979-50a7-4846-b7a6-c4c490dcb132","type":"point","x":368.9308776855469,"y":628.4978179931641},{"id":"205f43ac-fe92-43c0-b436-b283b335d8f2","type":"point","x":394.7925045665737,"y":628.4978179931641},{"id":"53e634fe-4fc7-4530-bae4-de2671beb515","type":"point","x":394.7925045665737,"y":607.1356048583984},{"id":"90973976-37db-4b9c-9ede-88f05a0f9819","type":"point","x":421.0367851257324,"y":607.1356048583984}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"039ba4ed-38ba-474a-9321-f196c79870bf","local_column_attnum":3,"referenced_table_uid":"b399750f-f357-4f9a-a206-19d515198253","referenced_column_attnum":12}}}},{"id":"c02441ff-9446-48c7-9102-b2169a9fb9f7","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"59b14db6-8eb9-4820-8d01-77b10a254c11":{"id":"59b14db6-8eb9-4820-8d01-77b10a254c11","type":"table","selected":false,"x":165,"y":675,"ports":[{"id":"4ffd330b-2ecc-4a96-95d2-f73ca835914c","type":"onetomany","x":166.03678512573242,"y":773.1151275634766,"name":"coll-port-1-left","alignment":"left","parentNode":"59b14db6-8eb9-4820-8d01-77b10a254c11","links":[]},{"id":"9b55b9f3-e2f3-48b3-a6a7-567d53e270a3","type":"onetomany","x":338.9308776855469,"y":773.1151275634766,"name":"coll-port-1-right","alignment":"right","parentNode":"59b14db6-8eb9-4820-8d01-77b10a254c11","links":["66d4d8bb-a763-4d05-b060-69b55631afe2"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["4ffd330b-2ecc-4a96-95d2-f73ca835914c","9b55b9f3-e2f3-48b3-a6a7-567d53e270a3"],"otherInfo":{"data":{"columns":[{"name":"card_number","atttypid":1043,"attlen":"19","attnum":1,"attndims":0,"atttypmod":23,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(19)","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":"dim_card_details","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":"expiry_date","atttypid":1082,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_card_details","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"card_provider","atttypid":25,"attlen":null,"attnum":3,"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":"dim_card_details","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":"date_payment_confirmed","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_card_details","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","date","timestamp with time zone","timestamp without time zone"]}],"name":"dim_card_details","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":18801,"name":"dim_card_details_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"card_number"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"1ed44a5f-ee62-4e83-a109-2f9298f94f88":{"id":"1ed44a5f-ee62-4e83-a109-2f9298f94f88","type":"table","selected":false,"x":450,"y":195,"ports":[{"id":"bb7591ec-7823-4f63-b789-3ea0ff9d9694","type":"onetomany","x":451.0367851257324,"y":424.25633239746094,"name":"coll-port-6-left","alignment":"left","parentNode":"1ed44a5f-ee62-4e83-a109-2f9298f94f88","links":[]},{"id":"d23cde9e-ad05-4412-a765-9c2f9836a50e","type":"onetomany","x":623.9308776855469,"y":424.25633239746094,"name":"coll-port-6-right","alignment":"right","parentNode":"1ed44a5f-ee62-4e83-a109-2f9298f94f88","links":["931692f3-3e91-48e7-a3a5-34f0fd9bcbc9"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["bb7591ec-7823-4f63-b789-3ea0ff9d9694","d23cde9e-ad05-4412-a765-9c2f9836a50e"],"otherInfo":{"data":{"columns":[{"name":"timestamp","atttypid":25,"attlen":null,"attnum":1,"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":"6","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_date_times","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":"month","atttypid":1043,"attlen":"2","attnum":2,"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":"6","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_date_times","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":"year","atttypid":1043,"attlen":"4","attnum":3,"attndims":0,"atttypmod":8,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(4)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"6","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_date_times","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":"day","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":"6","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_date_times","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":"time_period","atttypid":1043,"attlen":"255","attnum":5,"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":"6","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_date_times","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":"date_uuid","atttypid":2950,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"uuid","displaytypname":"uuid","cltype":"uuid","elemoid":2950,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"6","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_date_times","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":["uuid"]}],"name":"dim_date_times","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":18803,"name":"dim_date_times_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"date_uuid"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"8611fa86-4820-4891-b3c4-c528ca3343fb":{"id":"8611fa86-4820-4891-b3c4-c528ca3343fb","type":"table","selected":false,"x":750,"y":675,"ports":[{"id":"cf170b37-194f-4e74-a579-4121089698ba","type":"onetomany","x":751.0367851257324,"y":1022.4329681396484,"name":"coll-port-10-left","alignment":"left","parentNode":"8611fa86-4820-4891-b3c4-c528ca3343fb","links":["3754833d-c2c4-44dd-864e-a3e34956de2a"]},{"id":"a1877f9e-894a-4d0e-a6ad-c057e0aff976","type":"onetomany","x":923.9308776855469,"y":1022.4329681396484,"name":"coll-port-10-right","alignment":"right","parentNode":"8611fa86-4820-4891-b3c4-c528ca3343fb","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["cf170b37-194f-4e74-a579-4121089698ba","a1877f9e-894a-4d0e-a6ad-c057e0aff976"],"otherInfo":{"data":{"columns":[{"name":"Unnamed: 0","atttypid":20,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"bigint","displaytypname":"bigint","cltype":"bigint","elemoid":20,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"10","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"product_name","atttypid":25,"attlen":null,"attnum":2,"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":"10","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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","name","regclass","text"]},{"name":"product_price_in_gbp","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":"10","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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":"weight_in_kg","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":"10","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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":"category","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":"10","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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","name","regclass","text","text"]},{"name":"EAN","atttypid":1043,"attlen":"14","attnum":6,"attndims":0,"atttypmod":18,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(14)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"10","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"date_added","atttypid":1082,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"10","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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":["date","timestamp with time zone","timestamp without time zone"]},{"name":"uuid","atttypid":2950,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"uuid","displaytypname":"uuid","cltype":"uuid","elemoid":2950,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"10","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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":["uuid"]},{"name":"still_available","atttypid":16,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"boolean","displaytypname":"boolean","cltype":"boolean","elemoid":16,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"10","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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":["boolean","character","character varying","text"]},{"name":"product_code","atttypid":1043,"attlen":"12","attnum":10,"attndims":0,"atttypmod":16,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(12)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"10","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"weight_class","atttypid":1043,"attlen":"255","attnum":11,"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":"10","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_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","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"name":"dim_products","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":18805,"name":"dim_products_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"product_code"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"f5705309-d83d-486e-a00a-9805585bfb35":{"id":"f5705309-d83d-486e-a00a-9805585bfb35","type":"table","selected":false,"x":750,"y":225,"ports":[{"id":"0e5b6f98-5096-4393-81c5-1617a7d96abf","type":"onetomany","x":751.0367851257324,"y":435.26133728027344,"name":"coll-port-5-left","alignment":"left","parentNode":"f5705309-d83d-486e-a00a-9805585bfb35","links":["3bf4bef9-ba7e-4f82-bf68-8d8263a1eb73"]},{"id":"7945624a-3850-4dd2-b0c3-5d9e9d00c108","type":"onetomany","x":923.9308776855469,"y":435.26133728027344,"name":"coll-port-5-right","alignment":"right","parentNode":"f5705309-d83d-486e-a00a-9805585bfb35","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["0e5b6f98-5096-4393-81c5-1617a7d96abf","7945624a-3850-4dd2-b0c3-5d9e9d00c108"],"otherInfo":{"data":{"columns":[{"name":"index","atttypid":20,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"bigint","displaytypname":"bigint","cltype":"bigint","elemoid":20,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"5","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"address","atttypid":25,"attlen":null,"attnum":2,"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":"5","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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":"longitude","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":"5","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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":"locality","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":"5","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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":"store_code","atttypid":1043,"attlen":"12","attnum":5,"attndims":0,"atttypmod":16,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(12)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"5","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"staff_numbers","atttypid":21,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"smallint","displaytypname":"smallint","cltype":"smallint","elemoid":21,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"5","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"opening_date","atttypid":1082,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"5","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"store_type","atttypid":1043,"attlen":"255","attnum":8,"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":"5","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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":"latitude","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":"5","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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":"country_code","atttypid":1043,"attlen":"3","attnum":10,"attndims":0,"atttypmod":7,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(3)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"5","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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":"continent","atttypid":1043,"attlen":"255","attnum":11,"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":"5","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_store_details","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":"dim_store_details","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":18807,"name":"dim_store_details_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"store_code"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"b399750f-f357-4f9a-a206-19d515198253":{"id":"b399750f-f357-4f9a-a206-19d515198253","type":"table","selected":false,"x":165,"y":225,"ports":[{"id":"b52fca89-c22f-4f72-941d-c978ac2db618","type":"onetomany","x":166.03678512573242,"y":628.4978179931641,"name":"coll-port-12-left","alignment":"left","parentNode":"b399750f-f357-4f9a-a206-19d515198253","links":[]},{"id":"d7fd17a4-8d7a-4d8e-a18a-82aca3a793f3","type":"onetomany","x":338.9308776855469,"y":628.4978179931641,"name":"coll-port-12-right","alignment":"right","parentNode":"b399750f-f357-4f9a-a206-19d515198253","links":["f6eb9f4d-bc24-4dac-9304-533968f4878e"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["b52fca89-c22f-4f72-941d-c978ac2db618","d7fd17a4-8d7a-4d8e-a18a-82aca3a793f3"],"otherInfo":{"data":{"columns":[{"name":"index","atttypid":20,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"bigint","displaytypname":"bigint","cltype":"bigint","elemoid":20,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"12","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"first_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":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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":"last_name","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":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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":"date_of_birth","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"12","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"company","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":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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":"email_address","atttypid":25,"attlen":null,"attnum":6,"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":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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","text"]},{"name":"address","atttypid":25,"attlen":null,"attnum":7,"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":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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","text","text"]},{"name":"country","atttypid":25,"attlen":null,"attnum":8,"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":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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","text","text","text"]},{"name":"country_code","atttypid":1043,"attlen":"3","attnum":9,"attndims":0,"atttypmod":7,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(3)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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":"phone_number","atttypid":25,"attlen":null,"attnum":10,"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":"12","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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","text","text","text","text"]},{"name":"join_date","atttypid":1082,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"12","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","date","timestamp with time zone","timestamp without time zone"]},{"name":"user_uuid","atttypid":2950,"attlen":null,"attnum":12,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"uuid","displaytypname":"uuid","cltype":"uuid","elemoid":2950,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"12","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"dim_users","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":["uuid"]}],"name":"dim_users","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":18809,"name":"dim_users_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"user_uuid"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"039ba4ed-38ba-474a-9321-f196c79870bf":{"id":"039ba4ed-38ba-474a-9321-f196c79870bf","type":"table","selected":false,"x":450,"y":465,"ports":[{"id":"bb28caaf-37fc-422a-9cb8-6749f6f8fd02","type":"onetomany","x":451.0367851257324,"y":638.1914520263672,"name":"coll-port-4-left","alignment":"left","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":["66d4d8bb-a763-4d05-b060-69b55631afe2"]},{"id":"389ca5de-7a1e-43dc-92c8-fae8a3404f6a","type":"onetomany","x":623.9308776855469,"y":638.1914520263672,"name":"coll-port-4-right","alignment":"right","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":[]},{"id":"f287fcf4-8dcf-44a9-9705-f7bb11601b15","type":"onetomany","x":451.0367851257324,"y":582.1101531982422,"name":"coll-port-2-left","alignment":"left","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":[]},{"id":"fd3b837e-fa92-456f-9bc6-58d2de20c3e6","type":"onetomany","x":623.9308776855469,"y":582.1101531982422,"name":"coll-port-2-right","alignment":"right","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":["931692f3-3e91-48e7-a3a5-34f0fd9bcbc9"]},{"id":"1be130cf-0a02-4648-8542-7883bdb03f11","type":"onetomany","x":451.0367851257324,"y":712.3311920166016,"name":"coll-port-6-left","alignment":"left","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":[]},{"id":"dccaab36-0d34-40d8-91a5-94a39b321a53","type":"onetomany","x":623.9308776855469,"y":712.3311920166016,"name":"coll-port-6-right","alignment":"right","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":["3754833d-c2c4-44dd-864e-a3e34956de2a"]},{"id":"b5e55f36-4a47-4002-aaf6-ab4144a1d804","type":"onetomany","x":451.0367851257324,"y":675.2613372802734,"name":"coll-port-5-left","alignment":"left","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":[]},{"id":"11b99e3f-0f18-41e4-b865-e5efb9e962f0","type":"onetomany","x":623.9308776855469,"y":675.2613372802734,"name":"coll-port-5-right","alignment":"right","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":["3bf4bef9-ba7e-4f82-bf68-8d8263a1eb73"]},{"id":"3cfaf086-eba4-43aa-a523-280fb8edd819","type":"onetomany","x":451.0367851257324,"y":607.1356048583984,"name":"coll-port-3-left","alignment":"left","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":["f6eb9f4d-bc24-4dac-9304-533968f4878e"]},{"id":"adc16fda-f458-4638-a609-53aedafa53d3","type":"onetomany","x":623.9308776855469,"y":607.1356048583984,"name":"coll-port-3-right","alignment":"right","parentNode":"039ba4ed-38ba-474a-9321-f196c79870bf","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["bb28caaf-37fc-422a-9cb8-6749f6f8fd02","389ca5de-7a1e-43dc-92c8-fae8a3404f6a","f287fcf4-8dcf-44a9-9705-f7bb11601b15","fd3b837e-fa92-456f-9bc6-58d2de20c3e6","1be130cf-0a02-4648-8542-7883bdb03f11","dccaab36-0d34-40d8-91a5-94a39b321a53","b5e55f36-4a47-4002-aaf6-ab4144a1d804","11b99e3f-0f18-41e4-b865-e5efb9e962f0","3cfaf086-eba4-43aa-a523-280fb8edd819","adc16fda-f458-4638-a609-53aedafa53d3"],"otherInfo":{"data":{"columns":[{"name":"index","atttypid":20,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"bigint","displaytypname":"bigint","cltype":"bigint","elemoid":20,"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":"orders_table","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","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"date_uuid","atttypid":2950,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"uuid","displaytypname":"uuid","cltype":"uuid","elemoid":2950,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"orders_table","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":["uuid"]},{"name":"user_uuid","atttypid":2950,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"uuid","displaytypname":"uuid","cltype":"uuid","elemoid":2950,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"orders_table","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":["uuid","uuid"]},{"name":"card_number","atttypid":1043,"attlen":"19","attnum":4,"attndims":0,"atttypmod":23,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(19)","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":"orders_table","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":"store_code","atttypid":1043,"attlen":"12","attnum":5,"attndims":0,"atttypmod":16,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(12)","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":"orders_table","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_code","atttypid":1043,"attlen":"12","attnum":6,"attndims":0,"atttypmod":16,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(12)","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":"orders_table","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":"product_quantity","atttypid":21,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"smallint","displaytypname":"smallint","cltype":"smallint","elemoid":21,"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":"orders_table","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","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"orders_table","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"foreign_key":[{"name":"card_number_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[4],"confkey":[1],"confrelid":18708,"fknsp":"public","fktab":"orders_table","refnspoid":2200,"refnsp":"public","reftab":"dim_card_details","comment":null,"convalidated":false,"conislocal":true,"columns":[{"local_column":"card_number","references":"59b14db6-8eb9-4820-8d01-77b10a254c11","referenced":"card_number","references_table_name":"public.dim_card_details"}],"remote_schema":"public","remote_table":"dim_card_details","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"date_uuid_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[6],"confrelid":18736,"fknsp":"public","fktab":"orders_table","refnspoid":2200,"refnsp":"public","reftab":"dim_date_times","comment":null,"convalidated":false,"conislocal":true,"columns":[{"local_column":"date_uuid","references":"1ed44a5f-ee62-4e83-a109-2f9298f94f88","referenced":"date_uuid","references_table_name":"public.dim_date_times"}],"remote_schema":"public","remote_table":"dim_date_times","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"product_code_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[6],"confkey":[10],"confrelid":18726,"fknsp":"public","fktab":"orders_table","refnspoid":2200,"refnsp":"public","reftab":"dim_products","comment":null,"convalidated":false,"conislocal":true,"columns":[{"local_column":"product_code","references":"8611fa86-4820-4891-b3c4-c528ca3343fb","referenced":"product_code","references_table_name":"public.dim_products"}],"remote_schema":"public","remote_table":"dim_products","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"store_code_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[5],"confrelid":18721,"fknsp":"public","fktab":"orders_table","refnspoid":2200,"refnsp":"public","reftab":"dim_store_details","comment":null,"convalidated":false,"conislocal":true,"columns":[{"local_column":"store_code","references":"f5705309-d83d-486e-a00a-9805585bfb35","referenced":"store_code","references_table_name":"public.dim_store_details"}],"remote_schema":"public","remote_table":"dim_store_details","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"user_uuid_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[3],"confkey":[12],"confrelid":18703,"fknsp":"public","fktab":"orders_table","refnspoid":2200,"refnsp":"public","reftab":"dim_users","comment":null,"convalidated":false,"conislocal":true,"columns":[{"local_column":"user_uuid","references":"b399750f-f357-4f9a-a206-19d515198253","referenced":"user_uuid","references_table_name":"public.dim_users"}],"remote_schema":"public","remote_table":"dim_users","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}