Documentation for the discussions table

SHC

I'm writing a migration script from a heavily modified SMF 1.X backend to Flarum. I got users, categories all migrated successfully, and now is the time for the discussions. My limited understanding for the fields is as follows:

| Attribute | Description |
|--------------|-------------------------------------------------------------------------|
| id | Post ID |
| title | post title |
| comments_count | Number of replies |
| number_index | ?? |
| start_time | Time of creating the thread (discussion) |
| start_user_id | User who created the thread |
| start_post_id | ID of the first post in the thread |
| last_time | ?? Maybe last time modified?? |
| last_user_id | Maybe the last user to post a reply? |
| hide_time | ?? |
| hide_user_id | ?? |
| slug | The slug of the topic |

Could someone explain these to me?

SHC

Oops, I didn't know Flarum doesn't support Markdown Extra for tables.

luceos

Actually:

discussions.id is the ID used in the slug and unrelated to Posts. The content of the OP is created from the First Post (discussions.start_post_id).

This explains the use of the last_time and last_user_id ?

This the hide attributes. This happens when you soft delete a discussion (not the post).

number_index is a bit odd. It holds the information of the total amount of posts the discussion ever had. So when a post was deleted, the index will not change, whereas comments_count will.