{"contentType":"application/gliffy+json","version":"1.1","metadata":{"title":"untitled","revision":0,"exportBorder":false,"loadPosition":"default","libraries":["com.gliffy.libraries.erd.erd_v1.default","com.gliffy.libraries.uml.uml_v2.class","com.gliffy.libraries.uml.uml_v2.sequence","com.gliffy.libraries.uml.uml_v2.activity","com.gliffy.libraries.uml.uml_v2.state_machine","com.gliffy.libraries.uml.uml_v2.deployment","com.gliffy.libraries.uml.uml_v2.component","com.gliffy.libraries.uml.uml_v2.use_case","com.gliffy.libraries.basic.basic_v1.default","com.gliffy.libraries.images"],"lastSerialized":1473936111718,"analyticsProduct":"Confluence"},"embeddedResources":{"index":0,"resources":[]},"stage":{"objects":[{"x":1330,"y":460,"rotation":0,"id":181,"uid":"com.gliffy.shape.erd.erd_v1.default.one","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":128,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":12,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-1010,68],[-1010,95],[-262,95],[-262,55]],"lockSegments":{"1":true}}},"children":null,"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":0.5,"py":1}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":163,"px":0.5,"py":1}}},"linkMap":[]},{"x":30,"y":10,"rotation":0,"id":52,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":120,"lockAspectRatio":false,"lockShape":false,"order":41,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":53,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":42,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":54,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":43,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Fees

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":54}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":55,"uid":null,"width":120,"height":102,"lockAspectRatio":false,"lockShape":false,"order":44,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":56,"uid":null,"width":120,"height":102,"lockAspectRatio":false,"lockShape":false,"order":45,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

* availability:int

* availability_unit:int

* price:float

* currency:varchar

o is_mandatory:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":52},{"magnitude":-1,"id":53}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":53,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":53},{"magnitude":1,"id":56}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":196,"y":-65.5,"rotation":0,"id":64,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":51,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-46,123.5],[-39.61207736775441,123.5],[-33.22415473550882,123.5],[-26.836232103263228,123.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":52,"px":1,"py":0.4}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":58,"px":0,"py":0.5}}},"linkMap":[]},{"x":235,"y":170,"rotation":0,"id":0,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":169.99999999999994,"height":358,"lockAspectRatio":false,"lockShape":false,"order":0,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":1,"uid":null,"width":169.99999999999994,"height":18,"lockAspectRatio":false,"lockShape":false,"order":1,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":2,"uid":null,"width":169.99999999999994,"height":18,"lockAspectRatio":false,"lockShape":false,"order":2,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Users

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":2}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":3,"uid":null,"width":169.99999999999994,"height":340,"lockAspectRatio":false,"lockShape":false,"order":3,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":4,"uid":null,"width":169.99999999999994,"height":340,"lockAspectRatio":false,"lockShape":false,"order":4,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

o internal_email:varchar\n

o oauth_token:varchar\n

o oauth_expiration:timestamp\n

* contact_email:varchar\n

* first_name:varchar\n

* last_name:varchar\n

* date_of_birth:timestamp\n

* gender:int\n

* university:varchar\n

* studies_type_id:int\n

* study_field_id:int\n

o phone:varchar\n

o address:varchar\n

o city:varchar\n

o zipcode:varchar\n

o other:text\n

o is_superadmin:int\n

o is_suspended:int\n

o password:varchar\n

o activated_at:timestamp\n

o suspended_reason:varchar\n

o seo_url:varchar\n

o email_hash:varchar

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":0},{"magnitude":-1,"id":1}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":1,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":1},{"magnitude":1,"id":4}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":519,"y":292.5,"rotation":0,"id":16,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":15,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[31,-139],[31,-120.16666666666666],[31,-101.33333333333334],[31,-82.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":38,"px":0.5,"py":1}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":5,"px":0.5,"py":0}}},"linkMap":[]},{"x":533,"y":302.5,"rotation":0,"id":31,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":27,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-63,142.5],[-84.71111828723645,142.5],[-106.42223657447295,142.5],[-128.1333548617094,142.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":20,"px":0,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":0,"px":1,"py":0.7797927461139896}}},"linkMap":[]},{"x":863,"y":367.5,"rotation":0,"id":32,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":28,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-393,137.5],[-414.6669661728115,137.5],[-436.333932345623,137.5],[-458.0008985184345,137.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":25,"px":0,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":0,"px":1,"py":0.9367088607594937}}},"linkMap":[]},{"x":470,"y":33.5,"rotation":0,"id":38,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":120,"lockAspectRatio":false,"lockShape":false,"order":29,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":39,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":30,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":40,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":31,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Body_memberships

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":40}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":41,"uid":null,"width":160,"height":102,"lockAspectRatio":false,"lockShape":false,"order":32,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":42,"uid":null,"width":160,"height":102,"lockAspectRatio":false,"lockShape":false,"order":33,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* user_id:int\n

* body_id:int\n

o organizational_unit:int\n

o status:int\n

* start_date:timestamp\n

o end_date:timestamp

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":38},{"magnitude":-1,"id":39}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":39,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":39},{"magnitude":1,"id":42}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":680,"y":47.5,"rotation":0,"id":45,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":140,"height":92,"lockAspectRatio":false,"lockShape":false,"order":34,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":46,"uid":null,"width":140,"height":18,"lockAspectRatio":false,"lockShape":false,"order":35,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":47,"uid":null,"width":140,"height":18,"lockAspectRatio":false,"lockShape":false,"order":36,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Organizational_roles

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":47}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":48,"uid":null,"width":140,"height":74,"lockAspectRatio":false,"lockShape":false,"order":37,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":49,"uid":null,"width":140,"height":74,"lockAspectRatio":false,"lockShape":false,"order":38,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* name:varchar\n

o body_id:int\n

o is_internal:int\n

o is_admin:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":45},{"magnitude":-1,"id":46}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":46,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":46},{"magnitude":1,"id":49}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":459,"y":312.5,"rotation":0,"id":50,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":39,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[221,-219],[204.33333333333337,-219],[187.66666666666663,-219],[171,-219]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":45,"px":0,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":38,"px":1,"py":0.5}}},"linkMap":[]},{"x":174.99999999999997,"y":-8.5,"rotation":0,"id":51,"uid":"com.gliffy.shape.erd.erd_v1.default.zero_many_optional","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":40,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":9,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[229.99999999999997,283.35577233521593],[262.5,283.35577233521593],[262.5,126.85281374238569],[295,126.85281374238569]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":1,"py":0.29289321881345237}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":38,"px":0,"py":0.7071067811865475}}},"linkMap":[]},{"x":168.99999999999997,"y":13,"rotation":0,"id":58,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":170,"height":95,"lockAspectRatio":false,"lockShape":false,"order":46,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":59,"uid":null,"width":170,"height":18,"lockAspectRatio":false,"lockShape":false,"order":47,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":60,"uid":null,"width":170,"height":18,"lockAspectRatio":false,"lockShape":false,"order":48,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Fee_users

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":60}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":61,"uid":null,"width":170,"height":77,"lockAspectRatio":false,"lockShape":false,"order":49,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":62,"uid":null,"width":170,"height":74,"lockAspectRatio":false,"lockShape":false,"order":50,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* fee_id:int

* user_id:int

* date_paid:timestamp

o expiration_date:timestamp

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":58},{"magnitude":-1,"id":59}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":59,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":59},{"magnitude":1,"id":62}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":170.99999999999997,"y":-55.5,"rotation":0,"id":65,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":52,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[149.00000000000003,225.5],[149.00000000000003,194.5],[83,194.5],[83,163.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":0.5,"py":0}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":58,"px":0.5,"py":1}}},"linkMap":[]},{"x":873,"y":387.5,"rotation":0,"id":104,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":84,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-588.2081528017131,140.5],[-588.2081528017131,157.23842178692757],[-588.2081528017131,173.97684357385504],[-588.2081528017131,190.7152653607826]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":0.29289321881345254,"py":0.9999999999999998}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":90,"px":0.2928932188134524,"py":0}}},"linkMap":[]},{"x":854,"y":407.5,"rotation":0,"id":105,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":85,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-709,202],[-675.6662500026041,202],[-642.3325000052082,202],[-608.9987500078124,202]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":85,"px":1,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":90,"px":0,"py":0.5}}},"linkMap":[]},{"x":490,"y":210,"rotation":0,"id":5,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":120,"lockAspectRatio":false,"lockShape":false,"order":5,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":6,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":6,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":7,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":7,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Bodies

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":7}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":8,"uid":null,"width":120,"height":102,"lockAspectRatio":false,"lockShape":false,"order":8,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":9,"uid":null,"width":120,"height":102,"lockAspectRatio":false,"lockShape":false,"order":9,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* name:varchar\n

* type_id:int\n

* email:varchar\n

o city:varchar\n

o country_id:int\n

o description:text

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":5},{"magnitude":-1,"id":6}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":6,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":6},{"magnitude":1,"id":9}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":490,"y":358,"rotation":0,"id":10,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":50,"lockAspectRatio":false,"lockShape":false,"order":10,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":11,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":11,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":12,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":12,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Countries

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":12}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":13,"uid":null,"width":120,"height":32,"lockAspectRatio":false,"lockShape":false,"order":13,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":14,"uid":null,"width":120,"height":32,"lockAspectRatio":false,"lockShape":false,"order":14,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":10},{"magnitude":-1,"id":11}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":11,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":11},{"magnitude":1,"id":14}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":833,"y":265.5,"rotation":0,"id":18,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":16,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-283,92.5],[-283,83.16666666666669],[-283,73.83333333333331],[-283,64.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":10,"px":0.5,"py":0}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":5,"px":0.5,"py":1}}},"linkMap":[]},{"x":470,"y":420,"rotation":0,"id":20,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":50,"lockAspectRatio":false,"lockShape":false,"order":17,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":21,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":18,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":22,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":19,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Study_types

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":22}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":23,"uid":null,"width":120,"height":32,"lockAspectRatio":false,"lockShape":false,"order":20,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":24,"uid":null,"width":120,"height":32,"lockAspectRatio":false,"lockShape":false,"order":21,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":20},{"magnitude":-1,"id":21}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":21,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":21},{"magnitude":1,"id":24}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":470,"y":480,"rotation":0,"id":25,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":50,"lockAspectRatio":false,"lockShape":false,"order":22,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":26,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":23,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":27,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":24,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Study_fields

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":27}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":28,"uid":null,"width":120,"height":32,"lockAspectRatio":false,"lockShape":false,"order":25,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":29,"uid":null,"width":120,"height":32,"lockAspectRatio":false,"lockShape":false,"order":26,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":25},{"magnitude":-1,"id":26}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":26,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":26},{"magnitude":1,"id":29}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":883,"y":427.5,"rotation":0,"id":106,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":86,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-795.5,228],[-795.5,235.9197362470112],[-795.5,243.8394724940223],[-795.5,251.7592087410335]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":85,"px":0.5,"py":1}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":97,"px":0.38571428571428573,"py":0}}},"linkMap":[]},{"x":953,"y":417.5,"rotation":0,"id":107,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":87,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-722.99166724529,300.5],[-742.9944448301933,300.5],[-762.9972224150966,300.5],[-783,300.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":77,"px":0,"py":0.3333333333333333}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":97,"px":1,"py":0.5}}},"linkMap":[]},{"x":1238,"y":326,"rotation":0,"id":129,"uid":"com.gliffy.shape.erd.erd_v1.default.many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":102,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":14,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-688,461],[-688,501],[-468,501],[-468,461]],"lockSegments":{}}},"children":null,"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":72,"px":0.5,"py":1}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":122,"px":0.5,"py":1}}},"linkMap":[]},{"x":529,"y":302.5,"rotation":0,"id":173,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":123,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[80.94682558357965,-36.75230867899734],[137.63121705571973,-36.75230867899734],[194.31560852785992,-36.75230867899734],[251,-36.75230867899734]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":5,"px":1,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":155,"px":1.1102230246251563e-16,"py":0.2928932188134525}}},"linkMap":[]},{"x":543,"y":312.5,"rotation":0,"id":176,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":126,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[47,132.5],[298,132.5],[298,65.5],[445,65.5]],"lockSegments":{"1":true}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":20,"px":1,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":163,"px":0,"py":0.5}}},"linkMap":[]},{"x":553,"y":322.5,"rotation":0,"id":177,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":127,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[37,182.5],[309,182.5],[309,112.247258045114],[435,112.247258045114]],"lockSegments":{"1":true}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":25,"px":1,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":163,"px":0,"py":0.7071067811865475}}},"linkMap":[]},{"x":1010,"y":599,"rotation":0,"id":116,"uid":"com.gliffy.shape.basic.basic_v1.default.rectangle","width":409.99999999999994,"height":122,"lockAspectRatio":false,"lockShape":false,"order":94,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#ffffff","gradient":false,"dropShadow":false,"state":0,"shadowX":0,"shadowY":0,"opacity":1}},"children":[],"linkMap":[]},{"x":1020,"y":611,"rotation":0,"id":114,"uid":"com.gliffy.shape.basic.basic_v1.default.text","width":380,"height":98,"lockAspectRatio":false,"lockShape":false,"order":95,"graphic":{"type":"Text","Text":{"tid":null,"valign":"middle","overflow":"none","vposition":"none","hposition":"none","html":"

Explanation:

# &#;61 primary key

* = mandatory field

o = optional field

 

All tables also contain the created_at and updated_at fields

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[],"linkMap":[]},{"x":1188,"y":318,"rotation":0,"id":128,"uid":"com.gliffy.shape.erd.erd_v1.default.many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":101,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":14,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-558,416],[-538,416],[-518,416],[-498,416]],"lockSegments":{}}},"children":null,"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":72,"px":1,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":122,"px":0,"py":0.5}}},"linkMap":[]},{"x":30,"y":159.5,"rotation":0,"id":188,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":78,"lockAspectRatio":false,"lockShape":false,"order":138,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":189,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":134,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":190,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":135,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

News

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":190}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":191,"uid":null,"width":120,"height":60,"lockAspectRatio":false,"lockShape":false,"order":136,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":192,"uid":null,"width":120,"height":60,"lockAspectRatio":false,"lockShape":false,"order":137,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* title:varchar\n

* content:text\n

* user_id:int\n

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":188},{"magnitude":-1,"id":189}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":189,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":189},{"magnitude":1,"id":192}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":690,"y":681,"rotation":0,"id":122,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":106,"lockAspectRatio":false,"lockShape":false,"order":96,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":123,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":97,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":124,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":98,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Proxy_requests

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":124}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":125,"uid":null,"width":160,"height":88,"lockAspectRatio":false,"lockShape":false,"order":99,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":126,"uid":null,"width":160,"height":88,"lockAspectRatio":false,"lockShape":false,"order":100,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* from_module_id:int

* to_module_id:int

* to_url:string

* request:text

* response:text

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":122},{"magnitude":-1,"id":123}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":123,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":123},{"magnitude":1,"id":126}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":30,"y":679,"rotation":0,"id":97,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":140,"height":78,"lockAspectRatio":false,"lockShape":false,"order":79,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":98,"uid":null,"width":140,"height":18,"lockAspectRatio":false,"lockShape":false,"order":80,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":99,"uid":null,"width":140,"height":18,"lockAspectRatio":false,"lockShape":false,"order":81,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Role_module_pages

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":99}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":100,"uid":null,"width":140,"height":60,"lockAspectRatio":false,"lockShape":false,"order":82,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":101,"uid":null,"width":140,"height":60,"lockAspectRatio":false,"lockShape":false,"order":83,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* module_page_id:int

* role_id:int

o permission_level:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":97},{"magnitude":-1,"id":98}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":98,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":98},{"magnitude":1,"id":101}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":471,"y":774,"rotation":0,"id":82,"uid":"com.gliffy.shape.erd.erd_v1.default.many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":68,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":14,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-0.8004975155164402,-44],[-14.200331677010979,-44],[-27.60016583850546,-44],[-41,-44]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":72,"px":0,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":77,"px":1,"py":0.425}}},"linkMap":[]},{"x":230,"y":679,"rotation":0,"id":77,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":200,"height":120,"lockAspectRatio":false,"lockShape":false,"order":63,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":78,"uid":null,"width":200,"height":18,"lockAspectRatio":false,"lockShape":false,"order":64,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":79,"uid":null,"width":200,"height":18,"lockAspectRatio":false,"lockShape":false,"order":65,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Module_pages

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":79}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":80,"uid":null,"width":200,"height":102,"lockAspectRatio":false,"lockShape":false,"order":66,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":81,"uid":null,"width":200,"height":102,"lockAspectRatio":false,"lockShape":false,"order":67,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

o module_id:int

* name:varchar

* code:varchar

* module_link:varchar

o icon:varchar

o is_active:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":77},{"magnitude":-1,"id":78}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":78,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":78},{"magnitude":1,"id":81}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":470,"y":681,"rotation":0,"id":72,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":106,"lockAspectRatio":false,"lockShape":false,"order":58,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":73,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":59,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":74,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":60,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Modules

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":74}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":75,"uid":null,"width":160,"height":88,"lockAspectRatio":false,"lockShape":false,"order":61,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":76,"uid":null,"width":160,"height":88,"lockAspectRatio":false,"lockShape":false,"order":62,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

* code:varchar

* handshake_token:varchar

* base_url:varchar

o is_active:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":72},{"magnitude":-1,"id":73}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":73,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":73},{"magnitude":1,"id":76}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":216,"y":67,"rotation":0,"id":115,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":93,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[19,356.144227664784],[-8.5,356.144227664784],[-8.5,402],[-36,402]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":0,"py":0.7071067811865475}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":109,"px":1,"py":0.5}}},"linkMap":[]},{"x":20,"y":402,"rotation":0,"id":109,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":134,"lockAspectRatio":false,"lockShape":false,"order":88,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":110,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":89,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":111,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":90,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Auths

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":111}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":112,"uid":null,"width":160,"height":116,"lockAspectRatio":false,"lockShape":false,"order":91,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":113,"uid":null,"width":160,"height":116,"lockAspectRatio":false,"lockShape":false,"order":92,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* ip:varchar

* user_agent:varchar

* raw_request_params:text

o token_generated:varchar

o user_id:int

o successful:int

o expiration:timestamp

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":109},{"magnitude":-1,"id":110}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":110,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":110},{"magnitude":1,"id":113}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":245,"y":578,"rotation":0,"id":90,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":64,"lockAspectRatio":false,"lockShape":false,"order":74,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":91,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":75,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":92,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":76,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

 User_roles

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":92}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":93,"uid":null,"width":120,"height":46,"lockAspectRatio":false,"lockShape":false,"order":77,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":94,"uid":null,"width":120,"height":46,"lockAspectRatio":false,"lockShape":false,"order":78,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* role_id:int

* user_id:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":90},{"magnitude":-1,"id":91}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":91,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":91},{"magnitude":1,"id":94}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":30,"y":563.5,"rotation":0,"id":85,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":115,"height":92,"lockAspectRatio":false,"lockShape":false,"order":69,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":86,"uid":null,"width":115,"height":18,"lockAspectRatio":false,"lockShape":false,"order":70,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":87,"uid":null,"width":115,"height":18,"lockAspectRatio":false,"lockShape":false,"order":71,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Roles

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":87}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":88,"uid":null,"width":115,"height":74,"lockAspectRatio":false,"lockShape":false,"order":72,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":89,"uid":null,"width":115,"height":74,"lockAspectRatio":false,"lockShape":false,"order":73,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

o code:varchar

o system_role:int

o is_disabled:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":85},{"magnitude":-1,"id":86}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":86,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":86},{"magnitude":1,"id":89}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":220,"y":83,"rotation":0,"id":195,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":139,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[15.000000000000028,191.855772335216],[-27.5,191.855772335216],[-27.5,115.5],[-70,115.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":1.1102230246251563e-16,"py":0.2928932188134525}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":188,"px":1,"py":0.5}}},"linkMap":[]},{"x":30,"y":263,"rotation":0,"id":196,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":123,"lockAspectRatio":false,"lockShape":false,"order":144,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":197,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":140,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":198,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":141,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Notifications

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":198}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":199,"uid":null,"width":120,"height":105,"lockAspectRatio":false,"lockShape":false,"order":142,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":200,"uid":null,"width":120,"height":102,"lockAspectRatio":false,"lockShape":false,"order":143,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* title:varchar\n

* text:varchar\n

* user_id:integer\n

o link:text\n

o picture_link:text\n

o is_read:integer

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":196},{"magnitude":-1,"id":197}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":197,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":197},{"magnitude":1,"id":200}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":230,"y":93,"rotation":0,"id":201,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":145,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[5,256],[-37.5,256],[-37.5,231.5],[-80,231.5]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":0,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":196,"px":1,"py":0.5}}},"linkMap":[]},{"x":632,"y":359.75,"rotation":0,"id":202,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":52.5,"lockAspectRatio":false,"lockShape":false,"order":150,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":203,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":146,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":204,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":147,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Types

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":204}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":205,"uid":null,"width":120,"height":34.5,"lockAspectRatio":false,"lockShape":false,"order":148,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":206,"uid":null,"width":120,"height":32,"lockAspectRatio":false,"lockShape":false,"order":149,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* name:varchar

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":202},{"magnitude":-1,"id":203}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":203,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":203},{"magnitude":1,"id":206}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":843,"y":275.5,"rotation":0,"id":207,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":151,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-151,84.25],[-151,19.352813742385706],[-233,19.352813742385706]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":202,"px":0.5,"py":0}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":5,"px":0.9999999999999998,"py":0.7071067811865475}}},"linkMap":[]},{"x":898,"y":75.5,"rotation":0,"id":208,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":120,"lockAspectRatio":false,"lockShape":false,"order":156,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":209,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":152,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":210,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":153,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Forums

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":210}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":211,"uid":null,"width":160,"height":102,"lockAspectRatio":false,"lockShape":false,"order":154,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":212,"uid":null,"width":160,"height":102,"lockAspectRatio":false,"lockShape":false,"order":155,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* topic:varchar\n

* content:text\n

* user_id:int\n

o body_id:int\n

o organizational_unit:int\n

o admin_only:int\n

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":208},{"magnitude":-1,"id":209}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":209,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":209},{"magnitude":1,"id":212}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":469,"y":322.5,"rotation":0,"id":213,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":157,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[351,-229],[390,-229],[390,-187],[429,-187]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":45,"px":1,"py":0.5}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":208,"px":0,"py":0.5}}},"linkMap":[]},{"x":479,"y":332.5,"rotation":0,"id":214,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":158,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[419,-172.1471862576143],[275,-172.1471862576143],[275,-87.3528137423857],[131,-87.3528137423857]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":208,"px":0,"py":0.7071067811865475}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":5,"px":1,"py":0.29289321881345237}}},"linkMap":[]},{"x":1312,"y":425.75,"rotation":0,"id":175,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":125,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-164.05089825416917,6.504833995939123],[-143.7005988361127,6.504833995939123],[-123.35029941805647,6.504833995939066],[-103,6.504833995939066]],"lockSegments":{}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":163,"px":0.9999999999999998,"py":0.7071067811865475}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":168,"px":0,"py":0.7071067811865475}}},"linkMap":[]},{"x":856,"y":435.75,"rotation":0,"id":174,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":124,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[84,-114.49769132100266],[100.00000000065188,-114.49769132100266],[116.00000000130365,-114.49769132100266],[132.00000000195553,-114.49769132100266]],"lockSegments":{}}},"children":null,"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":155,"px":0.9999999999999998,"py":0.7071067811865475}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":163,"px":1.1102230246251563e-16,"py":0.2928932188134525}}},"linkMap":[]},{"x":988,"y":241,"rotation":0,"id":163,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":274,"lockAspectRatio":false,"lockShape":false,"order":113,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":164,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":114,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":165,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":115,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Recruted_users

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":165}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":166,"uid":null,"width":160,"height":256,"lockAspectRatio":false,"lockShape":false,"order":116,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":167,"uid":null,"width":160,"height":256,"lockAspectRatio":false,"lockShape":false,"order":117,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* campaign_id:int

* first_name:varchar

* last_name:varchar

* date_of_birth:timestamp

* gender:int

* university:varchar

* studies_type_id:int

* study_field_id:int

* email:varchar

* email_hash:varchar

o phone:varchar

o address:varchar

o city:varchar

o zipcode:varchar

o status:int

o user_id_created:id

o custom_responses:text

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":163},{"magnitude":-1,"id":164}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":164,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":164},{"magnitude":1,"id":167}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":780,"y":226.5,"rotation":0,"id":155,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":134,"lockAspectRatio":false,"lockShape":false,"order":108,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":156,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":109,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":157,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":110,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Recrutement_campaigns

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":157}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":158,"uid":null,"width":160,"height":116,"lockAspectRatio":false,"lockShape":false,"order":111,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":159,"uid":null,"width":160,"height":116,"lockAspectRatio":false,"lockShape":false,"order":112,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* antenna_id:int\n

o is_public:int\n

o requires_validation:int\n

o start_date:timestamp\n

o end_date:timestamp\n

o link:varchar\n

o custom_fields:text

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":155},{"magnitude":-1,"id":156}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":156,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":156},{"magnitude":1,"id":159}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":1209,"y":387,"rotation":0,"id":168,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":160,"height":64,"lockAspectRatio":false,"lockShape":false,"order":118,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":169,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":119,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":170,"uid":null,"width":160,"height":18,"lockAspectRatio":false,"lockShape":false,"order":120,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Recruted_comments

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":170}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":171,"uid":null,"width":160,"height":46,"lockAspectRatio":false,"lockShape":false,"order":121,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#FFFFFF","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":172,"uid":null,"width":160,"height":46,"lockAspectRatio":false,"lockShape":false,"order":122,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* recruted_user_id:int

* comment:text  

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":168},{"magnitude":-1,"id":169}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":169,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":169},{"magnitude":1,"id":172}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":479,"y":332.5,"rotation":0,"id":216,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":159,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[95.8528137423857,-122.5],[95.8528137423857,-167.5],[242.00505063388334,-167.5],[242.00505063388334,-193]],"lockSegments":{"1":true}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":5,"px":0.7071067811865476,"py":0}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":45,"px":0.29289321881345254,"py":0.9999999999999998}}},"linkMap":[]},{"x":469,"y":322.5,"rotation":0,"id":217,"uid":"com.gliffy.shape.erd.erd_v1.default.one_many","width":100,"height":100,"lockAspectRatio":false,"lockShape":false,"order":160,"graphic":{"type":"Line","Line":{"strokeWidth":1,"strokeColor":"#000000","fillColor":"none","dashStyle":null,"startArrow":0,"endArrow":10,"startArrowRotation":"auto","endArrowRotation":"auto","ortho":true,"interpolationType":"linear","cornerRadius":null,"controlPath":[[-113.79184719828697,-152.5],[-113.79184719828697,-299],[509,-299],[509,-247]],"lockSegments":{"1":true}}},"children":[],"constraints":{"constraints":[],"startConstraint":{"type":"StartPositionConstraint","StartPositionConstraint":{"nodeId":0,"px":0.7071067811865476,"py":0}},"endConstraint":{"type":"EndPositionConstraint","EndPositionConstraint":{"nodeId":208,"px":0.5,"py":0}}},"linkMap":[]},{"x":1208,"y":282.25,"rotation":0,"id":183,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":122,"height":50,"lockAspectRatio":false,"lockShape":false,"order":133,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":184,"uid":null,"width":122,"height":18,"lockAspectRatio":false,"lockShape":false,"order":129,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":185,"uid":null,"width":122,"height":18,"lockAspectRatio":false,"lockShape":false,"order":130,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Seeder_log

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":185}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":186,"uid":null,"width":122,"height":32,"lockAspectRatio":false,"lockShape":false,"order":131,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":187,"uid":null,"width":122,"height":32,"lockAspectRatio":false,"lockShape":false,"order":132,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int\n

* code:varchar

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":183},{"magnitude":-1,"id":184}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":184,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":184},{"magnitude":1,"id":187}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":1210,"y":21.5,"rotation":0,"id":150,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":120,"lockAspectRatio":false,"lockShape":false,"order":103,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":151,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":104,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":152,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":105,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Email_templates

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":152}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":153,"uid":null,"width":120,"height":102,"lockAspectRatio":false,"lockShape":false,"order":106,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":154,"uid":null,"width":120,"height":102,"lockAspectRatio":false,"lockShape":false,"order":107,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

* code:varchar

* title:varchar

* content:text

o allowed_fields:text

o description:text

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":150},{"magnitude":-1,"id":151}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":151,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":151},{"magnitude":1,"id":154}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]},{"x":1210,"y":156.5,"rotation":0,"id":67,"uid":"com.gliffy.shape.erd.erd_v1.default.entity_with_attributes","width":120,"height":106,"lockAspectRatio":false,"lockShape":false,"order":53,"graphic":null,"children":[{"x":0,"y":0,"rotation":0,"id":68,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":54,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":69,"uid":null,"width":120,"height":18,"lockAspectRatio":false,"lockShape":false,"order":55,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

Global_options

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":69}],"minHeight":0,"growParent":true,"padding":0}}]}},{"x":0,"y":18,"rotation":0,"id":70,"uid":null,"width":120,"height":88,"lockAspectRatio":false,"lockShape":false,"order":56,"graphic":{"type":"Shape","Shape":{"tid":"com.gliffy.stencil.rectangle.basic_v1","strokeWidth":1,"strokeColor":"#000000","fillColor":"#b6d7a8","gradient":false,"dropShadow":false,"state":0,"shadowX":4,"shadowY":4,"opacity":1}},"children":[{"x":0,"y":0,"rotation":0,"id":71,"uid":null,"width":120,"height":88,"lockAspectRatio":false,"lockShape":false,"order":57,"graphic":{"type":"Text","Text":{"tid":null,"valign":"top","overflow":"none","vposition":"none","hposition":"none","html":"

# id:int

* name:varchar

* code:varchar

* value:varchar

o description:text

o not_editable:int

","paddingLeft":2,"paddingRight":2,"paddingBottom":2,"paddingTop":2}},"children":[]}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":false,"heightInfo":[{"magnitude":1,"id":67},{"magnitude":-1,"id":68}],"minHeight":20,"growParent":false,"padding":0}},{"type":"PositionConstraint","PositionConstraint":{"nodeId":68,"px":0,"py":1}}]}}],"constraints":{"constraints":[{"type":"HeightConstraint","HeightConstraint":{"isMin":true,"heightInfo":[{"magnitude":1,"id":68},{"magnitude":1,"id":71}],"minHeight":0,"growParent":false,"padding":0}}]},"linkMap":[]}],"background":"#FFFFFF","width":1420,"height":831,"maxWidth":5000,"maxHeight":5000,"nodeIndex":219,"autoFit":true,"exportBorder":false,"gridOn":true,"snapToGrid":true,"drawingGuidesOn":true,"pageBreaksOn":false,"printGridOn":false,"printPaper":null,"printShrinkToFit":false,"printPortrait":false,"shapeStyles":{},"lineStyles":{},"textStyles":{"global":{"bold":true,"size":"14px","color":"#cc0000"}},"themeData":null}}