dataWarehouseSession.erdplus

{"version":2,"www":"erdplus.com","shapes":[{"type":"Table","details":{"name":"Stg.Revenue","x":315,"y":79,"sort":"manual","attributes":[{"names":["R_ID"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["ContractAmount"],"order":4,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"decimal(10,2)","id":3},{"names":["BilledAmount"],"order":5,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"decimal(10,2)","id":4},{"names":["ReceivedAmount"],"order":6,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"decimal(10,2)","id":5},{"names":["Cnct_ID"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":8,"attributeId":1}],"id":6}],"uniqueGroups":[],"id":1}},{"type":"Table","details":{"name":"Stg.Cost","x":316,"y":293,"sort":"manual","attributes":[{"names":["C_ID"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["CostType"],"order":4,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":3},{"names":["CostAmount"],"order":5,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"decimal(10,2)","id":4},{"names":["Cnct_ID"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":8,"attributeId":1}],"id":5}],"uniqueGroups":[],"id":2}},{"type":"Table","details":{"name":"Fact.ContributionMargin","x":642,"y":281,"sort":"manual","attributes":[{"names":["CM_ID"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["BilledAmount"],"order":5,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"decimal(10,2)","id":4},{"names":["CostAmount"],"order":7,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"custom","dataTypeSize":"decimal(10,2)","id":5},{"names":["Cnct_ID"],"order":3,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":8,"attributeId":1}],"id":9},{"names":["SuperIntendent"],"order":10,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":15,"attributeId":1}],"id":10},{"names":["ProjMgr"],"order":11,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":15,"attributeId":1}],"id":11}],"uniqueGroups":[],"id":3}},{"type":"Table","details":{"name":"Stg.OpsAOR","x":929,"y":114,"sort":"manual","attributes":[{"names":["OA_ID"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["Cnct_ID"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":8,"attributeId":1}],"id":5},{"names":["StartDt"],"order":8,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"date","dataTypeSize":"","id":6},{"names":["EndDt"],"order":9,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"date","dataTypeSize":"","id":7},{"names":["AT_ID"],"order":5,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":13,"attributeId":1}],"id":8},{"names":["E_ID"],"order":7,"pkMember":false,"optional":false,"soloUnique":false,"fk":true,"dataType":"int","dataTypeSize":null,"references":[{"tableId":15,"attributeId":1}],"id":9}],"uniqueGroups":[],"id":6}},{"type":"Table","details":{"name":"Stg.Contract","x":642,"y":159,"sort":"automatic","attributes":[{"names":["Cnct_ID"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["Contract"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"varcharn","dataTypeSize":"50","id":2}],"uniqueGroups":[],"id":8}},{"type":"Table","details":{"name":"Stg.AOR_Type","x":1149,"y":144,"sort":"automatic","attributes":[{"names":["AT_ID"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["AOR_Name"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"varcharn","dataTypeSize":"50","id":2}],"uniqueGroups":[],"id":13}},{"type":"Table","details":{"name":"Stg.Employees","x":928,"y":307,"sort":"automatic","attributes":[{"names":["E_ID"],"order":1,"pkMember":true,"optional":false,"soloUnique":false,"fk":false,"dataType":"int","dataTypeSize":null,"id":1},{"names":["EmployeeName"],"order":2,"pkMember":false,"optional":false,"soloUnique":false,"fk":false,"dataType":"varcharn","dataTypeSize":"250","id":2}],"uniqueGroups":[],"id":15}}],"connectors":[{"type":"TableConnector","details":{"fkAttributeId":5,"id":9},"source":8,"destination":2},{"type":"TableConnector","details":{"fkAttributeId":6,"id":10},"source":8,"destination":1},{"type":"TableConnector","details":{"fkAttributeId":9,"id":11},"source":8,"destination":3},{"type":"TableConnector","details":{"fkAttributeId":5,"id":12},"source":8,"destination":6},{"type":"TableConnector","details":{"fkAttributeId":8,"id":14},"source":13,"destination":6},{"type":"TableConnector","details":{"fkAttributeId":9,"id":16},"source":15,"destination":6},{"type":"TableConnector","details":{"fkAttributeId":10,"id":17},"source":15,"destination":3},{"type":"TableConnector","details":{"fkAttributeId":11,"id":18},"source":15,"destination":3}],"width":2000,"height":1000}