diff options
Diffstat (limited to 'docs/DatabaseTables.md')
| -rw-r--r-- | docs/DatabaseTables.md | 101 |
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) +``` |