Database - Action & Result Selection (action_result_selection_entity)

Description

This allows for the linking of an action to a result and a note.

Common Uses

Table Fields

Column

Data Type

Column Info

Value Notes

id

INT(11)

The ID of the action & result selection entity

note_id

INT(11)

The ID of the associated note.

action_id

INT(11)

The ID of the action. Actions can be found in the action_entity table.

result_id

INT(11)

The ID of the result. Results can be found in the result_entity table.

action_text

VARCHAR(255)

The description of the action for an action & result.

result_text

VARCHAR(255)

The description of the result for an action & result.

created

DATETIME

This is the date that the action & result note was created.

lastUpdated

TIMESTAMP

This is the date that the action & result note was last updated.

deleted

TINYINT(1)

Whether this record has been marked as deleted.

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)