White_Banner.jpg - 40746 Bytes
DATABASE TABLE DEFINITIONS

The PBM Client database contains a total of nine separate tables. Each table, and the data contained within that table will be described on this page. Knowledge of the tables will provide more options when picking numbers and provide the opportunity to be more flexible when chooseing which algorithm to use.

TABLE: MNTB

MNTB Table

MNTB basically stands for Main Table. It is the table that stores the actual drawing data. Each drawing is numbered sequentially started from 1 which was the first drawing on 04/22/1992. The next field contains the drawing day (either "Wed" or "Sat"), the date of the drawing, and the numbers and powerball number drawn.

TABLE: TTBL

Temp Table (TTBL)

TTBL or temporary table is the table that is used to store number sets before the number sets are transferred into the played number table. As number sets are selected for any particular drawing, they are temporarily stored in this table. Those numbers will eventually be used to process tickets, however at this time, those sets are only transferred to the played number table when "Print Ticket" is pressed from either the HTN Table or HTN Graph windows.

TABLE: PNTB

Played Number Table (PNTB)

PNTB (Played Number Table) contains all the numbers sets that have been played by PBM Client users. This table has the same structure of MNTB and TTBL with the exception og the last three data fields "MTHS", "MNMS", and "MPBS". As of this release, these fields are not used.

  • MTHS will eventually hold the total number of matching numbers for that drawing.
  • MNMS will hold the number of matching numbers.
  • MPBS will store the number of matching powerballs (1 or 0).
Those fields will automatically be updated when the tables are updated after each drawing.

TABLE: ALST

Table ALST

ALST (Algorithm Stats) is the table that stores each drawing where one of the fifteen algorithms used by PBM Client matches four or five numbers and the powerball. In other words, if four or five of the drawn numbers are in the hot number list of a particular algorithm, than that drawing is stored in this table. All fifteen algorithms are tracked for twenty and twenty-five hot number counts. That having been said, there are duplicates as a drawing where "AL1" matches four or five numbers with twenty hot numbers, it will also match for twenty-five numbers.

The tables fields and associated data are listed below:
  • RECORDS lists the total number of records in the table.
  • DATE is the drawing date.
  • NMALG is the number algorithm that produced the matching numbers
  • PBALG is the powerball algorithm that produced the matching powerball number.
  • NMDPTH is the number depth or more specifically the number of hot numbers in the hot number list.
  • PBDPTH is the number of hot powerballs in the not powerball list or hot powerball depth.
  • DKEY is the drawing number in which that matches occurred.
  • NM_MATCHES is the number of matching numbers.
  • PB_MATCHES is the number of matching powerballs.
  • MATCH_1 first matching number.
  • MATCH_2 second matching number.
  • MATCH_3 third matching number.
  • MATCH_4 fourth matching number.
  • MATCH_5 fifth matching number.
  • MATCH_PB matching powerball number if there was one.

TABLE: NMFR

Number Friends (NMFR)

NMFR (Number Friends) is a table that ranks the numbers according to how likely the are to be drawn with each number. For example looking up the record for number "1" in the example above, "55" is the most likely number to be drawn with "1" followed by "37" "21" and "35" etc..

The DKEY field refers to the drawing number that those numbers were calculated for. Finally, there is a field labeled "ACTF_RELF". ACTF (Actual Frequency) is the number list that was generated based on the actual frequency of all numbers. RELF (Relative Frequency) are the numbers generated based on the numbers relative frequency.

The type of frequency generally affects the numbers between 46 and 55 as they were added to the drawing years after the first drawing. There are two lists for each number. One for actual frequency and a second for relative frequency. As can be seen, the number lists do vary slightly.

TABLE: PBNF

Powerball Number Friends

PBNF (Powerball Number Friends)is similar to the NMFR table in that it lists the numbers ranked from most likely to be drawn with each powerball number to the least likely to be drawn.

TABLE: PBFR

Powerball Friends

PBFR (Powerball Friends) is also similar to NMFR in that is lists the powerball numbers that are most likely to be drawn with each number.

TABLE: ALNM

Algorithm Numbers (ALNM)

ALNM is the table that contains the number lists for each number algorithm AL1 through AL15. The numbers are listed from most likely to be drawn to least likely.

TABLE: ALPB

ALPB

Finally, ALPB lists the powerball numbers from most likely to be drawn to least likely to be drawn for each algorithm from AL1 through AL15.