spec
- Last UpdatedNov 20, 2024
- 1 minute read
The spec table lists the global domain of specifications that exist in the database, to which group they belong, their units of measure, and information on how to display them.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
spec_id |
string40 |
Y |
N |
Identify specification |
|
spec_desc |
string80 |
N |
Y |
Description of specification |
|
units |
string40 |
N |
N |
Unit of measure |
|
grp_id |
string40 |
N |
N |
Spec group to allow grouping of related specs |
|
display_seq |
int32 |
N |
N |
Display order within group |
|
data_type |
int32 |
N |
N |
Enumeration of the type of the data for this specification: 0 = text (default) 1 = float |
|
spare1 |
string1000 |
N |
Y |
Use defined by language term 4236 |
|
spare2 |
string1000 |
N |
Y |
Use defined by language term 4237 |
|
spare3 |
string1000 |
N |
Y |
Use defined by language term 4238 |
|
spare4 |
string1000 |
N |
Y |
Use defined by language term 4239 |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
mod_id |
timestamp |
N |
N |
A binary number that increments each time the row is modified. |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail |