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