ERD.pgerd

{"version":"91700","data":{"id":"2a26da72-8f59-42bd-bc3e-f84b32b0dc89","offsetX":3.566500000000019,"offsetY":-13.18699999999999,"zoom":100.05,"gridSize":15,"layers":[{"id":"84e02d5c-b7af-4eb8-89eb-3a9992b66f84","type":"diagram-links","isSvg":true,"transformed":true,"models":{"4079e0c3-fcd2-4d03-915e-81810d57db5b":{"id":"4079e0c3-fcd2-4d03-915e-81810d57db5b","locked":true,"type":"onetomany","source":"e3b8cf90-e27a-494a-811d-27b1c9c8db68","sourcePort":"356c7247-2696-4cc7-a770-326918596f4c","target":"d65c9f1d-eea1-439b-9a31-a5481e350b53","targetPort":"4a8d3b4e-c098-4b6d-b008-5bc32b77ebf1","points":[{"id":"7aaa42a6-5b21-4111-a512-77f2ee89d4d4","type":"point","x":344,"y":584.109375},{"id":"3f0ea974-948b-420d-bbbc-0d2c8466cc8c","type":"point","x":344,"y":760.25},{"id":"c645d8af-7947-41b0-9826-93e1509b76fd","type":"point","x":436,"y":760.25}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"d65c9f1d-eea1-439b-9a31-a5481e350b53","local_column_attnum":5,"referenced_table_uid":"e3b8cf90-e27a-494a-811d-27b1c9c8db68","referenced_column_attnum":1}},"445012fb-5cc1-435c-83e9-2dc7689e0c21":{"id":"445012fb-5cc1-435c-83e9-2dc7689e0c21","locked":true,"type":"onetomany","selected":false,"source":"ba94bcd3-9686-4a17-a2fa-b95961543a46","sourcePort":"6fb2da62-7d08-4db8-b88a-c16a691332fa","target":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","targetPort":"fea62473-1fdb-4fc9-adf5-8896ce1d561d","points":[{"id":"46216e98-5dfc-4c85-ab41-af9304fc8cc9","type":"point","x":254,"y":169.609375},{"id":"de483d2b-5545-4a71-b6ca-61bb088e02d0","type":"point","x":254,"y":261.056471764118},{"id":"0167abdd-1a3b-4c6d-b6c2-10c62f248e08","type":"point","x":436,"y":261.056471764118},{"id":"584b8838-8752-4412-8e07-9990218d162b","type":"point","x":436,"y":355.25}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","local_column_attnum":5,"referenced_table_uid":"ba94bcd3-9686-4a17-a2fa-b95961543a46","referenced_column_attnum":1}},"b9f3bfc1-feac-4eb3-8f3f-dab960f692cd":{"id":"b9f3bfc1-feac-4eb3-8f3f-dab960f692cd","locked":true,"type":"onetomany","source":"d65c9f1d-eea1-439b-9a31-a5481e350b53","sourcePort":"56c34942-2a30-4a4e-8f45-3da4e5fc1c1d","target":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","targetPort":"0175da34-356f-48d6-829d-59411695ceb1","points":[{"id":"434ada88-1706-483b-9086-564920ee05fd","type":"point","x":674,"y":599.109375},{"id":"dbcfb026-57e3-4093-bdac-51237523e0ae","type":"point","x":674,"y":400.28125},{"id":"b79a9932-d519-417e-934a-08b0e97c16be","type":"point","x":674,"y":400.28125}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","local_column_attnum":6,"referenced_table_uid":"d65c9f1d-eea1-439b-9a31-a5481e350b53","referenced_column_attnum":1}},"e826bd0d-f496-4748-b11c-d08637495ea4":{"id":"e826bd0d-f496-4748-b11c-d08637495ea4","locked":true,"type":"onetomany","source":"7a1cb68c-1403-4b91-b680-c734fa773f07","sourcePort":"d88a55c1-1225-40ab-b9fb-3c602f1ba405","target":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","targetPort":"c6f68e44-ce77-4ed8-be04-48264029fd34","points":[{"id":"1518d21b-6617-4702-9e36-0b11d952f04a","type":"point","x":811,"y":149.109375},{"id":"7a3d95aa-28d8-43c3-8f59-66bf59e0e63d","type":"point","x":811,"y":239.140625},{"id":"e90eaeb5-181e-44f0-a968-6fa3634330f1","type":"point","x":674,"y":239.140625}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","local_column_attnum":2,"referenced_table_uid":"7a1cb68c-1403-4b91-b680-c734fa773f07","referenced_column_attnum":1}},"80c86238-2e01-45d1-9367-7dba3f83ee0f":{"id":"80c86238-2e01-45d1-9367-7dba3f83ee0f","locked":true,"type":"onetomany","selected":true,"source":"ba94bcd3-9686-4a17-a2fa-b95961543a46","sourcePort":"6fb2da62-7d08-4db8-b88a-c16a691332fa","target":"9d334893-0cd0-498f-9401-8c586e2b6e02","targetPort":"367842cf-8a6b-4fcc-b1d0-d1c3b719c553","points":[{"id":"7355d0e9-6a7a-411b-9e19-f280f2bc2908","type":"point","x":254,"y":169.609375},{"id":"285cbda3-702b-4747-a0c3-9bba7c4cb052","type":"point","x":367.2498750624688,"y":169.609375},{"id":"d10bed06-0a77-469a-9fcf-812728013060","type":"point","x":367.2498750624688,"y":470.9515242378811},{"id":"3a255b69-be27-4a5a-83b4-bd2d7b3ca382","type":"point","x":781,"y":470.9515242378811},{"id":"4862ba47-fad2-48c4-b488-adccd11ba11e","type":"point","x":781,"y":655.25}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"9d334893-0cd0-498f-9401-8c586e2b6e02","local_column_attnum":5,"referenced_table_uid":"ba94bcd3-9686-4a17-a2fa-b95961543a46","referenced_column_attnum":1}}}},{"id":"420eee86-d16a-4bd2-9d95-74e79adb09ad","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"ba94bcd3-9686-4a17-a2fa-b95961543a46":{"id":"ba94bcd3-9686-4a17-a2fa-b95961543a46","type":"table","selected":false,"x":45,"y":75,"ports":[{"id":"5f1dae19-ccb7-4b14-a23d-4c7564c4685d","type":"onetomany","x":46,"y":169.609375,"name":"coll-port-1-left","alignment":"left","parentNode":"ba94bcd3-9686-4a17-a2fa-b95961543a46","links":[]},{"id":"6fb2da62-7d08-4db8-b88a-c16a691332fa","type":"onetomany","x":224,"y":169.609375,"name":"coll-port-1-right","alignment":"right","parentNode":"ba94bcd3-9686-4a17-a2fa-b95961543a46","links":["445012fb-5cc1-435c-83e9-2dc7689e0c21","80c86238-2e01-45d1-9367-7dba3f83ee0f"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["5f1dae19-ccb7-4b14-a23d-4c7564c4685d","6fb2da62-7d08-4db8-b88a-c16a691332fa"],"otherInfo":{"data":{"columns":[{"name":"isbn","atttypid":1043,"attlen":"50","attnum":1,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"books","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"book_title","atttypid":1043,"attlen":"80","attnum":2,"attndims":0,"atttypmod":84,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(80)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"books","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"category","atttypid":1043,"attlen":"30","attnum":3,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"books","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"rental_price","atttypid":1700,"attlen":"10","attnum":4,"attndims":0,"atttypmod":655366,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,2)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"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":"books","is_view_only":false,"attcompression":null,"defseqrelid":null,"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","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"status","atttypid":1043,"attlen":"10","attnum":5,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"books","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"author","atttypid":1043,"attlen":"30","attnum":6,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"books","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"publisher","atttypid":1043,"attlen":"30","attnum":7,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"books","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"oid":24597,"name":"books","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24601,"name":"books_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"isbn"}],"include":[]}],"unique_constraint":[],"original_foreign_keys":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"e3b8cf90-e27a-494a-811d-27b1c9c8db68":{"id":"e3b8cf90-e27a-494a-811d-27b1c9c8db68","type":"table","selected":false,"x":135,"y":480,"ports":[{"id":"a105885b-71c1-4e09-850b-2cfe08ab5e42","type":"onetomany","x":136,"y":584.109375,"name":"coll-port-1-left","alignment":"left","parentNode":"e3b8cf90-e27a-494a-811d-27b1c9c8db68","links":[]},{"id":"356c7247-2696-4cc7-a770-326918596f4c","type":"onetomany","x":314,"y":584.109375,"name":"coll-port-1-right","alignment":"right","parentNode":"e3b8cf90-e27a-494a-811d-27b1c9c8db68","links":["4079e0c3-fcd2-4d03-915e-81810d57db5b"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["a105885b-71c1-4e09-850b-2cfe08ab5e42","356c7247-2696-4cc7-a770-326918596f4c"],"otherInfo":{"data":{"columns":[{"name":"branch_id","atttypid":1043,"attlen":"10","attnum":1,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"branch","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"manager_id","atttypid":1043,"attlen":"10","attnum":2,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"branch","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"branch_address","atttypid":1043,"attlen":"55","attnum":3,"attndims":0,"atttypmod":59,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(55)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"branch","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"contact_no","atttypid":1043,"attlen":"15","attnum":4,"attndims":0,"atttypmod":19,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(15)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"branch","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"oid":24580,"name":"branch","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24584,"name":"branch_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"branch_id"}],"include":[]}],"unique_constraint":[],"original_foreign_keys":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"d65c9f1d-eea1-439b-9a31-a5481e350b53":{"id":"d65c9f1d-eea1-439b-9a31-a5481e350b53","type":"table","selected":false,"x":465,"y":495,"ports":[{"id":"4a8d3b4e-c098-4b6d-b008-5bc32b77ebf1","type":"onetomany","x":466,"y":760.25,"name":"coll-port-5-left","alignment":"left","parentNode":"d65c9f1d-eea1-439b-9a31-a5481e350b53","links":["4079e0c3-fcd2-4d03-915e-81810d57db5b"]},{"id":"e610feab-3d3d-4f2a-a111-22dd39fe2876","type":"onetomany","x":644,"y":760.25,"name":"coll-port-5-right","alignment":"right","parentNode":"d65c9f1d-eea1-439b-9a31-a5481e350b53","links":[]},{"id":"77bcb5d2-5350-47ac-9c29-f8f904145054","type":"onetomany","x":466,"y":599.109375,"name":"coll-port-1-left","alignment":"left","parentNode":"d65c9f1d-eea1-439b-9a31-a5481e350b53","links":[]},{"id":"56c34942-2a30-4a4e-8f45-3da4e5fc1c1d","type":"onetomany","x":644,"y":599.109375,"name":"coll-port-1-right","alignment":"right","parentNode":"d65c9f1d-eea1-439b-9a31-a5481e350b53","links":["b9f3bfc1-feac-4eb3-8f3f-dab960f692cd"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["4a8d3b4e-c098-4b6d-b008-5bc32b77ebf1","e610feab-3d3d-4f2a-a111-22dd39fe2876","77bcb5d2-5350-47ac-9c29-f8f904145054","56c34942-2a30-4a4e-8f45-3da4e5fc1c1d"],"otherInfo":{"data":{"columns":[{"name":"emp_id","atttypid":1043,"attlen":"10","attnum":1,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"employees","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"emp_name","atttypid":1043,"attlen":"30","attnum":2,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"employees","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"position","atttypid":1043,"attlen":"30","attnum":3,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"employees","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"salary","atttypid":1700,"attlen":"10","attnum":4,"attndims":0,"atttypmod":655366,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,2)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"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":"employees","is_view_only":false,"attcompression":null,"defseqrelid":null,"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","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"branch_id","atttypid":1043,"attlen":"10","attnum":5,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"employees","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"oid":24586,"name":"employees","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24590,"name":"employees_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"emp_id"}],"include":[]}],"foreign_key":[{"oid":24592,"name":"employees_branch_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24580,"fknsp":"public","fktab":"employees","refnspoid":2200,"refnsp":"public","reftab":"branch","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"branch_id","references":"e3b8cf90-e27a-494a-811d-27b1c9c8db68","referenced":"branch_id","references_table_name":"public.branch"}],"remote_schema":"public","remote_table":"branch","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[],"original_foreign_keys":[{"oid":24592,"name":"employees_branch_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24580,"fknsp":"public","fktab":"employees","refnspoid":2200,"refnsp":"public","reftab":"branch","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"branch_id","references":24580,"referenced":"branch_id","references_table_name":"public.branch"}],"remote_schema":"public","remote_table":"branch","coveringindex":null,"autoindex":false,"hasindex":false}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7":{"id":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","type":"table","selected":false,"x":465,"y":90,"ports":[{"id":"fea62473-1fdb-4fc9-adf5-8896ce1d561d","type":"onetomany","x":466,"y":355.25,"name":"coll-port-5-left","alignment":"left","parentNode":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","links":["445012fb-5cc1-435c-83e9-2dc7689e0c21"]},{"id":"c10df1d9-dcb2-485e-a357-ff99e05459b6","type":"onetomany","x":644,"y":355.25,"name":"coll-port-5-right","alignment":"right","parentNode":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","links":[]},{"id":"715d3c14-b43f-4a59-9c45-f53a5f4ed5ab","type":"onetomany","x":466,"y":400.28125,"name":"coll-port-6-left","alignment":"left","parentNode":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","links":[]},{"id":"0175da34-356f-48d6-829d-59411695ceb1","type":"onetomany","x":644,"y":400.28125,"name":"coll-port-6-right","alignment":"right","parentNode":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","links":["b9f3bfc1-feac-4eb3-8f3f-dab960f692cd"]},{"id":"6e4d81cf-6420-46ac-9a76-0400e0cd4228","type":"onetomany","x":466,"y":239.140625,"name":"coll-port-2-left","alignment":"left","parentNode":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","links":[]},{"id":"c6f68e44-ce77-4ed8-be04-48264029fd34","type":"onetomany","x":644,"y":239.140625,"name":"coll-port-2-right","alignment":"right","parentNode":"bbc55ff0-a8c1-4e75-ad40-cf51325ec4f7","links":["e826bd0d-f496-4748-b11c-d08637495ea4"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["fea62473-1fdb-4fc9-adf5-8896ce1d561d","c10df1d9-dcb2-485e-a357-ff99e05459b6","715d3c14-b43f-4a59-9c45-f53a5f4ed5ab","0175da34-356f-48d6-829d-59411695ceb1","6e4d81cf-6420-46ac-9a76-0400e0cd4228","c6f68e44-ce77-4ed8-be04-48264029fd34"],"otherInfo":{"data":{"columns":[{"name":"issued_id","atttypid":1043,"attlen":"10","attnum":1,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"issued_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"issued_member_id","atttypid":1043,"attlen":"30","attnum":2,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"issued_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"issued_book_name","atttypid":1043,"attlen":"80","attnum":3,"attndims":0,"atttypmod":84,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(80)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"issued_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"issued_date","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"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":"issued_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"issued_book_isbn","atttypid":1043,"attlen":"50","attnum":5,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"issued_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"issued_emp_id","atttypid":1043,"attlen":"10","attnum":6,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"issued_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"oid":24636,"name":"issued_status","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24640,"name":"issued_status_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"issued_id"}],"include":[]}],"foreign_key":[{"oid":24652,"name":"issued_status_issued_book_isbn_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24597,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"books","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_book_isbn","references":"ba94bcd3-9686-4a17-a2fa-b95961543a46","referenced":"isbn","references_table_name":"public.books"}],"remote_schema":"public","remote_table":"books","coveringindex":null,"autoindex":false,"hasindex":false},{"oid":24647,"name":"issued_status_issued_emp_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":24586,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"employees","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_emp_id","references":"d65c9f1d-eea1-439b-9a31-a5481e350b53","referenced":"emp_id","references_table_name":"public.employees"}],"remote_schema":"public","remote_table":"employees","coveringindex":null,"autoindex":false,"hasindex":false},{"oid":24642,"name":"issued_status_issued_member_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":24609,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"members","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_member_id","references":"7a1cb68c-1403-4b91-b680-c734fa773f07","referenced":"member_id","references_table_name":"public.members"}],"remote_schema":"public","remote_table":"members","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[],"original_foreign_keys":[{"oid":24652,"name":"issued_status_issued_book_isbn_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24597,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"books","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_book_isbn","references":24597,"referenced":"isbn","references_table_name":"public.books"}],"remote_schema":"public","remote_table":"books","coveringindex":null,"autoindex":false,"hasindex":false},{"oid":24647,"name":"issued_status_issued_emp_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":24586,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"employees","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_emp_id","references":24586,"referenced":"emp_id","references_table_name":"public.employees"}],"remote_schema":"public","remote_table":"employees","coveringindex":null,"autoindex":false,"hasindex":false},{"oid":24642,"name":"issued_status_issued_member_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":24609,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"members","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_member_id","references":24609,"referenced":"member_id","references_table_name":"public.members"}],"remote_schema":"public","remote_table":"members","coveringindex":null,"autoindex":false,"hasindex":false}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"7a1cb68c-1403-4b91-b680-c734fa773f07":{"id":"7a1cb68c-1403-4b91-b680-c734fa773f07","type":"table","selected":false,"x":840,"y":45,"ports":[{"id":"d88a55c1-1225-40ab-b9fb-3c602f1ba405","type":"onetomany","x":841,"y":149.109375,"name":"coll-port-1-left","alignment":"left","parentNode":"7a1cb68c-1403-4b91-b680-c734fa773f07","links":["e826bd0d-f496-4748-b11c-d08637495ea4"]},{"id":"77abf7cb-93ee-4887-abf0-4289a9d0e3c7","type":"onetomany","x":1019,"y":149.109375,"name":"coll-port-1-right","alignment":"right","parentNode":"7a1cb68c-1403-4b91-b680-c734fa773f07","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["d88a55c1-1225-40ab-b9fb-3c602f1ba405","77abf7cb-93ee-4887-abf0-4289a9d0e3c7"],"otherInfo":{"data":{"columns":[{"name":"member_id","atttypid":1043,"attlen":"10","attnum":1,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"members","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"member_name","atttypid":1043,"attlen":"30","attnum":2,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"members","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"member_address","atttypid":1043,"attlen":"30","attnum":3,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"members","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"reg_date","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"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":"members","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]}],"oid":24609,"name":"members","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24613,"name":"members_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"member_id"}],"include":[]}],"unique_constraint":[],"original_foreign_keys":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"9d334893-0cd0-498f-9401-8c586e2b6e02":{"id":"9d334893-0cd0-498f-9401-8c586e2b6e02","type":"table","selected":false,"x":810,"y":390,"ports":[{"id":"367842cf-8a6b-4fcc-b1d0-d1c3b719c553","type":"onetomany","x":811,"y":655.25,"name":"coll-port-5-left","alignment":"left","parentNode":"9d334893-0cd0-498f-9401-8c586e2b6e02","links":["80c86238-2e01-45d1-9367-7dba3f83ee0f"]},{"id":"6ed86b90-2304-40fa-8e28-b5dfaf9f6fdb","type":"onetomany","x":989,"y":655.25,"name":"coll-port-5-right","alignment":"right","parentNode":"9d334893-0cd0-498f-9401-8c586e2b6e02","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["367842cf-8a6b-4fcc-b1d0-d1c3b719c553","6ed86b90-2304-40fa-8e28-b5dfaf9f6fdb"],"otherInfo":{"data":{"columns":[{"name":"return_id","atttypid":1043,"attlen":"10","attnum":1,"attndims":0,"atttypmod":14,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(10)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"return_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"issued_id","atttypid":1043,"attlen":"30","attnum":2,"attndims":0,"atttypmod":34,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(30)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"return_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"return_book_name","atttypid":1043,"attlen":"80","attnum":3,"attndims":0,"atttypmod":84,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(80)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"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":"return_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"return_date","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"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":"return_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"return_book_isbn","atttypid":1043,"attlen":"50","attnum":5,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"return_status","is_view_only":false,"attcompression":null,"defseqrelid":null,"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,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"oid":24668,"name":"return_status","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24672,"name":"return_status_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"return_id"}],"include":[]}],"foreign_key":[{"oid":24674,"name":"return_status_return_book_isbn_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24597,"fknsp":"public","fktab":"return_status","refnspoid":2200,"refnsp":"public","reftab":"books","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"return_book_isbn","references":"ba94bcd3-9686-4a17-a2fa-b95961543a46","referenced":"isbn","references_table_name":"public.books"}],"remote_schema":"public","remote_table":"books","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[],"original_foreign_keys":[{"oid":24674,"name":"return_status_return_book_isbn_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24597,"fknsp":"public","fktab":"return_status","refnspoid":2200,"refnsp":"public","reftab":"books","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"return_book_isbn","references":24597,"referenced":"isbn","references_table_name":"public.books"}],"remote_schema":"public","remote_table":"books","coveringindex":null,"autoindex":false,"hasindex":false}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}