aboutsummaryrefslogtreecommitdiffstats
path: root/docs/DatabaseTables.md
diff options
context:
space:
mode:
authorMichael Hwang <mhwang@research.att.com>2017-02-14 15:10:16 +0000
committerMichael Hwang <mhwang@research.att.com>2017-08-23 13:18:27 -0400
commitac853c1e7186b10e34e392918af31e4ac62b45c2 (patch)
tree5b0acebf2704317cd9fe86545313e68771bad04f /docs/DatabaseTables.md
parent19488409d66aa5bbbc2856022f1187ce3f563b83 (diff)
Make first commit
Transferring from original dcae project Issue-Id: DCAEGEN2-45 Change-Id: If8500f4a120ec2d27a714c8917f163beb57ee64c Signed-off-by: Michael Hwang <mhwang@research.att.com>
Diffstat (limited to 'docs/DatabaseTables.md')
-rw-r--r--docs/DatabaseTables.md101
1 files changed, 101 insertions, 0 deletions
diff --git a/docs/DatabaseTables.md b/docs/DatabaseTables.md
new file mode 100644
index 0000000..30f4f7b
--- /dev/null
+++ b/docs/DatabaseTables.md
@@ -0,0 +1,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)
+```