ERD-project.pgerd

{"version":"61000","data":{"id":"e796cea2-c98f-4202-af11-b5e06ea3f04b","offsetX":79.7282583777457,"offsetY":-389.1953357445363,"zoom":82.76447413497762,"gridSize":15,"layers":[{"id":"f79f8bd3-4ce1-46f1-bd34-f756993807c4","type":"diagram-links","isSvg":true,"transformed":true,"models":{"8c245981-fd37-4dac-89a1-5d46ea32040f":{"id":"8c245981-fd37-4dac-89a1-5d46ea32040f","locked":true,"type":"onetomany","selected":false,"source":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","sourcePort":"23868b41-9aaf-4991-b387-6fcb5afccdfd","target":"43aefa7b-f38e-450b-926d-1f4b59373c1a","targetPort":"d5bba16d-ac8a-4b29-9744-2509f12a11e4","points":[{"id":"31baec65-5277-488a-95dd-2872fdbb9048","type":"point","x":278.9999967398155,"y":491.3749901815404},{"id":"128811cf-c3f7-4da8-a30b-6780c555fffd","type":"point","x":294.04927300158994,"y":491.3749901815404},{"id":"8a2b45e9-d53a-4bb8-86d7-a1c82e4ba90a","type":"point","x":294.04927300158994,"y":716.4127246526155},{"id":"64678a52-76bc-40f0-ac62-ab9559ad60e3","type":"point","x":609.0000016738117,"y":716.4127246526155},{"id":"fc56669e-c06c-48f5-a476-6f0a324dee96","type":"point","x":609.0000016738117,"y":680.5312357293855}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"43aefa7b-f38e-450b-926d-1f4b59373c1a","local_column_attnum":7,"referenced_table_uid":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","referenced_column_attnum":1}},"19218625-3cd1-4d73-a5b2-4b1f3ba84ab7":{"id":"19218625-3cd1-4d73-a5b2-4b1f3ba84ab7","locked":true,"type":"onetomany","selected":false,"source":"43aefa7b-f38e-450b-926d-1f4b59373c1a","sourcePort":"632944c3-1620-4006-bdd5-a9d988823092","target":"6a3e002a-12d9-4f18-8115-c63b9b65d319","targetPort":"801d4500-c0d2-4b31-9fec-86d97a41caca","points":[{"id":"576df2fe-e1ce-4845-972d-5551bc9a2a67","type":"point","x":609.0000016738117,"y":446.3749886333329},{"id":"758f62fa-9580-4046-a209-c4e411432727","type":"point","x":637.7407796438835,"y":446.3749886333329},{"id":"36035a2f-8877-4ab9-aa5c-66b386180e07","type":"point","x":637.7407796438835,"y":729.3441257626162},{"id":"c4b9be7c-3805-4ba0-81a6-817a49dcbd9d","type":"point","x":334.2034991882061,"y":729.3441257626162},{"id":"ccf91c04-0a82-4f40-9bf0-6bf7b90b34fe","type":"point","x":334.2034991882061,"y":1135.5625155409484},{"id":"e6c97364-742b-49fc-88e5-fe8808239a2a","type":"point","x":270.25001703475175,"y":1135.5625155409484}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6a3e002a-12d9-4f18-8115-c63b9b65d319","local_column_attnum":8,"referenced_table_uid":"43aefa7b-f38e-450b-926d-1f4b59373c1a","referenced_column_attnum":1}},"a7e61185-2a6b-48c3-87cd-308f17c3d55b":{"id":"a7e61185-2a6b-48c3-87cd-308f17c3d55b","locked":true,"type":"onetomany","selected":false,"source":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","sourcePort":"23868b41-9aaf-4991-b387-6fcb5afccdfd","target":"6a3e002a-12d9-4f18-8115-c63b9b65d319","targetPort":"3bc4a09a-6493-4336-b32c-32b7026f4080","points":[{"id":"5d92210f-bbf4-4dd8-95ee-c61f596a2192","type":"point","x":278.9999967398155,"y":491.3749901815404},{"id":"78d5687b-6c93-4e0b-b1da-e3ddb5fc4b1f","type":"point","x":294.29842797616857,"y":491.3749901815404},{"id":"6d132928-3ec3-469b-8273-5ad63b321caf","type":"point","x":294.29842797616857,"y":1106.5624903630035},{"id":"6e010a99-0edc-45e4-90ab-13560bfe9533","type":"point","x":270.25001703475175,"y":1106.5624903630035}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6a3e002a-12d9-4f18-8115-c63b9b65d319","local_column_attnum":7,"referenced_table_uid":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","referenced_column_attnum":1}},"c29cd509-503c-4994-b253-6301fa460bf9":{"id":"c29cd509-503c-4994-b253-6301fa460bf9","locked":true,"type":"onetomany","selected":false,"source":"6a3e002a-12d9-4f18-8115-c63b9b65d319","sourcePort":"6e0ad995-0367-41ac-a8ac-26e4b0834bd9","target":"c2e89893-a7f1-4f37-8723-23e974744d92","targetPort":"59a21ba2-1273-4c9c-99ba-2f3a1fc52aea","points":[{"id":"711449b3-9f04-4a73-96c7-20c7edc074f1","type":"point","x":270.25001703475175,"y":884.4374701760573},{"id":"af9ec793-ded1-4bb8-ba73-97434ef75b1e","type":"point","x":380.3536560939153,"y":884.4374701760573},{"id":"968c7487-69ef-46ac-87ef-597998dc9300","type":"point","x":380.3536560939153,"y":748.513668313499},{"id":"09871bd9-a4b4-4872-93b5-61ad13ec6e22","type":"point","x":609.0000016738117,"y":748.513668313499},{"id":"5291fb87-83d6-4b4d-b8f3-3dd70fb0bbcc","type":"point","x":609.0000016738117,"y":908.4062310245139}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"c2e89893-a7f1-4f37-8723-23e974744d92","local_column_attnum":1,"referenced_table_uid":"6a3e002a-12d9-4f18-8115-c63b9b65d319","referenced_column_attnum":1}},"c38ba6e4-68bb-46d9-97e9-ddd1416fb33c":{"id":"c38ba6e4-68bb-46d9-97e9-ddd1416fb33c","locked":true,"type":"onetomany","selected":false,"source":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","sourcePort":"08852cc4-0208-401c-b298-7af6c9a3e137","target":"c2e89893-a7f1-4f37-8723-23e974744d92","targetPort":"0e849213-622a-4c4e-a2e2-3e392c6d15ab","points":[{"id":"a2da1054-ba8a-4560-8a9e-bcff679f30e8","type":"point","x":609.0000016738117,"y":1136.3749963237008},{"id":"96badcf5-1d89-426f-bdc5-21fa8ad070bc","type":"point","x":653.1374441548656,"y":1136.3749963237008},{"id":"7e3c059d-bcc7-4c41-b093-fde5a3a18fc6","type":"point","x":653.1374441548656,"y":937.3279451029596},{"id":"2b5d7893-db8d-406a-a76f-7f8ad1fdff15","type":"point","x":622.4272358974906,"y":937.3279451029596},{"id":"0b4bd216-0dec-417c-8903-0b02051d1f2a","type":"point","x":622.4272358974906,"y":937.406217685308},{"id":"e02a448b-19ce-401c-b942-a4fb21c26299","type":"point","x":609.0000016738117,"y":937.406217685308}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"c2e89893-a7f1-4f37-8723-23e974744d92","local_column_attnum":2,"referenced_table_uid":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","referenced_column_attnum":1}},"03a891e8-7fab-4147-bc0b-12c63942cc88":{"id":"03a891e8-7fab-4147-bc0b-12c63942cc88","locked":true,"type":"onetomany","selected":false,"source":"af5c20ed-9fa6-421f-bee3-f42a7f188232","sourcePort":"44c91d1a-9c66-46b8-8386-96183a53ec3c","target":"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86","targetPort":"d16363e6-38fd-480d-93dc-9e674211cb98","points":[{"id":"6c0ad0e9-bac4-4f3d-aa29-a1513df4dc48","type":"point","x":864.0000264958001,"y":1541.3749813697045},{"id":"71a179f6-8f44-46f4-acf0-de25f7f9b9dc","type":"point","x":864.0000264958001,"y":1541.3749813697045},{"id":"9184d6eb-e6cb-4fd0-92b4-7a1287dd54a0","type":"point","x":864.0000264958001,"y":1387.4062139088069}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86","local_column_attnum":2,"referenced_table_uid":"af5c20ed-9fa6-421f-bee3-f42a7f188232","referenced_column_attnum":1}},"fcd6c064-3328-4886-9162-afe952c0bd93":{"id":"fcd6c064-3328-4886-9162-afe952c0bd93","locked":true,"type":"onetomany","selected":false,"source":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","sourcePort":"08852cc4-0208-401c-b298-7af6c9a3e137","target":"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86","targetPort":"c25321d5-ad93-4e03-ac73-e5cd075ad51d","points":[{"id":"396b3693-ca1a-43c9-a6d1-e22a0687dcc2","type":"point","x":609.0000016738117,"y":1136.3749963237008},{"id":"eef777bd-78a4-462e-8f0a-3fbd9654bdce","type":"point","x":653.244955156707,"y":1136.3749963237008},{"id":"71d4a40c-f60d-4585-8b16-7e4202653df4","type":"point","x":653.244955156707,"y":1212.587565114256},{"id":"1aa1e688-5416-4ff2-8d68-950cd87fbbab","type":"point","x":864.0000264958001,"y":1212.587565114256},{"id":"651143e3-d8c4-42a4-9c5c-9f6a14c7b037","type":"point","x":864.0000264958001,"y":1358.4062657651639}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86","local_column_attnum":1,"referenced_table_uid":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","referenced_column_attnum":1}}}},{"id":"77b19a22-5c29-49e0-afc0-9a6ce2ffc82f","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"af5c20ed-9fa6-421f-bee3-f42a7f188232":{"id":"af5c20ed-9fa6-421f-bee3-f42a7f188232","type":"table","selected":false,"x":660,"y":1440,"ports":[{"id":"44c91d1a-9c66-46b8-8386-96183a53ec3c","type":"onetomany","x":834.0000264958001,"y":1541.3749813697045,"name":"coll-port-1","alignment":"right","parentNode":"af5c20ed-9fa6-421f-bee3-f42a7f188232","links":["03a891e8-7fab-4147-bc0b-12c63942cc88"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["44c91d1a-9c66-46b8-8386-96183a53ec3c"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('category_id_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"category","is_view_only":false,"seqrelid":16603,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"name","atttypid":1043,"attlen":"255","attnum":2,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(255)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"category","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying(255)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"createAt","atttypid":1184,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"category","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updateAt","atttypid":1184,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"category","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"category","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16611,"name":"PK_9c4e4a89e3674fc9f382d733f03","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[{"oid":16613,"name":"UQ_23c05c292c439d77b0de816b500","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"name"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"43aefa7b-f38e-450b-926d-1f4b59373c1a":{"id":"43aefa7b-f38e-450b-926d-1f4b59373c1a","type":"table","selected":false,"x":405,"y":345,"ports":[{"id":"d5bba16d-ac8a-4b29-9744-2509f12a11e4","type":"onetomany","x":579.0000016738117,"y":680.5312357293855,"name":"coll-port-7","alignment":"right","parentNode":"43aefa7b-f38e-450b-926d-1f4b59373c1a","links":["8c245981-fd37-4dac-89a1-5d46ea32040f"],"subtype":"many"},{"id":"632944c3-1620-4006-bdd5-a9d988823092","type":"onetomany","x":579.0000016738117,"y":446.3749886333329,"name":"coll-port-1","alignment":"right","parentNode":"43aefa7b-f38e-450b-926d-1f4b59373c1a","links":["19218625-3cd1-4d73-a5b2-4b1f3ba84ab7"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["d5bba16d-ac8a-4b29-9744-2509f12a11e4","632944c3-1620-4006-bdd5-a9d988823092"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('customer_id_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"customer","is_view_only":false,"seqrelid":16519,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"name","atttypid":1043,"attlen":"100","attnum":2,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"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":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"customer","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(100)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"lastName","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"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":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"customer","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(100)","character varying(100)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"phone","atttypid":1043,"attlen":"100","attnum":4,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"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":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"customer","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(100)","character varying(100)","character varying(100)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"createAt","atttypid":1184,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"customer","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updateAt","atttypid":1184,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"customer","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"userId","atttypid":23,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"customer","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":"customer","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16527,"name":"PK_a7a13f4cacb744524e44dfdad32","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"FK_3f62b42ed23958b120c235f74df","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[7],"confkey":[1],"confrelid":16496,"fknsp":"public","fktab":"customer","refnsp":"public","reftab":"user","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"userId","references":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","referenced":"id","references_table_name":"public.user"}],"remote_schema":"public","remote_table":"user","coveringindex":"REL_3f62b42ed23958b120c235f74d","autoindex":true,"hasindex":true}],"unique_constraint":[{"oid":16529,"name":"REL_3f62b42ed23958b120c235f74d","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"userId"}],"include":[]}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"6a3e002a-12d9-4f18-8115-c63b9b65d319":{"id":"6a3e002a-12d9-4f18-8115-c63b9b65d319","type":"table","selected":false,"x":66.25,"y":783.066650390625,"ports":[{"id":"801d4500-c0d2-4b31-9fec-86d97a41caca","type":"onetomany","x":240.25001703475178,"y":1135.5625155409484,"name":"coll-port-8","alignment":"right","parentNode":"6a3e002a-12d9-4f18-8115-c63b9b65d319","links":["19218625-3cd1-4d73-a5b2-4b1f3ba84ab7"],"subtype":"many"},{"id":"3bc4a09a-6493-4336-b32c-32b7026f4080","type":"onetomany","x":240.25001703475178,"y":1106.5624903630035,"name":"coll-port-7","alignment":"right","parentNode":"6a3e002a-12d9-4f18-8115-c63b9b65d319","links":["a7e61185-2a6b-48c3-87cd-308f17c3d55b"],"subtype":"many"},{"id":"6e0ad995-0367-41ac-a8ac-26e4b0834bd9","type":"onetomany","x":240.25001703475178,"y":884.4374701760573,"name":"coll-port-1","alignment":"right","parentNode":"6a3e002a-12d9-4f18-8115-c63b9b65d319","links":["c29cd509-503c-4994-b253-6301fa460bf9"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["801d4500-c0d2-4b31-9fec-86d97a41caca","3bc4a09a-6493-4336-b32c-32b7026f4080","6e0ad995-0367-41ac-a8ac-26e4b0834bd9"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('invoice_id_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice","is_view_only":false,"seqrelid":16538,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"number","atttypid":1043,"attlen":"10","attnum":2,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice","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(10)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"concept","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"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":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice","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(10)","character varying(100)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"price","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice","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":"createAt","atttypid":1184,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"invoice","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updateAt","atttypid":1184,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"invoice","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"userId","atttypid":23,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"customerId","atttypid":23,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"invoice","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16546,"name":"PK_15d25c200d9bcd8a33f698daf18","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"FK_925aa26ea12c28a6adb614445ee","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[8],"confkey":[1],"confrelid":16521,"fknsp":"public","fktab":"invoice","refnsp":"public","reftab":"customer","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"customerId","references":"43aefa7b-f38e-450b-926d-1f4b59373c1a","referenced":"id","references_table_name":"public.customer"}],"remote_schema":"public","remote_table":"customer","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"FK_f8e849201da83b87f78c7497dde","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[7],"confkey":[1],"confrelid":16496,"fknsp":"public","fktab":"invoice","refnsp":"public","reftab":"user","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"userId","references":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","referenced":"id","references_table_name":"public.user"}],"remote_schema":"public","remote_table":"user","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[{"oid":16548,"name":"UQ_60284980bc8b9c624459948f4ac","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"number"}],"include":[]}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"c2e89893-a7f1-4f37-8723-23e974744d92":{"id":"c2e89893-a7f1-4f37-8723-23e974744d92","type":"table","selected":false,"x":405,"y":795,"ports":[{"id":"59a21ba2-1273-4c9c-99ba-2f3a1fc52aea","type":"onetomany","x":579.0000016738117,"y":908.4062310245139,"name":"coll-port-1","alignment":"right","parentNode":"c2e89893-a7f1-4f37-8723-23e974744d92","links":["c29cd509-503c-4994-b253-6301fa460bf9"],"subtype":"many"},{"id":"0e849213-622a-4c4e-a2e2-3e392c6d15ab","type":"onetomany","x":579.0000016738117,"y":937.406217685308,"name":"coll-port-2","alignment":"right","parentNode":"c2e89893-a7f1-4f37-8723-23e974744d92","links":["c38ba6e4-68bb-46d9-97e9-ddd1416fb33c"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["59a21ba2-1273-4c9c-99ba-2f3a1fc52aea","0e849213-622a-4c4e-a2e2-3e392c6d15ab"],"otherInfo":{"data":{"columns":[{"name":"invoiceId","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice_products_product","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"productId","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"invoice_products_product","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"invoice_products_product","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16558,"name":"PK_df7d1fccacf2eff277abe1cd099","col_count":2,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"invoiceId"},{"column":"productId"}],"include":[]}],"foreign_key":[{"name":"FK_a3b2dbd445d44d8c0e4f5539b99","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":16540,"fknsp":"public","fktab":"invoice_products_product","refnsp":"public","reftab":"invoice","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"invoiceId","references":"6a3e002a-12d9-4f18-8115-c63b9b65d319","referenced":"id","references_table_name":"public.invoice"}],"remote_schema":"public","remote_table":"invoice","coveringindex":"IDX_a3b2dbd445d44d8c0e4f5539b9","autoindex":true,"hasindex":true},{"name":"FK_e6f5f590fa787115b251f224301","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16506,"fknsp":"public","fktab":"invoice_products_product","refnsp":"public","reftab":"product","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"productId","references":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","referenced":"id","references_table_name":"public.product"}],"remote_schema":"public","remote_table":"product","coveringindex":"IDX_e6f5f590fa787115b251f22430","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53":{"id":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","type":"table","selected":false,"x":405,"y":1035,"ports":[{"id":"08852cc4-0208-401c-b298-7af6c9a3e137","type":"onetomany","x":579.0000016738117,"y":1136.3749963237008,"name":"coll-port-1","alignment":"right","parentNode":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","links":["c38ba6e4-68bb-46d9-97e9-ddd1416fb33c","fcd6c064-3328-4886-9162-afe952c0bd93"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["08852cc4-0208-401c-b298-7af6c9a3e137"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('product_id_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"product","is_view_only":false,"seqrelid":16504,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"name","atttypid":1043,"attlen":"255","attnum":2,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(255)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"product","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(255)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"description","atttypid":25,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"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":"product","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":"price","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"product","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":"stock","atttypid":23,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"product","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"image","atttypid":1043,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying","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":"product","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(255)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"createAt","atttypid":1184,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"product","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updateAt","atttypid":1184,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"product","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"product","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16513,"name":"PK_bebc9158e480b949565b4dc7a82","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[{"oid":16515,"name":"UQ_22cc43e9a74d7498546e9a63e77","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"name"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86":{"id":"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86","type":"table","selected":false,"x":660,"y":1245,"ports":[{"id":"d16363e6-38fd-480d-93dc-9e674211cb98","type":"onetomany","x":834.0000264958001,"y":1387.4062139088069,"name":"coll-port-2","alignment":"right","parentNode":"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86","links":["03a891e8-7fab-4147-bc0b-12c63942cc88"],"subtype":"many"},{"id":"c25321d5-ad93-4e03-ac73-e5cd075ad51d","type":"onetomany","x":834.0000264958001,"y":1358.4062657651639,"name":"coll-port-1","alignment":"right","parentNode":"5f7b6a3e-1bdb-4ff1-81b1-8ed317170b86","links":["fcd6c064-3328-4886-9162-afe952c0bd93"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["d16363e6-38fd-480d-93dc-9e674211cb98","c25321d5-ad93-4e03-ac73-e5cd075ad51d"],"otherInfo":{"data":{"columns":[{"name":"productId","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"product_categories_category","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["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":"categoryId","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"product_categories_category","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["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":"product_categories_category","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16628,"name":"PK_17f2a361443184000ee8d79f240","col_count":2,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"productId"},{"column":"categoryId"}],"include":[]}],"foreign_key":[{"name":"FK_15520e638eb4c46c4fb2c61c4b4","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16605,"fknsp":"public","fktab":"product_categories_category","refnsp":"public","reftab":"category","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"categoryId","references":"af5c20ed-9fa6-421f-bee3-f42a7f188232","referenced":"id","references_table_name":"public.category"}],"remote_schema":"public","remote_table":"category","coveringindex":"IDX_15520e638eb4c46c4fb2c61c4b","autoindex":true,"hasindex":true},{"name":"FK_342d06dd0583aafc156e0763790","condeferrable":false,"condeferred":false,"confupdtype":"c","confdeltype":"c","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":16506,"fknsp":"public","fktab":"product_categories_category","refnsp":"public","reftab":"product","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"productId","references":"fcd611a2-e5ff-41b7-ba2b-ea05f5ac1e53","referenced":"id","references_table_name":"public.product"}],"remote_schema":"public","remote_table":"product","coveringindex":"IDX_342d06dd0583aafc156e076379","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"cfbcbb5f-7389-4e25-8b92-9f0233ec749d":{"id":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","type":"table","selected":false,"x":75,"y":390,"ports":[{"id":"23868b41-9aaf-4991-b387-6fcb5afccdfd","type":"onetomany","x":248.99999673981554,"y":491.3749901815404,"name":"coll-port-1","alignment":"right","parentNode":"cfbcbb5f-7389-4e25-8b92-9f0233ec749d","links":["8c245981-fd37-4dac-89a1-5d46ea32040f","a7e61185-2a6b-48c3-87cd-308f17c3d55b"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["23868b41-9aaf-4991-b387-6fcb5afccdfd"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('user_id_seq'::regclass)","typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"user","is_view_only":false,"seqrelid":16494,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"email","atttypid":1043,"attlen":"30","attnum":2,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","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":"user","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(30)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"password","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"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":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"user","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(100)","character varying(30)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"role","atttypid":1043,"attlen":"20","attnum":4,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"user","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(100)","character varying(20)","character varying(30)","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"createAt","atttypid":1184,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"user","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updateAt","atttypid":1184,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","elemoid":1184,"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":"user","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","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"user","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16500,"name":"PK_cace4a159ff9f2512dd42373760","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[{"oid":16502,"name":"UQ_e12875dfb3b1d92d7d7c5377e22","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"email"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}