database reference guide
TRANSCRIPT
-
7/24/2019 Database Reference Guide
1/238
ENTERPRISEDatabase Reference Guide
Software Version 5.2.1
Reference Guide Edition 2
-
7/24/2019 Database Reference Guide
2/238
-
7/24/2019 Database Reference Guide
3/238
Copyright 2006 AIRCOM InternationalAll rights reserved
ADVANTAGE, ARCHITECT, ASSET3G, CONNECT, DATASAFE, ENTERPRISE,NEPTUNE, HOMEZONE, OPTIMA, TARGET and WEBWIZARD are recognisedtrademarks of AIRCOM International. Other product names are trademarks of theirrespective companies.
Microsoft Word, Microsoft Office, Windows, Windows 95, Windows 98,Windows NT and MS-DOS are trademarks of the Microsoft Corporation.
This documentation is protected by copyright and contains proprietary andconfidential information. No part of the contents of this documentation may bedisclosed, used or reproduced in any form, or by any means, without the priorwritten consent of AIRCOM International.
Although AIRCOM International has collated this documentation to reflect the
features and capabilities supported in the software products, the company makes nowarranty or representation, either expressed or implied, about this documentation, itsquality or fitness for particular customer purpose. Users are solely responsible for theproper use of ENTERPRISE software and the application of the results obtained.
An electronic version of this document exists.
This User Reference Guide finalised on 19 October 2006.
Refer to the Online Help for more information.
This User Reference Guide prepared by:
AIRCOM International Ltd
Cassini CourtRandalls Research ParkRandalls WayLeatherheadSurreyKT22 7TW
Telephone: +44 (0) 1932 442000Support Hotline: +44 (0) 1932 442345Fax: +44 (0) 1932 442005Web: www.aircominternational.com
-
7/24/2019 Database Reference Guide
4/238
-
7/24/2019 Database Reference Guide
5/238
Database Reference Guide Page iVersion 5.2.1
Contents
Chapter 1 About this ManualOverview of Database Table Definitions............................................................. 1
Primary and Foreign Keys ........................................................................................... 1About Permissions....................................................................................................... 2
Obtaining User Assistance.................................................................................. 2
About the ENTERPRISE User Reference Guides ...................................................... 3Can You Improve Our User Assistance?..................................................................... 4Obtaining Support........................................................................................................ 4Obtaining Further Information and Services................................................................ 6
Chapter 2 Database Table Relationships
Environment Set-up Database Table Relationships (1) ...................................... 8
Environment Set-up Database Table Relationships (2) ...................................... 9
Environment Set-up Database Table Relationships (3) .................................... 10
Environment Set-up Database Table Relationships (4) .................................... 11
Environment Set-up Database Table Relationships (5) .................................... 12
Equipment Database Table Relationships ........................................................ 13
Internal Database Table Relationships ............................................................. 14
Logical Network Database Table Relationships (1) .......................................... 15
Logical Network Database Table Relationships (2) .......................................... 16
Project Database Table Relationships (1)......................................................... 17
Project Database Table Relationships (2)......................................................... 18
Project Database Table Relationships (3)......................................................... 19
Project Database Table Relationships (4)......................................................... 20
Project Database Table Relationships (5)......................................................... 21
ADVANTAGE Database Table Relationships................................................... 22
CONNECT Database Table Relationships (1) .................................................. 23
CONNECT Database Table Relationships (2) .................................................. 24
Chapter 3 Environment Set-Up Database Tables
Table ACTIVEATTRIB ...................................................................................... 29
Table ACTIVEELEMENTS................................................................................ 30
Table ACTIVEFLAGS ....................................................................................... 30
Table ACTIVEOBJECTS................................................................................... 31
Table ACTIVEPOLYGONS............................................................................... 31
Table AICAR ..................................................................................................... 32
-
7/24/2019 Database Reference Guide
6/238
Page ii Database Reference GuideVersion 5.2.1
Table ATTRIBUTETYPES ................................................................................ 32
Table CARLAY.................................................................................................. 32
Table CARLAYAICAR....................................................................................... 33
Table CELLAY .................................................................................................. 33
Table CELLAYCARLAY .................................................................................... 34
Table COORDSYS............................................................................................ 34
Table COORDSYSDATA .................................................................................. 35
Table COVCLASS............................................................................................. 35
Table COVSCHEMA......................................................................................... 35
Table COVTHRESH.......................................................................................... 36
Table ENT_ACTIVELOGON_DATA.................................................................. 36
Table ENT_EVENTLOG_DATA........................................................................ 37
Table ENT_EXCEPTIONLOG........................................................................... 37
Table FILTERS ................................................................................................. 38
Table FLAGASSOCIATIONS............................................................................ 38
Table FLAGGROUPS ....................................................................................... 39
Table FLAGS .................................................................................................... 39
About Fields............................................................................................................... 39
Table FLAGVALUES......................................................................................... 40
Table FREQBAND ............................................................................................ 40
Table FREQCARRIERCONV............................................................................ 41
Table FREQUENCYDIV.................................................................................... 41
Table GRIDCANDIDATES ................................................................................ 42
Table GRIDCONFIG ......................................................................................... 42
Table GRIDCONFIGCELLS.............................................................................. 43
Table GROUPCARRIER................................................................................... 43
Table HEXAGONGRIDS................................................................................... 44
Table HSDPARATE .......................................................................................... 44
Table INTF ........................................................................................................ 45
Table INTFWEIGHTS ....................................................................................... 45
Table LOGICALOPS......................................................................................... 45
Table LOGUMTSCELLRATE............................................................................ 46
Table MAPNAMES............................................................................................ 47
Table MAPVALUES .......................................................................................... 47
Table PATTERN ............................................................................................... 48
Table PATTERNGROUP .................................................................................. 48
Table PROPCLUTTER ..................................................................................... 49
-
7/24/2019 Database Reference Guide
7/238
Database Reference Guide Page iiiVersion 5.2.1
Table PROPMODEL ......................................................................................... 49
Table RULES .................................................................................................... 51
Table RULETYPES........................................................................................... 51
Table SCHEMAMANAGERS ............................................................................ 51
Table SCRIPTEVENTS..................................................................................... 52
Table SCRIPTSTORAGE ................................................................................. 52
Table TERMRATE ............................................................................................ 52
Table TERMTYCELLAY.................................................................................... 53
Table TERMTYCLUTTER................................................................................. 53
Table TERMTYPE............................................................................................. 54
Table TERMTYPOLYGON................................................................................ 56
Table TERMTYVECTOR................................................................................... 56
Table TIMESLOTMAP ...................................................................................... 57
Table VECATTR ............................................................................................... 57
Table VECBOUNDS ......................................................................................... 58
Table VECFILE ................................................................................................. 58
Chapter 4 Equipment Database Tables
Table ANTENNADEVICE.................................................................................. 60
Table ANTENNAPATTERN .............................................................................. 61
Table BCFTYPE................................................................................................ 62
Table BTS ......................................................................................................... 63
Table CABIN ..................................................................................................... 64
Table EQUIPSUPPLIER ................................................................................... 65
Table FEEDER.................................................................................................. 65
Table GENREPEATERFEEDER ...................................................................... 66
Table LOGNODEBTYPE .................................................................................. 67
Table MASTHEADAMP .................................................................................... 69
Table TOWER................................................................................................... 70
Table VHMASK................................................................................................. 71
Chapter 5 Internal Database Tables
Table CELLEQUIPMENT.................................................................................. 75
Table CIBER ..................................................................................................... 75
Table DBCORERFI........................................................................................... 76
Table DBVERSION........................................................................................... 76
Table FIELDSTABLE ........................................................................................ 76
-
7/24/2019 Database Reference Guide
8/238
Page iv Database Reference GuideVersion 5.2.1
Table IDSEQUENCES...................................................................................... 76
Table INTERFWEIGHTS .................................................................................. 77
Table MPFINDEX.............................................................................................. 77
Table PREDFOLDER........................................................................................ 78
Table PREDINDEX ........................................................................................... 78
Table PRIORGROUPS ..................................................................................... 79
Table PRIORGROUPSRM................................................................................ 79
Table PRIORGROUPUSER.............................................................................. 79
Table PRIORGROUPUSERRM........................................................................ 80
Table PRIORUSER........................................................................................... 80
Table PRIORUSERPRIVEX.............................................................................. 81
Table PRIORUSERPRIVEXRM........................................................................ 81
Table PRIORUSERPRIVEXTYPE .................................................................... 82
Table PRIORUSERRM ..................................................................................... 82
Table PRIORUSERTYPE ................................................................................. 83
Table PROJECT ............................................................................................... 83
Table PROJECTREGION ................................................................................. 85
Table REF_COLUMNS ..................................................................................... 86
Table UPFINDEX.............................................................................................. 86
Chapter 6 Logical Network Database Tables
Table LOGATTACHMENT ................................................................................ 89
Table LOGCONNECTION ................................................................................ 89
Table LOGCONNROUTE ................................................................................. 90
Table LOGCONNRTHOP ................................................................................. 91
Table LOGCONNTRAFFIC............................................................................... 91
Table LOGLUMC .............................................................................................. 92
Table LOGNETWORK ...................................................................................... 93
Table LOGNODE .............................................................................................. 93
Table LOGNODEB............................................................................................ 94
Table LOGNODELMU....................................................................................... 95
Table LOGNODETRAFFIC............................................................................... 97
Table LOGNODETYPE..................................................................................... 98
Table LOGPLMN............................................................................................... 98
Table LOGRNC................................................................................................. 99
Table LOGUMTSANTENNA ............................................................................. 99
Table LOGUMTSCAR..................................................................................... 100
-
7/24/2019 Database Reference Guide
9/238
Database Reference Guide Page vVersion 5.2.1
Table LOGUMTSCELL ................................................................................... 102
Table LOGUMTSFEEDER.............................................................................. 106
Table SRVCELLBITPRIOR............................................................................. 107
Table SRVCELLPRIOR .................................................................................. 108
Table TGBITRATE.......................................................................................... 108
Table TGCARRIER......................................................................................... 111
Table TGCARRIERADJ .................................................................................. 112
Table TGCLUTPATHLOSS............................................................................. 113
Table TGRESTYPE ........................................................................................ 113
Table TGSERVBIT.......................................................................................... 114
Table TGSERVICE ......................................................................................... 114
Table TGSHOG............................................................................................... 116
Table TGTERMSERV ..................................................................................... 117
Table UMTSCODE.......................................................................................... 117
Table UMTSCODESCHEMA .......................................................................... 118
Chapter 7 Project Database Tables
Table ANTENNA............................................................................................. 122
Table ATTACHMENTS ................................................................................... 123
Table BACKTOBACKANTENNA..................................................................... 124
Table BCF....................................................................................................... 125
Table BSC....................................................................................................... 125
Table CARLAYDATA ...................................................................................... 126
Table CARRIERS............................................................................................ 127
About States in the CARRIERS Table..................................................................... 128
Table CELLAYDATA....................................................................................... 128
Table CELLEXCEPT....................................................................................... 131
Table CELLSITES........................................................................................... 131
Table CIXLAT.................................................................................................. 133
Table CLDANTENNA...................................................................................... 133
Table COMPOUNDARRAYEXP ..................................................................... 134
Table COMPOUNDARRAYTERMS................................................................ 135
Table CONTACTPERSON.............................................................................. 136
Table DISTRIBUTION..................................................................................... 136
Table FAXNUMBER........................................................................................ 137
Table FOLDERS ............................................................................................. 138
Table GENERICNBR ...................................................................................... 138
-
7/24/2019 Database Reference Guide
10/238
Page vi Database Reference GuideVersion 5.2.1
Table GENREPEATER................................................................................... 139
Table GRAPH ................................................................................................. 139
Table GRAPHLIST.......................................................................................... 140
Table GSMCELL............................................................................................. 140
Table HDRDLKPARAMS ................................................................................ 142
Table IS95CARRIER....................................................................................... 143
Table LOGIS95ANTENNA .............................................................................. 144
Table LOGIS95BS .......................................................................................... 145
Table LOGIS95BSC........................................................................................ 146
Table LOGIS95CAR........................................................................................ 146
Table LOGIS95CLSITE................................................................................... 147
Table LOGIS95CLUSTER .............................................................................. 147
Table LOGIS95FEEDER................................................................................. 148
Table LOGIS95MSC ....................................................................................... 149
Table LOGIS95SECCAR................................................................................ 149
Table LOGIS95SECTOR ................................................................................ 153
Table MSC ...................................................................................................... 154
Table PHONENUMBER.................................................................................. 155
Table PLMN .................................................................................................... 155
Table REPEATER........................................................................................... 155
Table REPEATERCELL.................................................................................. 157
Table SIMTRAF .............................................................................................. 158
Table SITEADDRESS..................................................................................... 159
Table TERMMOBSPEED................................................................................ 160
Table VECPROJECT...................................................................................... 161
Chapter 8 ADVANTAGE Database Tables
Table ACTIONCOMBINATIONS..................................................................... 165
Table ACTIVECONFIG ................................................................................... 166
Table ADVDESTGT ........................................................................................ 166
Table ADVGLOBCONSTR.............................................................................. 167
Table ADVGLOBDESTGT .............................................................................. 168
Table ADVOPTIPROFILE............................................................................... 168
Table ADVPROBCELLWGT ........................................................................... 169
Table CELLMOD............................................................................................. 170
Table CLUTCONS .......................................................................................... 170
Table CLUTTERT ........................................................................................... 171
-
7/24/2019 Database Reference Guide
11/238
Database Reference Guide Page viiVersion 5.2.1
Table CLUTTHRES......................................................................................... 172
Table CONFIGPROFILE................................................................................. 173
Table COSTCONVCOEFFICIENTS................................................................ 173
Table COSTFUNCTIONWEIGHTS................................................................. 174
Table CPVECTOR .......................................................................................... 175
Table DBVERSION......................................................................................... 175
Table DESIGNTARGET.................................................................................. 176
Table DESIGNTARGETATOM........................................................................ 176
Table DESIGNTARGETCOMP ....................................................................... 177
Table DESIGNTARGETGROUP..................................................................... 178
Table MAXACTIONCONSTRAINTS ............................................................... 178
Table OPTIMISATIONDETAILS...................................................................... 179
Table OPTIMISATIONSNAPSHOT................................................................. 180
Table OPVECTOR.......................................................................................... 180
Table PEDATAINDEX..................................................................................... 181
Table PLANREJECTIONOPTNS .................................................................... 182
Table PROBAREAID....................................................................................... 182
Table PROBCELLID ....................................................................................... 183
Table SIMCONFIG.......................................................................................... 184
Table STATISTIC............................................................................................ 185
Table STATISTICMC ...................................................................................... 186
Table THRESHOLD........................................................................................ 187
Table THRESHOLD_PT ................................................................................. 187
Table VECTORT............................................................................................. 188
Chapter 9 CONNECT Database Tables
Table AMPSBTSROUTE ................................................................................ 191
Table BAND .................................................................................................... 191
Table CARRIERFEED .................................................................................... 192
Table CHANNEL............................................................................................. 193
Table CIOBJ.................................................................................................... 193
Table CIOBJENTRY ....................................................................................... 194
Table GSMBTSROUTE .................................................................................. 194
Table LINK ...................................................................................................... 194
Table LINKATTACH........................................................................................ 198
Table LINKENDANTENNA ............................................................................. 198
Table LINKENDFEED..................................................................................... 199
-
7/24/2019 Database Reference Guide
12/238
Page vii i Database Reference GuideVersion 5.2.1
Table LINKTEMPRANGE ............................................................................... 200
Table LINKTERMEQUIP................................................................................. 200
Table LINKTYPE............................................................................................. 201
Table LINKUDH .............................................................................................. 202
LINKUDPROF................................................................................................. 202
Table MWANTENNATYPE ............................................................................. 203
Table MWMASK.............................................................................................. 204
Table PMPCARRIER ...................................................................................... 205
Table PMPHUB............................................................................................... 208
Table PMPHUBLINKEND ............................................................................... 209
Table PMPSECTOR ....................................................................................... 210
Table PRLINKEND.......................................................................................... 211
Table PRLLINK ............................................................................................... 211
Table PRLREF................................................................................................ 212
Table PTPLINKEND........................................................................................ 212
Table RADIOEQUIP........................................................................................ 216
Table RADIOMASK......................................................................................... 219
Table REFLECTOR ........................................................................................ 219
Table SECTORANTENNA .............................................................................. 220
Table SPLITTER............................................................................................. 221
Table SPURLINK ............................................................................................ 222
Table SPURREF............................................................................................. 222
Chapter 10 About Difference Tables
Permissions in Difference Tables.................................................................... 224
Index
-
7/24/2019 Database Reference Guide
13/238
Database Reference Guide Page 1Version 5.2.1
About this Manual
This Reference Guide describes the database tables in the ENTERPRISE database forversion 5.2.1, based on Build 13.
In This SectionOverview of Database Table Definitions 1Obtaining User Assistance 2
Overview of Database Table Definitions
The tables in the core database are divided into two distinct groups:
The master tables which store data available to all users
The difference tables which store information relating to user-specific changes
This chapter gives reference information on the separate database tables available inthe core database.
Important :Information about the DIRECT database is proprietary. For any queries youmay have, please contact Product Support.
Primary and Foreign Keys
The primary key is a column, or set of columns, whose values uniquely identify everyrow in a table.
A foreignkey is one or more columns within a table whose values are based on thoseof the primary key from another table. The foreign key relates the information fromanother table (the foreign table) to information in the current (referenced or primary)table.
If a foreign key is allowed to have a NULL value, it is said to be optional.
A foreign key that is not optional is called mandatory. Most foreign and primary keysare mandatory.
Note :Projectno is always part of the foreign key, so is not indicated as suchthroughout the database tables.
C H A P T E R 1
-
7/24/2019 Database Reference Guide
14/238
Page 2 Database Reference GuideVersion 5.2.1
About Permissions
Tables in the database for BSCs, MSCs, distribution nodes, Properties, repeaters andcell sites have a Permissions field. This contains a three digit code that grants theread/write privileges to the relational database as follows:
The first digit of the code is specific to the user
The second digit relates to that user's default group
The third digit relates to all available users in that project
Each digit extends from 0 to 2 inclusive, with 0 or 1 providing Read privileges and 2representing all permissions, that is Read and Write.
You set user permissions in Administrator, either when you first create a user or bychanging the properties of an existing user. For information on how to do this, see the
Installation and AdministrationGuide.
Obtaining User Assistance
Using Online Help
ENTERPRISE products come with a complete system of online Help which you canaccess in three ways:
From the Help menu, click Help Contents. Scroll through the table of contents andchoose a relevant topic to display.
To search for something particular, from the Help menu, click Help Contents andusing the Index tab or Find tab, type in a letter or word to start searching forrelevant topics.
Press F1 in a dialog box to view context-sensitive help (available for most dialogboxes).
Using ENTERPRISE User Reference Guides
If you prefer to read User Reference Guides, we also provide these. To view or printthese as PDFs (Adobe Acrobat portable document format):
1 Make sure you have Adobe Acrobat Reader installed on your PC. If you do nothave this, you can install it from the ENTERPRISE CD, or get it from the Adobewebsite.
Note :Adobe and Acrobat are trademarks of Adobe Systems, Incorporated.
2 Navigate to the Docs folder in the location where you installed the product.
3 If this folder does not exist or is empty, modify your ENTERPRISE installationnow and choose to install them. To do this:
From the Control Panel, double-click Add/Remove Programs.
In the list of items, choose the correct version of ENTERPRISE and click the
Change/Remove button.
-
7/24/2019 Database Reference Guide
15/238
Database Reference Guide Page 3Version 5.2.1
When prompted, select Modify then click Next twice until you are on theSelect Components page of the installation wizard.
Ensure that the documentation you require is selected.
4 When installed, in the Docs folder, double-click the PDF file that you want toopen.
5 Please always check the back of the manuals for any addenda or errata.
Tip : You can also download the latest User Reference Guides from our website.
Checking Release Notes
Each release of the ENTERPRISE software is accompanied by Release Notes, givingimportant information on system requirements, installation, known issues, upgradesand so on. These notes are included in the ENTERPRISE CD, or you can downloadthem from our website.
For any further documentation, such as application notes and extra referenceinformation, please email the support team at the address described in ObtainingSupport on page 4.
About the ENTERPRISE User Reference Guides
This table describes our range of User Reference Guides:
This Guide Contains Information On
What's New The main difference between the latest versions of the ENTERPRISEsuite.
ENTERPRISE Installationand AdministrationGuide Installing and configuring ENTERPRISE, your network, and Oracledatabases. Using Administrator to create users and groups, and setpermissions.
Also contains information on software licensing.
ENTERPRISE User Reference Functionality that is common to more than one of the products in theENTERPRISE suite, including how to access, view, edit and store data.
Also contains reference information about file formats.
ENTERPRISE Database Reference The relationships between tables in the database and the contents of eachtable.
ADVANTAGE User Reference Using ADVANTAGE to plan and optimise networks automatically, considermeasured data in analysis/optimisation, analyse network performance,identify problematic areas/cells, and more.
ARRAYWIZARD User Reference Using ARRAYWIZARD to automatically generate coverage predictions andbest server arrays, which gives you instantaneous display of coverage andinterference information for pre-selected filters when loaded intoASSET3G.
ASSET3G User Reference Using ASSET3G, the network planning and analysis tool, to design a rangeof 2g and 3g networks.
Includes information on hierarchical network planning, propagationmodelling, service and bearer definition, coverage analysis, traffic planning,neighbour planning, frequency planning, CW data analysis, detailedreporting, analysis arrays and simulation of network performance.
ASSET3G Technical Reference A separate technical reference for ASSET3G, which contains a list of arraydescriptions and information on many of the algorithms used.
-
7/24/2019 Database Reference Guide
16/238
Page 4 Database Reference GuideVersion 5.2.1
This Guide Contains Information On
CONNECT User Reference Using CONNECT, the network transmission and microwave link planningsoftware for full network physical link design and logical link design.
Also contains CONNECT-specific reference information.
DATASAFE User Reference Using DATASAFE, our network configuration tool to implement both smalland large scale changes to networks
DIRECT User Reference Using DIRECT to design telecommunications networks of different networklayers. Explains how to plan cellular, PSTN and data networks at a bothgeneral and strategic level.
Also contains DIRECT-specific reference information.
NEPTUNE User Reference Using NEPTUNE to collect, import and analyse testmobile data and usingthe optional module, PROBE for additional analysis.
Also contains reference information on NEPTUNE file formats.
OPTIMA User Reference Using OPTIMA to view performance data and statistics both withENTERPRISE and standalone using OPTIMA Lite.
RANOPT User Reference Using RANOPT to efficiently find faults in your network, optimise andvalidate its performance prior to commercial launch.
TARGET User Reference Using TARGET as an administrator to design forms, Gantt charts andreports. Using TARGET to view and edit information about your networkand its roll out.
Also contains TARGET reference information.
WEBWIZARD User Reference Using WEBWIZARD to display GIS and report information of network data,including creating layers, regions, nodes, layer types, administering andconfiguring the system and using the GIS view, explorer and reportviewers.
Can You Improve Our User Assistance?
We are always trying to improve the online Help and User Reference Guides. If youcannot find the Help you were looking for, need more information, or have anysuggestions for improvements, we would be grateful for your feedback.
Online Questionnaire
You can help us by completing our brief online questionnaire(http://tinyurl.com/kdg6e).
Alternatively, you can contact us directly at [email protected].
Obtaining Support
If you have a difficulty you cannot resolve yourself using the online Help orReference Guides, or you have found a possible fault in the software, you can log asupport request as described below. You may also wish to contact us if you want to:
Register for a customer web account to access the Support area
Obtain further documentation, such as application notes and extra referenceinformation
-
7/24/2019 Database Reference Guide
17/238
Database Reference Guide Page 5Version 5.2.1
Logging Support Requests Online
To log a support request online:
1 Go to the AIRCOM website, at www.aircominternational.com.2 Click the link to Support.
3 Log in, using your customer web account username and password.
4 In the Technical Support pane, click Online Helpdesk System.
5 Click Log New.
6 Enter the details of your request, and then click Log.
Contacting us via Telephone or Email
If you wish to contact us directly, here are the contact details of our regional offices:Locati on Regional Office Contact Details
Europe United Kingdom Tel : +44 (0) 1932 442345Fax :+44 (0) 1932 442005
Sweden [email protected]
France [email protected]
Italy [email protected]
Germany [email protected]
Belgium [email protected] East, Africa and Central Asia United Arab Emirates Tel : +971 4 391 2642
Fax :+971 4 391 8660
South Africa Tel : +27 11 3243600Fax : +27 11 7848027
Americas Mexico [email protected]
USA Tel : +1 866 207 8083Fax : +1 214 360 7241
[email protected] Tel : +55 12 3941-2199
Fax : +55 12 3911-3727
Asia and Oceania Australia [email protected]
Singapore [email protected]
China [email protected]
Taiwan [email protected]
India [email protected]
-
7/24/2019 Database Reference Guide
18/238
Page 6 Database Reference GuideVersion 5.2.1
When contacting us with a support query, it would help us if you:
Give us as much information as possible about the problem and the context inwhich it occurred
State the version and build you are using Have all the details of your query to hand
Are logged into the ENTERPRISE application
Can send extracts of your data sets if we need them to reproduce your problem
Obtaining Further Information and Services
As well as comprehensive online Help and User Reference Guides and dedicatedProduct Support, AIRCOM additionally provides:
Online Knowledgebase of Articles
If you register for a customer web account, you can view our searchable technicaldatabase in the Product Support section of the AIRCOM website. ThisKnowledgebase contains articles created by our support professionals who haveresolved issues for our customers, and is constantly updated, expanded, and refinedto ensure that you have access to the very latest information.
Power Tools
If you register for a customer web account, you can download from a selection of
useful power tools, such as file conversion utilities.
Latest Copies of the User Reference Guides
If you register for a customer web account, you can download the latest UserReference Guides PDFs from our website. If you do this, please check the back of theUser Reference Guides for any additions or corrections.
Consultancy Services
AIRCOM also provide full radio consultancy services in Network Audits, Business
Planning Support, Licence Applications, Radio Network Planning,Telecommunications Research and System Modelling and Propagation Analysis andModelling.
Training
There is a wide variety of courses run by AIRCOM. These courses range from tooltraining to technology training. For details, contact Competence DevelopmentSolutions ([email protected]).
-
7/24/2019 Database Reference Guide
19/238
Database Reference Guide Page 7Version 5.2.1
Database TableRelationships
This chapter shows the relationships between tables found in ENTERPRISE, describedin the following diagrams.
The direction of the arrows describes the way the tables are referenced.
In This Section
Environment Set-up Database Table Relationships (1) 8Environment Set-up Database Table Relationships (2) 9Environment Set-up Database Table Relationships (3) 10Environment Set-up Database Table Relationships (4) 11Environment Set-up Database Table Relationships (5) 12Equipment Database Table Relationships 13
Internal Database Table Relationships 14Logical Network Database Table Relationships (1) 15Logical Network Database Table Relationships (2) 16Project Database Table Relationships (1) 17Project Database Table Relationships (2) 18Project Database Table Relationships (3) 19Project Database Table Relationships (4) 20Project Database Table Relationships (5) 21ADVANTAGE Database Table Relationships 22CONNECT Database Table Relationships (1) 23CONNECT Database Table Relationships (2) 24
C H A P T E R 2
-
7/24/2019 Database Reference Guide
20/238
Page 8 Database Reference GuideVersion 5.2.1
Environment Set-up Database Table Relationships (1)
This diagram shows relationships between the environment set-up database tables:
Environment Set-up Database Tables
-
7/24/2019 Database Reference Guide
21/238
Database Reference Guide Page 9Version 5.2.1
Environment Set-up Database Table Relationships (2)
This diagram shows relationships between the environment set-up database tables:
Environment Set-up Database Tables
-
7/24/2019 Database Reference Guide
22/238
Page 10 Database Reference GuideVersion 5.2.1
Environment Set-up Database Table Relationships (3)
This diagram shows relationships between the environment set-up database tables:
Environment Set-up Database Tables
-
7/24/2019 Database Reference Guide
23/238
Database Reference Guide Page 11Version 5.2.1
Environment Set-up Database Table Relationships (4)
This diagram shows relationships between the environment set-up database tables:
Environment Set-up Database Tables
-
7/24/2019 Database Reference Guide
24/238
Page 12 Database Reference GuideVersion 5.2.1
Environment Set-up Database Table Relationships (5)
This diagram shows relationships between the environment set-up database tables:
Environment Set-up Database Tables
-
7/24/2019 Database Reference Guide
25/238
Database Reference Guide Page 13Version 5.2.1
Equipment Database Table Relationships
This diagram shows the relationships between the equipment database tables:
Equipment Database Tables
-
7/24/2019 Database Reference Guide
26/238
Page 14 Database Reference GuideVersion 5.2.1
Internal Database Table Relationships
This diagram shows the relationships between the internal database tables:
Internal Database Tables
-
7/24/2019 Database Reference Guide
27/238
Database Reference Guide Page 15Version 5.2.1
Logical Network Database Table Relationships (1)
This diagram shows the relationships between the logical network database tables:
Logical Network Database Tables
-
7/24/2019 Database Reference Guide
28/238
Page 16 Database Reference GuideVersion 5.2.1
Logical Network Database Table Relationships (2)
This diagram shows the relationships between the logical network database tables:
Logical Network Database Table Relationships
-
7/24/2019 Database Reference Guide
29/238
Database Reference Guide Page 17Version 5.2.1
Project Database Table Relationships (1)
This diagram shows relationships between the project database tables:
Project Database Tables
-
7/24/2019 Database Reference Guide
30/238
Page 18 Database Reference GuideVersion 5.2.1
Project Database Table Relationships (2)
This diagram shows relationships between the project database tables:
Project Database Tables
-
7/24/2019 Database Reference Guide
31/238
Database Reference Guide Page 19Version 5.2.1
Project Database Table Relationships (3)
This diagram shows relationships between the project database tables:
Project Database Tables
-
7/24/2019 Database Reference Guide
32/238
Page 20 Database Reference GuideVersion 5.2.1
Project Database Table Relationships (4)
This diagram shows relationships between the project database tables:
Project Database Tables
-
7/24/2019 Database Reference Guide
33/238
Database Reference Guide Page 21Version 5.2.1
Project Database Table Relationships (5)
This diagram shows relationships between the project database tables:
Project database tables
-
7/24/2019 Database Reference Guide
34/238
Page 22 Database Reference GuideVersion 5.2.1
ADVANTAGE Database Table Relationships
This diagram shows the relationships between the ADVANTAGE database tables:
ADVANTAGE Database Tables
-
7/24/2019 Database Reference Guide
35/238
Database Reference Guide Page 23Version 5.2.1
CONNECT Database Table Relationships (1)
This diagram shows relationships between the CONNECT database tables:
CONNECT Database Tables
-
7/24/2019 Database Reference Guide
36/238
Page 24 Database Reference GuideVersion 5.2.1
CONNECT Database Table Relationships (2)
This diagram shows relationships between the CONNECT database tables:
CONNECT Database Tables
-
7/24/2019 Database Reference Guide
37/238
Database Reference Guide Page 25Version 5.2.1
Environment Set-UpDatabase Tables
The following table describes the environment set-up database tables:This Table Stores Information On Primary Keys Foreign Keys
(projectno + ...)DiffTable?
ACTIVEATTRIB The active attributes used in user-defined filters.
activeattributekey
pickedobjectkey
projectno
FK1 - filterkey
FK2 - rulekey
YES
ACTIVEELEMENTS The active elements used in user-defined filters.
elementtypekey
filterkey
projectno
rulekey
FK1 - filterkey
FK2 - rulekey
YES
ACTIVEFLAGS The active fields used in user-definedfilters.
filterkey
flaggroupkey
flagkey
projectno
rulekey
FK1 - filterkey
FK2 - flaggroupkey
FK3 - rulekey
YES
ACTIVEOBJECTS The active objects used in user-definedfilters.
elementtypekey
filterkey
objectkey
projectno
FK1 - filterkey YES
ACTIVEPOLYGONS The active polygons used in user-defined filters.
featid
filterkey
guidfield
polygonkey
projectno
rulekey
FK1 - filterkey
FK2 - rulekey
YES
AICAR The available carriers defined in theCarrier Layers dialog box.
carriernumber
projectno
NO
ATTRIBUTETYPES The attribute types used in user-defined
filters.
attributetypekey NO
C H A P T E R 3
-
7/24/2019 Database Reference Guide
38/238
Page 26 Database Reference GuideVersion 5.2.1
This Table Stores Information On Primary Keys Foreign Keys(projectno + ...)
DiffTable?
CARLAY The carrier layers defined in the CarrierLayers dialog box.
carlaykey
projectno
FK1 - freqbandkey YES
CARLAYAICAR The carriers associated with eachcarrier layer defined in the CarrierLayers dialog box.
carlaykey
carriernumber
projectno
FK1 -carriernumber
YES
CELLAY The cell layers defined in the CellLayers dialog box.
cellaykey
projectno
YES
CELLAYCARLAY The relationship between the carrierlayers and cell layers.
carlaykey
cellaykey
projectno
FK1 - carlaykey
FK2 - cellaykey
YES
COORDSYS The datums, groups, units and co-ordinate systems used in the mapprojections.
projectno NO
COORDSYSDATA The BLOB record, containing the entireco-ordinate system file.
NO
COVCLASS The coverage classes defined in theCell Layer dialog box. These applyglobally to the system, and store thename and colour of each of the classes.
covclasskey
projectno
NO
COVSCHEMA The user and system coverageschemas created.
covshemakey
projectno
NO
COVTHRESH The thresholds for each coverage class.There are arranged on each cell layer
for different achieved coverages.
covthreshkey
projectno
NO
ENT_ACTIVELOGON_DATA The active connections to the database. sessionid
usrkey
NO
ENT_EVENTLOG_DATA Events in projects. NO
ENT_EXCEPTIONLOG Errors/exception that are logged. NO
FILTERS The names, types and attributes offilters defined in projects.
filterkey
projectno
YES
FLAGASSOCIATIONS The field groups available for differentelement types.
elementtypekey
flaggroupkey
projectno
FK1 - flaggroupkey NO
FLAGGROUPS The available field groups, defined inthe Field Editor dialog box.
flaggroupkey
projectno
NO
FLAGS The available fields, defined in the FieldEditor dialog box.
flaggroupkey
flagkey
projectno
FK1 - flaggroupkey NO
FLAGVALUES The field settings of each object. elementtypekey
flaggroupkey
objectkey
projectno
FK1 - flaggroupkey
FK2 - flaggroupkey+ flagkey
YES
-
7/24/2019 Database Reference Guide
39/238
Database Reference Guide Page 27Version 5.2.1
This Table Stores Information On Primary Keys Foreign Keys(projectno + ...)
DiffTable?
FREQBAND The frequency bands used in theproject.
freqbandkey
projectno
NO
FREQCARRIERCONV The conversion formulas used to extractthe uplink and downlink frequenciesfrom the appropriate ARFCNs. Afrequency band can use differentconversion formulas for different rangesof carriers.
freqbandkey
freqconversionkey
projectno
FK1 - freqbandkey NO
FREQUENCYDIV The frequency diversity hopping gainvalues.
freqhopcars
projectno
NO
GRIDCANDIDATES The candidate details for Properties. addressfk
candidatepk
projectno
FK1 - addressfk YES
GRIDCONFIG The grid settings, including themeasurement units.
configpk
projectno
YES
GRIDCONFIGCELLS The grid settings for the cells. configcellpk
configfk
projectno
FK1 - configfk YES
GROUPCARRIER The carriers associated with afrequency reuse group in a particularpattern, defined in the Group dialogbox.
carriernumber
groupkey
projectno
YES
HEXAGONGRIDS The available hexagon radii defined in
the Hexagon Radii dialog box.
gridkey
projectno
YES
HSDPARATE HSDPA coding rates. hsdparatekey
projectno
NO
INTF Not used. intfkey
projectno
NO
INTFWEIGHTS Not used. intfkey
intflevel
projectno
NO
LOGICALOPS The logical operators used in the user-
defined filters.
logicalopkey
projectno
FK1 - filterkey YES
LOGUMTSCELLRATE Associations between UMTS cells andHSDPA rates.
hsdparatefk
logumtscellfk
projectno
FK1 - hsdparatefk
FK2 - logumtscellfk
YES
MAPNAMES Channel to transceiver maps defined inthe Channel Maps dialog box.
mapkey
projectno
NO
MAPVALUES The way in which channels areorganised on the carriers in the ChannelMaps dialog box.
projectno FK1 - mapkey NO
PATTERN The frequency reuse structure, definedin the Groups dialog box.
patternkey
projectno
FK1 -carrierlayerkey
YES
-
7/24/2019 Database Reference Guide
40/238
Page 28 Database Reference GuideVersion 5.2.1
This Table Stores Information On Primary Keys Foreign Keys(projectno + ...)
DiffTable?
PATTERNGROUP The allocation of carriers to the variousfrequency groups in a particular pattern,defined in the Groups dialog box.
groupkey
patternkey
projectno
FK1 - patternkey YES
PROPCLUTTER The clutter entries and settingsassociated with each of the modelsdefined in the Propagation ModelEditor.
clutterval
modelkey
projectno
FK1 - modelkey YES
PROPMODEL The propagation models and theirsettings created in each project.
modelkey
projectno
YES
RULES The rules used in user-defined filters. projectno
rulekey
FK1 - filterkey
FK2 - logicalopkey
YES
RULETYPES The rule types used in user-definedfilters.
ruletypekey NO
SCHEMAMANAGERS The schema managers. classid NO
SCRIPTEVENTS The events stored in database scripts. lognodetypekey
projectnumber
scriptkey
FK1 -lognodetypekey
FK2 - scriptkey
NO
SCRIPTSTORAGE The database scripts. scriptkey NO
TERMRATE Associations between terminal typesand HSDPA rates.
hsdparatefk
projectno
termtypefk
FK1 - hsdparatefk
FK2 - termtypefk
YES
TERMTYCELLAY The relationship between the cell layersand terminal types, defined in theTerminal Types dialog box.
cellaykeyprojectno
termtypekey
FK1 - termtypekeyFK2 - cellaykey
YES
TERMTYCLUTTER The amount of traffic and weightings forthe clutter classes defined in theTerminal Types dialog box.
code
projectno
termtypekey
FK1 - termtypekey YES
TERMTYPE The available terminal types. projectno
termtypekey
YES
TERMTPOLYGON The amount of traffic spread in theprojects' polygons. The traffic can be
spread by using a weighting value or anErlang value.
code
featidguidfield
projectno
termtypekey
FK1 - termtypekey YES
TERMTYVECTOR The amount of traffic spread along theprojects' vectors. The traffic can bespread by using a weighting value or anErlang value.
code
featid
guidfield
projectno
termtypekey
FK1 - termtypekey YES
TIMESLOTMAP The timeslot maps defined for links inthe Link Database. projectnotimeslotmapkey
NO
-
7/24/2019 Database Reference Guide
41/238
Database Reference Guide Page 29Version 5.2.1
This Table Stores Information On Primary Keys Foreign Keys(projectno + ...)
DiffTable?
VECATTR Vector attributes and segments. attrid
segid
vecid
NO
VECBOUNDS The vectors in the project. vecid NO
VECFILE The location of the vector file. filename
vecid
NO
Table ACTIVEATTRIB
This table shows the column list:
Name DataType Constraint Descript ion
activeattributekey number Not null Primary key, storing a unique number for each active attribute inthe database.
attributenum number Not null Indicates the type of active attribute. A unique number will bestored for each parameter in the Site Database.
bool number Indicates whether the active attribute is boolean (1) or not (0).
carlayerid varchar2(128) Identifies the carrier layer.
cellayerid varchar2(128) Identifies the cell layer.
elementtypekey number Stores a unique number for each element type in the database.
filterkey number Not null Stores a unique number for each filter in the database.
modifyuser number Not null Stores a number indicating the last user who made changes to thetable.
numberA float If the active attribute is a number (or a range), this field is thenumber 1 on the Rules Definition page of the Filter Wizard.
numberB float If the active attribute is a range, this field is number 2 on the RulesDefinition page of the Filter Wizard.
objectkey number If a list is being used for the active attribute, identifies each object inthe list.
pickedobjectkey number Not null Primary key, storing a number each picked object if a pick-list isbeing used for the active attribute.
projectno number Not null Primary key, storing a unique number for each project in a
database.
rulekey number Not null Stores a number for each rule in the database.
string varchar2(255) If the active attribute is a string, contains the string value.
Foreign keys:
FK1 (projectno + filterkey) references the FILTERS table
FK2 (projectno + rulekey) references the RULES table
-
7/24/2019 Database Reference Guide
42/238
Page 30 Database Reference GuideVersion 5.2.1
Table ACTIVEELEMENTS
This table shows the column list:
Name DataType Constraint Descript ion
elementtypekey number Not null Primary key storing a unique number for each element type in adatabase.
filterkey number Not null Primary keystoring a unique number for each filter in thedatabase.
modifyuser number Not null Stores a number indicating the last user who made changes to thetable.
projectno number Not null Primary key, storing a unique number for each project in adatabase.
rulekey number Not null Primary key storing a unique number for each rule in thedatabase.
Foreign Keys:
FK1 (projectno + filterkey) references the FILTERS table
FK2 (projectno + rulekey) references the RULES table
Table ACTIVEFLAGS
This table shows the column list:
Name DataType Constraint Descript ion
filterkey number Not null Primary keystoring a unique number for each filter in thedatabase.
flaggroupkey number Not null Primary keystoring a unique number for each field group in thedatabase.
flagkey number Not null Primary keystoring a unique number for each field in thedatabase.
modifyuser number Not null Stores a number indicating the last user who made changes to thetable.
number1 float Contains the minimum field value.
number2 float Contains the maximum field value.
projectno number Not null Primary key, storing a unique number for each project in adatabase.
rulekey number Not null Primary keystoring a unique number for each rule in thedatabase.
string varchar2 (32) If the active field is a string, stores the string value.
Foreign Keys:
FK1 (projectno + filterkey) references the FILTERS table
FK2 (projectno + flaggroupkey) references the FLAGGROUPS table
FK3 (projectno + rulekey) references the RULES table
-
7/24/2019 Database Reference Guide
43/238
Database Reference Guide Page 31Version 5.2.1
Table ACTIVEOBJECTS
This table shows the column list:
Name DataType Constraint Descript ion
elementtypekey number not null Primary keythat stores a unique number for each element type inthe database.
filterkey number not null Primary keystoring a unique number for each filter in the database.
modifyuser number not null Stores a number indicating the last user who made changes to thetable.
objectkey number not null Primary keystoring a unique number for each object defined in thedatabase.
projectno number not null Primary key, storing a unique number for each project in a database.
Foreign Keys:
FK1 (projectno + filterkey) references the FILTERS table
Table ACTIVEPOLYGONS
This table shows the column list:
Name DataType Constraint Descript ion
featid number not null Primary key, used in conjunction with the guidfield to describethe polygon.
filterkey number not null Primary keystoring a unique number for each filter in thedatabase.
guidfield varchar2(48) not null Primary key, used in conjunction with the featid to describe thepolygon.
modifyuser number not null Stores a number indicating the last user who made changes tothe table.
polygonkey number not null Primary keystoring a unique number for each polygon in thedatabase.
projectno number not null Primary key, storing a unique number for each project in adatabase.
rulekey number not null Primary keythat stores a number for each rule in the database.
Foreign Keys:
FK1 (projectno + filterkey) references the FILTERS table
FK2 (projectno + rulekey) references the RULES table
-
7/24/2019 Database Reference Guide
44/238
Page 32 Database Reference GuideVersion 5.2.1
Table AICAR
This table shows the column list:
Name DataType Constraint Descript ion
carriernumber number not null Primary keythat stores the Absolute Radio Frequency ChannelNumber (ARFCN) available to the project.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Table ATTRIBUTETYPES
This table shows the column list:
Name DataType Constraint Descript ionattributetypekey number not null Primary keyused to identify attribute types in the database.
attributetypeid varchar2(32) not null Identifies the attribute type.
Table CARLAY
This table shows the column list:
Name DataType Constraint Descript ion
abbreviation varchar2(32) Stores an abbreviation for each carrier layer.
carlaykey number not null Primary key, storing a unique number for each carrier layer in theCarriers dialog box.
colourcode number Indicates whether SAT(0), DCC (1) or DVCC (2) is used on thecarrier layers.
Note :Available in AMPS/TDMA networks only.
createdate date The date when the object was created.
createuser number Stores a number indicating the user who created the object.Thenumber is based on the order users were created in.
freqbandkey number Indicates the particular frequency band associated with each carrierlayer.
Idname varchar2(32) Lists the names of all carrier layers.
maxcarriers number The maximum number of carriers associated with each carrierlayer.
modifydate date The date when the object was last modified.
modifyuser number not null Stores a number indicating the last user who made changes to thetable.
permission number Three digit code that provides the permissions for the user, thedefault group they belong to and all other users. For moreinformation on this, see About Permissions on page 2.
projectno number not null Primary key, storing a unique number for each project in adatabase.
type number Indicates the state of the carrier layer data - either traffic layer (0),
control layer (1) or MA list (2).
usereusepattern number Indicates whether to reuse a pattern (1) or not (0).
-
7/24/2019 Database Reference Guide
45/238
Database Reference Guide Page 33Version 5.2.1
Name DataType Constraint Descript ion
usergroup number Stores a number indicating the user group associated with the userwho created the object.
Foreign Keys:
FK1 (projectno + freqbandkey) references the FREQBAND table
Table CARLAYAICAR
This table shows the column list:
Name DataType Constraint Descript ion
carlaykey number not null Primary key, storing a unique number for each carrier layer in theCarriers dialog box.
carriernumber number not null Primary key,storing the carrier numbers allocated to each carrierlayer created.
modifyuser number not null Stores a number indicating the last user who made changes to thetable.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Foreign Keys:
FK1 (projectno + carriernumber) references the AICAR table
Table CELLAYThis table shows the column list:
Name DataType Constraint Descript ion
caoffset float Stores the C/A offset value.
ccmap number Stores a number indicating the channel to carrier map chosen foruse with the particular cell layers created or presented.
cellaykey number not null Primary key, storing a unique number for each cell layer in thedatabase.
createdate date The date when the object was created.
createuser number Stores a number indicating the user who created the object.Thenumber is based on the order users were created in.
idname varchar2(32) Lists the names of all cell layers.
iweight number Indicates which interference weights table is used with each celllayer.
meanci float Stores the mean C/I value.
modifydate date The date when the object was last modified.
modifyuser number not null Stores a number indicating the last user who made changes to thetable.
network number Indicates the technology that this cell uses, GSM(1), AMPS (2) or
TETRA (3). This is defined on the Technology tab of thePreferences dialog box.
-
7/24/2019 Database Reference Guide
46/238
Page 34 Database Reference GuideVersion 5.2.1
Name DataType Constraint Descript ion
permission number Three digit code that provides the permissions for the user, thedefault group they belong to and all other users. For moreinformation on this, see About Permissions on page 2.
priority number Describes the order in which traffic should be serviced by the celllayers, with 1 being the highest priority.
projectno number not null Primary key, storing a unique number for each project in adatabase.
superlayer number Indicates whether the cell layer is a superlayer (1) or not (0).
usergroup number Stores a number indicating the user group associated with the userwho created the object.
Table CELLAYCARLAY
This table shows the column list:
Name DataType Constraint Descript ion
carlaykey number not null Primary key, storing a unique number for each carrier layer in theCarriers dialog box.
cellaykey number not null Primary key,storing a unique number for each cell layer.
modifyuser number not null Stores a number indicating the last user who made changes tothe table.
priority number Specifies the order in which the carrier layers should be appearon the cell layers in the Site Database.
0 is the highest priority, then 1 and so on.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Foreign Keys:
FK1 (projectno + carlaykey) references the CARLAY table
FK2 (projectno + cellaykey) references the CELLAY table
Table COORDSYS
This table shows the column list:
Name DataType Constraint Descript ion
mapcoordsyskey varchar2(64) Stores a unique number for each map co-ordinate system in thedatabase.
mapdatumkey varchar2(64) Stores a unique number for each map datum in the database.
mapgroupkey varchar2(64) Stores a unique number for each map group in the database.
mapunitkey varchar2(64) Stores a unique number for each map unit in the database.
projectno number not null Primary key, storing a unique number for each project in adatabase.
viscoordsyskey varchar2(64) Stores a unique number for each co-ordinate system in thedatabase (used for visualisation).
-
7/24/2019 Database Reference Guide
47/238
Database Reference Guide Page 35Version 5.2.1
Name DataType Constraint Descript ion
visdatumkey varchar2(64) Stores a unique number for each datum in the database (used forvisualisation).
visgroupkey varchar2(64) Stores a unique number for each group in the database (used forvisualisation).
visunitkey varchar2(64) Stores a unique number for each unit in the database (used forvisualisation).
Table COORDSYSDATA
This table shows the column list:
Name DataType Constraint Descript ion
filedata blob The BLOB record contains the entire co-ordinate system databasefile, and is used by the co-ordinate conversion algorithms in thesoftware.
Table COVCLASS
This table shows the column list:
Name DataType Constraint Descript ion
colour number Associates a palette colour with each coverage class defined in theCell Layers dialog box.
The number refers to the colour's palette position.
covclasskey number not null Primary key, storing a unique number for each coverage class in
the Cell Layers dialog box.
covschemakey number not null Stores a unique number for each coverage schema in a project.
dataset number NOT USED.
modifyuser number not null Stores a number indicating the last user who made changes to thetable.
name varchar2(128) Stores the name of each coverage class defined in the Cell Layersdialog box.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Table COVSCHEMA
This table shows the column list:
Name DataType Constraint Descript ion
covschemakey number not null Primary key, storing a unique number for each coverage schemain a project.
createuser number not null Stores a number indicating the user who created the object.Thenumber is based on the order users were created in.
idname varchar2(32) Stores the name of each coverage schema.
projectno number not null Primary key, storing a unique number for each project in adatabase.
-
7/24/2019 Database Reference Guide
48/238
Page 36 Database Reference GuideVersion 5.2.1
Table COVTHRESH
This table shows the column list:
Name DataType Constraint Descript ion
celllayerkey number Associates each threshold with a cell layer.
covclasskey number Associate each coverage class with a threshold.
covthreshkey number not null Primary key, storing a unique number for each coveragethreshold in the database.
dataset number NOT USED.
modifyuser number not null Stores a number indicating the last user who made changes tothe table.
projectno number not null Primary key, storing a unique number for each project in adatabase.
threshold float (64) Stores all threshold values (in dBm)
Table ENT_ACTIVELOGON_DATA
This table shows the column list:
Name DataType Constraint Descript ion
authtype varchar(32) Indicates whether the user is externally authenticated or passwordauthenticated when connecting to the database.
childusrkey number Stores a unique number, associating the user with the particularuser that they are impersonating.
datetime date not null The date and time the user is connected to the database for thecurrent project.
hostname varchar2(255) not null The host name for the connected client.
ip_address varchar2(32) The IP address of the user's machine.
isdba varchar2(32) not null Indicates whether the user is a DBA user or not.
locked number Indicates whether the user has locked the project to prevent otherusers (1) or not (0).
modetype varchar2(50) Stores a temporary representation of usrkey.
os_user varchar2(255) The OS username of the user.
pid number not null Stores a unique number for the process connected to the database.
projectno number Stores the number of the project to which the user is connected.
rw number not null Indicates if the project is read-only (0) or writable (1).
sessionid varchar2(32) not null Primary key, storing a unique identity for the client session.
sharedno number The number of the sub-project that the user is logged into.
starttime date not null The start time when the user connected to the database.
userid varchar2(32) not null The identifier of the user connected to the database.
usrkey number not null Primary key, storing a unique number for each user in thedatabase.
-
7/24/2019 Database Reference Guide
49/238
Database Reference Guide Page 37Version 5.2.1
Table ENT_EVENTLOG_DATA
This table shows the column list:
Name DataType Constraint Descript ion
eventpk varchar(20) not null Stores a unique number for each event in a database.
eventtime date The date and time the event occurred.
eventtype number Stores the type of event that occurred - a commit (0), a refresh (1)or a deletion (2).
object2fk number Secondary number associated with an additional referencedobject.
objectfk number Number associated with the referenced object.
objectid varchar2(32) Stores the identifier of the object the event belongs to.
objecttype2fk number Secondary number associated with an additional type ofreferenced object.
objecttypefk number Number associated with the referenced object type.
projectno number Stores a unique number for each project in the database.
sharedno number The sub-project number.
usrkey number Stores a unique number for each user in the database
Table ENT_EXCEPTIONLOG
This table shows the column list:
Name DataType Constraint Descript ion
exinfo varchar2(2000) Stores a description of the error.
extime date The time and date when the error/exception occurred.
extype number Indicates the type of error.
funcdata xmltype Additional information on the package that raised theexception.
funcparams varchar2(2000) Parameter details of the call to the function that caused theerror.
oracode number The Oracle ORA error code.
oradesc varchar2(512) The Oracle error description.
projectno number Stores a unique number for each project in the database.
sourcefunction varchar2(32) The name of function that raised the error.
sourcepackage varchar2(32) The name of the package that raised the error.
userkey number Stores a number indicating the user who created theobject.The number is based on the order users were createdin.
-
7/24/2019 Database Reference Guide
50/238
Page 38 Database Reference GuideVersion 5.2.1
Table FILTERS
This table shows the column list:
Name DataType Constraint Descript ion
createdate date The date when the object was created.
createuser number not null Stores a number indicating the user who created the object.Thenumber is based on the order users were created in.
enddate date The filter's end date.
filterid varchar2(32) not null Stores a number to identify each filter.
filterkey number not null Primary keythat uniquely identifies each filter defined in thedatabase.
modifydate date The date when the object was last modified.
modifyuser number not null Stores a number indicating the last user who made changes to thetable.
parentkey number Identifies the parent folder for the filter.
permission number not null Three digit code that provides the permissions for the user, thedefault group they belong to and all other users. For moreinformation on this, see About Permissions on page 2.
projectno number not null Primary key, storing a unique number for each project in adatabase.
startdate date The filter's start date.
type number not null Indicates whether the filter is static (0) or dynamic (1).
usergroup number not null Stores a number indicating the user group associated with the user
who created the object.
Table FLAGASSOCIATIONS
This table shows the column list:
Name DataType Constraint Descript ion
elementtypekey number not null Primary key, storing a unique number for each element type in thedatabase.
flaggroupkey number not null Primary key, storing a unique number for each field group in thedatabase.
indx number not null NOT USED.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Foreign Keys:
FK1 (projectno + flaggroupkey) references the FLAGGROUPS table
-
7/24/2019 Database Reference Guide
51/238
Database Reference Guide Page 39Version 5.2.1
Table FLAGGROUPS
This table shows the column list:
Name DataType Constraint Descript ion
fieldtype number not null Indicates the data type for each field in the table - Boolean (0), Float(1), Integer (2), Picklist (3), String (4).
flaggroupid varchar2(32) not null Stores the name of the field group.
flaggroupkey number not null Primary key, storing a unique number for each field group in thedatabase.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Table FLAGSThe FLAGS table stores each field group and its respective fields. Each row representsone field group and has a unique name indicative of the order in which they wereadded, starting at 0, followed by 1, 2, and so on. In each group you can create 50 fieldsidentified with a two-digit code (00, 01, 02, 49). Again, these codes are indicative ofthe order in which they were added.
The columns in the FLAGS table are as follows:
Name DataType Constraint Descript ion
flaggroupkey number not null Primary key, storing a unique number for each field group in thedatabase.
flagid varchar2(32) not null Stores a unique identifier for each field.
flagkey number not null Primary keythat uniquely identifies each flag group within theproject, starting at 0 and counting upwards for each new oneadded.
indx number not null Stores a number for each fields in their order of creation.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Foreign Keys:
FK1 (projectno + flagroupkey) references the FLAGGROUPS table
About Fields
Fields are associated with sites and links. The table:
FLAGGROUPS, stores object parameter names, for example UMTS Cell Ids, forwhich the fields can be associated.
FLAGASSOCIATIONS, stores values indicating for which elements the fieldgroups are available.
FLAGVALUES, stores the individual data for the fields.
-
7/24/2019 Database Reference Guide
52/238
Page 40 Database Reference GuideVersion 5.2.1
Table FLAGVALUES
This table shows the column list:
Name DataType Constraint Descript ion
elementtypekey number not null Primary key, storing a unique number for each element type in thedatabase.
flaggroupkey number not null Primary key, storing a unique number for each field group in thedatabase.
flagkey number not null Stores a unique number for each flag group within the project,starting at 0 and counting upwards for each new one added.
floatfielddata float If the field value is expressed as a float, stores the float value.
intfielddata number If the field value is expressed as an integer, stores the integer value.
modifyuser number not null Stores a number indicating the last user who made changes to the
table.
objectkey number not null Primary keystoring a unique number for each object defined in thedatabase.
projectno number not null Primary key, storing a unique number for each project in adatabase.
stringfielddata varchar2 (32) If the field value is expressed as a string, stores the string value.
Foreign keys:
FK1 (projectno + flaggroupkey) references the FLAGGROUPS table
FK2 (projectno + flaggroupkey + flagkey) references the FLAGS table
Table FREQBAND
This table shows the column list:
Name DataType Constraint Descript ion
freqbandkey number not null Primary key, storing a unique number for each frequency band inthe database.
name varchar2(32) Stores the name of each frequency band in the database.
networktype number Indicates the type of network used, defined in the Preferences
dialog box. This can be GSM (1), AMPS (2) or TETRA (3).
projectno number not null Primary key, storing a unique number for each project in adatabase.
-
7/24/2019 Database Reference Guide
53/238
Database Reference Guide Page 41Version 5.2.1
Table FREQCARRIERCONV
This table shows the column list:
Name DataType Constraint Descript ion
freqbandkey number not null Primary key, indicating the particular frequency band associatedwith each carrier conversion formula.
freqconversionkey number not null Primary key, storing a unique number for each carrier conversionformula in the database.
name varchar2(32) Stores the name of each conversion formula in the database.
projectno number not null Primary key, storing a unique number for each project in adatabase.
rangex number Stores the first ARFCN number in the carrier range.
rangey number Stores the last ARFCN number in the carrier range.
separation float Stores the separation value between the uplink and downlinkfrequencies.
variablea float Stores the starting frequency for the conversion formulas.
variableb float Stores the frequency separation between adjacent frequencies(for example, between two adjacent uplink frequencies).
Foreign keys:
FK1 (projectno + freqbandkey) references the FREQBAND table
Table FREQUENCYDIVThis table shows the column list:
Name DataType Constraint Descript ion
freqhopcars number not null Primary key, storing a unique number for each frequencyhopping carrier.
gain float Stores the frequency diversity gain in dB.
projectno number not null Primary key, storing a unique number for each project in adatabase.
-
7/24/2019 Database Reference Guide
54/238
Page 42 Database Reference GuideVersion 5.2.1
Table GRIDCANDIDATES
This table shows the column list:
Name DataType Constraint Descript ion
addressfk number not null Primary key, storing the ID of the nominal Property thatcontains the candidate.
candaddressfk number Foreign key which stores the ID of the candidate Property.
candidatepk number not null Primary Key, storing a unique number for each candidateProperty in the database.
createdate date The date when the object was created.
createuser number Stores a number indicating the user who created theobject.The number is based on the order users werecreated in.
idname varchar2 (32) not null NOT USED.
latitude float Location of the candidate Property stored as Easting.
longitude float Location of the candidate Property stored as Northing.
modifydate date The date when the object was last modified.
modifyuser number not null Stores a number indicating the last user who madechanges to the table.
projectno number not null Primary key, storing a unique number for each project in adatabase.
Foreign Keys:
FK1 (projectno + addressfk) references the SITEADDRESS table
Table GRIDCONFIG
This table shows the column list:
Name DataType Constraint Descript ion
configpk number not null Primary Key, storing a unique number for each gridconfiguration.
createdate date The date when the object was created.
createuser number Stores a number ind