| liamfallon | c9e2790 | 2019-05-28 13:27:04 +0000 | [diff] [blame] | 1 | @startuml |
| 2 | |
| 3 | title Indicative Database Layout |
| 4 | |
| 5 | !define table(x) class x << (T,#FFAAAA) >> |
| 6 | !define primary_key(x) <u>x</u> |
| 7 | hide methods |
| 8 | hide stereotypes |
| 9 | |
| 10 | table(PDP_SUBGROUP) { |
| 11 | primary_key(PDP_SUBGROUP_ID) |
| 12 | PDP_SUBGROUP_NAME |
| 13 | PDP_SUBGROUP_VERSION |
| 14 | PDP_TYPE |
| 15 | PDP_SERVICE_ENDPOINT |
| 16 | POLICY_SET_ID |
| 17 | PDP_SUBGROUP_STATE |
| 18 | } |
| 19 | |
| 20 | table(PDP) { |
| 21 | primary_key(PDP_ID) |
| 22 | PDP_NAME |
| 23 | PDP_VERSION |
| 24 | PDP_TYPE |
| 25 | PDP_ENDPOINT |
| 26 | PDP_SUBGROUP_ID |
| 27 | POLICY_SET_ID PDP_STATE |
| 28 | } |
| 29 | |
| 30 | table(POLICY_SET) { |
| 31 | primary_key(POLICY_SET_ID) |
| 32 | POLICY_SET_NAME |
| 33 | POLICY_SET_VERSION |
| 34 | } |
| 35 | |
| 36 | table(POLICY_TYPE_IMPL) { |
| 37 | primary_key(POLICY_TYPE_IMPL_ID) |
| 38 | POLICY_NAME |
| 39 | POLICY_VERSION |
| 40 | PDP_TYPE POLICY_ARTIFACT |
| 41 | } |
| 42 | |
| 43 | table(POLICY_SET_TO_POLICY_TYPE_IMPL) { |
| 44 | POLICY_SET_ID |
| 45 | POLICY_TYPE_IMPL_ID |
| 46 | } |
| 47 | |
| 48 | PDP_SUBGROUP::POLICY_SET_ID --> POLICY_SET::POLICY_SET_ID |
| 49 | PDP::PDP_SUBGROUP_ID --> PDP_SUBGROUP::PDP_SUBGROUP_ID |
| 50 | PDP::POLICY_SET_ID --> POLICY_SET::POLICY_SET_ID |
| 51 | POLICY_SET_TO_POLICY_TYPE_IMPL::POLICY_SET_ID --> POLICY_SET::POLICY_SET_ID |
| 52 | POLICY_SET_TO_POLICY_TYPE_IMPL::POLICY_TYPE_IMPL_ID --> POLICY_TYPE_IMPL::POLICY_TYPE_IMPL_ID |
| 53 | |
| 54 | @enduml |