5GCF-V0.32

Tables (55)

CPF_AMF_AMF_CONF

  • amf_reg_id — int — Primary key — NOT NULL
  • amf_set_id — int — Primary key — NOT NULL
  • amf_pointer — int — Primary key — NOT NULL
  • amf_name — varchar(150) — NOT NULL
  • amf_capa — int — NOT NULL
  • amf_tos — int — NOT NULL
  • eir_flg — enum("ON", "OFF") — NOT NULL
  • auth_flg — enum("ON", "OFF") — NOT NULL
  • int_alg — ENUM("NIA0", "NIA1", "NIA2", "NIA3") — NOT NULL
  • sec_alg — ENUM("NEA0", "NEA1", "NEA2", "NEA3") — NOT NULL
  • fir_pag — ENUM("TAI", "TAL", "UE_TAL") — NOT NULL
  • sec_pag — ENUM("TAI", "TAL", "UE_TAL") — NOT NULL
  • thr_pag — ENUM("TAI", "TAL", "UE_TAL") — NOT NULL

CPF_AMF_GNB_INFO

  • gnb_id — int — Primary key — NOT NULL
  • plmn_id (plmn_id2) — varchar(6) — Foreign key → CPF_PLDMGR_PLMN.plmn_id — NOT NULL
  • master_gnb_ip — varchar(15)
  • master_ue_cnt — int
  • master_conn_status — varchar(16)
  • slave_gnb_ip — varchar(15)
  • slave_ue_cnt — int
  • slave_conn_status — varchar(16)
  • thr_idx — int
  • del_gnb_info_flag — tinyint
  • dis_gnb_info_flag — tinyint

CPF_AMF_SM_CONTEXT_INFO

  • imsi — varchar(15) — Primary key — NOT NULL
  • pdu_session_id — unsigned tinyint — Primary key — NOT NULL
  • amf_sm_context — varchar(256) — NOT NULL

CPF_AMF_TAI_FOR_PAGING_INFO

  • db_side — int — Primary key — NOT NULL
  • plmn_id — varchar(6) — Foreign key → CPF_PLDMGR_PLMN.plmn_id — NOT NULL
  • tac — int — Foreign key → CPF_PLDMGR_TAC.tac — NOT NULL
  • global_gnb_id — bigint unsigned — NOT NULL
  • thr_idx — int — NOT NULL

CPF_AMF_TAI_INFO

  • plmn_id — varchar(6) — Foreign key → CPF_PLDMGR_PLMN.plmn_id — NOT NULL
  • tac — int — Foreign key → CPF_PLDMGR_TAC.tac — NOT NULL
  • tal_id — int
  • del_tai_info_flag — tinyint

CPF_AMF_UE_CONTEXT_INFO

  • imsi — varchar(15) — Primary key — NOT NULL
  • tmsi — unsigned int — NOT NULL
  • amf_ue_ngap_id — bigint — NOT NULL
  • amf_ue_context — varchar(3072) — NOT NULL
  • pdu_session — bigint — NOT NULL

CPF_PCF_AM_CONTEXT

  • supi — varchar(64) — Primary key — NOT NULL
  • ampolicyid — varchar(128) — Primary key — NOT NULL
  • ue_amdata — varchar(3072) — NOT NULL

CPF_PCF_AREA

  • area_id — int — Primary key — NOT NULL
  • tac — int — Foreign key → CPF_PLDMGR_TAC.tac — NOT NULL
  • svr_area_rst_id — int — Foreign key → CPF_PCF_SVR_AREA_RST.svr_area_rst_id — NOT NULL
  • area_nm — varchar(150) — NOT NULL
  • area_cd — varchar(64)

CPF_PCF_PCC_RULE

  • supi — varchar(64) — Foreign key → CPF_UDM_SUBS_DNN.supi — NOT NULL
  • snssai — varchar(10) — Foreign key → CPF_UDM_SUBS_DNN.snssai — NOT NULL
  • dnn — varchar(64) — Foreign key → CPF_UDM_SUBS_DNN.dnn — NOT NULL
  • rule_name — varchar(64) — Foreign key → CPF_SMF_PCC_RULE_INFO.rule_name — NOT NULL
  • pre_def_yn — enum("Y", "N")
  • chk_amp_yn — enum("Y", "N") — NOT NULL

CPF_PCF_POL_ASSO

  • pol_asso_id — int — Primary key — NOT NULL
  • pol_asso_nm — varchar(150) — NOT NULL
  • rfsp — int

CPF_PCF_POL_ASSO_RST

  • supi — varchar(64) — Foreign key → CPF_UDM_SUBS_INFO.supi — NOT NULL
  • pol_asso_id — int — Foreign key → CPF_PCF_POL_ASSO.pol_asso_id
  • svr_area_rst_id — int — Foreign key → CPF_PCF_SVR_AREA_RST.svr_area_rst_id

CPF_PCF_ROUTE_SEL

  • route_sel_id — int — Primary key — NOT NULL
  • ursp_rule_id — int — Foreign key → CPF_PCF_URSP_RULE.ursp_rule_id — NOT NULL
  • route_sel_nm — varchar(150) — NOT NULL
  • prece — unsigned tinyint — NOT NULL
  • route_sel_type — bit(8) — NOT NULL
  • ssc_mode — enum("1", "2", "3") — 1 : ssc mode 1 2 : ssc mode 2 3 : ssc mode 3
  • snssai — varchar(10) — Foreign key → CPF_PLDMGR_SNSSAI.snssai
  • dnn — varchar(64) — Foreign key → CPF_PLDMGR_DNN.dnn
  • pdu_sess_type — enum("IP4","IP6","IP46","unstruct","ether","reserv") — IP4 : IPv4 IP6 : IPv6 IP46 : IPv4v6 unstruct : Unstructured ether : Ethernet reserv : reserved
  • prfr_accss_type (pref_accss_type) — enum("3gpp","non3gpp","multi")
  • pdu_sess_pair_id — enum("0","1","2","3","4","5","6") — The id is 0 to 6
  • rsn — enum("0","1") — Redundancy Sequence Number 0 : v1 1 : v2

CPF_PCF_SM_CONTEXT (CPF_PCF_UE_CONTEXT)

  • supi — varchar(64) — Primary key — NOT NULL
  • smpolicyid — varchar(128) — Primary key — NOT NULL
  • ue_smdata — varchar(3072) — NOT NULL

CPF_PCF_SVR_AREA_RST

  • svr_area_rst_id — int — Primary key — NOT NULL
  • svr_area_rst_nm — varchar(150) — NOT NULL
  • rst_type — enum
  • max_num_of_tas — unsinged int

CPF_PCF_TRAFF_DESC

  • traff_desc_id — int — Primary key — NOT NULL
  • ursp_rule_id — int — Foreign key → CPF_PCF_URSP_RULE.ursp_rule_id — NOT NULL
  • traff_desc_type — bit(8) — NOT NULL
  • ipv4_rmt_addr — varchar(18)
  • ipv6_rmt_addr — varchar(43)
  • sngl_rmt_port — unsinged smallint
  • rmt_port_range_high (Field) — unsigned smallint
  • rmt_port_range_low (rmt_port_range) — unsigned smallint
  • ip3tuple — bit(5)
  • dnn — varchar(64) — Foreign key → CPF_PLDMGR_DNN.dnn
  • conn_capab — varchar(36)
  • dest_fqdn — varchar(64)
  • reg_expre — varchar(64)

CPF_PCF_UE_CONTEXT (CopyOfCPF_PCF_AM_CONTEXT)

  • supi — varchar(64) — Primary key — NOT NULL
  • uepolicyid (ampolicyid) — varchar(128) — Primary key — NOT NULL
  • ue_uedata (ue_amdata) — varchar(3072) — NOT NULL
  • fsm_sts (Field) — varchar(64) — NOT NULL
  • ue_pti (Field2) — tinyint
  • pcf_pti (Field3) — tinyint
  • nas_cmd (Field4) — varchar(2048)

CPF_PCF_UPSC

  • upsc — unsigned smallint — Primary key — NOT NULL
  • plmn_id — varchar(6) — Foreign key → CPF_PLDMGR_PLMN.plmn_id — NOT NULL
  • ursp_rule_id — int — Foreign key → CPF_PCF_URSP_RULE.ursp_rule_id — NOT NULL
  • ue_policy_typ — enum('RESERVE','URSP','ANDSP') — NOT NULL

CPF_PCF_URSP_RULE

  • ursp_rule_id — int — Primary key — NOT NULL
  • ursp_rule_nm — varchar(150) — NOT NULL
  • ursp_rule_prece — unsigned tinyint — NOT NULL

CPF_PLDMGR_CALL_TRACE_INFO

  • trace_id — int — Primary key — NOT NULL
  • imsi — varchar(15)
  • timer — int
  • client_id — int

CPF_PLDMGR_CLOUD_LOG_INFO

  • cpf_id — int — Primary key — NOT NULL
  • log_level — int — NOT NULL
  • timestamp_l — bigint — NOT NULL

CPF_PLDMGR_DNN

  • dnn — varchar(64) — Primary key — NOT NULL

CPF_PLDMGR_NONUE_TRACE_INFO

  • trace_id — int — Primary key — NOT NULL
  • cpf_id — int
  • plmn_id — varchar(6)
  • gnb_id — int
  • timer — int

CPF_PLDMGR_OVLD_INFO

  • dummy_index — int — Primary key — NOT NULL
  • manual_ovld_ctrl — int
  • manual_call_limit — int
  • manual_ovld_action — int
  • min_ovld_action — int
  • maj_ovld_action — int
  • cri_ovld_action — int

CPF_PLDMGR_PLMN

  • plmn_id — varchar(6) — Primary key — NOT NULL

CPF_PLDMGR_SNSSAI

  • snssai — varchar(10) — Primary key — NOT NULL

CPF_PLDMGR_TAC

  • tac — int — Primary key — NOT NULL

CPF_PLDMGR_TIMER_INFO

  • timer_type — tinyint — Primary key — NOT NULL
  • timer_value — int
  • description — varchar(64)

CPF_PLDMGR_TIME_STAMP_INFO

  • time_stamp_type — tinyint — Primary key — NOT NULL
  • time_stamp_value — int
  • description — varchar(64)

CPF_SMF_FLOW_INFO

  • seq — bigint unsigned — Primary key — NOT NULL
  • rule_name — varchar(64) — Foreign key → CPF_SMF_PCC_RULE_INFO.rule_name — NOT NULL
  • filter_id — varchar(64) — NOT NULL
  • protocol — int
  • src_ip — varchar(15)
  • src_port — int
  • dest_ip — varchar(15)
  • dst_prefix_len (Field) — int
  • dest_port — int
  • flow_direction — varchar(8) — NOT NULL
  • filter_usage — varchar(5) — NOT NULL
  • tos_traffic_class — int
  • src_prefix_len — int

CPF_SMF_IP_POOL_INFO

  • cpf_id — int — Primary key — NOT NULL
  • virtual_upf_id — int — Foreign key → CPF_SMF_V_UPF_INFO.virtual_upf_id — NOT NULL
  • start_ip — varchar(39) — NOT NULL
  • end_ip — varchar(39) — NOT NULL
  • prefix_len — int — NOT NULL
  • pool_name — varchar(30)

CPF_SMF_IP_V4_INFO

  • ip_addr_v4 — varchar(15) — Primary key — NOT NULL
  • cpf_id — int — Foreign key → CPF_SMF_IP_POOL_INFO.cpf_id — NOT NULL
  • virtual_upf_id — int — Foreign key → CPF_SMF_IP_POOL_INFO.virtual_upf_id — NOT NULL
  • ipv4_used — char(1) — NOT NULL

CPF_SMF_IP_V6_INFO

  • ip_addr_v6 — varchar(39) — Primary key — NOT NULL
  • cpf_id — int — Foreign key → CPF_SMF_IP_POOL_INFO.cpf_id — NOT NULL
  • virtual_upf_id — int — Foreign key → CPF_SMF_IP_POOL_INFO.virtual_upf_id — NOT NULL
  • ipv6_used — char(1) — NOT NULL

CPF_SMF_NETWORK_SLICE_INFO

  • dnn — varchar(64) — Foreign key → CPF_PLDMGR_DNN.dnn — NOT NULL
  • snssai — varchar(10) — Foreign key → CPF_PLDMGR_SNSSAI.snssai — NOT NULL
  • plmn_id — varchar(6) — Foreign key → CPF_PLDMGR_PLMN.plmn_id — NOT NULL
  • tac — int — Foreign key → CPF_PLDMGR_TAC.tac — NOT NULL
  • virtual_upf_id — int — Foreign key → CPF_SMF_V_UPF_INFO.virtual_upf_id — NOT NULL

CPF_SMF_OPENAPI_EVENT_INFO

  • sqn — bigint unsigned — Primary key — NOT NULL
  • method — tinyint — NOT NULL
  • rule_name — varchar(64) — NOT NULL
  • timestamp — int

CPF_SMF_PCC_RULE_INFO

  • rule_name — varchar(64) — Primary key — NOT NULL
  • app_id — varchar(64)
  • 5qi — int
  • precedence — int
  • mbr_ul — int
  • mbr_dl — int
  • gbr_ul — int
  • gbr_dl (Field) — int
  • flow_status — tinyint — NOT NULL

CPF_SMF_SM_CONTEXT_INFO

  • imsi — varchar(15) — Primary key — NOT NULL
  • pdu_session_id — tinyint — Primary key — NOT NULL
  • smf_sm_context — varchar(12000) — NOT NULL

CPF_SMF_UE_CONTEXT_INFO

  • imsi — varchar(15) — Primary key — NOT NULL
  • smf_ue_context — varchar(9000) — NOT NULL
  • pdu_session_info (pdu_session) — bigint — NOT NULL

CPF_SMF_V_UPF_INFO

  • virtual_upf_id — int — Primary key — NOT NULL
  • rule_name — varchar(64) — Foreign key → CPF_SMF_PCC_RULE_INFO.rule_name — NOT NULL
  • pfcp_ip — varchar(15) — NOT NULL
  • pfcp_server_port — int — NOT NULL
  • pfcp_client_port — int — NOT NULL
  • n3_ip — varchar(15)
  • n6_ip — varchar(15)
  • n9_ip — varchar(15)

CPF_UDM_AMF_UEC_INFO

  • supi — varchar(64) — Foreign key → CPF_UDM_SUBS_INFO.supi — NOT NULL
  • amf_instance_id — varchar(64) — NOT NULL
  • dereg_cb_uri — varchar(128) — NOT NULL
  • plmn_id — varchar(6) — NOT NULL
  • amf_id — varchar(6) — NOT NULL
  • rat_type — tinyint — NOT NULL
  • pei — varchar(64) — NOT NULL
  • ims_vo_ps — tinyint — NOT NULL
  • amf_svc_name_dereg — tinyint — NOT NULL
  • reserved — varchar(16)

CPF_UDM_DNN_INFO

  • dnn — varchar(64) — Foreign key → CPF_PLDMGR_DNN.dnn — NOT NULL
  • default_pdu_session_type — tinyint — NOT NULL
  • allowed_pdu_session_type_list — varchar(32) — NOT NULL
  • 5qi — int — NOT NULL
  • arp_priority_level — int — NOT NULL
  • arp_preempt_cap — tinyint — NOT NULL
  • arp_preempt_vuln — tinyint — NOT NULL
  • session_ambr_ul — int — NOT NULL
  • session_ambr_dl — int — NOT NULL
  • charging_characteristics — varchar(16) — NOT NULL
  • up_security_integrity — tinyint — NOT NULL
  • up_security_confidentiality — tinyint — NOT NULL
  • default_ssc_mode — tinyint — NOT NULL
  • allowed_ssc_mode_list — varchar(32) — NOT NULL
  • reserved — varchar(16)

CPF_UDM_HE_KEY_INFO

  • idx — int — Primary key — NOT NULL
  • private_key_a — varchar(256) — NOT NULL
  • public_key_a — varchar(256) — NOT NULL
  • private_key_b — varchar(256) — NOT NULL
  • public_key_b — varchar(256) — NOT NULL
  • reserved — varchar(16)

CPF_UDM_OPENAPI_EVENT_INFO

  • sqn — bigint unsigned — Primary key — NOT NULL
  • method — tinyint — NOT NULL
  • supi — varchar(64) — NOT NULL
  • timestamp — int

CPF_UDM_SDM_SUBS

  • subs_id — bigint unsigned — Primary key — NOT NULL
  • supi — varchar(64) — Foreign key → CPF_UDM_SUBS_DNN.supi — NOT NULL
  • snssai — varchar(10) — Foreign key → CPF_UDM_SUBS_DNN.snssai — NOT NULL
  • dnn — varchar(64) — Foreign key → CPF_UDM_SUBS_DNN.dnn — NOT NULL
  • nf_instance_id — varchar(64) — NOT NULL
  • nf_type — tinyint — NOT NULL
  • implicit_unsub_flag — enum("TRUE", "FALSE") — NOT NULL
  • expire_time — int — NOT NULL
  • cb_reference — varchar(128) — NOT NULL
  • mon_res_uri_list — varchar(256) — NOT NULL
  • reserved — varchar(16)

CPF_UDM_SMF_UEC_INFO

  • pdu_session_id — tinyint — Primary key — NOT NULL
  • supi — varchar(64) — Foreign key → CPF_UDM_SUBS_DNN.supi — NOT NULL
  • dnn — varchar(64) — Foreign key → CPF_UDM_SUBS_DNN.dnn — NOT NULL
  • snssai — varchar(10) — Foreign key → CPF_UDM_SUBS_DNN.snssai — NOT NULL
  • smf_instance_id — varchar(64)
  • plmn_id — varchar(6)
  • reserved — varchar(16)

CPF_UDM_SNSSAI_DEFAULT_DNN

  • snssai — varchar(10) — Foreign key → CPF_PLDMGR_SNSSAI.snssai — NOT NULL
  • dnn — varchar(64) — Foreign key → CPF_UDM_DNN_INFO.dnn — NOT NULL
  • reserved — varchar(16)

CPF_UDM_SUBS_DEFAULT_SNSSAI

  • supi — varchar(64) — Foreign key → CPF_UDM_SUBS_INFO.supi — NOT NULL
  • snssai — varchar(10) — Foreign key → CPF_PLDMGR_SNSSAI.snssai — NOT NULL
  • reserved — varchar(16)

CPF_UDM_SUBS_DNN

  • supi — varchar(64) — Foreign key → CPF_UDM_SUBS_INFO.supi — NOT NULL
  • snssai — varchar(10) — Foreign key → CPF_PLDMGR_SNSSAI.snssai — NOT NULL
  • dnn — varchar(64) — Foreign key → CPF_UDM_DNN_INFO.dnn — NOT NULL
  • pdu_session_type — tinyint — NOT NULL
  • static_ip_addr_v4 — varchar(15) — NOT NULL
  • static_ip_addr_v6 — varchar(39) — NOT NULL
  • reserved — varchar(16)

CPF_UDM_SUBS_INFO

  • supi — varchar(64) — Primary key — NOT NULL
  • op — varchar(32) — NOT NULL
  • skey — varchar(32) — NOT NULL
  • sqn — bigint unsigned — NOT NULL
  • gpsi — varchar(64) — NOT NULL
  • pei — varchar(64) — NOT NULL
  • ue_ambr_ul — int — NOT NULL
  • ue_ambr_dl — int — NOT NULL
  • rfsp_idx — int — NOT NULL
  • odb_packet_svc — int — NOT NULL
  • subs_reg_timer — int — NOT NULL
  • reserved — varchar(16)

CPF_UDM_TIME_STAMP_INFO

  • time_stamp_type — tinyint — Primary key — NOT NULL
  • time_stamp_value — int
  • description — varchar(64)

PCF_PLDMGR_CALL_TRACE_INFO

  • trace_id — int — Primary key — NOT NULL
  • imsi — varchar(15)
  • timer — int
  • client_id — int

PCF_PLDMGR_CLOUD_LOG_INFO

  • pcf_id — int — Primary key — NOT NULL
  • log_level — int — NOT NULL
  • timestamp_l — bigint — NOT NULL

PCF_PLDMGR_TIME_STAMP_INFO

  • time_stamp_type — tinyint — Primary key — NOT NULL
  • time_stamp_value — int
  • description — varchar(64)

UPF_PLDMGR_CALL_TRACE_INFO

  • trace_id — int — Primary key — NOT NULL
  • imsi — varchar(15)
  • timer — int
  • client_id — int

UPF_PLDMGR_CLOUD_LOG_INFO

  • upf_id — int — Primary key — NOT NULL
  • log_level — int — NOT NULL
  • timestamp_l — bigint — NOT NULL

UPF_PLDMGR_TIME_STAMP_INFO

  • time_stamp_type — tinyint — Primary key — NOT NULL
  • time_stamp_value — int
  • description — varchar(64)