New Result Table (in FI_Large)

sample_id

int32

N

N

Identify the sample

char_id

int32

N

N

Identify the characteristic

value_no

int32

N

N

Identify the value in the subgroup

result_value

tfloat

N

N

Value of the characteristic measured.

created_by

string40

N

N

Who entered this value

created_at_utc

tdatetime

N

N

When this value was entered.

created_at_local

tdatetime

N

N

superseded

int32

N

N

Has this value subsequently been changed, so that a new result record was created for the same sample_id, char_id, and value_no?

0 (Default) = No

1= Superseded

last_edit_comment

string254

N

Y

Why this record was changed

last_edit_by

string40

N

N

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

row_id

ID 0

Y

N

Unique row identifier