What value is stored in a lookup column for a row with a primary key of -2?

In a lookup column, particularly in a database context within the Caboodle Data Model, the value stored typically corresponds to a key that corresponds to a related record in another table. In this scenario, if the lookup column is referencing another table, it is important to understand the nature of the relationship defined by the primary key of the row in question.

When the primary key is -2, it often signifies a special case in database management systems, commonly representing an unlinked or placeholder entry. The fact that the lookup value is stored as a date, such as 12/31/1840, suggests that this specific value is used to indicate the absence of a valid or applicable record for that lookup. It serves as a default date that represents a logical way to express 'not found' or 'not applicable' in the context of data that expects a date reference.

On the other hand, a value of -2 would typically not be stored in a lookup column as it reflects the primary key of the record, which should not be directly repeated as an associated value. NULL would denote the absence of a value, thus irrelevant here since some value needs to signify the lack of applicable data. The option of "Not Applicable" does not provide a concrete value