L TmpV2 table: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| Line 1: | Line 1: | ||
L_TmpV2 table in [[CCMDB. | L_TmpV2 table in [[CCMDB.accdb]] and [[Centralized_data.mdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. Collection projects that generate data for this table are categorized in [[:Category:Project|Project]] / [[:Category:L TmpV2 Data|L TmpV2 Data]]. | ||
The table has fields to accommodate dates, integers, reals/floating point variables, text or booleans. It can accommodate one of each of these per line, such that if two variables of the same data type are needed, two lines need to be entered. The table was set up this way to accommodate any possible combination of data, but this flexibility comes at the expense of some inefficiencies in data-entry. | The table has fields to accommodate dates, integers, reals/floating point variables, text or booleans. It can accommodate one of each of these per line, such that if two variables of the same data type are needed, two lines need to be entered. The table was set up this way to accommodate any possible combination of data, but this flexibility comes at the expense of some inefficiencies in data-entry. | ||
| Line 6: | Line 6: | ||
====Data Structure==== | ====Data Structure==== | ||
To see the most up-to-date data structure of this table, see most up-to-date ccmdb_data.mdb in [[Regional Server]]\data\Master [[CCMDB. | To see the most up-to-date data structure of this table, see most up-to-date ccmdb_data.mdb in [[Regional Server]]\data\Master [[CCMDB.accdb]]. | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||