WiRoc-Python.erdplus

{"version":2,"www":"erdplus.com","shapes":[{"type":"Table","details":{"name":"MessageTypeData","x":695,"y":9,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1}],"uniqueGroups":[],"id":1}},{"type":"Table","details":{"name":"SubscriberData","x":1173,"y":213,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["Name"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"varcharn","dataTypeSize":"25","id":2}],"uniqueGroups":[],"id":2}},{"type":"Table","details":{"name":"MessageBoxData","x":308,"y":267,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["MessageData"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"binary","id":2},{"names":["MessageTypeId"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":1,"attributeId":1}],"id":3}],"uniqueGroups":[],"id":3}},{"type":"Table","details":{"name":"MessageSubscriptionData","x":644,"y":206,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["TransformedDate"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"date","dataTypeSize":null,"id":2},{"names":["CustomData"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"varcharn","dataTypeSize":"25","id":3},{"names":["SentDate"],"order":4,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"date","dataTypeSize":null,"id":4},{"names":["MessageBoxId"],"order":5,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":3,"attributeId":1}],"id":5},{"names":["SubscriptionId"],"order":6,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":8,"attributeId":1}],"id":6}],"uniqueGroups":[],"id":6}},{"type":"Table","details":{"name":"SubscriptionData","x":983,"y":212,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["MessageTypeId"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":1,"attributeId":1}],"id":2},{"names":["SubscriberId"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":2,"attributeId":1}],"id":3},{"names":["TransformId"],"order":4,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":12,"attributeId":1}],"id":4},{"names":["DeleteAfterSent"],"order":5,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":5},{"names":["Enabled"],"order":6,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":6}],"uniqueGroups":[],"id":8}},{"type":"Table","details":{"name":"TransformData","x":981,"y":401,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["Name"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"varcharn","dataTypeSize":"25","id":2}],"uniqueGroups":[],"id":12}},{"type":"Table","details":{"name":"MessageBoxArchiveData","x":308,"y":584,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["MessageData"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"binary","id":2},{"names":["MessageTypeId"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":1,"attributeId":1}],"id":3}],"uniqueGroups":[],"id":14}},{"type":"Table","details":{"name":"MessageSubscriptionArchiveData","x":662,"y":567,"sort":"automatic","attributes":[{"names":["id"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["TransfomedDate"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"date","dataTypeSize":null,"id":2},{"names":["CustomData"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"varcharn","dataTypeSize":"25","id":3},{"names":["SentDate"],"order":4,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"date","dataTypeSize":null,"id":4},{"names":["MessageBoxId"],"order":5,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":14,"attributeId":1}],"id":5},{"names":["SubscriptionId"],"order":6,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":8,"attributeId":1}],"id":6}],"uniqueGroups":[],"id":16}}],"connectors":[{"type":"TableConnector","details":{"fkAttributeId":3,"id":5},"source":1,"destination":3},{"type":"TableConnector","details":{"fkAttributeId":5,"id":7},"source":3,"destination":6},{"type":"TableConnector","details":{"fkAttributeId":2,"id":9},"source":1,"destination":8},{"type":"TableConnector","details":{"fkAttributeId":3,"id":10},"source":2,"destination":8},{"type":"TableConnector","details":{"fkAttributeId":6,"id":11},"source":8,"destination":6},{"type":"TableConnector","details":{"fkAttributeId":4,"id":13},"source":12,"destination":8},{"type":"TableConnector","details":{"fkAttributeId":3,"id":15},"source":1,"destination":14},{"type":"TableConnector","details":{"fkAttributeId":5,"id":17},"source":14,"destination":16},{"type":"TableConnector","details":{"fkAttributeId":6,"id":18},"source":8,"destination":16}],"width":2000,"height":1000}