MySQL Create Table SQL
Table Structure: okayapi_praise：/tablelist/okayapi_praise.html
-- MySQL Table okayapi_praise
-- From: OkayAPI.com
CREATE TABLE `okayapi_praise` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`momentId` bigint(15) NULL COMMENT '唯一标识',
`userId` bigint(15) NULL COMMENT '用户id',
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '点赞时间',
KEY `momentId` (`momentId`),
KEY `userId` (`userId`),
KEY `date` (`date`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'web开发-动态点赞表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| momentId | bigint(15) | 否 | 唯一标识 | |||
| userId | bigint(15) | 否 | 用户id | |||
| date | timestamp | CURRENT_TIMESTAMP | 是 | 点赞时间 | CURRENT_TIMESTAMP |
