• Provides NS LCM Database Management
• Creates NS LCM Database tables
• Provides Database Access Objects (DAO)
• creates the following NS LCM Database tables and provides CRUD

• NFVO_NSINST

id = models.CharField(db_column='ID', primary_key=True, max_length=200)
name = models.CharField(db_column='NAME', max_length=200)
nspackage_id = models.CharField(db_column='NSPACKAGEID', max_length=200, null=True, blank=True)
nsd_id = models.CharField(db_column='NSDID', max_length=200)
nsd_invariant_id = models.CharField(db_column='NSDINVARIANTID', max_length=200)
description = models.CharField(db_column='DESCRIPTION', max_length=255, null=True, blank=True)
sdncontroller_id = models.CharField(db_column='SDNCONTROLLERID', max_length=200, null=True, blank=True)
flavour_id = models.CharField(db_column='FLAVOURID', max_length=200, null=True, blank=True)
ns_level = models.CharField(db_column='NSLEVEL', max_length=200, null=True, blank=True)
status = models.CharField(db_column='STATUS', max_length=200, null=True, blank=True)
nsd_model = models.TextField(db_column='NSDMODEL', max_length=20000, null=True, blank=True)
input_params = models.TextField(db_column='INPUTPARAMS', max_length=2000, null=True, blank=True)
scale_params = models.TextField(db_column='SCALEPARAMS', max_length=2000, null=True, blank=True)
create_time = models.CharField(db_column='CREATETIME', max_length=200, null=True, blank=True)
lastuptime = models.CharField(db_column='LASTUPTIME', max_length=200, null=True, blank=True)
global_customer_id = models.CharField(db_column='GLOBALCUSTOMERID', max_length=50, null=True, blank=True)
service_type = models.CharField(db_column='SERVICETYPE', max_length=50, null=True, blank=True)

• NFVO_NFINST

nfinstid = models.CharField(db_column='NFINSTID', max_length=200, primary_key=True)
mnfinstid = models.CharField(db_column='M_NFINSTID', max_length=200, blank=True, null=True)
nf_name = models.CharField(db_column='NFNAME', max_length=100, blank=True, null=True)
template_id = models.CharField(db_column='TEMPLATEID', max_length=200, blank=True, null=True)
vnf_id = models.CharField(db_column='VNFID', max_length=200, blank=True, null=True)
package_id = models.CharField(db_column='PACKAGEID', max_length=200, blank=True, null=True)
vnfm_inst_id = models.CharField(db_column='VNFMINSTID', max_length=200, blank=True, null=True)
ns_inst_id = models.CharField(db_column='NSINSTID', max_length=200, blank=True, null=True)
status = models.CharField(db_column='STATUS', max_length=20, blank=True, null=True)
flavour_id = models.CharField(db_column='FLAVOURID', max_length=200, blank=True, null=True)
vnf_level = models.CharField(db_column='VNFLEVEL', max_length=200, blank=True, null=True)
location = models.CharField(db_column='LOCATION', max_length=200, blank=True, null=True)
max_vm = models.IntegerField(db_column='MAXVM', null=True)
max_cpu = models.IntegerField(db_column='MAXCPU', null=True)
max_ram = models.IntegerField(db_column='MAXRAM', null=True)
max_hd = models.IntegerField(db_column='MAXHD', null=True)
max_shd = models.IntegerField(db_column='MAXSHD', null=True)
max_net = models.IntegerField(db_column='MAXNET', null=True)
version = models.CharField(db_column='VERSION', max_length=255, null=True)
vendor = models.CharField(db_column='VENDOR', max_length=255, null=True, blank=True)
vnfd_model = models.TextField(db_column='VNFDMODEL', max_length=20000, blank=True, null=True)
input_params = models.TextField(db_column='INPUTPARAMS', max_length=2000, blank=True, null=True)
scale_params = models.TextField(db_column='SCALEPARAMS', max_length=2000, null=True, blank=True)
create_time = models.CharField(db_column='CREATETIME', max_length=200, null=True, blank=True)
lastuptime = models.CharField(db_column='LASTUPTIME', max_length=200, blank=True, null=True)
extension = models.TextField(db_column='EXTENSION', max_length=65535, blank=True, null=True)

• NFVO_VLINST

vlinstanceid = models.CharField(db_column='VLINSTANCEID', max_length=255, primary_key=True)
vldid = models.CharField(db_column='VLDID', max_length=255)
vlinstancename = models.CharField(db_column='VLINSTANCENAME', max_length=255, blank=True, null=True)
ownertype = models.IntegerField(db_column='OWNERTYPE')
ownerid = models.CharField(db_column='OWNERID', max_length=255)
relatednetworkid = models.CharField(db_column='RELATEDNETWORKID', max_length=255, blank=True, null=True)
relatedsubnetworkid = models.CharField(db_column='RELATEDSUBNETWORKID', max_length=255, blank=True,
null=True)
vltype = models.IntegerField(db_column='VLTYPE', default=0)
vimid = models.CharField(db_column='VIMID', max_length=255)
tenant = models.CharField(db_column='TENANT', max_length=255)
status = models.CharField(db_column='STATUS', max_length=255)

• NFVO_JOB

jobid = models.CharField(db_column='JOBID', primary_key=True, max_length=255)
jobtype = models.CharField(db_column='JOBTYPE', max_length=255)
jobaction = models.CharField(db_column='JOBACTION', max_length=255)
resid = models.CharField(db_column='RESID', max_length=255)
status = models.IntegerField(db_column='STATUS', null=True, blank=True)
starttime = models.CharField(db_column='STARTTIME', max_length=255, null=True, blank=True)
endtime = models.CharField(db_column='ENDTIME', max_length=255, null=True, blank=True)
progress = models.IntegerField(db_column='PROGRESS', null=True, blank=True)
user = models.CharField(db_column='USER', max_length=255, null=True, blank=True)
parentjobid = models.CharField(db_column='PARENTJOBID', max_length=255, null=True, blank=True)
resname = models.CharField(db_column='RESNAME', max_length=255, null=True, blank=True)

• NFVO_OOF_DATA

request_id = models.CharField(db_column='REQUESTID', max_length=255)
transaction_id = models.CharField(db_column='TRANSACTIONID', max_length=255)
request_status = models.CharField(db_column='REQUESTSTATUS', max_length=50)
request_module_name = models.CharField(db_column='RESOURCEMODULENAME', max_length=100)
service_resource_id = models.CharField(db_column='SERVICERESOURCEID', max_length=255, primary_key=True)
vim_id = models.CharField(db_column='VIMID', max_length=255, null=True, blank=True)
cloud_owner = models.CharField(db_column='CLOUDOWNER', max_length=100, null=True, blank=True)
cloud_region_id = models.CharField(db_column='CLOUDREGIONID', max_length=255, null=True, blank=True)
vdu_info = models.TextField(db_column='VDUINFO', max_length=65535, null=True, blank=True)

• NFVO_SUBSCRIPTION

subscription_id = models.CharField(db_column='SUBSCRIPTIONID', max_length=255, primary_key=True)
vnf_instance_filter = models.TextField(db_column='VNFINSTANCEFILTER', null=True)
ns_instance_filter = models.TextField(db_column='NSINSTANCEFILTER', null=True)
notification_types = models.TextField(db_column='NOTIFICATIONTYPES', null=True)
operation_types = models.TextField(db_column='OPERATIONTYPES', null=True)
operation_states = models.TextField(db_column='OPERATIONSTATES', null=True)
ns_component_types = models.TextField(db_column='NSCOMPONENTTYPES', null=True)
lcm_opname_impacting_nscomponent = models.TextField(db_column='LCMOPNAMEIMPACTINGNSCOMPONENT', null=True)
lcm_opoccstatus_impacting_nscomponent = models.TextField(db_column='LCMOPOCCSTATUSIMPACTINGNSCOMPONENT', null=True)
callback_uri = models.CharField(db_column='CALLBACKURI', max_length=255)
links = models.TextField(db_column='LINKS', max_length=20000)
auth_info = models.TextField(db_column='AUTHINFO', max_length=20000, blank=True, null=True)

• NSLCMOPOCCS

id = models.CharField(db_column='ID', max_length=255, primary_key=True)
operation_state = models.CharField(db_column='OPERATIONSTATE', null=False, max_length=30)
state_entered_time = models.CharField(db_column='STATEENTEREDTIME', null=False, max_length=30)
start_time = models.CharField(db_column='STARTTIME', null=False, max_length=30)
ns_instance_id = models.CharField(db_column='NSINSTANCEID', null=False, max_length=255)
operation = models.CharField(db_column='OPERATION', null=False, max_length=30)
is_automatic_invocation = models.CharField(db_column='ISAUTOMATICINVOCATION', null=False, max_length=5)
operation_params = models.TextField(db_column='OPERATIONPARAMS', null=False)
is_cancel_pending = models.CharField(db_column='ISCANCELPENDING', null=False, max_length=5)
cancel_mode = models.TextField(db_column='CANCELMODE', null=True)
error = models.TextField(db_column='ERROR', null=True)
resource_changes = models.TextField(db_column='RESOURCECHANGES', null=True)
links = models.TextField(db_column='LINKS', null=False)

• NFVO_PNFINST

pnfId = models.CharField(db_column='PNFID', primary_key=True, max_length=255)
pnfName = models.CharField(db_column='PNFNAME', max_length=255)
pnfdId = models.CharField(db_column='PNFDID', max_length=50)
pnfdInfoId = models.CharField(db_column='PNFDINFOID', max_length=100)
pnfProfileId = models.CharField(db_column='PNFPROFILEID', max_length=255)
cpInfo = models.TextField(db_column='CPINFO', max_length=255, null=True, blank=True)
emsId = models.CharField(db_column='EMSID', null=True, max_length=255)
nsInstances = models.TextField(db_column='NSINSTANCES', max_length=1000, null=True, blank=True)

• t_lcm_defPackage_mapping 

service_id = models.CharField(db_column='serviceId', max_length=255, primary_key=True)
service_def_id = models.CharField(db_column='serviceDefId', max_length=255)
template_id = models.CharField(db_column='templateId', max_length=255)
template_name = models.CharField(db_column='templateName', max_length=255)

• t_lcm_inputParam_mapping 

service_id = models.CharField(db_column='serviceId', max_length=255)
input_key = models.CharField(db_column='inputKey', max_length=255)
input_value = models.CharField(db_column='inputValue', max_length=255, null=True, blank=True)

• t_lcm_servicebaseinfo 

service_id = models.CharField(db_column='serviceId', max_length=255, primary_key=True)
service_name = models.CharField(db_column='serviceName', max_length=255)
service_type = models.CharField(db_column='serviceType', max_length=20)
description = models.CharField(db_column='description', max_length=255, null=True, blank=True)
active_status = models.CharField(db_column='activeStatus', max_length=20)
status = models.CharField(db_column='status', max_length=20)
creator = models.CharField(db_column='creator', max_length=50)
create_time = models.BigIntegerField(db_column='createTime')