Show details of FieldRexTemp table information from Padme

showFieldRexTempTableInfo.R

# open test connection
source("O://CMEP\ Projects/Scriptbox/database_connections/function_TESTPadmeArabiaCon.R")
TESTPadmeArabiaCon()

# get column details for FieldRexTemp table
tableDetails <- sqlColumns(con_TESTPadmeArabia, sqtable="FieldRexTemp", errors = FALSE, as.is = TRUE,
           special = FALSE, catalog = NULL, schema = NULL,
           literal = FALSE)

# show relevant columns
tableDetails[,c(4, 5, 6, 7, 8, 12)]

# output of table info
# COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH
# 1                  id         4   COUNTER          10             4
# 2               recID        12   VARCHAR         255           510
# 3           collector        12   VARCHAR         255           510
# 4         collNumFull        12   VARCHAR          50           100
# 5              lnamID         4   INTEGER          10             4
# 6         acceptDetAs        12   VARCHAR         255           510
# 7     acceptDetNoAuth        12   VARCHAR         255           510
# 8               detAs        12   VARCHAR         255           510
# 9             lat1Dir        12   VARCHAR           1             2
# 10            lat1Deg         5  SMALLINT           5             2
# 11            lat1Min         4   INTEGER          10             4
# 12            lat1Sec         4   INTEGER          10             4
# 13            lat1Dec         8    DOUBLE          53             8
# 14             anyLat         4   INTEGER          10             4
# 15            lon1Dir        12   VARCHAR           1             2
# 16            lon1Deg         5  SMALLINT           5             2
# 17            lon1Min         4   INTEGER          10             4
# 18            lon1Sec         4   INTEGER          10             4
# 19            lon1Dec         8    DOUBLE          53             8
# 20             anyLon         4   INTEGER          10             4
# 21        coordSource         4   INTEGER          10             4
# 22      coordAccuracy         4   INTEGER          10             4
# 23 coordAccuracyUnits        12   VARCHAR          50           100
# 24    coordSourcePlus        12   VARCHAR         255           510
# 25             dateDD        -6      BYTE           3             1
# 26             dateMM        -6      BYTE           3             1
# 27           dateYYYY         4   INTEGER          10             4
# 28       fullLocation        -1  LONGCHAR  1073741823    2147483646

# REMARKS
# 1                                                                                            Autroincremented record key
# 2                                                             concat of letter determining record source & that table ID
# 3                                                                                               String of collector name
# 4                                                             Concatenation of the prefix, collection number and postfix
# 5  Foreign key pointing to a record key in the Latin Names table showing the determination of the field note [LnSy].[id]
# 6                                                               Accepted Determination with authority [LnSy].[Full Name]
# 7                                                                               Accepted Determination [LnSy].[sortName]
# 8                                                                       Original determination string [Lnam].[Full Name]
# 9                                                                                                  N or S of the equator
# 10                                                                           Degrees latitude of the collecting location
# 11                                                                           Minutes latitude of the collection location
# 12                                                                           Seconds latitude of the collection location
# 13                                                                  Decimal representation of the latitude of collection
# 14                                                                                                                  <NA>
#         15                                                                                      E or W of the Greenwich meridian
# 16                                                                          Degrees longitude of the collecting location
# 17                                                                          Minutes longitude of the collecting location
# 18                                                                          Seconds longitude of the collecting location
# 19                                                                 Decimal representation of the longitude of collection
# 20                                                                                                                  <NA>
#         21                                 Foreign key pointing pointing to type of source for the coordinates of the field note
# 22                                                                         Indication of the accuracy of the coordinates
# 23                                                                                         Units of the accuracy measure
# 24                                                                                                                  <NA>
#         25                                                                                   Calendar day of the collecting date
# 26                                                                                 Calendar month of the collecting date
# 27                                                                                  Calendar year of the collecting date
# 28                                                             The full string of the location chain - [Geog].[fullName]