db-structure.pgerd

{"version":"50100","data":{"id":"840e0191-2e95-42e3-9ca6-2c5321150867","offsetX":-13.170890470495554,"offsetY":210.52546653265014,"zoom":79.6833333333332,"gridSize":15,"layers":[{"id":"31bdb89a-67e8-4829-b44e-ddab512550af","type":"diagram-links","isSvg":true,"transformed":true,"models":{"41c05327-435d-4e4e-8f2f-2795a9ad25a5":{"id":"41c05327-435d-4e4e-8f2f-2795a9ad25a5","locked":true,"type":"onetomany","selected":false,"source":"597d6a10-1676-4c56-816b-e2fc40a0009a","sourcePort":"2f574b60-0503-4893-9a06-792aae8af40b","target":"f74ab2a2-354d-47d5-ba3e-d58db444297c","targetPort":"1fea1de8-086f-4881-a887-7b6a15ab9879","points":[{"id":"00a8466a-2bbf-4b60-b80a-45d32fa30766","type":"point","x":309,"y":192},{"id":"344ecf6d-eecf-479f-9b7f-2b3e92949a83","type":"point","x":309,"y":320.00001605954077},{"id":"c3521f4c-ccc4-459d-ae3d-26d505a65101","type":"point","x":578.9999933719429,"y":320.00001605954077}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"f74ab2a2-354d-47d5-ba3e-d58db444297c","local_column_attnum":"4","referenced_table_uid":"597d6a10-1676-4c56-816b-e2fc40a0009a","referenced_column_attnum":"0"}},"862af5ff-d574-45f1-9d40-cc12bad906c8":{"id":"862af5ff-d574-45f1-9d40-cc12bad906c8","locked":true,"type":"onetomany","selected":false,"source":"f74ab2a2-354d-47d5-ba3e-d58db444297c","sourcePort":"3674d7cd-0c59-4512-8402-1d2b320e149d","target":"990fa10f-c18c-4ea2-a85e-594fb61836fd","targetPort":"0487569f-f346-4efd-bbe2-2e02b012a177","points":[{"id":"86947add-10ae-4caa-8495-2ab76ceb3e66","type":"point","x":578.9999933719429,"y":191.99998685049695},{"id":"a4a87798-5984-49c7-8c08-7cad70ab2d35","type":"point","x":613,"y":191.99998685049695},{"id":"66f7bc18-3700-4b1b-b235-ca050479d239","type":"point","x":613,"y":349},{"id":"ace37fa0-1346-4128-a16f-a3f3b69031de","type":"point","x":879,"y":349}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"990fa10f-c18c-4ea2-a85e-594fb61836fd","local_column_attnum":"5","referenced_table_uid":"f74ab2a2-354d-47d5-ba3e-d58db444297c","referenced_column_attnum":"0"}}}},{"id":"e68899a5-71b4-4cfe-8c97-6d60d47ed809","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"597d6a10-1676-4c56-816b-e2fc40a0009a":{"id":"597d6a10-1676-4c56-816b-e2fc40a0009a","type":"table","selected":false,"x":105,"y":90,"ports":[{"id":"2f574b60-0503-4893-9a06-792aae8af40b","type":"onetomany","x":279,"y":192,"name":"coll-port-0","alignment":"right","parentNode":"597d6a10-1676-4c56-816b-e2fc40a0009a","links":["41c05327-435d-4e4e-8f2f-2795a9ad25a5"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["2f574b60-0503-4893-9a06-792aae8af40b"],"otherInfo":{"data":{"name":"users","schema":"public","columns":[{"name":"_id","attnum":0,"cltype":"integer","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"name","attnum":1,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"last_name","attnum":2,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"email","attnum":3,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"}],"primary_key":[{"columns":[{"column":"_id"}],"include":[]}]},"note":""}},"f74ab2a2-354d-47d5-ba3e-d58db444297c":{"id":"f74ab2a2-354d-47d5-ba3e-d58db444297c","type":"table","selected":false,"x":375,"y":90,"ports":[{"id":"1fea1de8-086f-4881-a887-7b6a15ab9879","type":"onetomany","x":548.9999933719429,"y":320.00001605954077,"name":"coll-port-4","alignment":"right","parentNode":"f74ab2a2-354d-47d5-ba3e-d58db444297c","links":["41c05327-435d-4e4e-8f2f-2795a9ad25a5"],"subtype":"many"},{"id":"3674d7cd-0c59-4512-8402-1d2b320e149d","type":"onetomany","x":548.9999933719429,"y":191.99998685049695,"name":"coll-port-0","alignment":"right","parentNode":"f74ab2a2-354d-47d5-ba3e-d58db444297c","links":["862af5ff-d574-45f1-9d40-cc12bad906c8"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["1fea1de8-086f-4881-a887-7b6a15ab9879","3674d7cd-0c59-4512-8402-1d2b320e149d"],"otherInfo":{"data":{"name":"products","schema":"public","columns":[{"name":"_id","attnum":0,"cltype":"integer","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"name","attnum":1,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"url","attnum":2,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"created_at","attnum":3,"cltype":"timestamp with time zone","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"_user_id","attnum":4,"cltype":"integer","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"image_url","attnum":5,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"status","attnum":6,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"rgb","attnum":7,"cltype":"integer[]","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"category","attnum":8,"cltype":"text[]","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"seller","attnum":9,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"price","attnum":10,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"isBuybox","attnum":11,"cltype":"boolean","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"catalogue_id","attnum":12,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"ml_id","attnum":13,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"}],"primary_key":[{"columns":[{"column":"_id"}],"include":[]}]},"note":""}},"990fa10f-c18c-4ea2-a85e-594fb61836fd":{"id":"990fa10f-c18c-4ea2-a85e-594fb61836fd","type":"table","selected":false,"x":675,"y":90,"ports":[{"id":"0487569f-f346-4efd-bbe2-2e02b012a177","type":"onetomany","x":849,"y":349,"name":"coll-port-5","alignment":"right","parentNode":"990fa10f-c18c-4ea2-a85e-594fb61836fd","links":["862af5ff-d574-45f1-9d40-cc12bad906c8"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["0487569f-f346-4efd-bbe2-2e02b012a177"],"otherInfo":{"data":{"name":"sales_registers","schema":"public","columns":[{"name":"_timestamp","attnum":0,"cltype":"timestamp with time zone","min_val_attlen":0,"max_val_attlen":6,"is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"daily_sells","attnum":1,"cltype":"integer","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"acumulated_sells","attnum":2,"cltype":"integer","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"dailly_visits","attnum":3,"cltype":"integer","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"acumulated_visits","attnum":4,"cltype":"integer","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"},{"name":"_product_id","attnum":5,"cltype":"integer","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"a","colconstype":"n","old_attidentity":"a"}],"primary_key":[{"columns":[{"column":"_timestamp"},{"column":"_product_id"}],"include":[]}]},"note":""}}}}]}}