ERD

{"version":"70000","data":{"id":"8d326f55-ec17-46aa-b675-18d932767602","offsetX":144.1319068312644,"offsetY":15.20078785220781,"zoom":80.71968485911688,"gridSize":15,"layers":[{"id":"628720e4-9be8-48ce-936a-852b036e2a03","type":"diagram-links","isSvg":true,"transformed":true,"models":{"915bf8d5-918a-4b67-ba2e-c312bb130b0f":{"id":"915bf8d5-918a-4b67-ba2e-c312bb130b0f","locked":true,"type":"onetomany","source":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","sourcePort":"9fc45fb6-92a6-4708-ad90-6ab3e2323fa4","target":"b34af872-e5b8-4466-9c3f-7c486ee419cc","targetPort":"5c46f46e-de1e-42e4-9c0a-b53c9a080750","points":[{"id":"62f09ceb-8f49-4ec6-9eea-68120687c9bd","type":"point","x":321.5,"y":290.03125},{"id":"2c06783d-8372-4110-9543-163d9b37e6af","type":"point","x":434,"y":478.09375},{"id":"a2e5fc47-2a4f-478a-a480-58bd496eed83","type":"point","x":434,"y":620.09375}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"b34af872-e5b8-4466-9c3f-7c486ee419cc","local_column_attnum":2,"referenced_table_uid":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","referenced_column_attnum":1}},"81d15705-7966-4324-9c14-907450d51ea7":{"id":"81d15705-7966-4324-9c14-907450d51ea7","locked":true,"type":"onetomany","source":"8a47da42-e71a-47d8-8347-945835d6d512","sourcePort":"0171af5d-07c9-4905-b9d6-cee5293b7ba4","target":"b34af872-e5b8-4466-9c3f-7c486ee419cc","targetPort":"e2bd011d-e566-4834-be56-4d5d1d3bc7c5","points":[{"id":"682c5afb-532d-43ab-bddd-9d71ca1f73de","type":"point","x":546.5,"y":339.5625},{"id":"2959b4ba-cbaa-447f-a4c8-acef23ed2a37","type":"point","x":434,"y":478.09375},{"id":"242ad58a-4cb5-492c-bd7f-637da20b1856","type":"point","x":434,"y":645.09375}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"b34af872-e5b8-4466-9c3f-7c486ee419cc","local_column_attnum":3,"referenced_table_uid":"8a47da42-e71a-47d8-8347-945835d6d512","referenced_column_attnum":1}},"00354540-a0d9-4c22-87eb-e62319aacb1c":{"id":"00354540-a0d9-4c22-87eb-e62319aacb1c","locked":true,"type":"onetomany","source":"fff345b7-6b68-42cd-8ec6-477e7f1fb402","sourcePort":"c4900fcf-d4dc-49e7-be0d-3670dfcc462d","target":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","targetPort":"f406cb54-8de1-4b21-87eb-93faee01d41d","points":[{"id":"6032a6a4-a1d9-4fb5-86cd-85921ca4414d","type":"point","x":209,"y":97},{"id":"b9e1341e-67b9-47b1-b9c5-3a1dba47551c","type":"point","x":321.5,"y":173.03125},{"id":"91f7552d-06da-422a-8745-00d459978200","type":"point","x":321.5,"y":414.09375}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","local_column_attnum":5,"referenced_table_uid":"fff345b7-6b68-42cd-8ec6-477e7f1fb402","referenced_column_attnum":1}},"e9a84537-281a-4df8-9073-7faf2d22f508":{"id":"e9a84537-281a-4df8-9073-7faf2d22f508","locked":true,"type":"onetomany","source":"77c0423e-14b5-4aaf-b103-27cbf06baab1","sourcePort":"ebd28a8e-41ad-4cf0-aeb3-90b1f9a0c907","target":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","targetPort":"0be19f5b-15ff-4958-b5d2-c4ff5e95797f","points":[{"id":"c9f64d4a-254b-41b2-851f-0678565ca959","type":"point","x":434,"y":97},{"id":"8082f091-b1a2-4e5c-b674-2ccf9ad95ed0","type":"point","x":321.5,"y":173.03125},{"id":"d3634ed4-5a5d-411f-a489-576f5e1cc2d9","type":"point","x":321.5,"y":439.09375}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","local_column_attnum":6,"referenced_table_uid":"77c0423e-14b5-4aaf-b103-27cbf06baab1","referenced_column_attnum":1}}}},{"id":"cf176f94-1905-41f4-bd01-47b1ca700466","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"b34af872-e5b8-4466-9c3f-7c486ee419cc":{"id":"b34af872-e5b8-4466-9c3f-7c486ee419cc","type":"table","x":230,"y":503.09375,"ports":[{"id":"8b76ee60-2333-41b9-961a-5c442de4429e","type":"onetomany","x":231,"y":620.09375,"name":"coll-port-2-left","alignment":"left","parentNode":"b34af872-e5b8-4466-9c3f-7c486ee419cc","links":[]},{"id":"5c46f46e-de1e-42e4-9c0a-b53c9a080750","type":"onetomany","x":404,"y":620.09375,"name":"coll-port-2-right","alignment":"right","parentNode":"b34af872-e5b8-4466-9c3f-7c486ee419cc","links":["915bf8d5-918a-4b67-ba2e-c312bb130b0f"]},{"id":"736d58a1-0dd0-49c0-8faf-0af68f399964","type":"onetomany","x":231,"y":645.09375,"name":"coll-port-3-left","alignment":"left","parentNode":"b34af872-e5b8-4466-9c3f-7c486ee419cc","links":[]},{"id":"e2bd011d-e566-4834-be56-4d5d1d3bc7c5","type":"onetomany","x":404,"y":645.09375,"name":"coll-port-3-right","alignment":"right","parentNode":"b34af872-e5b8-4466-9c3f-7c486ee419cc","links":["81d15705-7966-4324-9c14-907450d51ea7"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["8b76ee60-2333-41b9-961a-5c442de4429e","5c46f46e-de1e-42e4-9c0a-b53c9a080750","736d58a1-0dd0-49c0-8faf-0af68f399964","e2bd011d-e566-4834-be56-4d5d1d3bc7c5"],"otherInfo":{"data":{"columns":[{"name":"id_fat_venda","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('tb_fat_vendas_troca_id_fat_venda_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":"tb_fat_vendas_troca","is_view_only":false,"seqrelid":16737,"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":"fk_dim_livro","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_fat_vendas_troca","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":"fk_dim_tempo","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_fat_vendas_troca","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":"quantidade_vendida","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_fat_vendas_troca","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":"valor_total","atttypid":1700,"attlen":"10","attnum":5,"attndims":0,"atttypmod":655366,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,2)","cltype":"numeric","elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_fat_vendas_troca","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]}],"name":"tb_fat_vendas_troca","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16742,"name":"tb_fat_vendas_troca_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_fat_venda"}],"include":[]}],"foreign_key":[{"name":"tb_fat_vendas_troca_fk_dim_livro_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16721,"fknsp":"public","fktab":"tb_fat_vendas_troca","refnspoid":2200,"refnsp":"public","reftab":"tb_dim_livro","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"fk_dim_livro","references":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","referenced":"id_livro","references_table_name":"public.tb_dim_livro"}],"remote_schema":"public","remote_table":"tb_dim_livro","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"tb_fat_vendas_troca_fk_dim_tempo_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16714,"fknsp":"public","fktab":"tb_fat_vendas_troca","refnspoid":2200,"refnsp":"public","reftab":"tb_dim_tempo","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"fk_dim_tempo","references":"8a47da42-e71a-47d8-8347-945835d6d512","referenced":"id_tempo","references_table_name":"public.tb_dim_tempo"}],"remote_schema":"public","remote_table":"tb_dim_tempo","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c":{"id":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","type":"table","x":117.5,"y":198.03125,"ports":[{"id":"62e9bbce-dd2d-45fc-8124-e700135850ed","type":"onetomany","x":118.5,"y":290.03125,"name":"coll-port-1-left","alignment":"left","parentNode":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","links":[]},{"id":"9fc45fb6-92a6-4708-ad90-6ab3e2323fa4","type":"onetomany","x":291.5,"y":290.03125,"name":"coll-port-1-right","alignment":"right","parentNode":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","links":["915bf8d5-918a-4b67-ba2e-c312bb130b0f"]},{"id":"b4c2e3bb-4956-406d-9bb5-78c5ea16f5be","type":"onetomany","x":118.5,"y":414.09375,"name":"coll-port-5-left","alignment":"left","parentNode":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","links":[]},{"id":"f406cb54-8de1-4b21-87eb-93faee01d41d","type":"onetomany","x":291.5,"y":414.09375,"name":"coll-port-5-right","alignment":"right","parentNode":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","links":["00354540-a0d9-4c22-87eb-e62319aacb1c"]},{"id":"05eba145-16ac-4d49-a260-91628186797e","type":"onetomany","x":118.5,"y":439.09375,"name":"coll-port-6-left","alignment":"left","parentNode":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","links":[]},{"id":"0be19f5b-15ff-4958-b5d2-c4ff5e95797f","type":"onetomany","x":291.5,"y":439.09375,"name":"coll-port-6-right","alignment":"right","parentNode":"e0b1c6b8-d7de-4e02-ab0e-4639663bd19c","links":["e9a84537-281a-4df8-9073-7faf2d22f508"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["62e9bbce-dd2d-45fc-8124-e700135850ed","9fc45fb6-92a6-4708-ad90-6ab3e2323fa4","b4c2e3bb-4956-406d-9bb5-78c5ea16f5be","f406cb54-8de1-4b21-87eb-93faee01d41d","05eba145-16ac-4d49-a260-91628186797e","0be19f5b-15ff-4958-b5d2-c4ff5e95797f"],"otherInfo":{"data":{"columns":[{"name":"id_livro","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('tb_dim_livro_id_livro_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":"tb_dim_livro","is_view_only":false,"seqrelid":16720,"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":"titulo","atttypid":1043,"attlen":"250","attnum":2,"attndims":0,"atttypmod":254,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(250)","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":"tb_dim_livro","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":"preco","atttypid":1700,"attlen":"10","attnum":3,"attndims":0,"atttypmod":655367,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,3)","cltype":"numeric","elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_dim_livro","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":"3","edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"estrelas","atttypid":1043,"attlen":"20","attnum":4,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":false,"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":"tb_dim_livro","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":"fk_dim_categoria","atttypid":23,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_dim_livro","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":"fk_dim_estoque","atttypid":23,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_dim_livro","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":"tb_dim_livro","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16725,"name":"tb_dim_livro_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_livro"}],"include":[]}],"foreign_key":[{"name":"tb_dim_livro_fk_dim_categoria_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":16696,"fknsp":"public","fktab":"tb_dim_livro","refnspoid":2200,"refnsp":"public","reftab":"tb_dim_categoria","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"fk_dim_categoria","references":"fff345b7-6b68-42cd-8ec6-477e7f1fb402","referenced":"id_categoria","references_table_name":"public.tb_dim_categoria"}],"remote_schema":"public","remote_table":"tb_dim_categoria","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"tb_dim_livro_fk_dim_estoque_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":16705,"fknsp":"public","fktab":"tb_dim_livro","refnspoid":2200,"refnsp":"public","reftab":"tb_dim_estoque","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"fk_dim_estoque","references":"77c0423e-14b5-4aaf-b103-27cbf06baab1","referenced":"id_estoque","references_table_name":"public.tb_dim_estoque"}],"remote_schema":"public","remote_table":"tb_dim_estoque","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"fff345b7-6b68-42cd-8ec6-477e7f1fb402":{"id":"fff345b7-6b68-42cd-8ec6-477e7f1fb402","type":"table","x":5,"y":5,"ports":[{"id":"c6379396-8e09-4cbb-ada6-b80ec267969e","type":"onetomany","x":6,"y":97,"name":"coll-port-1-left","alignment":"left","parentNode":"fff345b7-6b68-42cd-8ec6-477e7f1fb402","links":[]},{"id":"c4900fcf-d4dc-49e7-be0d-3670dfcc462d","type":"onetomany","x":179,"y":97,"name":"coll-port-1-right","alignment":"right","parentNode":"fff345b7-6b68-42cd-8ec6-477e7f1fb402","links":["00354540-a0d9-4c22-87eb-e62319aacb1c"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["c6379396-8e09-4cbb-ada6-b80ec267969e","c4900fcf-d4dc-49e7-be0d-3670dfcc462d"],"otherInfo":{"data":{"columns":[{"name":"id_categoria","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('tb_dim_categoria_id_categoria_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":"tb_dim_categoria","is_view_only":false,"seqrelid":16695,"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":"categoria","atttypid":1043,"attlen":"50","attnum":2,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_dim_categoria","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":"tb_dim_categoria","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16700,"name":"tb_dim_categoria_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_categoria"}],"include":[]}],"unique_constraint":[{"oid":16702,"name":"unique_categoria","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"categoria"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"77c0423e-14b5-4aaf-b103-27cbf06baab1":{"id":"77c0423e-14b5-4aaf-b103-27cbf06baab1","type":"table","x":230,"y":5,"ports":[{"id":"5f06b4c2-58d5-4bea-a07e-40e5165d3fef","type":"onetomany","x":231,"y":97,"name":"coll-port-1-left","alignment":"left","parentNode":"77c0423e-14b5-4aaf-b103-27cbf06baab1","links":[]},{"id":"ebd28a8e-41ad-4cf0-aeb3-90b1f9a0c907","type":"onetomany","x":404,"y":97,"name":"coll-port-1-right","alignment":"right","parentNode":"77c0423e-14b5-4aaf-b103-27cbf06baab1","links":["e9a84537-281a-4df8-9073-7faf2d22f508"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["5f06b4c2-58d5-4bea-a07e-40e5165d3fef","ebd28a8e-41ad-4cf0-aeb3-90b1f9a0c907"],"otherInfo":{"data":{"columns":[{"name":"id_estoque","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('tb_dim_estoque_id_estoque_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":"tb_dim_estoque","is_view_only":false,"seqrelid":16704,"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":"estoque","atttypid":1043,"attlen":"50","attnum":2,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tb_dim_estoque","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":"tb_dim_estoque","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16709,"name":"tb_dim_estoque_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_estoque"}],"include":[]}],"unique_constraint":[{"oid":16711,"name":"unique_estoque","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"estoque"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"8a47da42-e71a-47d8-8347-945835d6d512":{"id":"8a47da42-e71a-47d8-8347-945835d6d512","type":"table","x":342.5,"y":247.5625,"ports":[{"id":"ae700c3b-7e2d-479c-b07b-0a1be22224d4","type":"onetomany","x":343.5,"y":339.5625,"name":"coll-port-1-left","alignment":"left","parentNode":"8a47da42-e71a-47d8-8347-945835d6d512","links":[]},{"id":"0171af5d-07c9-4905-b9d6-cee5293b7ba4","type":"onetomany","x":516.5,"y":339.5625,"name":"coll-port-1-right","alignment":"right","parentNode":"8a47da42-e71a-47d8-8347-945835d6d512","links":["81d15705-7966-4324-9c14-907450d51ea7"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["ae700c3b-7e2d-479c-b07b-0a1be22224d4","0171af5d-07c9-4905-b9d6-cee5293b7ba4"],"otherInfo":{"data":{"columns":[{"name":"id_tempo","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"nextval('tb_dim_tempo_id_tempo_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":"tb_dim_tempo","is_view_only":false,"seqrelid":16713,"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":"data","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":"tb_dim_tempo","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":"hora","atttypid":1083,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"time without time zone","displaytypname":"time without time zone","cltype":"time without time zone","elemoid":1083,"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":"tb_dim_tempo","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":["interval","time with time zone","time without time zone","time without time zone"]}],"name":"tb_dim_tempo","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16718,"name":"tb_dim_tempo_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id_tempo"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}