Make first commit

Transferring from original dcae project

Issue-Id: DCAEGEN2-45
Change-Id: If8500f4a120ec2d27a714c8917f163beb57ee64c
Signed-off-by: Michael Hwang <mhwang@research.att.com>

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)
+```