blob: 30f4f7b53a0d965f621c511abc3a101675b1b96a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
# Database Tables
As of version 0.12.0.
## `dcae_service_types`
### Relationships
* 1:1 - `dcae_services`
### Schema
```
Table "public.dcae_service_types"
Column | Type | Modifiers
--------------------+-----------------------------+-----------
type_id | character varying | not null
type_version | integer | not null
type_name | character varying | not null
owner | character varying | not null
blueprint_template | text | not null
vnf_types | character varying[] | not null
service_ids | character varying[] |
service_locations | character varying[] |
asdc_service_id | character varying | not null
asdc_resource_id | character varying | not null
created | timestamp without time zone | not null
is_active | boolean | not null
Indexes:
"pk_type_created" PRIMARY KEY, btree (type_id, created)
```
## `dcae_services`
### Relationships
* 1:1 - `dcae_service_types`
* N:N - `dcae_service_components` mapped through `dcae_services_components_maps`
### Schema
```
Table "public.dcae_services"
Column | Type | Modifiers
----------------+-----------------------------+-----------
service_id | character varying | not null
type_id | character varying | not null
vnf_id | character varying | not null
vnf_type | character varying | not null
vnf_location | character varying | not null
deployment_ref | character varying |
created | timestamp without time zone | not null
modified | timestamp without time zone | not null
status | character varying | not null
Indexes:
"dcae_services_pkey" PRIMARY KEY, btree (service_id)
Referenced by:
TABLE "dcae_services_components_maps" CONSTRAINT "dcae_services_components_maps_service_id_fkey" FOREIGN KEY (service_id) REFERENCES dcae_services(service_id)
```
## `dcae_service_components`
### Relationships
* N:N - `dcae_services` mapped through `dcae_services_components_maps`
### Schema
```
Table "public.dcae_service_components"
Column | Type | Modifiers
------------------+-----------------------------+-----------
component_id | character varying | not null
component_type | character varying | not null
component_source | character varying | not null
shareable | integer | default 0
created | timestamp without time zone | not null
modified | timestamp without time zone | not null
Indexes:
"dcae_service_components_pkey" PRIMARY KEY, btree (component_id)
Referenced by:
TABLE "dcae_services_components_maps" CONSTRAINT "dcae_services_components_maps_component_id_fkey" FOREIGN KEY (component_id) REFERENCES dcae_service_components(component_id)
```
## `dcae_services_components_maps`
### Schema
```
Table "public.dcae_services_components_maps"
Column | Type | Modifiers
--------------+-----------------------------+-----------
service_id | character varying | not null
component_id | character varying | not null
created | timestamp without time zone | not null
Indexes:
"dcae_services_components_maps_pkey" PRIMARY KEY, btree (service_id, component_id)
Foreign-key constraints:
"dcae_services_components_maps_component_id_fkey" FOREIGN KEY (component_id) REFERENCES dcae_service_components(component_id)
"dcae_services_components_maps_service_id_fkey" FOREIGN KEY (service_id) REFERENCES dcae_services(service_id)
```
|
