summaryrefslogtreecommitdiffstats
path: root/docs/DatabaseTables.md
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)
```