Skip to main content

stimulus_id

REQUIRED

Primary key of the Stimulus table. Reference to this identifier in other tables are thus named stimulus_id.

info

Part of the Key category of the Stimulus table in the trial schema.

Details

PropertyValue
TypePRIMARY KEY
Requirementrequired
RangeEach row in this table has a unique id.
CategoriesKey

Notes

  • If the same stimulus is shown at two different times in a trial, those two instances will have their own row in the Stimulus table, each with its own id.
  • Make sure to refer to this field as stimulus_id rather than id When joining tables. This also applies to all the id fields; they are named id within their own context/table, but <context/table>_id when addressed from other tables. For example, X_id in a table refers (hence a foreign key) to the id column in the X table.