MySQL Create Table SQL
Table Structure: okayapi_crm_product:/tablelist/okayapi_crm_product.html
-- MySQL Table okayapi_crm_product
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_product` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`productcategory_id` int(11) NULL COMMENT '产品分类ID',
`unit` varchar(255) NULL COMMENT '单位',
`model` varchar(255) NULL COMMENT '型号',
`weight` decimal(10,0) NULL COMMENT '重量',
`unitprice` decimal(10,0) NULL COMMENT '单价',
`costprice` decimal(10,0) NULL COMMENT '成本',
`saleprice` decimal(10,0) NULL COMMENT '售价',
`description` text NULL COMMENT '描述',
`productname` varchar(255) NULL COMMENT '产品名称',
`deleted` tinyint(4) NULL DEFAULT '0' COMMENT '删除标识,0-未删除,1-删除',
`warrantydays` varchar(255) NULL COMMENT '保修天数',
`website` int(11) NULL COMMENT '网址',
KEY `productcategory_id` (`productcategory_id`),
KEY `unit` (`unit`),
KEY `model` (`model`),
KEY `weight` (`weight`),
KEY `unitprice` (`unitprice`),
KEY `costprice` (`costprice`),
KEY `saleprice` (`saleprice`),
KEY `description` (`description`),
KEY `productname` (`productname`),
KEY `deleted` (`deleted`),
KEY `warrantydays` (`warrantydays`),
KEY `website` (`website`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-产品';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
productcategory_id | int(11) | 是 | 产品分类ID | |||
unit | varchar(255) | 是 | 单位 | |||
model | varchar(255) | 是 | 型号 | |||
weight | decimal(10,0) | 是 | 重量 | |||
unitprice | decimal(10,0) | 是 | 单价 | |||
costprice | decimal(10,0) | 是 | 成本 | |||
saleprice | decimal(10,0) | 是 | 售价 | |||
description | text | 是 | 描述 | |||
productname | varchar(255) | 是 | 产品名称 | |||
deleted | tinyint(4) | 0 | 否 | 删除标识,0-未删除,1-删除 | 0 | |
warrantydays | varchar(255) | 是 | 保修天数 | |||
website | int(11) | 是 | 网址 |