schema-erd-diagram.pgerd

{"version":"60400","data":{"id":"ca74132a-b861-42d3-aae9-63deb9dee712","offsetX":386.6850365868179,"offsetY":471.24787614193355,"zoom":75.83333333333334,"gridSize":15,"layers":[{"id":"6d17e865-e640-42ce-b0aa-ffb26c2636cf","type":"diagram-links","isSvg":true,"transformed":true,"models":{"de0f13c2-88e2-4433-94c3-cd8ebcad4459":{"id":"de0f13c2-88e2-4433-94c3-cd8ebcad4459","locked":true,"type":"onetomany","source":"2e64c167-954d-42f5-94aa-9e82b036e3af","sourcePort":"cf84c53e-2823-499e-a456-7c24e5e0809a","target":"dd65412c-e65e-4d02-af38-642a6e128a17","targetPort":"2acffadb-8b75-4ec3-a5a6-3f9ab217036b","points":[{"id":"9c88313d-2da9-4178-b2c6-a44eda39dbdb","type":"point","x":586.5000000623365,"y":456.00000538296183},{"id":"e8eba17e-586e-486f-b707-05f3cb36f80a","type":"point","x":586.5000000623365,"y":1038.9999802843927},{"id":"5759700f-308c-4b26-8a2e-e08fcd59c8ec","type":"point","x":208.9999772454559,"y":1038.9999802843927}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"dd65412c-e65e-4d02-af38-642a6e128a17","local_column_attnum":0,"referenced_table_uid":"2e64c167-954d-42f5-94aa-9e82b036e3af","referenced_column_attnum":0}},"e3e3ca7b-55a9-4d95-8134-0345eb4452fe":{"id":"e3e3ca7b-55a9-4d95-8134-0345eb4452fe","locked":true,"type":"onetomany","selected":false,"source":"6aef958e-02cc-4170-b342-f32f56f6a8de","sourcePort":"16bdfe06-d0ce-4ae3-932a-a6b568ea1495","target":"dd65412c-e65e-4d02-af38-642a6e128a17","targetPort":"4005d92a-ad86-4d35-8e9c-73d7eca63737","points":[{"id":"5f103fe5-a48f-41d2-8c21-9e2155fb5f05","type":"point","x":361.499977245456,"y":106.99999739705365},{"id":"2b190e5c-398b-4a19-b1e4-c78f0122bd33","type":"point","x":92.5,"y":1067.9999848477687},{"id":"b85b35d4-4990-4cdb-a7e5-a27f60806495","type":"point","x":208.9999772454559,"y":1067.9999848477687}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"dd65412c-e65e-4d02-af38-642a6e128a17","local_column_attnum":1,"referenced_table_uid":"6aef958e-02cc-4170-b342-f32f56f6a8de","referenced_column_attnum":0}},"bc175d21-9b5c-446d-a55c-c2c734e09bad":{"id":"bc175d21-9b5c-446d-a55c-c2c734e09bad","locked":true,"type":"onetomany","selected":false,"source":"6aef958e-02cc-4170-b342-f32f56f6a8de","sourcePort":"16bdfe06-d0ce-4ae3-932a-a6b568ea1495","target":"24ea67c8-81f8-45a4-be88-5a412a9edb46","targetPort":"13b9123d-005d-485e-86b9-d6047738c5a7","points":[{"id":"04392389-b48d-477f-a4b2-fc0abfed398f","type":"point","x":361.499977245456,"y":106.99999739705365},{"id":"ff44a2a6-7bf7-4718-b717-e40a026d3193","type":"point","x":327.5,"y":1061.9999757210164},{"id":"9ee4123b-c3d7-4163-a267-a693457ad50b","type":"point","x":434.00000006233654,"y":1061.9999757210164}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"24ea67c8-81f8-45a4-be88-5a412a9edb46","local_column_attnum":1,"referenced_table_uid":"6aef958e-02cc-4170-b342-f32f56f6a8de","referenced_column_attnum":0}},"5bee09be-62cb-4352-90c6-8aca108fab61":{"id":"5bee09be-62cb-4352-90c6-8aca108fab61","locked":true,"type":"onetomany","source":"2e64c167-954d-42f5-94aa-9e82b036e3af","sourcePort":"cf84c53e-2823-499e-a456-7c24e5e0809a","target":"24ea67c8-81f8-45a4-be88-5a412a9edb46","targetPort":"a676128e-5d0a-4230-af0f-330dc4e1cccd","points":[{"id":"22265e9b-ad6f-4390-8821-030f3b8f20b3","type":"point","x":586.5000000623365,"y":456.00000538296183},{"id":"40ee1e58-4e1a-45cd-b60c-71ed91c9053f","type":"point","x":434.00000006233654,"y":906},{"id":"a49f5fe1-36ef-4c02-a1f6-96752c626fac","type":"point","x":434.00000006233654,"y":1090.9999802843927}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"24ea67c8-81f8-45a4-be88-5a412a9edb46","local_column_attnum":2,"referenced_table_uid":"2e64c167-954d-42f5-94aa-9e82b036e3af","referenced_column_attnum":0}},"1e5f59b8-4a6e-422b-bbb4-0355b08da0e0":{"id":"1e5f59b8-4a6e-422b-bbb4-0355b08da0e0","locked":true,"type":"onetomany","selected":false,"source":"dd65412c-e65e-4d02-af38-642a6e128a17","sourcePort":"a8882cfa-f0bc-4c02-aa0a-255eb1533f5a","target":"6aef958e-02cc-4170-b342-f32f56f6a8de","targetPort":"0520687b-4b77-4976-a1a1-e1815b97efcc","points":[{"id":"ab17a551-99ee-4e20-b985-029d4f5ae84b","type":"point","x":208.9999772454559,"y":1184.0000031012733},{"id":"1b605f0c-e4e1-407d-b92a-6fd732cd9bb6","type":"point","x":361.499977245456,"y":1184.0000031012733},{"id":"8d39a7bd-984d-4e53-8d28-fdd19932a035","type":"point","x":361.499977245456,"y":164.99998941114532}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"6aef958e-02cc-4170-b342-f32f56f6a8de","local_column_attnum":2,"referenced_table_uid":"dd65412c-e65e-4d02-af38-642a6e128a17","referenced_column_attnum":5}},"470d60a8-b921-453b-8237-303572ae44c0":{"id":"470d60a8-b921-453b-8237-303572ae44c0","locked":true,"type":"onetomany","source":"6aef958e-02cc-4170-b342-f32f56f6a8de","sourcePort":"16bdfe06-d0ce-4ae3-932a-a6b568ea1495","target":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","targetPort":"1cff944c-7210-4250-a6dd-dc9e04ea886c","points":[{"id":"be20d5ad-462e-413c-b916-5b1b69f34fb6","type":"point","x":361.499977245456,"y":106.99999739705365},{"id":"8660b6b8-ddd5-492e-a1af-0826deffa068","type":"point","x":361.499977245456,"y":1076.5000065337408},{"id":"28a988c5-095c-4d58-980c-051e98bf8d42","type":"point","x":750.2499758855096,"y":1076.5000065337408}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","local_column_attnum":1,"referenced_table_uid":"6aef958e-02cc-4170-b342-f32f56f6a8de","referenced_column_attnum":0}},"fd76fb71-f424-414d-8e7c-937d904c2f66":{"id":"fd76fb71-f424-414d-8e7c-937d904c2f66","locked":true,"type":"onetomany","source":"2e64c167-954d-42f5-94aa-9e82b036e3af","sourcePort":"cf84c53e-2823-499e-a456-7c24e5e0809a","target":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","targetPort":"26086730-1251-47d6-8b3a-594d4750a770","points":[{"id":"15ec59b9-4961-4d44-ab92-2c9a7d658059","type":"point","x":586.5000000623365,"y":456.00000538296183},{"id":"a7549f16-0958-4272-90c7-a42267fd88ad","type":"point","x":586.5000000623365,"y":1134.5000097673915},{"id":"898f6108-5fda-46cc-ad16-c0c2cd778b74","type":"point","x":750.2500243902696,"y":1134.5000097673915}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","local_column_attnum":3,"referenced_table_uid":"2e64c167-954d-42f5-94aa-9e82b036e3af","referenced_column_attnum":0}},"7acc49e8-1275-4a92-ab3d-c3d32d65cc22":{"id":"7acc49e8-1275-4a92-ab3d-c3d32d65cc22","locked":true,"type":"onetomany","source":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","sourcePort":"ef50fba3-3d7b-4cda-8ffe-f75741cdb229","target":"83c1a81f-975c-4ed4-ad87-c899708f3d46","targetPort":"9bde3750-d733-46cb-aef6-dd1feb561f31","points":[{"id":"4d969199-13a3-47c6-b129-2552c0480c1e","type":"point","x":750.2500243902696,"y":1047.5000049169157},{"id":"38dfa641-62f1-40db-ba2b-37305a8e6037","type":"point","x":750.2500243902696,"y":1446.9999983333578},{"id":"cdd534fb-04bd-41ba-96aa-2773ec938992","type":"point","x":688.9999808021424,"y":1446.9999983333578}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"83c1a81f-975c-4ed4-ad87-c899708f3d46","local_column_attnum":4,"referenced_table_uid":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","referenced_column_attnum":0}},"52a9a564-ccb6-4091-ab82-53153b9931b7":{"id":"52a9a564-ccb6-4091-ab82-53153b9931b7","locked":true,"type":"onetomany","source":"2e64c167-954d-42f5-94aa-9e82b036e3af","sourcePort":"cf84c53e-2823-499e-a456-7c24e5e0809a","target":"83c1a81f-975c-4ed4-ad87-c899708f3d46","targetPort":"ab67a144-b7d7-4916-98fc-e7055ea12906","points":[{"id":"50ae9f5e-ec2f-4385-b225-e3b65be9b702","type":"point","x":586.5000000623365,"y":456.00000538296183},{"id":"f5a3d11a-15af-408b-ae92-680b8273613d","type":"point","x":586.5000000623365,"y":906},{"id":"a6db7765-a91e-4546-8782-e4c517c54920","type":"point","x":511.25,"y":1069.5},{"id":"489d533e-08ef-4688-b605-af08fe28e0d7","type":"point","x":511.25,"y":1475.9999997670695},{"id":"bf5e321f-33b8-4c1e-828b-10afb77ab1e1","type":"point","x":688.9999808021424,"y":1475.9999997670695}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"83c1a81f-975c-4ed4-ad87-c899708f3d46","local_column_attnum":5,"referenced_table_uid":"2e64c167-954d-42f5-94aa-9e82b036e3af","referenced_column_attnum":0}},"705e37a0-d65e-4de9-9804-3d2b68743398":{"id":"705e37a0-d65e-4de9-9804-3d2b68743398","locked":true,"type":"onetomany","source":"6aef958e-02cc-4170-b342-f32f56f6a8de","sourcePort":"16bdfe06-d0ce-4ae3-932a-a6b568ea1495","target":"83c1a81f-975c-4ed4-ad87-c899708f3d46","targetPort":"17fbfaef-b9db-4d2b-af5e-28c7302a6d2a","points":[{"id":"40243128-3c2b-4255-8f67-9be81d4041eb","type":"point","x":361.499977245456,"y":106.99999739705365},{"id":"f384bd4f-5964-41fc-976e-b05b70977dd1","type":"point","x":361.499977245456,"y":906},{"id":"094dda1d-f936-4a46-93f8-e6e4a59e8fa3","type":"point","x":450,"y":1069.5},{"id":"e23c98f5-d086-4667-8cd1-b9d452fc2cd1","type":"point","x":450,"y":1505.0000165619783},{"id":"cd4347a6-4167-4e46-85c1-a83a1726d7b0","type":"point","x":688.9999808021425,"y":1505.0000165619783}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"83c1a81f-975c-4ed4-ad87-c899708f3d46","local_column_attnum":6,"referenced_table_uid":"6aef958e-02cc-4170-b342-f32f56f6a8de","referenced_column_attnum":0}}}},{"id":"8e99d13d-874f-430d-a01d-63b80b0bf398","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"6aef958e-02cc-4170-b342-f32f56f6a8de":{"id":"6aef958e-02cc-4170-b342-f32f56f6a8de","type":"table","selected":false,"x":157.5,"y":5,"ports":[{"id":"16bdfe06-d0ce-4ae3-932a-a6b568ea1495","type":"onetomany","x":331.499977245456,"y":106.99999739705365,"name":"coll-port-0","alignment":"right","parentNode":"6aef958e-02cc-4170-b342-f32f56f6a8de","links":["e3e3ca7b-55a9-4d95-8134-0345eb4452fe","bc175d21-9b5c-446d-a55c-c2c734e09bad","470d60a8-b921-453b-8237-303572ae44c0","705e37a0-d65e-4de9-9804-3d2b68743398"],"subtype":"one"},{"id":"0520687b-4b77-4976-a1a1-e1815b97efcc","type":"onetomany","x":331.499977245456,"y":164.99998941114532,"name":"coll-port-2","alignment":"right","parentNode":"6aef958e-02cc-4170-b342-f32f56f6a8de","links":["1e5f59b8-4a6e-422b-bbb4-0355b08da0e0"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["16bdfe06-d0ce-4ae3-932a-a6b568ea1495","0520687b-4b77-4976-a1a1-e1815b97efcc"],"otherInfo":{"data":{"columns":[{"name":"guild_id","is_primary_key":true,"attnum":0,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"defval":"","attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c233"},{"name":"premium","is_primary_key":false,"attnum":1,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c234"},{"name":"member_join_leave_logs","is_primary_key":false,"attnum":2,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c235"},{"name":"greet_members","is_primary_key":false,"attnum":3,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c236"},{"name":"farewell_members","is_primary_key":false,"attnum":4,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c237"},{"name":"greet_bots","is_primary_key":false,"attnum":5,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c238"},{"name":"farewell_bots","is_primary_key":false,"attnum":6,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c239"},{"name":"raidmode_status","is_primary_key":false,"attnum":7,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c240"},{"name":"required_age","is_primary_key":false,"attnum":8,"cltype":"smallint","attlen":null,"attprecision":null,"collspcname":null,"defval":"7","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c241"},{"name":"default_log_webhook","is_primary_key":false,"attnum":9,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c242"},{"name":"role_log_webhook","is_primary_key":false,"attnum":10,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c243"},{"name":"message_log_webhook","is_primary_key":false,"attnum":11,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c244"},{"name":"channel_log_webhook","is_primary_key":false,"attnum":12,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c245"},{"name":"guild_log_webhook","is_primary_key":false,"attnum":13,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c246"},{"name":"voice_log_webhook","is_primary_key":false,"attnum":14,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c247"},{"name":"member_log_webhook","is_primary_key":false,"attnum":15,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c248"},{"name":"join_leave_log_webhook","is_primary_key":false,"attnum":16,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c249"},{"name":"raidmode_log_webhook","is_primary_key":false,"attnum":17,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c250"},{"name":"member_greetings","is_primary_key":false,"attnum":18,"cltype":"text[]","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c251"},{"name":"member_goodbyes","is_primary_key":false,"attnum":19,"cltype":"text[]","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c252"},{"name":"member_greetings_channel","is_primary_key":false,"attnum":20,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c253"},{"name":"member_goodbyes_channel","is_primary_key":false,"attnum":21,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c254"},{"name":"bot_greeting_channel","is_primary_key":false,"attnum":22,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c255"},{"name":"bot_goodbyes_channel","is_primary_key":false,"attnum":23,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c256"},{"name":"bot_role","is_primary_key":false,"attnum":24,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c257"}],"name":"guild","description":"The main table of Zupie, holds all Guild related Information.","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"guild_id","cid":"c230"}],"include":[],"cid":"c229","name":"","comment":""}],"foreign_key":[{"name":"premium","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"premium","referenced":"premium","references":"dd65412c-e65e-4d02-af38-642a6e128a17","references_table_name":"(public) members_guilds","cid":"c232"}],"confupdtype":"a","confdeltype":"a","cid":"c231"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"public"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"2e64c167-954d-42f5-94aa-9e82b036e3af":{"id":"2e64c167-954d-42f5-94aa-9e82b036e3af","type":"table","selected":false,"x":382.5,"y":354,"ports":[{"id":"cf84c53e-2823-499e-a456-7c24e5e0809a","type":"onetomany","x":556.5000000623365,"y":456.00000538296183,"name":"coll-port-0","alignment":"right","parentNode":"2e64c167-954d-42f5-94aa-9e82b036e3af","links":["de0f13c2-88e2-4433-94c3-cd8ebcad4459","5bee09be-62cb-4352-90c6-8aca108fab61","fd76fb71-f424-414d-8e7c-937d904c2f66","52a9a564-ccb6-4091-ab82-53153b9931b7"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["cf84c53e-2823-499e-a456-7c24e5e0809a"],"otherInfo":{"data":{"columns":[{"name":"member_id","is_primary_key":true,"attnum":0,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c206"},{"name":"premium_slots","is_primary_key":false,"attnum":4,"cltype":"smallint","attlen":null,"attprecision":null,"collspcname":null,"defval":"0","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c208"},{"name":"DM_Reminders","is_primary_key":false,"attnum":5,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c209"}],"name":"member","description":"Holds member related information","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"member_id","cid":"c205"}],"include":[],"cid":"c204"}],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"public"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"dd65412c-e65e-4d02-af38-642a6e128a17":{"id":"dd65412c-e65e-4d02-af38-642a6e128a17","type":"table","selected":false,"x":5,"y":937,"ports":[{"id":"2acffadb-8b75-4ec3-a5a6-3f9ab217036b","type":"onetomany","x":178.9999772454559,"y":1038.9999802843927,"name":"coll-port-0","alignment":"right","parentNode":"dd65412c-e65e-4d02-af38-642a6e128a17","links":["de0f13c2-88e2-4433-94c3-cd8ebcad4459"],"subtype":"many"},{"id":"4005d92a-ad86-4d35-8e9c-73d7eca63737","type":"onetomany","x":178.9999772454559,"y":1067.9999848477687,"name":"coll-port-1","alignment":"right","parentNode":"dd65412c-e65e-4d02-af38-642a6e128a17","links":["e3e3ca7b-55a9-4d95-8134-0345eb4452fe"],"subtype":"many"},{"id":"a8882cfa-f0bc-4c02-aa0a-255eb1533f5a","type":"onetomany","x":178.9999772454559,"y":1184.0000031012733,"name":"coll-port-5","alignment":"right","parentNode":"dd65412c-e65e-4d02-af38-642a6e128a17","links":["1e5f59b8-4a6e-422b-bbb4-0355b08da0e0"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["2acffadb-8b75-4ec3-a5a6-3f9ab217036b","4005d92a-ad86-4d35-8e9c-73d7eca63737","a8882cfa-f0bc-4c02-aa0a-255eb1533f5a"],"otherInfo":{"data":{"columns":[{"name":"member_id","is_primary_key":true,"attnum":0,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c86"},{"name":"guild_id","is_primary_key":true,"attnum":1,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c87"},{"name":"afk_status","is_primary_key":false,"attnum":2,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c88"},{"name":"afk_message","is_primary_key":false,"attnum":3,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c89"},{"name":"joincount","is_primary_key":false,"attnum":4,"cltype":"smallint","attlen":null,"attprecision":null,"collspcname":null,"defval":"0","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c90"},{"name":"premium","is_primary_key":false,"attnum":5,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"defval":"False","attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c94"}],"name":"members_guilds","description":"Links the members table to the guilds table.","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"member_id","cid":"c80"},{"column":"guild_id","cid":"c81"}],"include":[],"cid":"c79"}],"foreign_key":[{"name":"member_id","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"member_id","referenced":"member_id","references":"2e64c167-954d-42f5-94aa-9e82b036e3af","references_table_name":"(public) member","cid":"c83"}],"confupdtype":"c","confdeltype":"a","cid":"c82"},{"name":"guild_id","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"guild_id","referenced":"guild_id","references":"6aef958e-02cc-4170-b342-f32f56f6a8de","references_table_name":"(public) data","cid":"c85"}],"confupdtype":"c","confdeltype":"c","cid":"c84"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"public"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"24ea67c8-81f8-45a4-be88-5a412a9edb46":{"id":"24ea67c8-81f8-45a4-be88-5a412a9edb46","type":"table","selected":false,"x":230,"y":931,"ports":[{"id":"13b9123d-005d-485e-86b9-d6047738c5a7","type":"onetomany","x":404.00000006233654,"y":1061.9999757210164,"name":"coll-port-1","alignment":"right","parentNode":"24ea67c8-81f8-45a4-be88-5a412a9edb46","links":["bc175d21-9b5c-446d-a55c-c2c734e09bad"],"subtype":"many"},{"id":"a676128e-5d0a-4230-af0f-330dc4e1cccd","type":"onetomany","x":404.00000006233654,"y":1090.9999802843927,"name":"coll-port-2","alignment":"right","parentNode":"24ea67c8-81f8-45a4-be88-5a412a9edb46","links":["5bee09be-62cb-4352-90c6-8aca108fab61"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["13b9123d-005d-485e-86b9-d6047738c5a7","a676128e-5d0a-4230-af0f-330dc4e1cccd"],"otherInfo":{"data":{"columns":[{"name":"reminder_id","is_primary_key":true,"attnum":0,"cltype":"bigserial","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c61"},{"name":"guild_id","is_primary_key":false,"attnum":1,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c62"},{"name":"member_id","is_primary_key":false,"attnum":2,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c63"},{"name":"reminder_time","is_primary_key":false,"attnum":3,"cltype":"timestamp with time zone","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c64","min_val_attlen":0,"max_val_attlen":6},{"name":"reminder_text","is_primary_key":false,"attnum":4,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c65"},{"name":"reminder_status","is_primary_key":false,"attnum":5,"cltype":"boolean","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c66"}],"name":"reminders","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"reminder_id","cid":"c56"}],"include":[],"cid":"c55"}],"foreign_key":[{"name":"guild","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"guild_id","referenced":"guild_id","references":"6aef958e-02cc-4170-b342-f32f56f6a8de","references_table_name":"(public) data","cid":"c58"}],"confupdtype":"a","confdeltype":"a","cid":"c57"},{"name":"user","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"member_id","referenced":"member_id","references":"2e64c167-954d-42f5-94aa-9e82b036e3af","references_table_name":"(public) member","cid":"c60"}],"confupdtype":"a","confdeltype":"a","cid":"c59"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"public"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"83c1a81f-975c-4ed4-ad87-c899708f3d46":{"id":"83c1a81f-975c-4ed4-ad87-c899708f3d46","type":"table","selected":false,"x":485,"y":1258,"ports":[{"id":"9bde3750-d733-46cb-aef6-dd1feb561f31","type":"onetomany","x":658.9999808021424,"y":1446.9999983333578,"name":"coll-port-4","alignment":"right","parentNode":"83c1a81f-975c-4ed4-ad87-c899708f3d46","links":["7acc49e8-1275-4a92-ab3d-c3d32d65cc22"],"subtype":"many"},{"id":"ab67a144-b7d7-4916-98fc-e7055ea12906","type":"onetomany","x":658.9999808021424,"y":1475.9999997670695,"name":"coll-port-5","alignment":"right","parentNode":"83c1a81f-975c-4ed4-ad87-c899708f3d46","links":["52a9a564-ccb6-4091-ab82-53153b9931b7"],"subtype":"many"},{"id":"17fbfaef-b9db-4d2b-af5e-28c7302a6d2a","type":"onetomany","x":658.9999808021425,"y":1505.0000165619783,"name":"coll-port-6","alignment":"right","parentNode":"83c1a81f-975c-4ed4-ad87-c899708f3d46","links":["705e37a0-d65e-4de9-9804-3d2b68743398"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["9bde3750-d733-46cb-aef6-dd1feb561f31","ab67a144-b7d7-4916-98fc-e7055ea12906","17fbfaef-b9db-4d2b-af5e-28c7302a6d2a"],"otherInfo":{"data":{"name":"tags","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"name":"","comment":"","columns":[{"column":"tag_id","cid":"c362"}],"include":[],"cid":"c361"}],"foreign_key":[{"name":"embed","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"tag_embed","referenced":"embed_id","references":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","references_table_name":"(public) embeds","cid":"c364"}],"confupdtype":"a","confdeltype":"a","cid":"c363"},{"name":"member","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"member_id","referenced":"member_id","references":"2e64c167-954d-42f5-94aa-9e82b036e3af","references_table_name":"(public) member","cid":"c366"}],"confupdtype":"a","confdeltype":"a","cid":"c365"},{"name":"guild","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"guild_id","referenced":"guild_id","references":"6aef958e-02cc-4170-b342-f32f56f6a8de","references_table_name":"(public) guild","cid":"c393"}],"confupdtype":"a","confdeltype":"a","cid":"c375"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"tag_id","is_primary_key":true,"attnum":0,"cltype":"bigserial","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c367"},{"name":"tag_name","is_primary_key":false,"attnum":2,"cltype":"text","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"d","attoptions":[],"cid":"c368"},{"name":"tag_content","is_primary_key":false,"attnum":3,"cltype":"text","attlen":null,"attprecision":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c369"},{"name":"tag_embed","is_primary_key":false,"attnum":4,"cltype":"bigserial","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c370"},{"name":"member_id","is_primary_key":false,"attnum":5,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c371"},{"name":"guild_id","is_primary_key":false,"attnum":6,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c372"}],"schema":"public"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"5811027f-9eaa-4bf1-a9d1-cab311a6b73b":{"id":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","type":"table","selected":false,"x":546.25,"y":945.5,"ports":[{"id":"1cff944c-7210-4250-a6dd-dc9e04ea886c","type":"onetomany","x":720.2499758855096,"y":1076.5000065337408,"name":"coll-port-1","alignment":"right","parentNode":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","links":["470d60a8-b921-453b-8237-303572ae44c0"],"subtype":"many"},{"id":"26086730-1251-47d6-8b3a-594d4750a770","type":"onetomany","x":720.2500243902696,"y":1134.5000097673915,"name":"coll-port-3","alignment":"right","parentNode":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","links":["fd76fb71-f424-414d-8e7c-937d904c2f66"],"subtype":"many"},{"id":"ef50fba3-3d7b-4cda-8ffe-f75741cdb229","type":"onetomany","x":720.2500243902696,"y":1047.5000049169157,"name":"coll-port-0","alignment":"right","parentNode":"5811027f-9eaa-4bf1-a9d1-cab311a6b73b","links":["7acc49e8-1275-4a92-ab3d-c3d32d65cc22"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["1cff944c-7210-4250-a6dd-dc9e04ea886c","26086730-1251-47d6-8b3a-594d4750a770","ef50fba3-3d7b-4cda-8ffe-f75741cdb229"],"otherInfo":{"data":{"name":"embeds","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"columns":[{"column":"embed_id","cid":"c87"}],"include":[],"cid":"c86"}],"foreign_key":[{"name":"guild_id","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"guild_id","referenced":"guild_id","references":"6aef958e-02cc-4170-b342-f32f56f6a8de","references_table_name":"(public) guild","cid":"c89"}],"confupdtype":"a","confdeltype":"a","cid":"c88"},{"name":"member_id","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"member_id","referenced":"member_id","references":"2e64c167-954d-42f5-94aa-9e82b036e3af","references_table_name":"(public) member","cid":"c143"}],"confupdtype":"a","confdeltype":"a","cid":"c97"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"embed_id","is_primary_key":true,"attnum":0,"cltype":"bigserial","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":true,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c90"},{"name":"guild_id","is_primary_key":false,"attnum":1,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c91"},{"name":"embed_json","is_primary_key":false,"attnum":2,"cltype":"json","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c92"},{"name":"member_id","is_primary_key":false,"attnum":3,"cltype":"bigint","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c93"},{"name":"created_at","is_primary_key":false,"attnum":4,"cltype":"timestamp with time zone","attlen":null,"attprecision":null,"collspcname":null,"attnotnull":false,"colconstype":"n","attidentity":"a","attoptions":[],"cid":"c94","min_val_attlen":0,"max_val_attlen":6}],"schema":"public"},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"c589480a-782e-4487-b8b8-4669d036c2b5":{"id":"c589480a-782e-4487-b8b8-4669d036c2b5","type":"table","selected":false,"x":607.5,"y":397.5,"ports":[],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":[],"otherInfo":{"data":{"columns":[],"name":"suggestions","coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[],"foreign_key":[],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"schema":"public"},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}