okayapi_smpss_log - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_smpss_log：/tablelist/okayapi_smpss_log.html


-- MySQL Table okayapi_smpss_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_smpss_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `type` tinyint(1) NOT NULL COMMENT '日志类型：0添加商品1商品入库2商品出库',
    `goods_id` int(10) NOT NULL COMMENT '商品ID',
    `content` text NOT NULL COMMENT '',
    `user_id` int(10) NOT NULL COMMENT '',
    `username` varchar(32) NOT NULL COMMENT '',
    `dateymd` date NOT NULL COMMENT '',
    `dateline` int(10) NOT NULL COMMENT '',
    KEY `type` (`type`),
    KEY `goods_id` (`goods_id`),
    KEY `content` (`content`),
    KEY `user_id` (`user_id`),
    KEY `username` (`username`),
    KEY `dateymd` (`dateymd`),
    KEY `dateline` (`dateline`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '进销存-商品管理日志表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-7 of 7 results.

Field Name	Field Type	IS NULL	Field Comment	Index
type	tinyint(1)	否	日志类型：0添加商品1商品入库2商品出库
goods_id	int(10)	否	商品ID
content	text	否
user_id	int(10)	否		Normal Index
username	varchar(32)	否
dateymd	date	否		Normal Index
dateline	int(10)	否