Difference between UpdateAt and EditAt in Posts table

1

Dear All,

I have a query regarding the Posts table in the Mattermost Database.

The schema is as follows:

describe Posts;
±-------------±------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±-------------±------------±-----±----±--------±------+
| Id | varchar(26) | NO | PRI | NULL | |
| CreateAt | bigint | YES | MUL | NULL | |
| UpdateAt | bigint | YES | MUL | NULL | |
| EditAt | bigint | YES | | NULL | |
| DeleteAt | bigint | YES | MUL | NULL | |
| IsPinned | tinyint(1) | YES | MUL | NULL | |
| UserId | varchar(26) | YES | MUL | NULL | |
| ChannelId | varchar(26) | YES | MUL | NULL | |
| RootId | varchar(26) | YES | MUL | NULL | |
| OriginalId | varchar(26) | YES | MUL | NULL | |
| Message | text | YES | MUL | NULL | |
| Type | varchar(26) | YES | | NULL | |
| Props | json | YES | | NULL | |
| Hashtags | text | YES | MUL | NULL | |
| Filenames | text | YES | | NULL | |
| FileIds | text | YES | | NULL | |
| HasReactions | tinyint(1) | YES | | NULL | |
| RemoteId | varchar(26) | YES | | NULL | |
±-------------±------------±-----±----±--------±------+
18 rows in set (0.01 sec)

My query is : What is the difference between UpdateAt and EditAt ?

Is there a documentation for the database schema some where?
I tried Googling but I did not succeed.

Here is my database version:
Mattermost Version: 8.1.8
Database Schema Version: 113
Database: mysql

Many thanks,
Ashim

2

Hi Ashim! Great question! The UpdateAt field reflects when any attribute of the post is updated, while EditAt specifically tracks when the post’s message content is edited. For detailed documentation, you can check this Mattermost database schema documentation. If you need further assistance, feel free to ask!