Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| story_id | INT | 10 | 0 |
|
|
|||
| story_name | VARCHAR | 255 | null |
|
|
|||
| story_description | TEXT | 65535 | √ | null |
|
|
||
| story_requirements | JSON | 1073741824 | √ | null |
|
|
||
| story_image_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| story_image_name | MEDIUMTEXT | 16777215 | √ | null |
|
|
The file system path to the image. |
|
| project_id | INT | 10 | √ | 0 |
|
|
||
| project_name | VARCHAR | 255 | √ | null |
|
|
||
| project_description | TEXT | 65535 | √ | null |
|
|
||
| story_featured | BIT | 1 | 0 |
|
|
|||
| story_visibility | BIT | 1 | 1 |
|
|
|||
| story_user_id | INT | 10 | null |
|
|
|||
| publication_id | INT | 10 | √ | 0 |
|
|
||
| publication_doi | TEXT | 65535 | √ | null |
|
|
||
| story_steps | JSON | 1073741824 | √ | null |
|
|
||
| story_created_on | DATETIME | 19 | CURRENT_TIMESTAMP |
|
|
|||
| story_updated_on | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|