Book_review_Database_ERD.pgerd

{"version":"61900","data":{"id":"fc191d28-fc74-44f0-9056-04e65cd2afd9","offsetX":255.88736229274252,"offsetY":135.99593531534128,"zoom":73.81558368504047,"gridSize":15,"layers":[{"id":"29fd8b4c-f1c9-4ea4-83e8-d030b57606c2","type":"diagram-links","isSvg":true,"transformed":true,"models":{"0b48fda7-04f0-4c2c-8b35-499a0319bbe5":{"id":"0b48fda7-04f0-4c2c-8b35-499a0319bbe5","locked":true,"type":"onetomany","selected":false,"source":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","sourcePort":"9e4233e2-02f1-43be-9de4-eeba858f6c8c","target":"67cc017c-a4db-4ac9-8e48-7be469ff7968","targetPort":"17a4ad32-4c85-4d35-8d2c-ced86a7b45f2","points":[{"id":"4dae42dd-470c-4b0a-86ab-708930b9dee5","type":"point","x":575.000002927854,"y":272.00001377712425},{"id":"dfe3878a-8376-48ca-b5e5-484a860bfeb1","type":"point","x":605,"y":272.00001377712425},{"id":"8480c8f2-2cb7-444f-a533-44c1ec3e717a","type":"point","x":605,"y":297}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"67cc017c-a4db-4ac9-8e48-7be469ff7968","local_column_attnum":0,"referenced_table_uid":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","referenced_column_attnum":0}},"89dd8ba4-0344-464b-b667-3ec436277270":{"id":"89dd8ba4-0344-464b-b667-3ec436277270","locked":true,"type":"onetomany","selected":false,"source":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","sourcePort":"1417f9c5-3077-4338-b1b6-04d8d11c2a0e","target":"67cc017c-a4db-4ac9-8e48-7be469ff7968","targetPort":"c19ccb85-f899-431c-bd77-49b82d24c1d0","points":[{"id":"5e138d2e-3fed-4943-8f30-4c88b0421e3c","type":"point","x":875.0000832820826,"y":272.00001377712425},{"id":"49552a98-9fd6-44ca-925d-b39adebc9f0e","type":"point","x":875.0000832820826,"y":322},{"id":"fe61014a-faec-4bf9-b54e-1b7b681ac324","type":"point","x":830,"y":322}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"67cc017c-a4db-4ac9-8e48-7be469ff7968","local_column_attnum":1,"referenced_table_uid":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","referenced_column_attnum":0}},"59c8736d-4e83-4bf8-9d1f-006d500d2dbd":{"id":"59c8736d-4e83-4bf8-9d1f-006d500d2dbd","locked":true,"type":"onetomany","selected":false,"source":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","sourcePort":"dec0681e-7d6b-486d-b92e-a9c00da8d733","target":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","targetPort":"00c5d391-97df-4437-91af-27d0d26c5c50","points":[{"id":"6f7ff35f-6a18-47a5-ae52-0b7458e4221c","type":"point","x":350.0000383853676,"y":272.00001377712425},{"id":"326203bb-189b-40fd-a70d-64ec827fb77b","type":"point","x":350.0000383853676,"y":271.96015291633387},{"id":"d88ad717-5ebd-42a6-8f63-5fd9ca30737a","type":"point","x":323.9446585681032,"y":271.96015291633387},{"id":"0256e552-00e8-4521-a4b2-10a9ffb7303a","type":"point","x":323.9446585681032,"y":107.00001229804707},{"id":"73c758a6-bbcb-4d2f-8f05-d8e8b07c08b5","type":"point","x":289.99998890351316,"y":107.00001229804707}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","local_column_attnum":0,"referenced_table_uid":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","referenced_column_attnum":0}},"5b8e350e-5ac5-486c-af3e-369fbcff8705":{"id":"5b8e350e-5ac5-486c-af3e-369fbcff8705","locked":true,"type":"onetomany","selected":false,"source":"8d00e054-8b06-4cd2-8194-206b648ba2c9","sourcePort":"9ddaa1a5-48ef-4366-b2bd-c0a7c43b257e","target":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","targetPort":"d5342a87-2003-40ed-97ef-e76a1462174a","points":[{"id":"fa8de44d-d109-49b0-9ef2-1bd297763347","type":"point","x":350.0000383853676,"y":16.999994535674944},{"id":"ec074619-bc2d-461a-8c71-431b0f4df02b","type":"point","x":350.0000383853676,"y":131.2924702132075},{"id":"643f8647-2cdb-4c5d-a1f0-3c43cd6e20e4","type":"point","x":289.99998890351316,"y":131.2924702132075},{"id":"a87f8429-4066-45b0-b06f-7dbdbc8c9f91","type":"point","x":289.99998890351316,"y":132.0000213204179}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","local_column_attnum":1,"referenced_table_uid":"8d00e054-8b06-4cd2-8194-206b648ba2c9","referenced_column_attnum":0}},"fb152c8f-37d9-46ab-a3a0-23b9693ce0f9":{"id":"fb152c8f-37d9-46ab-a3a0-23b9693ce0f9","locked":true,"type":"onetomany","selected":false,"source":"574ce38d-cb41-48dc-a079-a65b5b2f976c","sourcePort":"123a9848-e39d-4df0-ad4e-64b8ce9cfed9","target":"17173b30-aaea-4de5-9fae-8799d8353207","targetPort":"c705c9e3-9a1c-442a-b4cf-736f6ff91a3b","points":[{"id":"356059aa-250f-4b90-80f2-391f613e85a9","type":"point","x":350.0000383853676,"y":586.9999911472436},{"id":"8a173935-0b8a-431e-8a61-4cb7f6b1ab06","type":"point","x":350.0000383853676,"y":548.3190600214667},{"id":"adda411a-0ce8-4385-bab7-63518ad84819","type":"point","x":289.99998890351316,"y":548.3190600214667},{"id":"816050ae-1007-4245-a944-0a9127735d38","type":"point","x":289.99998890351316,"y":548.000001245307}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"17173b30-aaea-4de5-9fae-8799d8353207","local_column_attnum":0,"referenced_table_uid":"574ce38d-cb41-48dc-a079-a65b5b2f976c","referenced_column_attnum":0}},"72d5eb7a-ca9a-4f4b-8e7f-347f0e5585c5":{"id":"72d5eb7a-ca9a-4f4b-8e7f-347f0e5585c5","locked":true,"type":"onetomany","selected":false,"source":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","sourcePort":"dec0681e-7d6b-486d-b92e-a9c00da8d733","target":"17173b30-aaea-4de5-9fae-8799d8353207","targetPort":"f4fdf14f-274d-41a4-ba0f-b239dc3b0729","points":[{"id":"d3cf058e-3bd9-4bd5-af4c-ab2c9c49a476","type":"point","x":350.0000383853676,"y":272.00001377712425},{"id":"13fcc991-9b2d-4890-81ef-4bd51bc1b935","type":"point","x":335.59058720165604,"y":272.00001377712425},{"id":"91db1445-e0cc-4418-949f-7ba93175af6c","type":"point","x":335.59058720165604,"y":578.9999992149374},{"id":"5546aa72-faeb-46bd-93fa-cc3f8edd6f63","type":"point","x":289.99998890351316,"y":578.9999992149374}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"17173b30-aaea-4de5-9fae-8799d8353207","local_column_attnum":1,"referenced_table_uid":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","referenced_column_attnum":0}},"13cfe86f-2025-4bfb-bc7e-5c9b4bc9c80f":{"id":"13cfe86f-2025-4bfb-bc7e-5c9b4bc9c80f","locked":true,"type":"onetomany","selected":false,"source":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","sourcePort":"dec0681e-7d6b-486d-b92e-a9c00da8d733","target":"72ae19fc-33ec-4444-b69f-e3f1792b8e74","targetPort":"4e1472f5-f2dc-43f9-8d33-beb9e2a35750","points":[{"id":"913d7bab-dc1a-43e7-94b6-28648f6df420","type":"point","x":350.0000383853676,"y":272.00001377712425},{"id":"653c68fd-378d-4592-ada6-4e14ff584340","type":"point","x":306.92282721505705,"y":272.00001377712425},{"id":"37b9b831-aabb-438a-a098-9dc7e9b92079","type":"point","x":306.92282721505705,"y":296.4187677360175},{"id":"168ab07a-991b-4fb4-8572-df2bd4c1f231","type":"point","x":275.00000111846913,"y":296.4187677360175},{"id":"9166808a-fd51-4c3b-a72f-6f201d48776d","type":"point","x":275.00000111846913,"y":297.00003823801126}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"72ae19fc-33ec-4444-b69f-e3f1792b8e74","local_column_attnum":1,"referenced_table_uid":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","referenced_column_attnum":0}},"b8d70221-0632-4b66-9b7f-2c3ca8012a2c":{"id":"b8d70221-0632-4b66-9b7f-2c3ca8012a2c","locked":true,"type":"onetomany","selected":false,"source":"f7d9ec18-5c63-435c-8565-2354ccc57730","sourcePort":"3c752e34-4bc6-40e4-a997-5a8d8a432fb1","target":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","targetPort":"ca95e104-5735-4d2d-9f8b-cd1efdf2c591","points":[{"id":"e208c9c2-bec2-4b9e-add7-b4d5369740ca","type":"point","x":1159.9999985088944,"y":2.0000153004532013},{"id":"bf3813c2-7bee-4a93-8fb1-8d889ca0c1f2","type":"point","x":1159.9999985088944,"y":154.0000102541358},{"id":"9b947fbc-c68f-4bfb-a83f-92d3cfbbbcce","type":"point","x":1100.000086712255,"y":154.0000102541358}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","local_column_attnum":5,"referenced_table_uid":"f7d9ec18-5c63-435c-8565-2354ccc57730","referenced_column_attnum":0}},"38df8566-8dd9-4681-9158-898ce6832128":{"id":"38df8566-8dd9-4681-9158-898ce6832128","locked":true,"type":"onetomany","selected":false,"source":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","sourcePort":"7f34858d-7cf5-4279-a52d-08060af47cfc","target":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","targetPort":"c2120598-bc04-4446-9272-63d7e283065d","points":[{"id":"239f62ad-4d3f-4eb1-9cb6-d25ceb84f2e0","type":"point","x":874.9999805255188,"y":17.0000153004532},{"id":"61a73df6-425b-4886-b523-7a380ba4fd81","type":"point","x":874.9999805255188,"y":140.46615340891915},{"id":"2a0765c1-7f19-4c0f-aa53-1cac54dbaf95","type":"point","x":575.0000351666561,"y":140.46615340891915},{"id":"24e303b6-e301-4e01-847e-3264731b4153","type":"point","x":575.0000351666561,"y":421.00002694311274}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","local_column_attnum":5,"referenced_table_uid":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","referenced_column_attnum":0}},"97eb3ca9-9dde-4465-a6a6-7cb800b39f74":{"id":"97eb3ca9-9dde-4465-a6a6-7cb800b39f74","locked":true,"type":"onetomany","selected":false,"source":"8d00e054-8b06-4cd2-8194-206b648ba2c9","sourcePort":"04c8c5fa-1672-47e3-adde-355ec6eff0e5","target":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","targetPort":"74998dc0-06a7-4730-ba99-5df096b46253","points":[{"id":"33643b90-3064-4d18-9ea5-da78c4d4b48b","type":"point","x":575.000002927854,"y":16.999994535674944},{"id":"27adf668-e1e2-4c7f-9a63-f402b41b8dbd","type":"point","x":575.000002927854,"y":17.00001154853419},{"id":"acac251d-3664-44d1-9cbe-ea854d2b7ab1","type":"point","x":604.9999870574302,"y":17.00001154853419}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","local_column_attnum":0,"referenced_table_uid":"8d00e054-8b06-4cd2-8194-206b648ba2c9","referenced_column_attnum":0}},"d58a2f86-72b5-40db-8e4b-df4c8f9015c5":{"id":"d58a2f86-72b5-40db-8e4b-df4c8f9015c5","locked":true,"type":"onetomany","selected":false,"source":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","sourcePort":"1417f9c5-3077-4338-b1b6-04d8d11c2a0e","target":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","targetPort":"7d27d8f1-26fb-4e8a-b3b0-9e18f7e9f406","points":[{"id":"321ab91c-ed9e-486b-881b-60372b6296dd","type":"point","x":875.0000832820826,"y":272.00001377712425},{"id":"22b1a9b7-88e0-498e-b71e-b51d1fc1a3c6","type":"point","x":845.8767149631176,"y":272.00001377712425},{"id":"740402b7-dbb4-44c6-b7e3-3bbef672a04e","type":"point","x":845.8767149631176,"y":42.00003400012889},{"id":"912f11b6-fe44-402a-99a5-b37d6d2e7307","type":"point","x":829.999988259694,"y":42.00003400012889}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","local_column_attnum":1,"referenced_table_uid":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","referenced_column_attnum":0}},"ae2258d3-fe17-43d7-a051-bf52d53021c5":{"id":"ae2258d3-fe17-43d7-a051-bf52d53021c5","locked":true,"type":"onetomany","selected":false,"source":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","sourcePort":"1417f9c5-3077-4338-b1b6-04d8d11c2a0e","target":"956a5af0-313d-42ab-995b-d0771a0874b0","targetPort":"28c9b014-b2a0-424a-8319-987fa3695f3d","points":[{"id":"9da33747-c222-4322-820c-f6245be092a0","type":"point","x":875.0000832820826,"y":272.00001377712425},{"id":"9359ec16-afde-4958-804c-b8bd7992f82c","type":"point","x":875.0000832820826,"y":587.0000115485341},{"id":"83384a3c-63b5-4b5b-9521-36e47c8983aa","type":"point","x":829.999988259694,"y":587.0000115485341}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"956a5af0-313d-42ab-995b-d0771a0874b0","local_column_attnum":0,"referenced_table_uid":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","referenced_column_attnum":0}},"18d92eeb-5c21-4b59-9fa0-9e98ed7dc762":{"id":"18d92eeb-5c21-4b59-9fa0-9e98ed7dc762","locked":true,"type":"onetomany","selected":false,"source":"574ce38d-cb41-48dc-a079-a65b5b2f976c","sourcePort":"0272608e-a7ea-4c6a-aeec-4120536d4d58","target":"956a5af0-313d-42ab-995b-d0771a0874b0","targetPort":"1c537bf4-0dd2-4212-88a3-1e496d106de3","points":[{"id":"0d9da339-a1cb-478c-8fa6-55301103bfce","type":"point","x":575.000002927854,"y":586.9999911472436},{"id":"b98a6ce6-d6dc-4937-acca-b42e4d27145d","type":"point","x":575.000002927854,"y":618.0000015941014},{"id":"4b22b662-bb22-41b5-ac9f-2f3a09319e3b","type":"point","x":604.9999870574302,"y":618.0000015941014}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"956a5af0-313d-42ab-995b-d0771a0874b0","local_column_attnum":1,"referenced_table_uid":"574ce38d-cb41-48dc-a079-a65b5b2f976c","referenced_column_attnum":0}}}},{"id":"57e45234-8a53-40cf-ba6d-86ca1675b8db","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"2d9d1f7a-d007-431f-ab01-bee73ed33a65":{"id":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","type":"table","selected":false,"x":375,"y":180,"ports":[{"id":"dec0681e-7d6b-486d-b92e-a9c00da8d733","type":"onetomany","x":380.0000383853676,"y":272.00001377712425,"name":"coll-port-0-left","alignment":"left","parentNode":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","links":["59c8736d-4e83-4bf8-9d1f-006d500d2dbd","72d5eb7a-ca9a-4f4b-8e7f-347f0e5585c5","13cfe86f-2025-4bfb-bc7e-5c9b4bc9c80f"]},{"id":"9e4233e2-02f1-43be-9de4-eeba858f6c8c","type":"onetomany","x":545.000002927854,"y":272.00001377712425,"name":"coll-port-0-right","alignment":"right","parentNode":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","links":["0b48fda7-04f0-4c2c-8b35-499a0319bbe5"]},{"id":"af4e5b1d-f7c3-409c-8062-e25e04e9e627","type":"onetomany","x":379.9999639747441,"y":421.00002694311274,"name":"coll-port-5-left","alignment":"left","parentNode":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","links":[]},{"id":"c2120598-bc04-4446-9272-63d7e283065d","type":"onetomany","x":545.0000351666561,"y":421.00002694311274,"name":"coll-port-5-right","alignment":"right","parentNode":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","links":["38df8566-8dd9-4681-9158-898ce6832128"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["dec0681e-7d6b-486d-b92e-a9c00da8d733","9e4233e2-02f1-43be-9de4-eeba858f6c8c","af4e5b1d-f7c3-409c-8062-e25e04e9e627","c2120598-bc04-4446-9272-63d7e283065d"],"otherInfo":{"data":{"name":"User","description":"Customers of the application","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"user_id","cid":"c967"}],"include":[],"cid":"c966"}],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"subscription_id","referenced":"subscription_id","references_table_name":"Subscriptions","references":"c8c80434-4ca4-4f70-9e8a-a5de14903fea"}],"confupdtype":"a","confdeltype":"a"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"user_id","is_primary_key":true,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c968"},{"name":"first_name","is_primary_key":false,"attnum":1,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c969"},{"name":"last_name","is_primary_key":false,"attnum":2,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c970"},{"name":"email","is_primary_key":false,"attnum":3,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c971"},{"name":"password","is_primary_key":false,"attnum":4,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c972"},{"name":"subscription_id","is_primary_key":false,"attnum":5,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"defval":"","attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c973"},{"name":"fellow_reviewers","is_primary_key":false,"attnum":6,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"defval":"0","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c977"}],"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"8d00e054-8b06-4cd2-8194-206b648ba2c9":{"id":"8d00e054-8b06-4cd2-8194-206b648ba2c9","type":"table","selected":false,"x":375,"y":-75,"ports":[{"id":"9ddaa1a5-48ef-4366-b2bd-c0a7c43b257e","type":"onetomany","x":380.0000383853676,"y":16.999994535674944,"name":"coll-port-0-left","alignment":"left","parentNode":"8d00e054-8b06-4cd2-8194-206b648ba2c9","links":["5b8e350e-5ac5-486c-af3e-369fbcff8705"]},{"id":"04c8c5fa-1672-47e3-adde-355ec6eff0e5","type":"onetomany","x":545.000002927854,"y":16.999994535674944,"name":"coll-port-0-right","alignment":"right","parentNode":"8d00e054-8b06-4cd2-8194-206b648ba2c9","links":["97eb3ca9-9dde-4465-a6a6-7cb800b39f74"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["9ddaa1a5-48ef-4366-b2bd-c0a7c43b257e","04c8c5fa-1672-47e3-adde-355ec6eff0e5"],"otherInfo":{"data":{"columns":[{"name":"author_id","is_primary_key":true,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1171"},{"name":"first_name","is_primary_key":false,"attnum":1,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1172"},{"name":"last_name","is_primary_key":false,"attnum":2,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1173"},{"name":"followers","is_primary_key":false,"attnum":3,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"defval":"0","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1174"}],"name":"Author","description":"Details of Authors registered on site","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"author_id","cid":"c1170"}],"include":[],"cid":"c1169"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"67cc017c-a4db-4ac9-8e48-7be469ff7968":{"id":"67cc017c-a4db-4ac9-8e48-7be469ff7968","type":"table","selected":false,"x":630,"y":180,"ports":[{"id":"17a4ad32-4c85-4d35-8d2c-ced86a7b45f2","type":"onetomany","x":635,"y":297,"name":"coll-port-0-left","alignment":"left","parentNode":"67cc017c-a4db-4ac9-8e48-7be469ff7968","links":["0b48fda7-04f0-4c2c-8b35-499a0319bbe5"]},{"id":"5eb57969-2732-4ab3-a0e6-6bb06d1f0f01","type":"onetomany","x":635,"y":322,"name":"coll-port-1-left","alignment":"left","parentNode":"67cc017c-a4db-4ac9-8e48-7be469ff7968","links":[]},{"id":"c19ccb85-f899-431c-bd77-49b82d24c1d0","type":"onetomany","x":800,"y":322,"name":"coll-port-1-right","alignment":"right","parentNode":"67cc017c-a4db-4ac9-8e48-7be469ff7968","links":["89dd8ba4-0344-464b-b667-3ec436277270"]},{"id":"15f1a4eb-7c12-4377-8679-e226c7efe060","type":"onetomany","x":800,"y":297,"name":"coll-port-0-right","alignment":"right","parentNode":"67cc017c-a4db-4ac9-8e48-7be469ff7968","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["17a4ad32-4c85-4d35-8d2c-ced86a7b45f2","5eb57969-2732-4ab3-a0e6-6bb06d1f0f01","c19ccb85-f899-431c-bd77-49b82d24c1d0","15f1a4eb-7c12-4377-8679-e226c7efe060"],"otherInfo":{"data":{"name":"Review","description":"Details about the user reviews, rating and likes on a book","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"review_id","cid":"c989"}],"include":[],"cid":"c988"}],"foreign_key":[{"name":"user_id","comment":"Reference to user_id column in Users table","confmatchtype":true,"autoindex":false,"coveringindex":"","columns":[{"local_column":"user_id","referenced":"user_id","references":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","references_table_name":"User","cid":"c991"}],"confupdtype":"c","confdeltype":"c","cid":"c990"},{"name":"book_id","confmatchtype":true,"autoindex":false,"coveringindex":"","columns":[{"local_column":"book_id","referenced":"book_id","references":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","references_table_name":"Books","cid":"c993"}],"confupdtype":"c","confdeltype":"c","cid":"c992"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"review_id","is_primary_key":true,"attnum":5,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c994"},{"name":"user_id","is_primary_key":false,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c995"},{"name":"book_id","is_primary_key":false,"attnum":1,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c996"},{"name":"reviews","is_primary_key":false,"attnum":2,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c997"},{"name":"upvotes","is_primary_key":false,"attnum":4,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"defval":"0","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c999"},{"name":"downvotes","is_primary_key":false,"attnum":6,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"defval":"0","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1003"}],"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1":{"id":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","type":"table","selected":false,"x":900,"y":180,"ports":[{"id":"1417f9c5-3077-4338-b1b6-04d8d11c2a0e","type":"onetomany","x":905.0000832820826,"y":272.00001377712425,"name":"coll-port-0-left","alignment":"left","parentNode":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","links":["89dd8ba4-0344-464b-b667-3ec436277270","d58a2f86-72b5-40db-8e4b-df4c8f9015c5","ae2258d3-fe17-43d7-a051-bf52d53021c5"]},{"id":"953440ce-2abe-4f93-bed3-15ec74b362b3","type":"onetomany","x":1070.0000065179777,"y":272.00001377712425,"name":"coll-port-0-right","alignment":"right","parentNode":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["1417f9c5-3077-4338-b1b6-04d8d11c2a0e","953440ce-2abe-4f93-bed3-15ec74b362b3"],"otherInfo":{"data":{"name":"Books","description":"Information about the books offered on the platform","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"book_id","cid":"c943"}],"include":[],"cid":"c942"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"book_id","is_primary_key":true,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c944"},{"name":"publisher_id","is_primary_key":false,"attnum":2,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c946"},{"name":"cover_image_url","is_primary_key":false,"attnum":6,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c950"},{"name":"book_title","is_primary_key":false,"attnum":3,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c947"},{"name":"book_description","is_primary_key":false,"attnum":8,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c955"},{"name":"book_softcopy_link","is_primary_key":false,"attnum":7,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c951"}],"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"574ce38d-cb41-48dc-a079-a65b5b2f976c":{"id":"574ce38d-cb41-48dc-a079-a65b5b2f976c","type":"table","selected":false,"x":375,"y":495,"ports":[{"id":"123a9848-e39d-4df0-ad4e-64b8ce9cfed9","type":"onetomany","x":380.0000383853676,"y":586.9999911472436,"name":"coll-port-0-left","alignment":"left","parentNode":"574ce38d-cb41-48dc-a079-a65b5b2f976c","links":["fb152c8f-37d9-46ab-a3a0-23b9693ce0f9"]},{"id":"0272608e-a7ea-4c6a-aeec-4120536d4d58","type":"onetomany","x":545.000002927854,"y":586.9999911472436,"name":"coll-port-0-right","alignment":"right","parentNode":"574ce38d-cb41-48dc-a079-a65b5b2f976c","links":["18d92eeb-5c21-4b59-9fa0-9e98ed7dc762"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["123a9848-e39d-4df0-ad4e-64b8ce9cfed9","0272608e-a7ea-4c6a-aeec-4120536d4d58"],"otherInfo":{"data":{"columns":[{"name":"publisher_id","is_primary_key":true,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c683"},{"name":"publisher_name","is_primary_key":false,"attnum":1,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c684"},{"name":"email","is_primary_key":false,"attnum":2,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c685"}],"name":"Publisher","description":"Details about various book publications available on the platform","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"publisher_id"}],"include":[]}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"c8c80434-4ca4-4f70-9e8a-a5de14903fea":{"id":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","type":"table","selected":false,"x":900,"y":-75,"ports":[{"id":"7f34858d-7cf5-4279-a52d-08060af47cfc","type":"onetomany","x":904.9999805255188,"y":17.0000153004532,"name":"coll-port-0-left","alignment":"left","parentNode":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","links":["38df8566-8dd9-4681-9158-898ce6832128"]},{"id":"0a6af0a9-75b5-4c83-961c-b82e0de2442d","type":"onetomany","x":1070.000086712255,"y":17.0000153004532,"name":"coll-port-0-right","alignment":"right","parentNode":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","links":[]},{"id":"91818fc2-b9e4-4e5e-aa64-f9b264da0066","type":"onetomany","x":904.9999805255188,"y":154.0000102541358,"name":"coll-port-5-left","alignment":"left","parentNode":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","links":[]},{"id":"ca95e104-5735-4d2d-9f8b-cd1efdf2c591","type":"onetomany","x":1070.000086712255,"y":154.0000102541358,"name":"coll-port-5-right","alignment":"right","parentNode":"c8c80434-4ca4-4f70-9e8a-a5de14903fea","links":["b8d70221-0632-4b66-9b7f-2c3ca8012a2c"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["7f34858d-7cf5-4279-a52d-08060af47cfc","0a6af0a9-75b5-4c83-961c-b82e0de2442d","91818fc2-b9e4-4e5e-aa64-f9b264da0066","ca95e104-5735-4d2d-9f8b-cd1efdf2c591"],"otherInfo":{"data":{"columns":[{"name":"subscription_id","is_primary_key":true,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c766"},{"name":"subscription_name","is_primary_key":false,"attnum":1,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c767"},{"name":"duration","is_primary_key":false,"attnum":2,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c768"},{"name":"price","is_primary_key":false,"attnum":3,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c769"},{"name":"subscribers","is_primary_key":false,"attnum":4,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c770"},{"name":"offer_id","is_primary_key":false,"attnum":5,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c771"}],"name":"Subscriptions","description":"Subscription Tiers available on the platform","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"subscription_id"}],"include":[]}],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"offer_id","referenced":"offer_id","references_table_name":"Offer","references":"f7d9ec18-5c63-435c-8565-2354ccc57730"}],"confupdtype":"a","confdeltype":"a"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"f7d9ec18-5c63-435c-8565-2354ccc57730":{"id":"f7d9ec18-5c63-435c-8565-2354ccc57730","type":"table","selected":false,"x":1185,"y":-90,"ports":[{"id":"3c752e34-4bc6-40e4-a997-5a8d8a432fb1","type":"onetomany","x":1189.9999985088944,"y":2.0000153004532013,"name":"coll-port-0-left","alignment":"left","parentNode":"f7d9ec18-5c63-435c-8565-2354ccc57730","links":["b8d70221-0632-4b66-9b7f-2c3ca8012a2c"]},{"id":"0bf97b7f-c958-4793-8268-373c9b04724a","type":"onetomany","x":1355.0000347059822,"y":2.0000153004532013,"name":"coll-port-0-right","alignment":"right","parentNode":"f7d9ec18-5c63-435c-8565-2354ccc57730","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["3c752e34-4bc6-40e4-a997-5a8d8a432fb1","0bf97b7f-c958-4793-8268-373c9b04724a"],"otherInfo":{"data":{"columns":[{"name":"offer_id","is_primary_key":true,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c844"},{"name":"offer_name","is_primary_key":false,"attnum":1,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c845"},{"name":"description","is_primary_key":false,"attnum":2,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c846"},{"name":"start_date","is_primary_key":false,"attnum":3,"cltype":"date","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c847"},{"name":"end_date","is_primary_key":false,"attnum":4,"cltype":"date","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c848"}],"name":"Offer","description":"Information on Offeres available on the platform","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"offer_id"}],"include":[]}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"72ae19fc-33ec-4444-b69f-e3f1792b8e74":{"id":"72ae19fc-33ec-4444-b69f-e3f1792b8e74","type":"table","selected":false,"x":75,"y":180,"ports":[{"id":"2d67ad1d-1162-4c55-a2ef-915918813b43","type":"onetomany","x":79.99999554185251,"y":272.0000157864165,"name":"coll-port-0-left","alignment":"left","parentNode":"72ae19fc-33ec-4444-b69f-e3f1792b8e74","links":[]},{"id":"c3ad7c96-0d19-4ffa-89a3-28487ba417f2","type":"onetomany","x":245.00000111846913,"y":272.0000157864165,"name":"coll-port-0-right","alignment":"right","parentNode":"72ae19fc-33ec-4444-b69f-e3f1792b8e74","links":[]},{"id":"b206662f-9837-4fa9-a3c4-fe68e3a8c412","type":"onetomany","x":79.99999554185251,"y":297.00003823801126,"name":"coll-port-1-left","alignment":"left","parentNode":"72ae19fc-33ec-4444-b69f-e3f1792b8e74","links":[]},{"id":"4e1472f5-f2dc-43f9-8d33-beb9e2a35750","type":"onetomany","x":245.00000111846913,"y":297.00003823801126,"name":"coll-port-1-right","alignment":"right","parentNode":"72ae19fc-33ec-4444-b69f-e3f1792b8e74","links":["13cfe86f-2025-4bfb-bc7e-5c9b4bc9c80f"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["2d67ad1d-1162-4c55-a2ef-915918813b43","c3ad7c96-0d19-4ffa-89a3-28487ba417f2","b206662f-9837-4fa9-a3c4-fe68e3a8c412","4e1472f5-f2dc-43f9-8d33-beb9e2a35750"],"otherInfo":{"data":{"columns":[{"name":"feed_id","is_primary_key":true,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c927"},{"name":"user_id","is_primary_key":false,"attnum":1,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c928"},{"name":"image_url","is_primary_key":false,"attnum":2,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c929"},{"name":"description","is_primary_key":false,"attnum":3,"cltype":"character varying","attlen":null,"min_val_attlen":1,"max_val_attlen":2147483647,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c930"},{"name":"upvotes","is_primary_key":false,"attnum":4,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"defval":"0","attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c931"}],"name":"Feed","description":"Feeds/Posts of a user on the platform","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"feed_id"}],"include":[]}],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"user_id","referenced":"user_id","references_table_name":"User","references":"2d9d1f7a-d007-431f-ab01-bee73ed33a65"}],"confupdtype":"a","confdeltype":"a"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}},"b3fa17db-0951-476f-934d-34ac3aa4d7cb":{"id":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","type":"table","selected":false,"x":90,"y":15,"ports":[{"id":"6b73b042-f65e-4c63-9106-3827f937475c","type":"onetomany","x":95.00000370773103,"y":107.00001229804707,"name":"coll-port-0-left","alignment":"left","parentNode":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","links":[]},{"id":"00c5d391-97df-4437-91af-27d0d26c5c50","type":"onetomany","x":259.99998890351316,"y":107.00001229804707,"name":"coll-port-0-right","alignment":"right","parentNode":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","links":["59c8736d-4e83-4bf8-9d1f-006d500d2dbd"]},{"id":"13dbe9da-703e-4458-a842-3466dd985589","type":"onetomany","x":95.00000370773103,"y":132.0000213204179,"name":"coll-port-1-left","alignment":"left","parentNode":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","links":[]},{"id":"d5342a87-2003-40ed-97ef-e76a1462174a","type":"onetomany","x":259.99998890351316,"y":132.0000213204179,"name":"coll-port-1-right","alignment":"right","parentNode":"b3fa17db-0951-476f-934d-34ac3aa4d7cb","links":["5b8e350e-5ac5-486c-af3e-369fbcff8705"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["6b73b042-f65e-4c63-9106-3827f937475c","00c5d391-97df-4437-91af-27d0d26c5c50","13dbe9da-703e-4458-a842-3466dd985589","d5342a87-2003-40ed-97ef-e76a1462174a"],"otherInfo":{"data":{"name":"User_Author","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"User_user_id","referenced":"user_id","references_table_name":"User","references":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","cid":"c1189"}],"confupdtype":"c","confdeltype":"c","cid":"c1188"},{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"Author_author_id","referenced":"author_id","references_table_name":"Author","references":"8d00e054-8b06-4cd2-8194-206b648ba2c9","cid":"c1191"}],"confupdtype":"a","confdeltype":"a","cid":"c1190"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"User_user_id","is_primary_key":false,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1193"},{"name":"Author_author_id","is_primary_key":false,"attnum":1,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1192"}],"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"17173b30-aaea-4de5-9fae-8799d8353207":{"id":"17173b30-aaea-4de5-9fae-8799d8353207","type":"table","selected":false,"x":90,"y":450,"ports":[{"id":"fa4c7fd5-f4a2-4bc2-b15e-51a6df1a274b","type":"onetomany","x":95.00000370773103,"y":548.000001245307,"name":"coll-port-0-left","alignment":"left","parentNode":"17173b30-aaea-4de5-9fae-8799d8353207","links":[]},{"id":"c705c9e3-9a1c-442a-b4cf-736f6ff91a3b","type":"onetomany","x":259.99998890351316,"y":548.000001245307,"name":"coll-port-0-right","alignment":"right","parentNode":"17173b30-aaea-4de5-9fae-8799d8353207","links":["fb152c8f-37d9-46ab-a3a0-23b9693ce0f9"]},{"id":"83599974-5b72-40e3-925f-3ff455b44d31","type":"onetomany","x":95.00000370773103,"y":578.9999992149374,"name":"coll-port-1-left","alignment":"left","parentNode":"17173b30-aaea-4de5-9fae-8799d8353207","links":[]},{"id":"f4fdf14f-274d-41a4-ba0f-b239dc3b0729","type":"onetomany","x":259.99998890351316,"y":578.9999992149374,"name":"coll-port-1-right","alignment":"right","parentNode":"17173b30-aaea-4de5-9fae-8799d8353207","links":["72d5eb7a-ca9a-4f4b-8e7f-347f0e5585c5"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["fa4c7fd5-f4a2-4bc2-b15e-51a6df1a274b","c705c9e3-9a1c-442a-b4cf-736f6ff91a3b","83599974-5b72-40e3-925f-3ff455b44d31","f4fdf14f-274d-41a4-ba0f-b239dc3b0729"],"otherInfo":{"data":{"name":"Publisher_User","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"Publisher_publisher_id","referenced":"publisher_id","references_table_name":"Publisher","references":"574ce38d-cb41-48dc-a079-a65b5b2f976c","cid":"c1207"}],"confupdtype":"a","confdeltype":"a","cid":"c1206"},{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"User_user_id","referenced":"user_id","references_table_name":"User","references":"2d9d1f7a-d007-431f-ab01-bee73ed33a65","cid":"c1209"}],"confupdtype":"a","confdeltype":"a","cid":"c1208"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"Publisher_publisher_id","is_primary_key":false,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1211"},{"name":"User_user_id","is_primary_key":false,"attnum":1,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1210"}],"schema":"Book_Review_App"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"53b4d43b-a87e-418c-b23c-5bcd2ff220d5":{"id":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","type":"table","selected":false,"x":630,"y":-75,"ports":[{"id":"74998dc0-06a7-4730-ba99-5df096b46253","type":"onetomany","x":634.9999870574302,"y":17.00001154853419,"name":"coll-port-0-left","alignment":"left","parentNode":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","links":["97eb3ca9-9dde-4465-a6a6-7cb800b39f74"]},{"id":"b4b73435-6200-45f9-816f-b60a24768481","type":"onetomany","x":799.999988259694,"y":17.00001154853419,"name":"coll-port-0-right","alignment":"right","parentNode":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","links":[]},{"id":"d39897f1-a62a-4e16-94dd-65ce45e3c0dc","type":"onetomany","x":634.9999870574302,"y":42.00003400012889,"name":"coll-port-1-left","alignment":"left","parentNode":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","links":[]},{"id":"7d27d8f1-26fb-4e8a-b3b0-9e18f7e9f406","type":"onetomany","x":799.999988259694,"y":42.00003400012889,"name":"coll-port-1-right","alignment":"right","parentNode":"53b4d43b-a87e-418c-b23c-5bcd2ff220d5","links":["d58a2f86-72b5-40db-8e4b-df4c8f9015c5"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["74998dc0-06a7-4730-ba99-5df096b46253","b4b73435-6200-45f9-816f-b60a24768481","d39897f1-a62a-4e16-94dd-65ce45e3c0dc","7d27d8f1-26fb-4e8a-b3b0-9e18f7e9f406"],"otherInfo":{"data":{"columns":[{"name":"Author_author_id","is_primary_key":false,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c1171"},{"name":"Books_book_id","is_primary_key":false,"attnum":1,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c944"}],"name":"Author_Books","schema":"Book_Review_App","is_partitioned":false,"coll_inherits":[],"partition_type":"range","partition_keys":[],"partitions":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"Author_author_id","referenced":"author_id","references_table_name":"Author","references":"8d00e054-8b06-4cd2-8194-206b648ba2c9"}],"confupdtype":"a","confdeltype":"a"},{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"Books_book_id","referenced":"book_id","references_table_name":"Books","references":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1"}],"confupdtype":"a","confdeltype":"a"}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"956a5af0-313d-42ab-995b-d0771a0874b0":{"id":"956a5af0-313d-42ab-995b-d0771a0874b0","type":"table","selected":false,"x":630,"y":495,"ports":[{"id":"395e8bdf-8828-491b-865e-93a8ad12e4e9","type":"onetomany","x":634.9999870574302,"y":587.0000115485341,"name":"coll-port-0-left","alignment":"left","parentNode":"956a5af0-313d-42ab-995b-d0771a0874b0","links":[]},{"id":"28c9b014-b2a0-424a-8319-987fa3695f3d","type":"onetomany","x":799.999988259694,"y":587.0000115485341,"name":"coll-port-0-right","alignment":"right","parentNode":"956a5af0-313d-42ab-995b-d0771a0874b0","links":["ae2258d3-fe17-43d7-a051-bf52d53021c5"]},{"id":"1c537bf4-0dd2-4212-88a3-1e496d106de3","type":"onetomany","x":634.9999870574302,"y":618.0000015941014,"name":"coll-port-1-left","alignment":"left","parentNode":"956a5af0-313d-42ab-995b-d0771a0874b0","links":["18d92eeb-5c21-4b59-9fa0-9e98ed7dc762"]},{"id":"2f643891-b775-43d2-afa0-94663bc92b7b","type":"onetomany","x":799.999988259694,"y":618.0000015941014,"name":"coll-port-1-right","alignment":"right","parentNode":"956a5af0-313d-42ab-995b-d0771a0874b0","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["395e8bdf-8828-491b-865e-93a8ad12e4e9","28c9b014-b2a0-424a-8319-987fa3695f3d","1c537bf4-0dd2-4212-88a3-1e496d106de3","2f643891-b775-43d2-afa0-94663bc92b7b"],"otherInfo":{"data":{"columns":[{"name":"Books_book_id","is_primary_key":false,"attnum":0,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c944"},{"name":"Publisher_publisher_id","is_primary_key":false,"attnum":1,"cltype":"integer","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c683"}],"name":"Books_Publisher","schema":"Book_Review_App","is_partitioned":false,"coll_inherits":[],"partition_type":"range","partition_keys":[],"partitions":[],"foreign_key":[{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"Books_book_id","referenced":"book_id","references_table_name":"Books","references":"3fe0e05c-c5e2-4abf-bfcf-02cfd5ec57b1"}],"confupdtype":"a","confdeltype":"a"},{"confmatchtype":false,"autoindex":false,"columns":[{"local_column":"Publisher_publisher_id","referenced":"publisher_id","references_table_name":"Publisher","references":"574ce38d-cb41-48dc-a079-a65b5b2f976c"}],"confupdtype":"a","confdeltype":"a"}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}