2 database table – Rice Lake 920i Short Axle Weighing User Manual

Page 9

Advertising
background image

Modifying the Database Tables

5

4.2

Database Table

Field

Type

Description

ID

String

Truck Id – 16 alphanumeric

Axle1

Real

Axle 1 weight

Axle2

Real

Axle 2 weight (if applicable)

Axle3

Real

Axle 3 weight (if applicable)

Axle4

Real

Axle 4 weight (if applicable)

Axle5

Real

Axle 5 weight (if applicable)

Axle6

Real

Axle 6 weight (if applicable)

Axle7

Real

Axle 7 weight (if applicable)

Axle8

Real

Axle 8 weight (if applicable)

Axle9

Real

Axle 9 weight (if applicable)

Axle10

Real

Axle 10 weight (if applicable)

Axle11

Real

Axle 11 weight (if applicable)

Axle12

Real

Axle 12 weight (if applicable)

Axle13

Real

Axle 13 weight (if applicable)

Axle14

Real

Axle 14 weight (if applicable)

Axle15

Real

Axle 15 weight (if applicable)

Total

Real

Total of all axles

TimeDate

Datetime

Time/date of weighment

Table 4-2. Transactions (“Trans”) Database Table 350 Records

Advertising