Table system-channel-post
Posts in a system channel
Fields
| Field |
Description |
Type |
Null |
Key |
Default |
Extra |
| channel |
System channel id |
varchar(20) |
NO |
PRI |
NULL |
|
| uid |
User id |
mediumint unsigned |
NO |
PRI |
NULL |
|
| uri-id |
Post engagement entry |
int unsigned |
NO |
PRI |
NULL |
|
| created |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
| received |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
| commented |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
Indexes
| Name |
Fields |
| PRIMARY |
channel, uid, uri-id |
| uri-id |
uri-id |
| uid |
uid |
| channel_created |
channel, uid, created |
Foreign keys
Return to database documentation