tables.pgerd

{"version":"81400","data":{"id":"1b2c580c-e769-4c2c-9805-ad36da85accf","offsetX":295.73371559535576,"offsetY":-617.7159720272381,"zoom":96.66666666666667,"gridSize":15,"layers":[{"id":"30061203-aa3a-41e0-a925-d63517e6e908","type":"diagram-links","isSvg":true,"transformed":true,"models":{"3c07bce4-802f-4106-81c6-190f8fd0a86d":{"id":"3c07bce4-802f-4106-81c6-190f8fd0a86d","locked":true,"type":"onetomany","source":"a1590bb9-ecd3-4210-8575-a4767b77f6df","sourcePort":"b3b28723-747a-480e-842b-dfc854b8fd0f","target":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","targetPort":"6166c007-0e85-4a2e-861f-c0f58500cde3","points":[{"id":"b81ad334-6b94-4211-9c03-3ac0fb12e6cc","type":"point","x":728.9999658802099,"y":839.1093642941821},{"id":"80af48d2-f98a-4900-b228-3e7fe2f3ae83","type":"point","x":728.9999658802099,"y":1300.2421767941828},{"id":"0f552e73-6ddd-462a-83ab-bd6def28a7f8","type":"point","x":683.9999658802099,"y":1300.2421767941828}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","local_column_attnum":5,"referenced_table_uid":"a1590bb9-ecd3-4210-8575-a4767b77f6df","referenced_column_attnum":1}},"3f91041d-7967-4e0b-95d9-80afcb93bc1a":{"id":"3f91041d-7967-4e0b-95d9-80afcb93bc1a","locked":true,"type":"onetomany","source":"831863d2-66aa-46b6-9d12-d3062bcb5197","sourcePort":"957caf7d-b3f9-4007-96a0-294bcedc91f1","target":"6010e042-b3a3-483b-9241-17df9da72dd2","targetPort":"fb5d9505-3127-4c8e-b37b-1540d55465d9","points":[{"id":"f90e84f4-9c33-4479-be3d-abcdd68fb0d6","type":"point","x":128.99996588020952,"y":1099.6093642941823},{"id":"42226033-4cc2-42f6-9b3c-46e89bbd3b2f","type":"point","x":128.99996588020952,"y":1105.2499892941835},{"id":"8cb8aa12-bcee-4240-b491-845fccb822e2","type":"point","x":196.00001470833456,"y":1105.2499892941835}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6010e042-b3a3-483b-9241-17df9da72dd2","local_column_attnum":5,"referenced_table_uid":"831863d2-66aa-46b6-9d12-d3062bcb5197","referenced_column_attnum":1}},"80d2b57f-0df6-421e-af70-3e5f0e860fc7":{"id":"80d2b57f-0df6-421e-af70-3e5f0e860fc7","locked":true,"type":"onetomany","source":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","sourcePort":"227b697f-fa97-486f-8d51-7528799e1439","target":"6010e042-b3a3-483b-9241-17df9da72dd2","targetPort":"a9d8682a-8ed2-4583-bdb0-1b17b653d222","points":[{"id":"e609675e-3d4f-4add-9483-e0766394627b","type":"point","x":451.0000147083347,"y":1139.1016006223076},{"id":"16576db2-4c2a-49ef-a4e3-01ae84f64419","type":"point","x":451.0000147083347,"y":1150.2811904660584},{"id":"86408d9f-fa55-4a98-803e-24fcd9e44bf4","type":"point","x":428.99996588020986,"y":1150.2811904660584}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6010e042-b3a3-483b-9241-17df9da72dd2","local_column_attnum":6,"referenced_table_uid":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","referenced_column_attnum":1}},"f61cc5aa-5cc0-44e0-9320-0f3873eb2ffa":{"id":"f61cc5aa-5cc0-44e0-9320-0f3873eb2ffa","locked":true,"type":"onetomany","source":"71ceacfe-7ecf-41b9-9295-8ad5a53d4549","sourcePort":"971ab05c-9798-4c74-a207-ac2dfd00a9dd","target":"6010e042-b3a3-483b-9241-17df9da72dd2","targetPort":"7308330a-595b-4f19-aa0a-648c6595136f","points":[{"id":"3e8b567f-778b-477a-b188-52b85d8a804b","type":"point","x":751.0000147083349,"y":989.1094131223076},{"id":"85d7c676-f069-44cc-be93-5e0ea5220327","type":"point","x":751.0000147083349,"y":989.1406142941833},{"id":"fdefa959-699e-4f23-aa7c-41d7492ac825","type":"point","x":428.99996588020986,"y":989.1406142941833}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6010e042-b3a3-483b-9241-17df9da72dd2","local_column_attnum":2,"referenced_table_uid":"71ceacfe-7ecf-41b9-9295-8ad5a53d4549","referenced_column_attnum":1}},"5bddcd51-86c1-4528-8987-37c72fc91d52":{"id":"5bddcd51-86c1-4528-8987-37c72fc91d52","locked":true,"type":"onetomany","source":"6010e042-b3a3-483b-9241-17df9da72dd2","sourcePort":"068cef8b-a103-48bf-82ff-0bf2923281e1","target":"12dee88d-1ad1-4fc6-b0b6-391e1a5a2313","targetPort":"cc5eda02-9d6a-48f7-8f57-3a3326794614","points":[{"id":"54787c0f-6360-4137-b508-8e6d1df6bdf6","type":"point","x":428.99996588020986,"y":944.1094131223081},{"id":"419ed9f8-36c5-4ebb-aafd-ce520232b0bf","type":"point","x":428.99996588020986,"y":1334.1405654660584},{"id":"aa5d6cce-0078-4a2e-b1c7-9290b28ef643","type":"point","x":428.99996588020986,"y":1334.1405654660584}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"12dee88d-1ad1-4fc6-b0b6-391e1a5a2313","local_column_attnum":2,"referenced_table_uid":"6010e042-b3a3-483b-9241-17df9da72dd2","referenced_column_attnum":1}}}},{"id":"7c862090-521f-4ec6-8e71-3c817f81a35b","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"31fcd96b-174d-4de2-a4c0-60d42b923759":{"id":"31fcd96b-174d-4de2-a4c0-60d42b923759","type":"table","selected":false,"x":-15,"y":810,"ports":[],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":[],"otherInfo":{"data":{"columns":[{"name":"isbn","atttypid":1043,"attlen":"20","attnum":1,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"book_issued_cnt","is_view_only":false,"attcompression":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","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"book_title","atttypid":1043,"attlen":"75","attnum":2,"attndims":0,"atttypmod":79,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(75)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"book_issued_cnt","is_view_only":false,"attcompression":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":"issue_count","atttypid":20,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"bigint","displaytypname":"bigint","cltype":"bigint","inheritedfrom":null,"inheritedid":null,"elemoid":20,"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":"book_issued_cnt","is_view_only":false,"attcompression":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":["bigint","double precision","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"book_issued_cnt","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"831863d2-66aa-46b6-9d12-d3062bcb5197":{"id":"831863d2-66aa-46b6-9d12-d3062bcb5197","type":"table","selected":false,"x":-75,"y":1005,"ports":[{"id":"f508c97e-4db8-4d8d-b1e1-d73f30d47fbe","type":"onetomany","x":-74.00000360221259,"y":1099.6093642941823,"name":"coll-port-1-left","alignment":"left","parentNode":"831863d2-66aa-46b6-9d12-d3062bcb5197","links":[]},{"id":"957caf7d-b3f9-4007-96a0-294bcedc91f1","type":"onetomany","x":98.99996588020952,"y":1099.6093642941823,"name":"coll-port-1-right","alignment":"right","parentNode":"831863d2-66aa-46b6-9d12-d3062bcb5197","links":["3f91041d-7967-4e0b-95d9-80afcb93bc1a"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["f508c97e-4db8-4d8d-b1e1-d73f30d47fbe","957caf7d-b3f9-4007-96a0-294bcedc91f1"],"otherInfo":{"data":{"columns":[{"name":"isbn","atttypid":1043,"attlen":"20","attnum":1,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","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,"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":"75","attnum":2,"attndims":0,"atttypmod":79,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(75)","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,"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":"20","attnum":3,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","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,"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":701,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"double precision","displaytypname":"double precision","cltype":"double precision","inheritedfrom":null,"inheritedid":null,"elemoid":701,"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":"books","is_view_only":false,"attcompression":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":["bigint","double precision","integer","numeric","real","smallint"]},{"name":"status","atttypid":1043,"attlen":"15","attnum":5,"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":"books","is_view_only":false,"attcompression":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":"35","attnum":6,"attndims":0,"atttypmod":39,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(35)","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,"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":"35","attnum":7,"attndims":0,"atttypmod":39,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(35)","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,"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"]}],"name":"books","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24620,"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":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"a1590bb9-ecd3-4210-8575-a4767b77f6df":{"id":"a1590bb9-ecd3-4210-8575-a4767b77f6df","type":"table","selected":false,"x":525,"y":735,"ports":[{"id":"71dd0535-a56a-49ad-9a4e-40647de58959","type":"onetomany","x":526.0000147083347,"y":839.1093642941821,"name":"coll-port-1-left","alignment":"left","parentNode":"a1590bb9-ecd3-4210-8575-a4767b77f6df","links":[]},{"id":"b3b28723-747a-480e-842b-dfc854b8fd0f","type":"onetomany","x":698.9999658802099,"y":839.1093642941821,"name":"coll-port-1-right","alignment":"right","parentNode":"a1590bb9-ecd3-4210-8575-a4767b77f6df","links":["3c07bce4-802f-4106-81c6-190f8fd0a86d"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["71dd0535-a56a-49ad-9a4e-40647de58959","b3b28723-747a-480e-842b-dfc854b8fd0f"],"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,"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,"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":"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":"branch","is_view_only":false,"attcompression":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,"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":"branch","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24610,"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":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"392b3a74-92dc-47fd-8d58-a5ad1b7813c7":{"id":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","type":"table","selected":false,"x":480,"y":1035,"ports":[{"id":"84e0cd41-1fbf-4b3e-a602-cd7095553db6","type":"onetomany","x":481.0000147083347,"y":1300.2421767941828,"name":"coll-port-5-left","alignment":"left","parentNode":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","links":[]},{"id":"6166c007-0e85-4a2e-861f-c0f58500cde3","type":"onetomany","x":653.9999658802099,"y":1300.2421767941828,"name":"coll-port-5-right","alignment":"right","parentNode":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","links":["3c07bce4-802f-4106-81c6-190f8fd0a86d"]},{"id":"227b697f-fa97-486f-8d51-7528799e1439","type":"onetomany","x":481.0000147083347,"y":1139.1016006223076,"name":"coll-port-1-left","alignment":"left","parentNode":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","links":["80d2b57f-0df6-421e-af70-3e5f0e860fc7"]},{"id":"b1cce567-fbe5-48bb-812b-41ada314a0a7","type":"onetomany","x":653.9999658802099,"y":1139.1016006223076,"name":"coll-port-1-right","alignment":"right","parentNode":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["84e0cd41-1fbf-4b3e-a602-cd7095553db6","6166c007-0e85-4a2e-861f-c0f58500cde3","227b697f-fa97-486f-8d51-7528799e1439","b1cce567-fbe5-48bb-812b-41ada314a0a7"],"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":"employess","is_view_only":false,"attcompression":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":"employess","is_view_only":false,"attcompression":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":"employess","is_view_only":false,"attcompression":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":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"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":"employess","is_view_only":false,"attcompression":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":["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":"branch_id","atttypid":1043,"attlen":"25","attnum":5,"attndims":0,"atttypmod":29,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(25)","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":"employess","is_view_only":false,"attcompression":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":"employess","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24615,"name":"employess_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":[{"name":"fk_branch","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24607,"fknsp":"public","fktab":"employess","refnspoid":2200,"refnsp":"public","reftab":"branch","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"branch_id","references":"a1590bb9-ecd3-4210-8575-a4767b77f6df","referenced":"branch_id","references_table_name":"public.branch"}],"remote_schema":"public","remote_table":"branch","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"9eb78c5c-4e24-47ab-8d25-5d1ea3f4b7a3":{"id":"9eb78c5c-4e24-47ab-8d25-5d1ea3f4b7a3","type":"table","selected":false,"x":765,"y":1140,"ports":[],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":[],"otherInfo":{"data":{"columns":[{"name":"isbn","atttypid":1043,"attlen":"20","attnum":1,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"expensive_books","is_view_only":false,"attcompression":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","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"book_title","atttypid":1043,"attlen":"75","attnum":2,"attndims":0,"atttypmod":79,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(75)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"expensive_books","is_view_only":false,"attcompression":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":"20","attnum":3,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"expensive_books","is_view_only":false,"attcompression":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":701,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"double precision","displaytypname":"double precision","cltype":"double precision","inheritedfrom":null,"inheritedid":null,"elemoid":701,"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":"expensive_books","is_view_only":false,"attcompression":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":["bigint","double precision","integer","numeric","real","smallint"]},{"name":"status","atttypid":1043,"attlen":"15","attnum":5,"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":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"expensive_books","is_view_only":false,"attcompression":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":"35","attnum":6,"attndims":0,"atttypmod":39,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(35)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"expensive_books","is_view_only":false,"attcompression":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":"35","attnum":7,"attndims":0,"atttypmod":39,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(35)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":null,"isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"expensive_books","is_view_only":false,"attcompression":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"]}],"name":"expensive_books","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"6010e042-b3a3-483b-9241-17df9da72dd2":{"id":"6010e042-b3a3-483b-9241-17df9da72dd2","type":"table","selected":false,"x":225,"y":840,"ports":[{"id":"fb5d9505-3127-4c8e-b37b-1540d55465d9","type":"onetomany","x":226.00001470833456,"y":1105.2499892941835,"name":"coll-port-5-left","alignment":"left","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":["3f91041d-7967-4e0b-95d9-80afcb93bc1a"]},{"id":"367b6073-b310-4139-8144-cd3631123256","type":"onetomany","x":398.99996588020986,"y":1105.2499892941835,"name":"coll-port-5-right","alignment":"right","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":[]},{"id":"5d451427-1b89-484d-8027-ddfec01d15d1","type":"onetomany","x":226.00001470833456,"y":1150.2811904660584,"name":"coll-port-6-left","alignment":"left","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":[]},{"id":"a9d8682a-8ed2-4583-bdb0-1b17b653d222","type":"onetomany","x":398.99996588020986,"y":1150.2811904660584,"name":"coll-port-6-right","alignment":"right","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":["80d2b57f-0df6-421e-af70-3e5f0e860fc7"]},{"id":"5155f4fc-86be-484d-adae-e8051517d84c","type":"onetomany","x":226.00001470833456,"y":989.1406142941833,"name":"coll-port-2-left","alignment":"left","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":[]},{"id":"7308330a-595b-4f19-aa0a-648c6595136f","type":"onetomany","x":398.99996588020986,"y":989.1406142941833,"name":"coll-port-2-right","alignment":"right","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":["f61cc5aa-5cc0-44e0-9320-0f3873eb2ffa"]},{"id":"5d00b653-8759-4f7f-93f6-0a223ee50e0a","type":"onetomany","x":226.00001470833456,"y":944.1094131223081,"name":"coll-port-1-left","alignment":"left","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":[]},{"id":"068cef8b-a103-48bf-82ff-0bf2923281e1","type":"onetomany","x":398.99996588020986,"y":944.1094131223081,"name":"coll-port-1-right","alignment":"right","parentNode":"6010e042-b3a3-483b-9241-17df9da72dd2","links":["5bddcd51-86c1-4528-8987-37c72fc91d52"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["fb5d9505-3127-4c8e-b37b-1540d55465d9","367b6073-b310-4139-8144-cd3631123256","5d451427-1b89-484d-8027-ddfec01d15d1","a9d8682a-8ed2-4583-bdb0-1b17b653d222","5155f4fc-86be-484d-adae-e8051517d84c","7308330a-595b-4f19-aa0a-648c6595136f","5d00b653-8759-4f7f-93f6-0a223ee50e0a","068cef8b-a103-48bf-82ff-0bf2923281e1"],"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,"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":"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"issued_status","is_view_only":false,"attcompression":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":"75","attnum":3,"attndims":0,"atttypmod":79,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(75)","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,"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,"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":"25","attnum":5,"attndims":0,"atttypmod":29,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(25)","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,"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,"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":"issued_status","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24630,"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":[{"name":"fk_books","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":24617,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"books","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_book_isbn","references":"831863d2-66aa-46b6-9d12-d3062bcb5197","referenced":"isbn","references_table_name":"public.books"}],"remote_schema":"public","remote_table":"books","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_employess","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":24612,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"employess","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_emp_id","references":"392b3a74-92dc-47fd-8d58-a5ad1b7813c7","referenced":"emp_id","references_table_name":"public.employess"}],"remote_schema":"public","remote_table":"employess","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_members","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":24622,"fknsp":"public","fktab":"issued_status","refnspoid":2200,"refnsp":"public","reftab":"members","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_member_id","references":"71ceacfe-7ecf-41b9-9295-8ad5a53d4549","referenced":"member_id","references_table_name":"public.members"}],"remote_schema":"public","remote_table":"members","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"71ceacfe-7ecf-41b9-9295-8ad5a53d4549":{"id":"71ceacfe-7ecf-41b9-9295-8ad5a53d4549","type":"table","selected":false,"x":780,"y":885,"ports":[{"id":"971ab05c-9798-4c74-a207-ac2dfd00a9dd","type":"onetomany","x":781.0000147083349,"y":989.1094131223076,"name":"coll-port-1-left","alignment":"left","parentNode":"71ceacfe-7ecf-41b9-9295-8ad5a53d4549","links":["f61cc5aa-5cc0-44e0-9320-0f3873eb2ffa"]},{"id":"7fc8c047-9498-46fa-a879-33ed0a680104","type":"onetomany","x":953.9999658802099,"y":989.1094131223076,"name":"coll-port-1-right","alignment":"right","parentNode":"71ceacfe-7ecf-41b9-9295-8ad5a53d4549","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["971ab05c-9798-4c74-a207-ac2dfd00a9dd","7fc8c047-9498-46fa-a879-33ed0a680104"],"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,"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":"25","attnum":2,"attndims":0,"atttypmod":29,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(25)","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,"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":"75","attnum":3,"attndims":0,"atttypmod":79,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(75)","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,"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,"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":"members","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":24625,"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":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"12dee88d-1ad1-4fc6-b0b6-391e1a5a2313":{"id":"12dee88d-1ad1-4fc6-b0b6-391e1a5a2313","type":"table","selected":false,"x":225,"y":1185,"ports":[{"id":"55cd6677-7c5d-4b1f-8e10-bd49fd47cef6","type":"onetomany","x":226.00001470833456,"y":1334.1405654660584,"name":"coll-port-2-left","alignment":"left","parentNode":"12dee88d-1ad1-4fc6-b0b6-391e1a5a2313","links":[]},{"id":"cc5eda02-9d6a-48f7-8f57-3a3326794614","type":"onetomany","x":398.99996588020986,"y":1334.1405654660584,"name":"coll-port-2-right","alignment":"right","parentNode":"12dee88d-1ad1-4fc6-b0b6-391e1a5a2313","links":["5bddcd51-86c1-4528-8987-37c72fc91d52"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["55cd6677-7c5d-4b1f-8e10-bd49fd47cef6","cc5eda02-9d6a-48f7-8f57-3a3326794614"],"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,"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":"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"return_status","is_view_only":false,"attcompression":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":"75","attnum":3,"attndims":0,"atttypmod":79,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(75)","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,"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,"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":"20","attnum":5,"attndims":0,"atttypmod":24,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(20)","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,"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":"return_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":"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":[{"name":"fk_issued_status","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"a","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":24627,"fknsp":"public","fktab":"return_status","refnspoid":2200,"refnsp":"public","reftab":"issued_status","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"issued_id","references":"6010e042-b3a3-483b-9241-17df9da72dd2","referenced":"issued_id","references_table_name":"public.issued_status"}],"remote_schema":"public","remote_table":"issued_status","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}