-
Notifications
You must be signed in to change notification settings - Fork 0
/
court-management-ERD.pgerd
1 lines (1 loc) · 110 KB
/
court-management-ERD.pgerd
1
{"version":"80200","data":{"id":"aaf7e306-da7a-4a9f-98d1-0b88bb43b0f9","offsetX":294.4884491464717,"offsetY":-99.30369091498059,"zoom":44.28043999137461,"gridSize":15,"layers":[{"id":"1aae29f9-589d-467b-b4c5-c067af33ae8e","type":"diagram-links","isSvg":true,"transformed":true,"models":{"cc82f5d2-7e16-4581-83de-4af78034407c":{"id":"cc82f5d2-7e16-4581-83de-4af78034407c","locked":true,"type":"onetomany","selected":false,"source":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","sourcePort":"3c93a9f5-ffd5-4bbd-818e-1f7a4c238c44","target":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","targetPort":"26f23c50-e9f2-4623-bfe2-8fee4b93e1ee","points":[{"id":"0b00ed0f-c4c3-43cb-90bf-56a45ea0638e","type":"point","x":684.1999863888534,"y":271.19999178415105},{"id":"afb945fa-2476-4876-accd-57e56bdb7991","type":"point","x":1382.923521375847,"y":271.19999178415105},{"id":"f2ca1c47-31e8-4f72-9eab-12aed990e369","type":"point","x":1382.923521375847,"y":806.0000203548389},{"id":"7903081e-b47c-4c04-978e-29462f030891","type":"point","x":849.2000273885744,"y":806.0000203548389}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","local_column_attnum":2,"referenced_table_uid":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","referenced_column_attnum":1}},"85115173-c6fc-4814-ad60-f4dd0c19d9ea":{"id":"85115173-c6fc-4814-ad60-f4dd0c19d9ea","locked":true,"type":"onetomany","selected":false,"source":"8e785c67-930d-4edc-bdd3-62f76c2f092d","sourcePort":"68f5746f-0ece-4337-b8a0-2f6e3aedc6b8","target":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","targetPort":"deabf9bb-3f18-4630-8f0a-477c51b7cd62","points":[{"id":"6bb9ba46-91b0-4495-a7af-c77a8c152571","type":"point","x":264.1999948022569,"y":976.2000588874614},{"id":"6082a0ff-e051-45fc-90ab-cb783e31d842","type":"point","x":264.1999948022569,"y":841.4689832106111},{"id":"a101d54a-e044-4434-9c85-25439613eb21","type":"point","x":615.8001547191601,"y":841.4689832106111},{"id":"39342dd6-bbec-4946-a44e-6a1d586e95c8","type":"point","x":615.8001547191601,"y":830.7999926843222}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","local_column_attnum":3,"referenced_table_uid":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced_column_attnum":1}},"8177641e-a84d-485a-a2d9-81158821be99":{"id":"8177641e-a84d-485a-a2d9-81158821be99","locked":true,"type":"onetomany","selected":false,"source":"95c51c9c-e63f-4451-8901-1843c43c8080","sourcePort":"e8c6ce93-f84f-4cd1-8827-c5324f157c07","target":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","targetPort":"cdf7f2fd-c05e-48fc-b1b5-bbcf009f79e9","points":[{"id":"f3c0c3de-ec5e-4d51-8c70-6835755fc411","type":"point","x":-50.79996442825629,"y":751.2000092441025},{"id":"8a32740c-b83c-4469-9b0c-7cf01c7127ac","type":"point","x":-50.79996442825629,"y":751.1674286963848},{"id":"0d8f5c46-c68e-418f-8565-be926f6d17ff","type":"point","x":450.7999069628341,"y":751.1674286963848},{"id":"b35aedec-3fdb-4fb7-bd74-7c0dafb830b2","type":"point","x":450.7999069628341,"y":345.6000121509035}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","local_column_attnum":4,"referenced_table_uid":"95c51c9c-e63f-4451-8901-1843c43c8080","referenced_column_attnum":1}},"859daa4a-2598-4a1f-b678-99db76c5cfc2":{"id":"859daa4a-2598-4a1f-b678-99db76c5cfc2","locked":true,"type":"onetomany","selected":false,"source":"6f726a92-17cf-497e-82e5-7dc5b0fb6930","sourcePort":"d1435504-c29c-4975-811e-988e8c9cf7c8","target":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","targetPort":"317cca64-9fa5-415a-a318-b84dbb0f9fff","points":[{"id":"7472ab9e-169f-405c-bce5-04a67b0376be","type":"point","x":1035.80000846802,"y":511.1999746695511},{"id":"9cb0ebcd-15c1-4754-b232-bce75e839434","type":"point","x":1035.80000846802,"y":370.85476847707486},{"id":"dc73d81e-17ae-4bad-897c-bf80e396ff5c","type":"point","x":684.1999863888534,"y":370.85476847707486},{"id":"316fc60d-b11a-481b-a53a-c6f71fc8f2dc","type":"point","x":684.1999863888534,"y":370.40000171010394}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","local_column_attnum":5,"referenced_table_uid":"6f726a92-17cf-497e-82e5-7dc5b0fb6930","referenced_column_attnum":1}},"c1b63c82-b4a2-4da0-bce8-01f73cb8a5c5":{"id":"c1b63c82-b4a2-4da0-bce8-01f73cb8a5c5","locked":true,"type":"onetomany","selected":false,"source":"7fe62a79-f4ac-4c94-bf70-f73ca2625561","sourcePort":"8f7b0237-a029-4988-a84b-017f9ecf847e","target":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","targetPort":"de74b201-1fe9-411a-bed7-32ca1616baee","points":[{"id":"3dce702b-1b95-4b0d-a1e4-f69380645715","type":"point","x":765.8000040310839,"y":571.200017772623},{"id":"4886d982-1aad-4365-b549-8d8691f1b6ce","type":"point","x":684.1999863888534,"y":571.200017772623},{"id":"a55429d7-2fb4-456d-b489-56c1cb2773b2","type":"point","x":684.1999863888534,"y":395.19997403958723}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","local_column_attnum":6,"referenced_table_uid":"7fe62a79-f4ac-4c94-bf70-f73ca2625561","referenced_column_attnum":1}},"ed421037-9cbe-435d-a147-2cc08a15cdae":{"id":"ed421037-9cbe-435d-a147-2cc08a15cdae","locked":true,"type":"onetomany","selected":false,"source":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","sourcePort":"a3806f7d-3c95-481c-a0d7-110752a0998c","target":"481d9e48-489e-4910-a80b-31ef4e914cad","targetPort":"d7276254-316f-41a8-894d-3aab09716eb2","points":[{"id":"b2fc62ef-4d4e-4f1d-92f7-e850c151fb21","type":"point","x":-350.79997318701123,"y":796.200032956548},{"id":"3fae9af7-b9a7-4047-8117-f3c60a1e0e24","type":"point","x":-332.806014394454,"y":796.200032956548},{"id":"2de68fba-4204-4b7e-8e17-27a89222c3e8","type":"point","x":-332.806014394454,"y":385.9999943088082},{"id":"23717dfd-0599-4f65-bd38-63f28808ad77","type":"point","x":-284.1999749354072,"y":385.9999943088082}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"481d9e48-489e-4910-a80b-31ef4e914cad","local_column_attnum":2,"referenced_table_uid":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","referenced_column_attnum":1}},"8f17ddc9-8baa-45bf-95cc-cee055815700":{"id":"8f17ddc9-8baa-45bf-95cc-cee055815700","locked":true,"type":"onetomany","selected":false,"source":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","sourcePort":"6b8623f4-e477-4f3b-8cbb-2538995ec6fe","target":"481d9e48-489e-4910-a80b-31ef4e914cad","targetPort":"6231b1ab-3524-4cf3-9c24-03fed537bfe7","points":[{"id":"c42e1a75-40cd-4b01-a9f7-30dc15962b3b","type":"point","x":450.7999069628341,"y":271.19999178415105},{"id":"d7ed6308-fa07-4d92-8a61-7b1bd7bdb6d2","type":"point","x":449.5513921062065,"y":271.19999178415105},{"id":"c8715dba-cf9e-4a66-81fc-745ace053b05","type":"point","x":449.5513921062065,"y":212.58315712939185},{"id":"a455e07d-e587-4b28-ae35-047ecc64462b","type":"point","x":-50.79996442825629,"y":212.58315712939185},{"id":"03a8e64b-ca64-4169-911e-aa2d87c0b708","type":"point","x":-50.79996442825629,"y":410.7999666382915}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"481d9e48-489e-4910-a80b-31ef4e914cad","local_column_attnum":3,"referenced_table_uid":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","referenced_column_attnum":1}},"5f458f28-9de7-4278-b4e2-efb80c0c47fb":{"id":"5f458f28-9de7-4278-b4e2-efb80c0c47fb","locked":true,"type":"onetomany","selected":false,"source":"8e785c67-930d-4edc-bdd3-62f76c2f092d","sourcePort":"68f5746f-0ece-4337-b8a0-2f6e3aedc6b8","target":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","targetPort":"f1c9afaf-1490-4cd6-8428-e4684bb0d271","points":[{"id":"50fb742e-8e43-46d0-bc09-9eaf5bae6106","type":"point","x":264.1999948022569,"y":976.2000588874614},{"id":"79698c1a-0f71-4569-8bb2-37b4358b27d1","type":"point","x":264.1999948022569,"y":908.9017271240987},{"id":"feee69db-a752-4941-9f10-d0c2fa238fe5","type":"point","x":870.7999674682989,"y":908.9017271240987},{"id":"b71bc92a-6bb9-48fc-be5a-2281ff71f584","type":"point","x":870.7999674682989,"y":1013.0250642786426}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","local_column_attnum":2,"referenced_table_uid":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced_column_attnum":1}},"353dc500-901d-42a4-848b-ebed252e4698":{"id":"353dc500-901d-42a4-848b-ebed252e4698","locked":true,"type":"onetomany","selected":false,"source":"cbc89653-5319-4e06-974e-5d78452d7614","sourcePort":"336f8189-8317-4d1d-83e6-4ed2f701c578","target":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","targetPort":"36dc6eb1-afae-418e-9f2d-e04c772488c2","points":[{"id":"676a18bd-6b23-49b5-93d7-721121e2d9fd","type":"point","x":1200.800049467741,"y":1081.2000223246764},{"id":"b6f2b0a4-4db2-44fa-8cf8-0ba6e0eed196","type":"point","x":1195.870301310664,"y":1081.2000223246764},{"id":"a7e47148-ac43-4527-89ab-1e3cc4087f9a","type":"point","x":1195.870301310664,"y":1163.974535047134},{"id":"15ec6638-99be-4cb0-b1fa-aeea3a39046e","type":"point","x":1104.1999779754499,"y":1163.974535047134},{"id":"4a404ccc-1bc6-40a7-8704-7729e88d454d","type":"point","x":1104.1999779754499,"y":1037.825036608126}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","local_column_attnum":3,"referenced_table_uid":"cbc89653-5319-4e06-974e-5d78452d7614","referenced_column_attnum":1}},"e7ad0659-5732-43db-984d-fcd3d0fe1fb8":{"id":"e7ad0659-5732-43db-984d-fcd3d0fe1fb8","locked":true,"type":"onetomany","selected":false,"source":"da71ace3-1c5d-46a5-8d42-cdf8720ddf87","sourcePort":"980040b8-b224-446a-abc6-5a9c363e3f2e","target":"8e785c67-930d-4edc-bdd3-62f76c2f092d","targetPort":"167a3173-4ae4-4adb-929d-6c2d1add10bb","points":[{"id":"8d58b38a-1cb1-4e0f-b204-d47f2f230a37","type":"point","x":345.80001244448744,"y":1306.1999341302985},{"id":"4e3c3112-b66b-48ad-ad03-44f3c0db6383","type":"point","x":299.3048672051306,"y":1306.1999341302985},{"id":"12eded6d-1038-4b8b-8fd6-eee8ee0d0b72","type":"point","x":299.3048672051306,"y":1124.2499866582739},{"id":"620ee1d5-4dac-4429-b3df-2645b39500b3","type":"point","x":264.1999948022569,"y":1124.2499866582739}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"8e785c67-930d-4edc-bdd3-62f76c2f092d","local_column_attnum":6,"referenced_table_uid":"da71ace3-1c5d-46a5-8d42-cdf8720ddf87","referenced_column_attnum":1}},"874c6154-f027-4c6b-9b42-83a6ad3eecca":{"id":"874c6154-f027-4c6b-9b42-83a6ad3eecca","locked":true,"type":"onetomany","selected":false,"source":"71eccd59-ea0d-4f5c-abfc-72aa419dd098","sourcePort":"ee7fef0b-6e7a-4ab4-8f4f-830655c9a9e9","target":"6477e184-1e13-4c34-9cb9-d90e8d35c987","targetPort":"22256524-da4b-4a4c-8211-af3da74f9dad","points":[{"id":"554a394d-78cd-4a80-9163-70f01f798f61","type":"point","x":855.8000514559748,"y":1411.1998975675135},{"id":"d3bb3de3-22fb-4064-bb15-a3354e01654a","type":"point","x":855.8000514559748,"y":1411.1999969482422},{"id":"bd8fabd9-222d-47b7-bf9e-2ee82d83e238","type":"point","x":855.7999992370605,"y":1370.3780882225085},{"id":"0a81cd17-d74b-404a-8c21-474e25fa27c6","type":"point","x":834.1999969482422,"y":1370.3780882225085},{"id":"9bbd3c5a-e484-41aa-80fd-961c1b5bff13","type":"point","x":834.1999735385137,"y":1133.0249938964844},{"id":"da307551-f6e8-48db-a25c-b228e5d0dca4","type":"point","x":834.1999735385137,"y":1133.0250815659183}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6477e184-1e13-4c34-9cb9-d90e8d35c987","local_column_attnum":2,"referenced_table_uid":"71eccd59-ea0d-4f5c-abfc-72aa419dd098","referenced_column_attnum":1}},"76fe3c56-918e-47ce-bf00-7bb6180c5a71":{"id":"76fe3c56-918e-47ce-bf00-7bb6180c5a71","locked":true,"type":"onetomany","selected":false,"source":"8e785c67-930d-4edc-bdd3-62f76c2f092d","sourcePort":"68f5746f-0ece-4337-b8a0-2f6e3aedc6b8","target":"6477e184-1e13-4c34-9cb9-d90e8d35c987","targetPort":"e7fdb5a1-f358-4df4-8fd4-63b3d1b1b7c9","points":[{"id":"eb63baca-744f-4621-aee2-555bf4c37d05","type":"point","x":264.1999948022569,"y":976.2000588874614},{"id":"552bfab6-c6f2-4e4a-b09e-bc8bfe1bc684","type":"point","x":600.8001008690994,"y":976.2000588874614},{"id":"aa50861d-4e34-4117-a9c8-22448df8087c","type":"point","x":600.8001008690994,"y":1157.824916057665}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6477e184-1e13-4c34-9cb9-d90e8d35c987","local_column_attnum":3,"referenced_table_uid":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced_column_attnum":1}},"02eb31ee-1b40-4893-b99a-7aed982f039d":{"id":"02eb31ee-1b40-4893-b99a-7aed982f039d","locked":true,"type":"onetomany","selected":false,"source":"95c51c9c-e63f-4451-8901-1843c43c8080","sourcePort":"e8c6ce93-f84f-4cd1-8827-c5324f157c07","target":"d35be415-11d8-4f45-a073-6d7d5c63ff46","targetPort":"05248f4a-d87c-4ee6-adc7-4318d25f3045","points":[{"id":"f4dcdbed-75e9-4342-ad37-16a63aed77a3","type":"point","x":-50.79996442825629,"y":751.2000092441025},{"id":"6564ad19-8b1d-4a31-9569-0e26d16748fc","type":"point","x":-50.79996442825629,"y":676.9911517739846},{"id":"4bdbb1e4-fe6d-458b-b1c6-408697c8a4e0","type":"point","x":105.80004678880445,"y":676.9911517739846},{"id":"86b013e1-d75b-47ee-b103-13eed1467e9d","type":"point","x":105.80004678880445,"y":567.6250237761826}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"d35be415-11d8-4f45-a073-6d7d5c63ff46","local_column_attnum":4,"referenced_table_uid":"95c51c9c-e63f-4451-8901-1843c43c8080","referenced_column_attnum":1}},"8e05acf6-3164-410b-b60a-c3b71399b0d1":{"id":"8e05acf6-3164-410b-b60a-c3b71399b0d1","locked":true,"type":"onetomany","selected":false,"source":"95c51c9c-e63f-4451-8901-1843c43c8080","sourcePort":"e8c6ce93-f84f-4cd1-8827-c5324f157c07","target":"d35be415-11d8-4f45-a073-6d7d5c63ff46","targetPort":"cb103063-eb48-44fe-94d5-b83bfe0b4edf","points":[{"id":"fcdb0457-60d8-4f67-8975-2d36244ce205","type":"point","x":-50.79996442825629,"y":751.2000092441025},{"id":"66d89cba-4fd4-4905-9fd1-c26cc9326879","type":"point","x":-50.79996442825629,"y":712.4667624760021},{"id":"f50acc81-9344-4a11-9c11-fa96eeeed818","type":"point","x":105.79999923706055,"y":712.4667624760021},{"id":"62f0afa5-6d14-4173-ae8e-0a79388caf04","type":"point","x":105.80004678880445,"y":592.4250030517578},{"id":"d3c018df-e828-4bd1-b0af-be767bb6e85d","type":"point","x":105.80004678880445,"y":592.424996105666}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"d35be415-11d8-4f45-a073-6d7d5c63ff46","local_column_attnum":5,"referenced_table_uid":"95c51c9c-e63f-4451-8901-1843c43c8080","referenced_column_attnum":1}},"cd49372b-b1f0-4b90-ab56-d5817e7e9f89":{"id":"cd49372b-b1f0-4b90-ab56-d5817e7e9f89","locked":true,"type":"onetomany","selected":false,"source":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","sourcePort":"6b8623f4-e477-4f3b-8cbb-2538995ec6fe","target":"d35be415-11d8-4f45-a073-6d7d5c63ff46","targetPort":"626c9abb-0f0a-44ab-a6ca-7f8815e57031","points":[{"id":"25eb1900-7743-4222-ae15-0e9fb3057ab8","type":"point","x":450.7999069628341,"y":271.19999178415105},{"id":"5c7229a3-680c-4786-aa41-e84e721fc5e6","type":"point","x":360.5809220540699,"y":271.19999178415105},{"id":"84d69961-a9c9-4bb6-b286-284320800665","type":"point","x":360.5809220540699,"y":617.2250028945836},{"id":"4de3bbb4-0b8d-43ad-aba9-430b2a52b168","type":"point","x":339.1999883770871,"y":617.2250028945836}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"d35be415-11d8-4f45-a073-6d7d5c63ff46","local_column_attnum":6,"referenced_table_uid":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","referenced_column_attnum":1}},"21b34fa6-6dba-49d2-a062-90cb93fc8c86":{"id":"21b34fa6-6dba-49d2-a062-90cb93fc8c86","locked":true,"type":"onetomany","selected":false,"source":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","sourcePort":"a3806f7d-3c95-481c-a0d7-110752a0998c","target":"55db95a2-6c76-46e5-a136-688ad2ee8030","targetPort":"aacb9c78-0f2f-42cd-9796-9de6ffd7378f","points":[{"id":"d4a57280-4e47-4891-beac-0e9608ffc9ad","type":"point","x":-350.79997318701123,"y":796.200032956548},{"id":"129503f2-2a42-49ea-8a61-cc327bf5bf84","type":"point","x":-350.79997318701123,"y":969.6590834296155},{"id":"f79e81e6-81dd-44d7-b4c1-1f2535baea06","type":"point","x":-310.2306257658974,"y":969.6590834296155},{"id":"85d105da-8ab0-4ced-8df9-b7d142c84c1f","type":"point","x":-310.2306257658974,"y":1150.9999494477368},{"id":"4c7b7dc7-aba5-46fe-b134-800f37d59d60","type":"point","x":-314.1999792572262,"y":1150.9999494477368}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"55db95a2-6c76-46e5-a136-688ad2ee8030","local_column_attnum":2,"referenced_table_uid":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","referenced_column_attnum":1}},"850448d7-ba10-41b0-83ad-0742e7dd033b":{"id":"850448d7-ba10-41b0-83ad-0742e7dd033b","locked":true,"type":"onetomany","selected":false,"source":"8e785c67-930d-4edc-bdd3-62f76c2f092d","sourcePort":"4e557380-7d96-45a2-b003-9ea60328a6ea","target":"55db95a2-6c76-46e5-a136-688ad2ee8030","targetPort":"00b06aa6-e7d1-432f-9098-e7a96c706171","points":[{"id":"e789a4ea-2db1-4553-a7a5-f05a29561863","type":"point","x":30.800053213974245,"y":976.2000588874614},{"id":"6f7827f8-37e4-4718-9557-47725b52969e","type":"point","x":12.274926070625343,"y":976.2000588874614},{"id":"cc1fa208-7ec6-4115-bbcc-9dfec95c483e","type":"point","x":12.274926070625343,"y":1175.7999906960883},{"id":"aa4c7397-f7d9-40e4-8b1a-ed53eb44b0ca","type":"point","x":-80.7999687500752,"y":1175.7999906960883}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"55db95a2-6c76-46e5-a136-688ad2ee8030","local_column_attnum":3,"referenced_table_uid":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced_column_attnum":1}}}},{"id":"196bcf62-91e7-4fbb-a122-5f69f94235c0","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"ea591f87-ab9b-4d84-b41c-bbf0249cc82f":{"id":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","type":"table","selected":false,"x":645,"y":690,"ports":[{"id":"0a289e21-3ec5-4c8c-a7b7-3a4da0a89632","type":"onetomany","x":645.8001547191601,"y":806.0000203548389,"name":"coll-port-2-left","alignment":"left","parentNode":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","links":[]},{"id":"26f23c50-e9f2-4623-bfe2-8fee4b93e1ee","type":"onetomany","x":819.2000273885744,"y":806.0000203548389,"name":"coll-port-2-right","alignment":"right","parentNode":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","links":["cc82f5d2-7e16-4581-83de-4af78034407c"]},{"id":"deabf9bb-3f18-4630-8f0a-477c51b7cd62","type":"onetomany","x":645.8001547191601,"y":830.7999926843222,"name":"coll-port-3-left","alignment":"left","parentNode":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","links":["85115173-c6fc-4814-ad60-f4dd0c19d9ea"]},{"id":"d491016b-4338-4c06-ad15-043fe6ecd62a","type":"onetomany","x":819.2000273885744,"y":830.7999926843222,"name":"coll-port-3-right","alignment":"right","parentNode":"ea591f87-ab9b-4d84-b41c-bbf0249cc82f","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["0a289e21-3ec5-4c8c-a7b7-3a4da0a89632","26f23c50-e9f2-4623-bfe2-8fee4b93e1ee","deabf9bb-3f18-4630-8f0a-477c51b7cd62","d491016b-4338-4c06-ad15-043fe6ecd62a"],"otherInfo":{"data":{"columns":[{"name":"case_party_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"assigned","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":["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":"case_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"assigned","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"party_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"assigned","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"assigned","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16890,"name":"assigned_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"case_party_id"}],"include":[]}],"foreign_key":[{"name":"fk_assigned_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16847,"fknsp":"public","fktab":"assigned","refnspoid":2200,"refnsp":"public","reftab":"court_case","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"case_id","references":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","referenced":"case_id","references_table_name":"public.court_case"}],"remote_schema":"public","remote_table":"court_case","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_assigned_3","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16862,"fknsp":"public","fktab":"assigned","refnspoid":2200,"refnsp":"public","reftab":"party","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"party_id","references":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced":"party_id","references_table_name":"party"}],"remote_schema":"public","remote_table":"party","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"6f726a92-17cf-497e-82e5-7dc5b0fb6930":{"id":"6f726a92-17cf-497e-82e5-7dc5b0fb6930","type":"table","selected":false,"x":1065,"y":420,"ports":[{"id":"d1435504-c29c-4975-811e-988e8c9cf7c8","type":"onetomany","x":1065.80000846802,"y":511.1999746695511,"name":"coll-port-1-left","alignment":"left","parentNode":"6f726a92-17cf-497e-82e5-7dc5b0fb6930","links":["859daa4a-2598-4a1f-b678-99db76c5cfc2"]},{"id":"03d1f0bb-d3af-4133-9ed6-51907f12adb5","type":"onetomany","x":1239.1998811374342,"y":511.1999746695511,"name":"coll-port-1-right","alignment":"right","parentNode":"6f726a92-17cf-497e-82e5-7dc5b0fb6930","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["d1435504-c29c-4975-811e-988e8c9cf7c8","03d1f0bb-d3af-4133-9ed6-51907f12adb5"],"otherInfo":{"data":{"name":"case_types","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":16855,"name":"case_types_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"case_type_id","cid":"c142"}],"include":[],"cid":"c141"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"case_type_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"case_types","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c143"},{"name":"case_type_code","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"case_types","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c144"},{"name":"case_type","atttypid":1042,"attlen":"100","attnum":3,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"case_types","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","character varying","name","text"],"cid":"c145","min_val_attlen":1,"max_val_attlen":2147483647}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"95c51c9c-e63f-4451-8901-1843c43c8080":{"id":"95c51c9c-e63f-4451-8901-1843c43c8080","type":"table","selected":false,"x":-255,"y":660,"ports":[{"id":"ac5c50a9-918a-46b2-9511-3938f1da40b6","type":"onetomany","x":-254.19997493540725,"y":751.2000092441025,"name":"coll-port-1-left","alignment":"left","parentNode":"95c51c9c-e63f-4451-8901-1843c43c8080","links":[]},{"id":"e8c6ce93-f84f-4cd1-8827-c5324f157c07","type":"onetomany","x":-80.79996442825629,"y":751.2000092441025,"name":"coll-port-1-right","alignment":"right","parentNode":"95c51c9c-e63f-4451-8901-1843c43c8080","links":["8177641e-a84d-485a-a2d9-81158821be99","02eb31ee-1b40-4893-b99a-7aed982f039d","8e05acf6-3164-410b-b60a-c3b71399b0d1"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["ac5c50a9-918a-46b2-9511-3938f1da40b6","e8c6ce93-f84f-4cd1-8827-c5324f157c07"],"otherInfo":{"data":{"name":"court","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":16840,"name":"court_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"court_id","cid":"c91"}],"include":[],"cid":"c90"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"court_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"court","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c92"},{"name":"court_name","atttypid":1042,"attlen":"200","attnum":2,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"court","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","character varying","name","text"],"cid":"c93","min_val_attlen":1,"max_val_attlen":2147483647}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"5ab89ecb-ecf6-440d-8042-7431c5b890d6":{"id":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","type":"table","selected":false,"x":480,"y":180,"ports":[{"id":"6b8623f4-e477-4f3b-8cbb-2538995ec6fe","type":"onetomany","x":480.7999069628341,"y":271.19999178415105,"name":"coll-port-1-left","alignment":"left","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":["8f17ddc9-8baa-45bf-95cc-cee055815700","cd49372b-b1f0-4b90-ab56-d5817e7e9f89"]},{"id":"3c93a9f5-ffd5-4bbd-818e-1f7a4c238c44","type":"onetomany","x":654.1999863888534,"y":271.19999178415105,"name":"coll-port-1-right","alignment":"right","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":["cc82f5d2-7e16-4581-83de-4af78034407c"]},{"id":"cdf7f2fd-c05e-48fc-b1b5-bbcf009f79e9","type":"onetomany","x":480.7999069628341,"y":345.6000121509035,"name":"coll-port-4-left","alignment":"left","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":["8177641e-a84d-485a-a2d9-81158821be99"]},{"id":"97f8e7aa-9052-4983-8d98-ab6be568c869","type":"onetomany","x":654.1999863888534,"y":345.6000121509035,"name":"coll-port-4-right","alignment":"right","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":[]},{"id":"863b8a76-0888-4c2f-8ccd-2a65d76aaf44","type":"onetomany","x":480.7999069628341,"y":370.40000171010394,"name":"coll-port-5-left","alignment":"left","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":[]},{"id":"317cca64-9fa5-415a-a318-b84dbb0f9fff","type":"onetomany","x":654.1999863888534,"y":370.40000171010394,"name":"coll-port-5-right","alignment":"right","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":["859daa4a-2598-4a1f-b678-99db76c5cfc2"]},{"id":"b677563a-9e4d-4c88-9a3d-8fa42578a4af","type":"onetomany","x":480.7999069628341,"y":395.19997403958723,"name":"coll-port-6-left","alignment":"left","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":[]},{"id":"de74b201-1fe9-411a-bed7-32ca1616baee","type":"onetomany","x":654.1999863888534,"y":395.19997403958723,"name":"coll-port-6-right","alignment":"right","parentNode":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","links":["c1b63c82-b4a2-4da0-bce8-01f73cb8a5c5"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["6b8623f4-e477-4f3b-8cbb-2538995ec6fe","3c93a9f5-ffd5-4bbd-818e-1f7a4c238c44","cdf7f2fd-c05e-48fc-b1b5-bbcf009f79e9","97f8e7aa-9052-4983-8d98-ab6be568c869","863b8a76-0888-4c2f-8ccd-2a65d76aaf44","317cca64-9fa5-415a-a318-b84dbb0f9fff","b677563a-9e4d-4c88-9a3d-8fa42578a4af","de74b201-1fe9-411a-bed7-32ca1616baee"],"otherInfo":{"data":{"columns":[{"name":"case_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"court_case","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":["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":"case_code","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"court_case","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"date_of_charge","atttypid":1082,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"court_case","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":"court_id","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"court_case","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"case_type_id","atttypid":23,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"court_case","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","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"location_id","atttypid":23,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"court_case","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","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"court_case","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16850,"name":"court_case_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"case_id"}],"include":[]}],"foreign_key":[{"name":"fk_court_case_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[4],"confkey":[1],"confrelid":16837,"fknsp":"public","fktab":"court_case","refnspoid":2200,"refnsp":"public","reftab":"court","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"court_id","references":"95c51c9c-e63f-4451-8901-1843c43c8080","referenced":"court_id","references_table_name":"court"}],"remote_schema":"public","remote_table":"court","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_court_case_3","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":16852,"fknsp":"public","fktab":"court_case","refnspoid":2200,"refnsp":"public","reftab":"case_types","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"case_type_id","references":"6f726a92-17cf-497e-82e5-7dc5b0fb6930","referenced":"case_type_id","references_table_name":"case_types"}],"remote_schema":"public","remote_table":"case_types","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_court_case_4","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":16857,"fknsp":"public","fktab":"court_case","refnspoid":2200,"refnsp":"public","reftab":"location","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"location_id","references":"7fe62a79-f4ac-4c94-bf70-f73ca2625561","referenced":"location_id","references_table_name":"location"}],"remote_schema":"public","remote_table":"location","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"cbc89653-5319-4e06-974e-5d78452d7614":{"id":"cbc89653-5319-4e06-974e-5d78452d7614","type":"table","selected":true,"x":1230,"y":990,"ports":[{"id":"336f8189-8317-4d1d-83e6-4ed2f701c578","type":"onetomany","x":1230.800049467741,"y":1081.2000223246764,"name":"coll-port-1-left","alignment":"left","parentNode":"cbc89653-5319-4e06-974e-5d78452d7614","links":["353dc500-901d-42a4-848b-ebed252e4698"]},{"id":"69285af1-0deb-4462-94ae-1a6b659a93ac","type":"onetomany","x":1404.200059974892,"y":1081.2000223246764,"name":"coll-port-1-right","alignment":"right","parentNode":"cbc89653-5319-4e06-974e-5d78452d7614","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["336f8189-8317-4d1d-83e6-4ed2f701c578","69285af1-0deb-4462-94ae-1a6b659a93ac"],"otherInfo":{"data":{"name":"email","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":16875,"name":"email_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"party_email_id","cid":"c278"}],"include":[],"cid":"c277"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"party_email_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"email","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c279"},{"name":"party_email","atttypid":1042,"attlen":"200","attnum":2,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"email","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","character varying","name","text"],"cid":"c280","min_val_attlen":1,"max_val_attlen":2147483647}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"481d9e48-489e-4910-a80b-31ef4e914cad":{"id":"481d9e48-489e-4910-a80b-31ef4e914cad","type":"table","selected":false,"x":-255,"y":270,"ports":[{"id":"d7276254-316f-41a8-894d-3aab09716eb2","type":"onetomany","x":-254.19997493540725,"y":385.9999943088082,"name":"coll-port-2-left","alignment":"left","parentNode":"481d9e48-489e-4910-a80b-31ef4e914cad","links":["ed421037-9cbe-435d-a147-2cc08a15cdae"]},{"id":"1244919f-2801-412a-816a-23e7b1969bfa","type":"onetomany","x":-80.79996442825629,"y":385.9999943088082,"name":"coll-port-2-right","alignment":"right","parentNode":"481d9e48-489e-4910-a80b-31ef4e914cad","links":[]},{"id":"bf587c24-a554-43c0-b526-1845f56ec44d","type":"onetomany","x":-254.19997493540725,"y":410.7999666382915,"name":"coll-port-3-left","alignment":"left","parentNode":"481d9e48-489e-4910-a80b-31ef4e914cad","links":[]},{"id":"6231b1ab-3524-4cf3-9c24-03fed537bfe7","type":"onetomany","x":-80.79996442825629,"y":410.7999666382915,"name":"coll-port-3-right","alignment":"right","parentNode":"481d9e48-489e-4910-a80b-31ef4e914cad","links":["8f17ddc9-8baa-45bf-95cc-cee055815700"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["d7276254-316f-41a8-894d-3aab09716eb2","1244919f-2801-412a-816a-23e7b1969bfa","bf587c24-a554-43c0-b526-1845f56ec44d","6231b1ab-3524-4cf3-9c24-03fed537bfe7"],"otherInfo":{"data":{"columns":[{"name":"case_notice_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"issues","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":["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":"notice_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"issues","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"case_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"issues","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"issues","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16895,"name":"issues_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"case_notice_id"}],"include":[]}],"foreign_key":[{"name":"fk_issues_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16867,"fknsp":"public","fktab":"issues","refnspoid":2200,"refnsp":"public","reftab":"notice","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"notice_id","references":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","referenced":"notice_id","references_table_name":"public.notice"}],"remote_schema":"public","remote_table":"notice","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_issues_3","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16847,"fknsp":"public","fktab":"issues","refnspoid":2200,"refnsp":"public","reftab":"court_case","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"case_id","references":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","referenced":"case_id","references_table_name":"public.court_case"}],"remote_schema":"public","remote_table":"court_case","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"7fe62a79-f4ac-4c94-bf70-f73ca2625561":{"id":"7fe62a79-f4ac-4c94-bf70-f73ca2625561","type":"table","selected":false,"x":795,"y":480,"ports":[{"id":"8f7b0237-a029-4988-a84b-017f9ecf847e","type":"onetomany","x":795.8000040310839,"y":571.200017772623,"name":"coll-port-1-left","alignment":"left","parentNode":"7fe62a79-f4ac-4c94-bf70-f73ca2625561","links":["c1b63c82-b4a2-4da0-bce8-01f73cb8a5c5"]},{"id":"8a9728be-40b3-432f-a753-4398a9b0048d","type":"onetomany","x":969.2000145382349,"y":571.200017772623,"name":"coll-port-1-right","alignment":"right","parentNode":"7fe62a79-f4ac-4c94-bf70-f73ca2625561","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["8f7b0237-a029-4988-a84b-017f9ecf847e","8a9728be-40b3-432f-a753-4398a9b0048d"],"otherInfo":{"data":{"name":"location","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":16860,"name":"location_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"location_id","cid":"c168"}],"include":[],"cid":"c167"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"location_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"location","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c169"},{"name":"location_code","atttypid":1042,"attlen":null,"attnum":2,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":null,"is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"location","is_view_only":false,"attcompression":"","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","character varying","name","text"],"cid":"c170","min_val_attlen":1,"max_val_attlen":2147483647},{"name":"location_name","atttypid":1042,"attlen":"200","attnum":3,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"location","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","character","character varying","name","text"],"cid":"c171","min_val_attlen":1,"max_val_attlen":2147483647}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac":{"id":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","type":"table","selected":false,"x":-555,"y":705,"ports":[{"id":"a73a42f3-d62e-4f1c-b954-7f8f9718adde","type":"onetomany","x":-554.1999923090208,"y":796.200032956548,"name":"coll-port-1-left","alignment":"left","parentNode":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","links":[]},{"id":"a3806f7d-3c95-481c-a0d7-110752a0998c","type":"onetomany","x":-380.79997318701123,"y":796.200032956548,"name":"coll-port-1-right","alignment":"right","parentNode":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","links":["21b34fa6-6dba-49d2-a062-90cb93fc8c86","ed421037-9cbe-435d-a147-2cc08a15cdae"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["a73a42f3-d62e-4f1c-b954-7f8f9718adde","a3806f7d-3c95-481c-a0d7-110752a0998c"],"otherInfo":{"data":{"columns":[{"name":"notice_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"notice","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c66"},{"name":"receipt_date","atttypid":1082,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"notice","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"],"cid":"c67"},{"name":"issue_date","atttypid":1082,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"notice","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","date","timestamp with time zone","timestamp without time zone"],"cid":"c68"}],"name":"notice","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16870,"name":"notice_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"notice_id","cid":"c65"}],"include":[],"cid":"c64"}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651":{"id":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","type":"table","selected":false,"x":900,"y":885,"ports":[{"id":"f1c9afaf-1490-4cd6-8428-e4684bb0d271","type":"onetomany","x":900.7999674682989,"y":1013.0250642786426,"name":"coll-port-2-left","alignment":"left","parentNode":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","links":["5f458f28-9de7-4278-b4e2-efb80c0c47fb"]},{"id":"99f1abbf-7c10-4afa-9ef6-a32da7af3c44","type":"onetomany","x":1074.1999779754499,"y":1013.0250642786426,"name":"coll-port-2-right","alignment":"right","parentNode":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","links":[]},{"id":"c730f943-5330-42bf-83a8-31d2f363f46e","type":"onetomany","x":900.7999674682989,"y":1037.825036608126,"name":"coll-port-3-left","alignment":"left","parentNode":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","links":[]},{"id":"36dc6eb1-afae-418e-9f2d-e04c772488c2","type":"onetomany","x":1074.1999779754499,"y":1037.825036608126,"name":"coll-port-3-right","alignment":"right","parentNode":"2a9f7ecb-70b2-4a20-ae31-2e98bf43a651","links":["353dc500-901d-42a4-848b-ebed252e4698"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["f1c9afaf-1490-4cd6-8428-e4684bb0d271","99f1abbf-7c10-4afa-9ef6-a32da7af3c44","c730f943-5330-42bf-83a8-31d2f363f46e","36dc6eb1-afae-418e-9f2d-e04c772488c2"],"otherInfo":{"data":{"columns":[{"name":"party_email_relationship_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"owns","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":["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":"party_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"owns","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"party_email_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"owns","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"owns","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16905,"name":"owns_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"party_email_relationship_id"}],"include":[]}],"foreign_key":[{"name":"fk_owns_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16862,"fknsp":"public","fktab":"owns","refnspoid":2200,"refnsp":"public","reftab":"party","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"party_id","references":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced":"party_id","references_table_name":"party"}],"remote_schema":"public","remote_table":"party","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_owns_3","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16872,"fknsp":"public","fktab":"owns","refnspoid":2200,"refnsp":"public","reftab":"email","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"party_email_id","references":"cbc89653-5319-4e06-974e-5d78452d7614","referenced":"party_email_id","references_table_name":"email"}],"remote_schema":"public","remote_table":"email","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"8e785c67-930d-4edc-bdd3-62f76c2f092d":{"id":"8e785c67-930d-4edc-bdd3-62f76c2f092d","type":"table","selected":false,"x":60,"y":885,"ports":[{"id":"4e557380-7d96-45a2-b003-9ea60328a6ea","type":"onetomany","x":60.800053213974245,"y":976.2000588874614,"name":"coll-port-1-left","alignment":"left","parentNode":"8e785c67-930d-4edc-bdd3-62f76c2f092d","links":["850448d7-ba10-41b0-83ad-0742e7dd033b"]},{"id":"68f5746f-0ece-4337-b8a0-2f6e3aedc6b8","type":"onetomany","x":234.1999948022569,"y":976.2000588874614,"name":"coll-port-1-right","alignment":"right","parentNode":"8e785c67-930d-4edc-bdd3-62f76c2f092d","links":["85115173-c6fc-4814-ad60-f4dd0c19d9ea","76fe3c56-918e-47ce-bf00-7bb6180c5a71","5f458f28-9de7-4278-b4e2-efb80c0c47fb"]},{"id":"fbd22891-c10b-4d01-9594-88fa3d36e817","type":"onetomany","x":60.800053213974245,"y":1124.2499866582739,"name":"coll-port-6-left","alignment":"left","parentNode":"8e785c67-930d-4edc-bdd3-62f76c2f092d","links":[]},{"id":"167a3173-4ae4-4adb-929d-6c2d1add10bb","type":"onetomany","x":234.1999948022569,"y":1124.2499866582739,"name":"coll-port-6-right","alignment":"right","parentNode":"8e785c67-930d-4edc-bdd3-62f76c2f092d","links":["e7ad0659-5732-43db-984d-fcd3d0fe1fb8"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["4e557380-7d96-45a2-b003-9ea60328a6ea","68f5746f-0ece-4337-b8a0-2f6e3aedc6b8","fbd22891-c10b-4d01-9594-88fa3d36e817","167a3173-4ae4-4adb-929d-6c2d1add10bb"],"otherInfo":{"data":{"name":"party","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":16865,"name":"party_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"party_id","cid":"c194"}],"include":[],"cid":"c193"}],"foreign_key":[{"name":"fk_party_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":16882,"fknsp":"public","fktab":"party","refnspoid":2200,"refnsp":"public","reftab":"place","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"place_id","references":"da71ace3-1c5d-46a5-8d42-cdf8720ddf87","referenced":"place_id","references_table_name":"place","cid":"c196"}],"remote_schema":"public","remote_table":"place","coveringindex":null,"autoindex":false,"hasindex":false,"cid":"c195"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"party_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"party","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c197"},{"name":"party_cpf","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"party","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c198"},{"name":"party_name","atttypid":1042,"attlen":"200","attnum":3,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"party","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","character varying","name","text"],"cid":"c199","min_val_attlen":1,"max_val_attlen":2147483647},{"name":"party_phone_number_1","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"party","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c200"},{"name":"party_phone_number_2","atttypid":23,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"party","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","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c201"},{"name":"place_id","atttypid":23,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"party","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","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c202"}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"71eccd59-ea0d-4f5c-abfc-72aa419dd098":{"id":"71eccd59-ea0d-4f5c-abfc-72aa419dd098","type":"table","selected":false,"x":885,"y":1320,"ports":[{"id":"ee7fef0b-6e7a-4ab4-8f4f-830655c9a9e9","type":"onetomany","x":885.8000514559748,"y":1411.1998975675135,"name":"coll-port-1-left","alignment":"left","parentNode":"71eccd59-ea0d-4f5c-abfc-72aa419dd098","links":["874c6154-f027-4c6b-9b42-83a6ad3eecca"]},{"id":"9331b6b1-661e-4160-88a7-65c16c1b1543","type":"onetomany","x":1059.199924125389,"y":1411.1998975675135,"name":"coll-port-1-right","alignment":"right","parentNode":"71eccd59-ea0d-4f5c-abfc-72aa419dd098","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["ee7fef0b-6e7a-4ab4-8f4f-830655c9a9e9","9331b6b1-661e-4160-88a7-65c16c1b1543"],"otherInfo":{"data":{"name":"party_type","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":16880,"name":"party_type_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"party_type_id","cid":"c253"}],"include":[],"cid":"c252"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"party_type_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"party_type","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c254"},{"name":"party_type","atttypid":1042,"attlen":"100","attnum":2,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"party_type","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","character varying","name","text"],"cid":"c255","min_val_attlen":1,"max_val_attlen":2147483647}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"da71ace3-1c5d-46a5-8d42-cdf8720ddf87":{"id":"da71ace3-1c5d-46a5-8d42-cdf8720ddf87","type":"table","selected":false,"x":375,"y":1215,"ports":[{"id":"980040b8-b224-446a-abc6-5a9c363e3f2e","type":"onetomany","x":375.80001244448744,"y":1306.1999341302985,"name":"coll-port-1-left","alignment":"left","parentNode":"da71ace3-1c5d-46a5-8d42-cdf8720ddf87","links":["e7ad0659-5732-43db-984d-fcd3d0fe1fb8"]},{"id":"536b53d2-d357-4989-b4eb-aaea3ffc70e6","type":"onetomany","x":549.200160789375,"y":1306.1999341302985,"name":"coll-port-1-right","alignment":"right","parentNode":"da71ace3-1c5d-46a5-8d42-cdf8720ddf87","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["980040b8-b224-446a-abc6-5a9c363e3f2e","536b53d2-d357-4989-b4eb-aaea3ffc70e6"],"otherInfo":{"data":{"name":"place","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":16885,"name":"place_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"place_id","cid":"c225"}],"include":[],"cid":"c224"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"place_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"place","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":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c226"},{"name":"party_street_name","atttypid":1042,"attlen":"200","attnum":2,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"place","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","character varying","name","text"],"cid":"c227","min_val_attlen":1,"max_val_attlen":2147483647},{"name":"party_street_number","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"place","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"],"cid":"c228"},{"name":"party_city","atttypid":1042,"attlen":"100","attnum":4,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"place","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","character","character varying","name","text"],"cid":"c229","min_val_attlen":1,"max_val_attlen":2147483647},{"name":"fu","atttypid":1042,"attlen":"10","attnum":5,"attndims":0,"atttypmod":5,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character","displaytypname":"character(1)","cltype":"character","inheritedfrom":null,"inheritedid":null,"elemoid":1042,"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":"place","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","character","character","character varying","name","text"],"cid":"c230","min_val_attlen":1,"max_val_attlen":2147483647}],"schema":"public","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"6477e184-1e13-4c34-9cb9-d90e8d35c987":{"id":"6477e184-1e13-4c34-9cb9-d90e8d35c987","type":"table","selected":false,"x":630,"y":1005,"ports":[{"id":"f9516a92-7089-4b42-81b1-81d75199b18a","type":"onetomany","x":630.8001008690994,"y":1133.0250815659183,"name":"coll-port-2-left","alignment":"left","parentNode":"6477e184-1e13-4c34-9cb9-d90e8d35c987","links":[]},{"id":"22256524-da4b-4a4c-8211-af3da74f9dad","type":"onetomany","x":804.1999735385137,"y":1133.0250815659183,"name":"coll-port-2-right","alignment":"right","parentNode":"6477e184-1e13-4c34-9cb9-d90e8d35c987","links":["874c6154-f027-4c6b-9b42-83a6ad3eecca"]},{"id":"e7fdb5a1-f358-4df4-8fd4-63b3d1b1b7c9","type":"onetomany","x":630.8001008690994,"y":1157.824916057665,"name":"coll-port-3-left","alignment":"left","parentNode":"6477e184-1e13-4c34-9cb9-d90e8d35c987","links":["76fe3c56-918e-47ce-bf00-7bb6180c5a71"]},{"id":"0bd58abe-492b-48eb-92fc-e69cc09dba06","type":"onetomany","x":804.1999735385137,"y":1157.824916057665,"name":"coll-port-3-right","alignment":"right","parentNode":"6477e184-1e13-4c34-9cb9-d90e8d35c987","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["f9516a92-7089-4b42-81b1-81d75199b18a","22256524-da4b-4a4c-8211-af3da74f9dad","e7fdb5a1-f358-4df4-8fd4-63b3d1b1b7c9","0bd58abe-492b-48eb-92fc-e69cc09dba06"],"otherInfo":{"data":{"columns":[{"name":"party_type_relationship_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"possesses","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":["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":"party_type_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"possesses","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"party_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"possesses","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"possesses","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16910,"name":"possesses_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"party_type_relationship_id"}],"include":[]}],"foreign_key":[{"name":"fk_possesses_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16877,"fknsp":"public","fktab":"possesses","refnspoid":2200,"refnsp":"public","reftab":"party_type","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"party_type_id","references":"71eccd59-ea0d-4f5c-abfc-72aa419dd098","referenced":"party_type_id","references_table_name":"party_type"}],"remote_schema":"public","remote_table":"party_type","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_possesses_3","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16862,"fknsp":"public","fktab":"possesses","refnspoid":2200,"refnsp":"public","reftab":"party","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"party_id","references":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced":"party_id","references_table_name":"party"}],"remote_schema":"public","remote_table":"party","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"d35be415-11d8-4f45-a073-6d7d5c63ff46":{"id":"d35be415-11d8-4f45-a073-6d7d5c63ff46","type":"table","selected":false,"x":135,"y":390,"ports":[{"id":"05248f4a-d87c-4ee6-adc7-4318d25f3045","type":"onetomany","x":135.80004678880445,"y":567.6250237761826,"name":"coll-port-4-left","alignment":"left","parentNode":"d35be415-11d8-4f45-a073-6d7d5c63ff46","links":["02eb31ee-1b40-4893-b99a-7aed982f039d"]},{"id":"adaf6d59-2c86-46df-9f4b-bf0288c26080","type":"onetomany","x":309.1999883770871,"y":567.6250237761826,"name":"coll-port-4-right","alignment":"right","parentNode":"d35be415-11d8-4f45-a073-6d7d5c63ff46","links":[]},{"id":"cb103063-eb48-44fe-94d5-b83bfe0b4edf","type":"onetomany","x":135.80004678880445,"y":592.424996105666,"name":"coll-port-5-left","alignment":"left","parentNode":"d35be415-11d8-4f45-a073-6d7d5c63ff46","links":["8e05acf6-3164-410b-b60a-c3b71399b0d1"]},{"id":"e58ca127-6da9-47a2-a6eb-91972435b642","type":"onetomany","x":309.1999883770871,"y":592.424996105666,"name":"coll-port-5-right","alignment":"right","parentNode":"d35be415-11d8-4f45-a073-6d7d5c63ff46","links":[]},{"id":"bf9c3f51-f0bc-41bb-ac72-303bdd71723b","type":"onetomany","x":135.80004678880445,"y":617.2250028945836,"name":"coll-port-6-left","alignment":"left","parentNode":"d35be415-11d8-4f45-a073-6d7d5c63ff46","links":[]},{"id":"626c9abb-0f0a-44ab-a6ca-7f8815e57031","type":"onetomany","x":309.1999883770871,"y":617.2250028945836,"name":"coll-port-6-right","alignment":"right","parentNode":"d35be415-11d8-4f45-a073-6d7d5c63ff46","links":["cd49372b-b1f0-4b90-ab56-d5817e7e9f89"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["05248f4a-d87c-4ee6-adc7-4318d25f3045","adaf6d59-2c86-46df-9f4b-bf0288c26080","cb103063-eb48-44fe-94d5-b83bfe0b4edf","e58ca127-6da9-47a2-a6eb-91972435b642","bf9c3f51-f0bc-41bb-ac72-303bdd71723b","626c9abb-0f0a-44ab-a6ca-7f8815e57031"],"otherInfo":{"data":{"columns":[{"name":"process_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"process","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":["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":"process_time","atttypid":1083,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"time without time zone","displaytypname":"time without time zone","cltype":"time without time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1083,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"process","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":["interval","time with time zone","time without time zone","time without time zone"]},{"name":"process_date","atttypid":1082,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"process","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":"court_id_sends","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"process","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"court_id_receives","atttypid":23,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"process","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"case_id","atttypid":23,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"process","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","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"process","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16845,"name":"process_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"process_id"}],"include":[]}],"foreign_key":[{"name":"fk_process_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[4],"confkey":[1],"confrelid":16837,"fknsp":"public","fktab":"process","refnspoid":2200,"refnsp":"public","reftab":"court","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"court_id_sends","references":"95c51c9c-e63f-4451-8901-1843c43c8080","referenced":"court_id","references_table_name":"court"}],"remote_schema":"public","remote_table":"court","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_process_3","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[5],"confkey":[1],"confrelid":16837,"fknsp":"public","fktab":"process","refnspoid":2200,"refnsp":"public","reftab":"court","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"court_id_receives","references":"95c51c9c-e63f-4451-8901-1843c43c8080","referenced":"court_id","references_table_name":"court"}],"remote_schema":"public","remote_table":"court","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_process_4","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"r","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":16847,"fknsp":"public","fktab":"process","refnspoid":2200,"refnsp":"public","reftab":"court_case","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"case_id","references":"5ab89ecb-ecf6-440d-8042-7431c5b890d6","referenced":"case_id","references_table_name":"public.court_case"}],"remote_schema":"public","remote_table":"court_case","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"55db95a2-6c76-46e5-a136-688ad2ee8030":{"id":"55db95a2-6c76-46e5-a136-688ad2ee8030","type":"table","selected":false,"x":-285,"y":1035,"ports":[{"id":"aacb9c78-0f2f-42cd-9796-9de6ffd7378f","type":"onetomany","x":-284.1999792572262,"y":1150.9999494477368,"name":"coll-port-2-left","alignment":"left","parentNode":"55db95a2-6c76-46e5-a136-688ad2ee8030","links":["21b34fa6-6dba-49d2-a062-90cb93fc8c86"]},{"id":"27dded61-ebd4-49fe-86d2-79af907f579e","type":"onetomany","x":-110.7999687500752,"y":1150.9999494477368,"name":"coll-port-2-right","alignment":"right","parentNode":"55db95a2-6c76-46e5-a136-688ad2ee8030","links":[]},{"id":"75b4e570-f263-4a5d-a264-bfb8ed53ed74","type":"onetomany","x":-284.1999792572262,"y":1175.7999906960883,"name":"coll-port-3-left","alignment":"left","parentNode":"55db95a2-6c76-46e5-a136-688ad2ee8030","links":[]},{"id":"00b06aa6-e7d1-432f-9098-e7a96c706171","type":"onetomany","x":-110.7999687500752,"y":1175.7999906960883,"name":"coll-port-3-right","alignment":"right","parentNode":"55db95a2-6c76-46e5-a136-688ad2ee8030","links":["850448d7-ba10-41b0-83ad-0742e7dd033b"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["aacb9c78-0f2f-42cd-9796-9de6ffd7378f","27dded61-ebd4-49fe-86d2-79af907f579e","75b4e570-f263-4a5d-a264-bfb8ed53ed74","00b06aa6-e7d1-432f-9098-e7a96c706171"],"otherInfo":{"data":{"columns":[{"name":"party_notice_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":"receives","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":["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":"notice_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"receives","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","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"party_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"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":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"receives","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","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"receives","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":16900,"name":"receives_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"party_notice_id"}],"include":[]}],"foreign_key":[{"name":"fk_receives_2","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":16867,"fknsp":"public","fktab":"receives","refnspoid":2200,"refnsp":"public","reftab":"notice","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"notice_id","references":"4feb70fe-4bc9-44e1-8d3e-41478d8b81ac","referenced":"notice_id","references_table_name":"public.notice"}],"remote_schema":"public","remote_table":"notice","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"fk_receives_3","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":16862,"fknsp":"public","fktab":"receives","refnspoid":2200,"refnsp":"public","reftab":"party","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"party_id","references":"8e785c67-930d-4edc-bdd3-62f76c2f092d","referenced":"party_id","references_table_name":"party"}],"remote_schema":"public","remote_table":"party","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}