vets-schema-diagram.pgerd

{"version":"62100","data":{"id":"e4d0254a-7d5d-496f-8676-9c48699d0a8c","offsetX":0,"offsetY":0,"zoom":100,"gridSize":15,"layers":[{"id":"ef1518f4-0fb4-4b82-a2f5-14af78b2f5b8","type":"diagram-links","isSvg":true,"transformed":true,"models":{"79dcf648-0e9c-4e61-91f6-55c7fae9c200":{"id":"79dcf648-0e9c-4e61-91f6-55c7fae9c200","locked":true,"type":"onetomany","selected":false,"source":"0834460f-b7e2-4363-8e6b-21947b4e3783","sourcePort":"8c87d2cd-c010-4119-9f1b-42bdecb55568","target":"759d3e38-a474-42bc-b871-7bf51cee5c50","targetPort":"b4dd1793-3e37-466c-a4ad-7927e91fea67","points":[{"id":"ab399e89-0dc8-4236-a6cc-335e8bba5257","type":"point","x":729,"y":387},{"id":"243a121e-d862-431b-919d-18955df0a247","type":"point","x":729,"y":392},{"id":"a31d36f9-070d-439c-aa2f-ec5ac75e15c6","type":"point","x":796,"y":392}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"759d3e38-a474-42bc-b871-7bf51cee5c50","local_column_attnum":1,"referenced_table_uid":"0834460f-b7e2-4363-8e6b-21947b4e3783","referenced_column_attnum":10}},"b117d4ce-7556-4af2-a7a6-1becadb8cf7a":{"id":"b117d4ce-7556-4af2-a7a6-1becadb8cf7a","locked":true,"type":"onetomany","selected":false,"source":"0834460f-b7e2-4363-8e6b-21947b4e3783","sourcePort":"e3f307ec-fbce-4b8b-8d89-b13bb64f0205","target":"7a797e75-e568-4977-969c-1cda12076fe2","targetPort":"2c40ccd8-c8ac-49e7-b8ec-cc39a165815f","points":[{"id":"b5a5d281-2873-4d3b-aaff-b581d06233af","type":"point","x":496,"y":362},{"id":"543b0ac1-829e-4866-97a9-feef027ae040","type":"point","x":496,"y":392},{"id":"c14ed665-8f93-4474-8124-4daf3b6f196f","type":"point","x":489,"y":392}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"7a797e75-e568-4977-969c-1cda12076fe2","local_column_attnum":1,"referenced_table_uid":"0834460f-b7e2-4363-8e6b-21947b4e3783","referenced_column_attnum":9}},"fd2ea81b-c58a-49ef-9b93-e9bac731aaff":{"id":"fd2ea81b-c58a-49ef-9b93-e9bac731aaff","locked":true,"type":"onetomany","selected":false,"source":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","sourcePort":"3a6841cb-81ca-4329-9a3a-12d0a843950f","target":"bc44c8ab-572f-44b9-b7e7-6b8beea41f09","targetPort":"30b4b01c-ac85-43ba-9de6-2a7179800d03","points":[{"id":"08cf611a-6b73-42c0-b2da-57e4aedfd5fc","type":"point","x":219,"y":317},{"id":"77cca849-cd9b-49e6-9645-ddeff1f5ec70","type":"point","x":218,"y":317},{"id":"b0f7b17a-d95e-41e4-94af-e6a5c426e8fd","type":"point","x":218,"y":107},{"id":"b2c423cf-bd65-4534-b192-3376c17c675a","type":"point","x":241,"y":107}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"bc44c8ab-572f-44b9-b7e7-6b8beea41f09","local_column_attnum":1,"referenced_table_uid":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","referenced_column_attnum":2}},"d9de334b-4bf1-48c1-aa04-a0133c60f6f4":{"id":"d9de334b-4bf1-48c1-aa04-a0133c60f6f4","locked":true,"type":"onetomany","selected":false,"source":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","sourcePort":"0719cc66-6231-41e1-8c2b-aacd6cdbd172","target":"7a797e75-e568-4977-969c-1cda12076fe2","targetPort":"11bc8b6c-f7b0-4644-bc43-282cf3aebde7","points":[{"id":"28fd0947-a1af-453d-b9aa-1330a712859d","type":"point","x":219,"y":342},{"id":"3be09126-43e2-4209-b8d2-f2e8cf5ca7f9","type":"point","x":219,"y":392},{"id":"6bbee866-1af5-4d40-8da7-d7583ded1426","type":"point","x":256,"y":392}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"7a797e75-e568-4977-969c-1cda12076fe2","local_column_attnum":1,"referenced_table_uid":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","referenced_column_attnum":1}},"c754b591-e1b5-45fd-a1d6-481a729bacb8":{"id":"c754b591-e1b5-45fd-a1d6-481a729bacb8","locked":true,"type":"onetomany","selected":false,"source":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","sourcePort":"4bc23fab-126e-4c3e-88a4-392ef09722a7","target":"bc44c8ab-572f-44b9-b7e7-6b8beea41f09","targetPort":"65ccaa72-0f0a-4087-a55e-7db04597e47d","points":[{"id":"9557a0db-c178-4040-b128-717ccd5f7d0a","type":"point","x":796,"y":137},{"id":"27ebe860-eed0-4d71-bb1d-f0677f760fa3","type":"point","x":796,"y":107},{"id":"a968e069-cafd-4604-84ab-12fe992881ff","type":"point","x":474,"y":107}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"bc44c8ab-572f-44b9-b7e7-6b8beea41f09","local_column_attnum":1,"referenced_table_uid":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","referenced_column_attnum":2}},"6887b72f-d0fd-4dbe-b983-9ee842f4542f":{"id":"6887b72f-d0fd-4dbe-b983-9ee842f4542f","locked":true,"type":"onetomany","selected":false,"source":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","sourcePort":"35426c52-e034-42ad-b59b-536e8d65110c","target":"0834460f-b7e2-4363-8e6b-21947b4e3783","targetPort":"7f68e532-4431-4211-8d3a-814b6b853945","points":[{"id":"04cac8c0-9414-428c-8ef0-b77f75bb4ce4","type":"point","x":796,"y":162},{"id":"87d24c21-e2d3-4593-ac03-11780a02441b","type":"point","x":796,"y":212},{"id":"e8e13482-7197-471d-af64-eddd49abc62f","type":"point","x":729,"y":212}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"0834460f-b7e2-4363-8e6b-21947b4e3783","local_column_attnum":1,"referenced_table_uid":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","referenced_column_attnum":1}}}},{"id":"7d3912b8-e6f6-457c-b1a4-9015736b87eb","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"0834460f-b7e2-4363-8e6b-21947b4e3783":{"id":"0834460f-b7e2-4363-8e6b-21947b4e3783","type":"table","selected":false,"x":525,"y":120,"ports":[{"id":"d863c52f-6cbb-4711-8e9f-6bbd493da907","type":"onetomany","x":526,"y":387,"name":"coll-port-10-left","alignment":"left","parentNode":"0834460f-b7e2-4363-8e6b-21947b4e3783","links":[]},{"id":"8c87d2cd-c010-4119-9f1b-42bdecb55568","type":"onetomany","x":699,"y":387,"name":"coll-port-10-right","alignment":"right","parentNode":"0834460f-b7e2-4363-8e6b-21947b4e3783","links":["79dcf648-0e9c-4e61-91f6-55c7fae9c200"]},{"id":"e3f307ec-fbce-4b8b-8d89-b13bb64f0205","type":"onetomany","x":526,"y":362,"name":"coll-port-9-left","alignment":"left","parentNode":"0834460f-b7e2-4363-8e6b-21947b4e3783","links":["b117d4ce-7556-4af2-a7a6-1becadb8cf7a"]},{"id":"c6758699-e530-490a-acb0-a9d89c0c1f56","type":"onetomany","x":699,"y":362,"name":"coll-port-9-right","alignment":"right","parentNode":"0834460f-b7e2-4363-8e6b-21947b4e3783","links":[]},{"id":"d0dd41c4-9f2f-4f89-b3ab-e59fdbcd2f62","type":"onetomany","x":526,"y":212,"name":"coll-port-1-left","alignment":"left","parentNode":"0834460f-b7e2-4363-8e6b-21947b4e3783","links":[]},{"id":"7f68e532-4431-4211-8d3a-814b6b853945","type":"onetomany","x":699,"y":212,"name":"coll-port-1-right","alignment":"right","parentNode":"0834460f-b7e2-4363-8e6b-21947b4e3783","links":["6887b72f-d0fd-4dbe-b983-9ee842f4542f"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["d863c52f-6cbb-4711-8e9f-6bbd493da907","8c87d2cd-c010-4119-9f1b-42bdecb55568","e3f307ec-fbce-4b8b-8d89-b13bb64f0205","c6758699-e530-490a-acb0-a9d89c0c1f56","d0dd41c4-9f2f-4f89-b3ab-e59fdbcd2f62","7f68e532-4431-4211-8d3a-814b6b853945"],"otherInfo":{"data":{"name":"animals","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"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('animals_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":"animals","is_view_only":false,"seqrelid":24598,"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":"30","attnum":2,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"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":"animals","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"date_of_birth","atttypid":1082,"attlen":null,"attnum":3,"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":"animals","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":"escape_attempts","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":"animals","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":"neutered","atttypid":16,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"boolean","displaytypname":"boolean","cltype":"boolean","elemoid":16,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"animals","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["boolean","character","character varying","text"]},{"name":"weight_kg","atttypid":1700,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric","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":"animals","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"species_id","atttypid":23,"attlen":null,"attnum":9,"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":"animals","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":"owner_id","atttypid":23,"attlen":null,"attnum":10,"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":"animals","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"]}],"primary_key":[{"oid":24605,"name":"animals_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"id","referenced":"animal_id","references_table_name":"visits","references":"de9e4c90-d182-4b0b-ac8c-57a48744f95f"}],"confupdtype":"a","confdeltype":"a"}]},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"759d3e38-a474-42bc-b871-7bf51cee5c50":{"id":"759d3e38-a474-42bc-b871-7bf51cee5c50","type":"table","selected":false,"x":825,"y":300,"ports":[{"id":"b4dd1793-3e37-466c-a4ad-7927e91fea67","type":"onetomany","x":826,"y":392,"name":"coll-port-1-left","alignment":"left","parentNode":"759d3e38-a474-42bc-b871-7bf51cee5c50","links":["79dcf648-0e9c-4e61-91f6-55c7fae9c200"]},{"id":"1abd3053-8074-4d1a-bdf9-d264b9b68853","type":"onetomany","x":999,"y":392,"name":"coll-port-1-right","alignment":"right","parentNode":"759d3e38-a474-42bc-b871-7bf51cee5c50","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["b4dd1793-3e37-466c-a4ad-7927e91fea67","1abd3053-8074-4d1a-bdf9-d264b9b68853"],"otherInfo":{"data":{"name":"owners","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"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('owners_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":"owners","is_view_only":false,"seqrelid":24621,"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":"full_name","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":"owners","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":"age","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":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"owners","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"]}],"primary_key":[{"oid":24626,"name":"owners_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"id","referenced":"owner_id","references_table_name":"animals","references":"0834460f-b7e2-4363-8e6b-21947b4e3783"}],"confupdtype":"a","confdeltype":"a"}]},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"7a797e75-e568-4977-969c-1cda12076fe2":{"id":"7a797e75-e568-4977-969c-1cda12076fe2","type":"table","selected":false,"x":285,"y":300,"ports":[{"id":"11bc8b6c-f7b0-4644-bc43-282cf3aebde7","type":"onetomany","x":286,"y":392,"name":"coll-port-1-left","alignment":"left","parentNode":"7a797e75-e568-4977-969c-1cda12076fe2","links":["d9de334b-4bf1-48c1-aa04-a0133c60f6f4"]},{"id":"2c40ccd8-c8ac-49e7-b8ec-cc39a165815f","type":"onetomany","x":459,"y":392,"name":"coll-port-1-right","alignment":"right","parentNode":"7a797e75-e568-4977-969c-1cda12076fe2","links":["b117d4ce-7556-4af2-a7a6-1becadb8cf7a"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["11bc8b6c-f7b0-4644-bc43-282cf3aebde7","2c40ccd8-c8ac-49e7-b8ec-cc39a165815f"],"otherInfo":{"data":{"name":"species","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"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('species_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":"species","is_view_only":false,"seqrelid":24628,"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"],"cid":"c58"},{"name":"name","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":"species","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"],"cid":"c59"}],"primary_key":[{"oid":24633,"name":"species_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id","cid":"c55"}],"include":[],"cid":"c54"}],"unique_constraint":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"id","referenced":"species_id","references_table_name":"animals","references":"0834460f-b7e2-4363-8e6b-21947b4e3783","cid":"c57"}],"confupdtype":"a","confdeltype":"a","cid":"c56"},{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"id","referenced":"species_id","references_table_name":"specializations","references":"b01f590a-2ec2-47ea-8d37-347fcd3b7643"}],"confupdtype":"a","confdeltype":"a"}]},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"bc44c8ab-572f-44b9-b7e7-6b8beea41f09":{"id":"bc44c8ab-572f-44b9-b7e7-6b8beea41f09","type":"table","selected":false,"x":270,"y":15,"ports":[{"id":"30b4b01c-ac85-43ba-9de6-2a7179800d03","type":"onetomany","x":271,"y":107,"name":"coll-port-1-left","alignment":"left","parentNode":"bc44c8ab-572f-44b9-b7e7-6b8beea41f09","links":["fd2ea81b-c58a-49ef-9b93-e9bac731aaff"]},{"id":"65ccaa72-0f0a-4087-a55e-7db04597e47d","type":"onetomany","x":444,"y":107,"name":"coll-port-1-right","alignment":"right","parentNode":"bc44c8ab-572f-44b9-b7e7-6b8beea41f09","links":["c754b591-e1b5-45fd-a1d6-481a729bacb8"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["30b4b01c-ac85-43ba-9de6-2a7179800d03","65ccaa72-0f0a-4087-a55e-7db04597e47d"],"otherInfo":{"data":{"name":"vets","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"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('vets_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":"vets","is_view_only":false,"seqrelid":24650,"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":"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":"vets","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":"age","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":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"vets","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":"date_of_graduation","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"vets","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"]}],"primary_key":[{"oid":24655,"name":"vets_pkey","col_count":1,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"id","referenced":"vets_id","references_table_name":"specializations","references":"b01f590a-2ec2-47ea-8d37-347fcd3b7643"}],"confupdtype":"a","confdeltype":"a"},{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"id","referenced":"vets_id","references_table_name":"visits","references":"de9e4c90-d182-4b0b-ac8c-57a48744f95f"}],"confupdtype":"a","confdeltype":"a"}]},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"b01f590a-2ec2-47ea-8d37-347fcd3b7643":{"id":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","type":"table","selected":false,"x":15,"y":225,"ports":[{"id":"18a23428-b338-4f00-b490-940ba8f1cfa1","type":"onetomany","x":16,"y":317,"name":"coll-port-2-left","alignment":"left","parentNode":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","links":[]},{"id":"3a6841cb-81ca-4329-9a3a-12d0a843950f","type":"onetomany","x":189,"y":317,"name":"coll-port-2-right","alignment":"right","parentNode":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","links":["fd2ea81b-c58a-49ef-9b93-e9bac731aaff"]},{"id":"8f0e0337-5f50-45c2-9b8c-88c1f8436ca1","type":"onetomany","x":16,"y":342,"name":"coll-port-1-left","alignment":"left","parentNode":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","links":[]},{"id":"0719cc66-6231-41e1-8c2b-aacd6cdbd172","type":"onetomany","x":189,"y":342,"name":"coll-port-1-right","alignment":"right","parentNode":"b01f590a-2ec2-47ea-8d37-347fcd3b7643","links":["d9de334b-4bf1-48c1-aa04-a0133c60f6f4"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["18a23428-b338-4f00-b490-940ba8f1cfa1","3a6841cb-81ca-4329-9a3a-12d0a843950f","8f0e0337-5f50-45c2-9b8c-88c1f8436ca1","0719cc66-6231-41e1-8c2b-aacd6cdbd172"],"otherInfo":{"data":{"name":"specializations","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"vets_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"specializations","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"],"cid":"c130"},{"name":"species_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"specializations","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c131"}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"de9e4c90-d182-4b0b-ac8c-57a48744f95f":{"id":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","type":"table","selected":false,"x":825,"y":45,"ports":[{"id":"4bc23fab-126e-4c3e-88a4-392ef09722a7","type":"onetomany","x":826,"y":137,"name":"coll-port-2-left","alignment":"left","parentNode":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","links":["c754b591-e1b5-45fd-a1d6-481a729bacb8"]},{"id":"d53e59b1-32bf-47c7-a1b8-85d49c6c60aa","type":"onetomany","x":999,"y":137,"name":"coll-port-2-right","alignment":"right","parentNode":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","links":[]},{"id":"35426c52-e034-42ad-b59b-536e8d65110c","type":"onetomany","x":826,"y":162,"name":"coll-port-1-left","alignment":"left","parentNode":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","links":["6887b72f-d0fd-4dbe-b983-9ee842f4542f"]},{"id":"95d77cfa-8950-4000-8696-2de0c78580bc","type":"onetomany","x":999,"y":162,"name":"coll-port-1-right","alignment":"right","parentNode":"de9e4c90-d182-4b0b-ac8c-57a48744f95f","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["4bc23fab-126e-4c3e-88a4-392ef09722a7","d53e59b1-32bf-47c7-a1b8-85d49c6c60aa","35426c52-e034-42ad-b59b-536e8d65110c","95d77cfa-8950-4000-8696-2de0c78580bc"],"otherInfo":{"data":{"name":"visits","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"vets_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visits","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"],"cid":"c152"},{"name":"animal_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":null,"isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visits","is_view_only":false,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c151"},{"name":"date_of_visit","atttypid":1082,"attlen":null,"attnum":3,"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":null,"isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visits","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"],"cid":"c153"}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}}}}]}}