physical_modell.erdplus

{"version":2,"www":"erdplus.com","shapes":[{"type":"Entity","details":{"name":"Customer","type":"regular","x":1070,"y":328,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":1}},{"type":"Entity","details":{"name":"Address","type":"regular","x":1103,"y":622,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":2}},{"type":"Entity","details":{"name":"Bike","type":"regular","x":163,"y":97,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":3}},{"type":"Entity","details":{"name":"Leasing","type":"regular","x":628,"y":331,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":4}},{"type":"Entity","details":{"name":"Paymentinfo","type":"regular","x":1069,"y":133,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":5}},{"type":"Relationship","details":{"name":"lives","isIdentifying":false,"x":1104,"y":516.5,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":1},{"slotIndex":1,"minimum":"1","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":2}],"id":9}},{"type":"Relationship","details":{"name":"has","isIdentifying":false,"x":1070,"y":251.5,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":5},{"slotIndex":1,"minimum":"1","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":1}],"id":13}},{"type":"Relationship","details":{"name":"has","isIdentifying":false,"x":838,"y":329.5,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":4},{"slotIndex":1,"minimum":"1","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":1}],"id":16}},{"type":"Relationship","details":{"name":"has","isIdentifying":false,"x":340,"y":96.5,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":3},{"slotIndex":1,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":124}],"id":19}},{"type":"Entity","details":{"name":"Country","type":"regular","x":1102,"y":832,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":28}},{"type":"Attribute","details":{"name":"name: varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":967,"y":903,"id":29}},{"type":"Attribute","details":{"name":"cID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":1234,"y":902,"id":30}},{"type":"Relationship","details":{"name":"is_in","isIdentifying":false,"x":1103,"y":737,"slots":[{"slotIndex":0,"minimum":"1","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":2},{"slotIndex":1,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":28}],"id":34}},{"type":"Attribute","details":{"name":"street: varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1016,"y":689,"id":37}},{"type":"Attribute","details":{"name":"streetNo: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1213,"y":544,"id":39}},{"type":"Attribute","details":{"name":"city: varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1266,"y":616,"id":40}},{"type":"Attribute","details":{"name":"postcode: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1007,"y":540,"id":41}},{"type":"Attribute","details":{"name":"aID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":1208,"y":707,"id":46}},{"type":"Attribute","details":{"name":"name: varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":962,"y":403,"id":48}},{"type":"Attribute","details":{"name":"cID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":951,"y":260,"id":49}},{"type":"Attribute","details":{"name":"firstname: varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1196,"y":402,"id":50}},{"type":"Attribute","details":{"name":"tel: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1204,"y":262,"id":51}},{"type":"Attribute","details":{"name":"email: varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1070,"y":450,"id":53}},{"type":"Attribute","details":{"name":"piID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":950,"y":70,"id":62}},{"type":"Attribute","details":{"name":"cardNo: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1118,"y":44,"id":63}},{"type":"Attribute","details":{"name":"lID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":506,"y":269,"id":68}},{"type":"Attribute","details":{"name":"startDate: Date","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":504,"y":389,"id":70}},{"type":"Attribute","details":{"name":"endDate: Date","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":756,"y":387,"id":71}},{"type":"Attribute","details":{"name":"total: Number","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":757,"y":276,"id":74}},{"type":"Entity","details":{"name":"Part","type":"regular","x":628,"y":736,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":76}},{"type":"Entity","details":{"name":"PartType","type":"regular","x":252,"y":736,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":77}},{"type":"Relationship","details":{"name":"is_from_type","isIdentifying":false,"x":447,"y":737,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":76},{"slotIndex":1,"minimum":"1","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":77}],"id":80}},{"type":"Attribute","details":{"name":"ptID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":253,"y":839,"id":85}},{"type":"Attribute","details":{"name":"type: String","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":347,"y":634,"id":86}},{"type":"Attribute","details":{"name":"pID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":629,"y":826,"id":89}},{"type":"Attribute","details":{"name":"name: Varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":744,"y":799,"id":90}},{"type":"Relationship","details":{"name":"is_leased","isIdentifying":false,"x":630,"y":561,"slots":[{"slotIndex":0,"minimum":"0","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":4},{"slotIndex":1,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":76}],"id":104}},{"type":"Entity","details":{"name":"BikeType","type":"regular","x":162,"y":419,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":113}},{"type":"Relationship","details":{"name":"is_from_type","isIdentifying":false,"x":163,"y":279,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":3},{"slotIndex":1,"minimum":"1","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":113}],"id":114}},{"type":"Attribute","details":{"name":"type: Varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":270,"y":494,"id":117}},{"type":"Attribute","details":{"name":"btID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":135,"y":512,"id":118}},{"type":"Entity","details":{"name":"LeasingBike","type":"regular","x":504,"y":97,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":124}},{"type":"Relationship","details":{"name":"has","isIdentifying":false,"x":630,"y":186,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"unspecified","cardinality":"unspecified","role":"","entityId":124},{"slotIndex":1,"minimum":"1","maximum":"n","participation":"unspecified","cardinality":"unspecified","role":"","entityId":4}],"id":129}},{"type":"Attribute","details":{"name":"bID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":59,"y":40.5,"id":156}},{"type":"Attribute","details":{"name":"lbID: Integer","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":610,"y":31.5,"id":158}},{"type":"Attribute","details":{"name":"Primary Key","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":1428,"y":480.5,"id":160}},{"type":"Attribute","details":{"name":"pricePerDay: Number","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":195,"y":33.5,"id":161}},{"type":"Attribute","details":{"name":"owner: varchar","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1215,"y":94.5,"id":163}},{"type":"Attribute","details":{"name":"valid_till: Date","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1195,"y":169.5,"id":165}},{"type":"Attribute","details":{"name":"Foreign Key","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1427,"y":536.5,"id":195}},{"type":"Attribute","details":{"name":"biketype","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":251,"y":167.5,"id":196}},{"type":"Attribute","details":{"name":"bike","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":501,"y":28,"id":198}},{"type":"Attribute","details":{"name":"leasing","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":653,"y":89,"id":200}},{"type":"Attribute","details":{"name":"country","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":969,"y":619,"id":202}},{"type":"Attribute","details":{"name":"address","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1219,"y":328,"id":204}},{"type":"Attribute","details":{"name":"customer","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":930,"y":133,"id":206}},{"type":"Attribute","details":{"name":"customer","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":488,"y":325,"id":208}},{"type":"Attribute","details":{"name":"leasing","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":717,"y":656,"id":210}},{"type":"Attribute","details":{"name":"parttype","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":781,"y":718,"id":212}},{"type":"Attribute","details":{"name":"pricePerDay: Number","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":856,"y":779.5,"id":251}}],"connectors":[{"type":"RelationshipConnector","details":{"slotIndex":0,"id":10},"source":1,"destination":9},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":11},"source":2,"destination":9},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":14},"source":5,"destination":13},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":15},"source":1,"destination":13},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":17},"source":4,"destination":16},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":18},"source":1,"destination":16},{"type":"Connector","details":{"id":252},"source":29,"destination":28},{"type":"Connector","details":{"id":253},"source":30,"destination":28},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":35},"source":2,"destination":34},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":36},"source":28,"destination":34},{"type":"Connector","details":{"id":254},"source":37,"destination":2},{"type":"Connector","details":{"id":255},"source":39,"destination":2},{"type":"Connector","details":{"id":256},"source":41,"destination":2},{"type":"Connector","details":{"id":257},"source":40,"destination":2},{"type":"Connector","details":{"id":258},"source":46,"destination":2},{"type":"Connector","details":{"id":259},"source":49,"destination":1},{"type":"Connector","details":{"id":260},"source":48,"destination":1},{"type":"Connector","details":{"id":261},"source":50,"destination":1},{"type":"Connector","details":{"id":262},"source":53,"destination":1},{"type":"Connector","details":{"id":263},"source":51,"destination":1},{"type":"Connector","details":{"id":264},"source":62,"destination":5},{"type":"Connector","details":{"id":265},"source":63,"destination":5},{"type":"Connector","details":{"id":266},"source":68,"destination":4},{"type":"Connector","details":{"id":267},"source":70,"destination":4},{"type":"Connector","details":{"id":268},"source":71,"destination":4},{"type":"Connector","details":{"id":269},"source":74,"destination":4},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":83},"source":76,"destination":80},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":84},"source":77,"destination":80},{"type":"Connector","details":{"id":270},"source":86,"destination":77},{"type":"Connector","details":{"id":271},"source":85,"destination":77},{"type":"Connector","details":{"id":272},"source":90,"destination":76},{"type":"Connector","details":{"id":273},"source":89,"destination":76},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":106},"source":76,"destination":104},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":108},"source":4,"destination":104},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":115},"source":3,"destination":114},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":116},"source":113,"destination":114},{"type":"Connector","details":{"id":274},"source":117,"destination":113},{"type":"Connector","details":{"id":275},"source":118,"destination":113},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":125},"source":124,"destination":19},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":126},"source":3,"destination":19},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":130},"source":124,"destination":129},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":131},"source":4,"destination":129},{"type":"Connector","details":{"id":276},"source":156,"destination":3},{"type":"Connector","details":{"id":277},"source":158,"destination":124},{"type":"Connector","details":{"id":278},"source":161,"destination":3},{"type":"Connector","details":{"id":279},"source":163,"destination":5},{"type":"Connector","details":{"id":280},"source":165,"destination":5},{"type":"Connector","details":{"id":281},"source":196,"destination":3},{"type":"Connector","details":{"id":282},"source":198,"destination":124},{"type":"Connector","details":{"id":283},"source":200,"destination":124},{"type":"Connector","details":{"id":284},"source":202,"destination":2},{"type":"Connector","details":{"id":285},"source":204,"destination":1},{"type":"Connector","details":{"id":286},"source":206,"destination":5},{"type":"Connector","details":{"id":287},"source":208,"destination":4},{"type":"Connector","details":{"id":288},"source":210,"destination":76},{"type":"Connector","details":{"id":289},"source":212,"destination":76},{"type":"Connector","details":{"id":290},"source":251,"destination":76}],"width":2000,"height":1000}