schema.pgerd

{"version":"50500","data":{"id":"3e8c59e4-9f0f-4a40-9377-b0c334e27f56","offsetX":185.43526131544976,"offsetY":129.55244699652815,"zoom":60.80468056797981,"gridSize":15,"layers":[{"id":"c534c983-efdc-497d-a601-6cd86ee33cb1","type":"diagram-links","isSvg":true,"transformed":true,"models":{"57fca961-4556-4265-9de6-021b267943b7":{"id":"57fca961-4556-4265-9de6-021b267943b7","locked":true,"type":"onetomany","source":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","sourcePort":"25a8ab8d-2fb1-403f-82ba-9cc0ad4d9583","target":"f8496b1a-49f9-4750-9fa2-0df459d4128c","targetPort":"f1c54bf9-67dd-4ced-8017-aefd2e119aad","points":[{"id":"918aeeb7-19ae-46ff-a996-8a3b59f2e814","type":"point","x":309,"y":-3},{"id":"31b44d68-836b-439d-9ad4-d32fa1efb1e2","type":"point","x":219,"y":336},{"id":"7e97dd7e-f5e5-4353-8e91-c2996664796e","type":"point","x":219,"y":621}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"f8496b1a-49f9-4750-9fa2-0df459d4128c","local_column_attnum":7,"referenced_table_uid":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","referenced_column_attnum":1}},"bfbf5b6a-96cf-467d-a270-f1cf4141e2eb":{"id":"bfbf5b6a-96cf-467d-a270-f1cf4141e2eb","locked":true,"type":"onetomany","source":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","sourcePort":"25a8ab8d-2fb1-403f-82ba-9cc0ad4d9583","target":"f8496b1a-49f9-4750-9fa2-0df459d4128c","targetPort":"b74e37b1-2149-46ef-8fea-861ed4f7c64f","points":[{"id":"070c66ca-9147-4f1b-a05b-5e68f5ef1a4e","type":"point","x":309,"y":-3},{"id":"4ba20496-842c-47d6-bc64-7b7deccdcfa0","type":"point","x":219,"y":336},{"id":"c07f3172-5cb7-45b0-9b6e-f24f753b3bbb","type":"point","x":219,"y":592}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"f8496b1a-49f9-4750-9fa2-0df459d4128c","local_column_attnum":6,"referenced_table_uid":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","referenced_column_attnum":1}},"278f8456-d393-40de-a4ca-cb6077538905":{"id":"278f8456-d393-40de-a4ca-cb6077538905","locked":true,"type":"onetomany","source":"1d63315a-87c2-4508-ac68-8962d4627a33","sourcePort":"0383ef08-bc16-4311-83c5-f37a684ef075","target":"f8496b1a-49f9-4750-9fa2-0df459d4128c","targetPort":"d6a4ed3f-ccb5-48dc-a044-c28973011f1a","points":[{"id":"0484d47f-f72d-4a13-8deb-1f5a6eb1db94","type":"point","x":54,"y":102},{"id":"045e91e2-411f-4a70-bd44-bda4bef84f33","type":"point","x":219,"y":336},{"id":"220cf16e-e2d2-4867-8689-4a2876f1e3ca","type":"point","x":219,"y":964}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"f8496b1a-49f9-4750-9fa2-0df459d4128c","local_column_attnum":18,"referenced_table_uid":"1d63315a-87c2-4508-ac68-8962d4627a33","referenced_column_attnum":1}},"c07ce6ca-8d52-4ea6-be07-930ff3d3cd75":{"id":"c07ce6ca-8d52-4ea6-be07-930ff3d3cd75","locked":true,"type":"onetomany","selected":false,"source":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","sourcePort":"25a8ab8d-2fb1-403f-82ba-9cc0ad4d9583","target":"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb","targetPort":"ed227775-aa7d-46b0-ae15-4cd287346451","points":[{"id":"d190c25b-e195-413f-8267-3148491d950a","type":"point","x":309,"y":-3},{"id":"305ba905-983e-41f9-a42c-eaad0407e48d","type":"point","x":309,"y":-1.8850473118540527},{"id":"0f1096c8-b2dd-48ea-9052-1083c81806a0","type":"point","x":339.71848343748843,"y":-149.89996846480665},{"id":"48339841-858a-447b-9d8a-5083f0a5b2f8","type":"point","x":909,"y":-149.89996846480665},{"id":"9b34737f-5c29-43a9-9515-a44e9eac89c2","type":"point","x":909,"y":11}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb","local_column_attnum":2,"referenced_table_uid":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","referenced_column_attnum":1}},"7e5be695-e909-4ba7-84d8-31ae65d3d393":{"id":"7e5be695-e909-4ba7-84d8-31ae65d3d393","locked":true,"type":"onetomany","selected":false,"source":"b8851f9b-c87c-4a48-a853-02b0445b815d","sourcePort":"9a78801c-ba74-4754-83e9-cf5cae90436f","target":"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb","targetPort":"a345afea-924e-484c-a105-30579e6b0abd","points":[{"id":"95a2e289-1ae3-4755-b5da-ed6cfebbc1b8","type":"point","x":1119,"y":717},{"id":"e2bf3e3d-418e-4feb-8b1b-a6ab44dbe43a","type":"point","x":1119,"y":336},{"id":"0703d2bf-4edb-4767-a6c6-5b20bb47001c","type":"point","x":1122.5529553131043,"y":156},{"id":"054f2967-783d-4be8-a7fa-883369a34efb","type":"point","x":909,"y":156}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb","local_column_attnum":7,"referenced_table_uid":"b8851f9b-c87c-4a48-a853-02b0445b815d","referenced_column_attnum":1}}}},{"id":"cd4dba5d-74ff-4e49-a3a5-5eb52ec55965","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e":{"id":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","type":"table","selected":false,"x":105,"y":-105,"ports":[{"id":"25a8ab8d-2fb1-403f-82ba-9cc0ad4d9583","type":"onetomany","x":279,"y":-3,"name":"coll-port-1","alignment":"right","parentNode":"6a0f4aa2-d222-4bc2-9f77-164dd56bcc4e","links":["57fca961-4556-4265-9de6-021b267943b7","bfbf5b6a-96cf-467d-a270-f1cf4141e2eb","c07ce6ca-8d52-4ea6-be07-930ff3d3cd75"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["25a8ab8d-2fb1-403f-82ba-9cc0ad4d9583"],"otherInfo":{"data":{"columns":[{"name":"country","description":null,"attnum":1,"cltype":"text","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"coach","description":null,"attnum":2,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null}],"name":"country","schema":"public","description":null,"primary_key":[{"columns":[{"column":"country"}]}]},"note":""}},"f8496b1a-49f9-4750-9fa2-0df459d4128c":{"id":"f8496b1a-49f9-4750-9fa2-0df459d4128c","type":"table","selected":false,"x":15,"y":345,"ports":[{"id":"f1c54bf9-67dd-4ced-8017-aefd2e119aad","type":"onetomany","x":189,"y":621,"name":"coll-port-7","alignment":"right","parentNode":"f8496b1a-49f9-4750-9fa2-0df459d4128c","links":["57fca961-4556-4265-9de6-021b267943b7"],"subtype":"many"},{"id":"b74e37b1-2149-46ef-8fea-861ed4f7c64f","type":"onetomany","x":189,"y":592,"name":"coll-port-6","alignment":"right","parentNode":"f8496b1a-49f9-4750-9fa2-0df459d4128c","links":["bfbf5b6a-96cf-467d-a270-f1cf4141e2eb"],"subtype":"many"},{"id":"d6a4ed3f-ccb5-48dc-a044-c28973011f1a","type":"onetomany","x":189,"y":964,"name":"coll-port-18","alignment":"right","parentNode":"f8496b1a-49f9-4750-9fa2-0df459d4128c","links":["278f8456-d393-40de-a4ca-cb6077538905"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["f1c54bf9-67dd-4ced-8017-aefd2e119aad","b74e37b1-2149-46ef-8fea-861ed4f7c64f","d6a4ed3f-ccb5-48dc-a044-c28973011f1a"],"otherInfo":{"data":{"columns":[{"name":"stage","description":null,"attnum":1,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"date","description":null,"attnum":2,"cltype":"date","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"pens","description":null,"attnum":3,"cltype":"boolean","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"pens_home_score","description":null,"attnum":4,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"pens_away_score","description":null,"attnum":5,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"team_name_home","description":null,"attnum":6,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"team_name_away","description":null,"attnum":7,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"team_home_score","description":null,"attnum":8,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"team_away_score","description":null,"attnum":9,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"possession_home","description":null,"attnum":10,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"possession_away","description":null,"attnum":11,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"total_shots_home","description":null,"attnum":12,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"total_shots_away","description":null,"attnum":13,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"shots_on_target_home","description":null,"attnum":14,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"shots_on_target_away","description":null,"attnum":15,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"duels_won_home","description":null,"attnum":16,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"duels_won_away","description":null,"attnum":17,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"venue_id","description":null,"attnum":18,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"match_id","description":null,"attnum":19,"cltype":"bigint","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null}],"name":"match","schema":"public","description":null,"primary_key":[{"columns":[{"column":"match_id"}]}]},"note":""}},"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb":{"id":"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb","type":"table","selected":false,"x":705,"y":-120,"ports":[{"id":"ed227775-aa7d-46b0-ae15-4cd287346451","type":"onetomany","x":879,"y":11,"name":"coll-port-2","alignment":"right","parentNode":"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb","links":["c07ce6ca-8d52-4ea6-be07-930ff3d3cd75"],"subtype":"many"},{"id":"a345afea-924e-484c-a105-30579e6b0abd","type":"onetomany","x":879,"y":156,"name":"coll-port-7","alignment":"right","parentNode":"dda6b62a-16c7-4d00-a0a6-d9c0c164aceb","links":["7e5be695-e909-4ba7-84d8-31ae65d3d393"],"subtype":"many"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["ed227775-aa7d-46b0-ae15-4cd287346451","a345afea-924e-484c-a105-30579e6b0abd"],"otherInfo":{"data":{"columns":[{"name":"player_id","description":null,"attnum":1,"cltype":"bigint","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"country_id","description":null,"attnum":2,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"name","description":null,"attnum":3,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"age","description":null,"attnum":4,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"club","description":null,"attnum":5,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"squad_number","description":null,"attnum":6,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"position","description":null,"attnum":7,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"picture","description":null,"attnum":8,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"matches","description":null,"attnum":9,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"minutes","description":null,"attnum":10,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"yellow_cards","description":null,"attnum":11,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"red_cards","description":null,"attnum":12,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"passing_acc_perc","description":null,"attnum":13,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"goals","description":null,"attnum":14,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"fouls_comm","description":null,"attnum":15,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"fouls_suff","description":null,"attnum":16,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"attempts","description":null,"attnum":17,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"attempts_on_target","description":null,"attnum":18,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"assists","description":null,"attnum":19,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"speed_km_h","description":null,"attnum":20,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"tackles","description":null,"attnum":21,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"balls_recovered","description":null,"attnum":22,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"distance_covered_km","description":null,"attnum":23,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"clearances","description":null,"attnum":24,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"blocks","description":null,"attnum":25,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"saves","description":null,"attnum":26,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"goals_conceded","description":null,"attnum":27,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"claims","description":null,"attnum":28,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"punches","description":null,"attnum":29,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"clean_sheets","description":null,"attnum":30,"cltype":"double precision","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null}],"name":"player","schema":"public","description":null,"primary_key":[{"columns":[{"column":"player_id"}]}]},"note":""}},"b8851f9b-c87c-4a48-a853-02b0445b815d":{"id":"b8851f9b-c87c-4a48-a853-02b0445b815d","type":"table","selected":false,"x":915,"y":615,"ports":[{"id":"9a78801c-ba74-4754-83e9-cf5cae90436f","type":"onetomany","x":1089,"y":717,"name":"coll-port-1","alignment":"right","parentNode":"b8851f9b-c87c-4a48-a853-02b0445b815d","links":["7e5be695-e909-4ba7-84d8-31ae65d3d393"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["9a78801c-ba74-4754-83e9-cf5cae90436f"],"otherInfo":{"data":{"columns":[{"name":"position_id","description":null,"attnum":1,"cltype":"text","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"position","description":null,"attnum":2,"cltype":"text","is_primary_key":false,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null}],"name":"position","schema":"public","description":null,"primary_key":[{"columns":[{"column":"position_id"}]}]},"note":""}},"1b43d3a6-e59b-4203-a778-d0c695fd14bd":{"id":"1b43d3a6-e59b-4203-a778-d0c695fd14bd","type":"table","selected":false,"x":390,"y":225,"ports":[],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":[],"otherInfo":{"data":{"columns":[{"name":"srid","description":null,"attnum":1,"cltype":"integer","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"auth_name","description":null,"attnum":2,"cltype":"character varying","is_primary_key":false,"attnotnull":false,"attlen":"256","attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"auth_srid","description":null,"attnum":3,"cltype":"integer","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"srtext","description":null,"attnum":4,"cltype":"character varying","is_primary_key":false,"attnotnull":false,"attlen":"2048","attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"proj4text","description":null,"attnum":5,"cltype":"character varying","is_primary_key":false,"attnotnull":false,"attlen":"2048","attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null}],"name":"spatial_ref_sys","schema":"public","description":null,"primary_key":[{"columns":[{"column":"srid"}]}]},"note":""}},"1d63315a-87c2-4508-ac68-8962d4627a33":{"id":"1d63315a-87c2-4508-ac68-8962d4627a33","type":"table","selected":false,"x":-150,"y":0,"ports":[{"id":"0383ef08-bc16-4311-83c5-f37a684ef075","type":"onetomany","x":24,"y":102,"name":"coll-port-1","alignment":"right","parentNode":"1d63315a-87c2-4508-ac68-8962d4627a33","links":["278f8456-d393-40de-a4ca-cb6077538905"],"subtype":"one"}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["0383ef08-bc16-4311-83c5-f37a684ef075"],"otherInfo":{"data":{"columns":[{"name":"venue_id","description":null,"attnum":1,"cltype":"text","is_primary_key":true,"attnotnull":true,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"name","description":null,"attnum":2,"cltype":"character varying","is_primary_key":false,"attnotnull":false,"attlen":"50","attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"capacity","description":null,"attnum":3,"cltype":"bigint","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"geom","description":null,"attnum":4,"cltype":"geometry","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"city","description":null,"attnum":5,"cltype":"character varying","is_primary_key":false,"attnotnull":false,"attlen":"50","attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"country","description":null,"attnum":6,"cltype":"character varying","is_primary_key":false,"attnotnull":false,"attlen":"50","attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null},{"name":"picture","description":null,"attnum":7,"cltype":"text","is_primary_key":false,"attnotnull":false,"attlen":null,"attprecision":null,"attidentity":"","colconstype":"n","seqincrement":null,"seqstart":null,"seqmin":null,"seqmax":null,"seqcache":null,"seqcycle":null}],"name":"venue","schema":"public","description":null,"primary_key":[{"columns":[{"column":"venue_id"}]}]},"note":""}}}}]}}