...
| Code Block |
|---|
mysql> show tables; mysql> show columns from SERVICE_MODEL; mysql> select name, service_uuid, invariant_uuid from SERVICE_MODEL; +------------------------+--------------------------------------+--------------------------------------+ | name | service_uuid | invariant_uuid | +------------------------+--------------------------------------+--------------------------------------+ | NULL | 0 | NULL | | vBNG_0202 | 00e50cbd-ef0f-4b28-821e-f2b583752dd3 | dbf9288d-18ef-4d28-82cb-29373028f367 | | BK-012317-UUID-Service | 0a92fd9c-baab-4c03-b4e2-827e2cb9bcc7 | 083b57cd-4b76-4924-a64c-610445528063 | | vEPC | 2c02b479-905f-4b6d-bd03-a2c8a8cdfae4 | 6dd6969c-b75c-4146-8a96-0cb9c0af19a7 | | VoLTE e2e Service | 96a01eb8-1538-40a6-a9ab-0f6bf8e0d877 | e9b5654e-6627-4590-9a54-a39b4d85955e | | vIMS | de3dc33a-799a-48fe-aef2-9a7e93631a4c | 970177ab-40d9-4ab7-9a9b-aa2d08c9ca91 | +------------------------+--------------------------------------+--------------------------------------+ |
| Code Block | ||
|---|---|---|
| ||
mysql> select * from VF_MODEL where nf_role is not null;
+--------------------------------------+------------+--------------------------------------+--------------------------------------+---------+-------------------------+-------------------------------------------------+------------------------+----------------------+--------------------------------------+---------------------+--------------------+-----------------------+-------------------------+----------------+
| customization_uuid | model_yaml | invariant_uuid | uuid | version | name | naming_policy | ecomp_generated_naming | avail_zone_max_count | nf_function | nf_code | nf_type | nf_role | vendor | vendor_version |
+--------------------------------------+------------+--------------------------------------+--------------------------------------+---------+-------------------------+-------------------------------------------------+------------------------+----------------------+--------------------------------------+---------------------+--------------------+-----------------------+-------------------------+----------------+
| 232972fe-4ee2-4056-b23a-73c5052eb791 | null | af94e0b5-454c-4fd8-b62b-ef27632afd22 | 71b87384-8e60-4d0b-9ed0-757245996fc3 | 1.0 | VID-PCRF-05-15-17 | NULL | NULL | 1 | function_2 | code_1 | Type_1 | role_1 | null | null |
| 53ed3b2b-4225-45da-bf21-ebb5abdc9000 | null | 15b244fa-a9e2-4f68-a978-05184d78b911 | 028c08dd-56c6-42e3-ae6d-84f98ca09f37 | 2.0 | 06e7a3b5-f81c-4f99-b33d | SDNC_Policy.Config_MS_ONAP_VFW_NAMING_TIMESTAMP | Y | 1 | ONAP-TRAFFIC-GEN | vpg | TRAFFIC-GEN | vPG | 8f64125f-125a-40b4-b882 | 1.0 | |
Preconfiguration for VoLTE SDNC: ONAP VoLTE SDNC Integration Test.docx
...