+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
productcategory_idint(11)产品分类ID
unitvarchar(255)单位
modelvarchar(255)型号
weightdecimal(10,0)重量
unitpricedecimal(10,0)单价
costpricedecimal(10,0)成本
salepricedecimal(10,0)售价
descriptiontext描述
productnamevarchar(255)产品名称
deletedtinyint(4)0删除标识,0-未删除,1-删除0
warrantydaysvarchar(255)保修天数
websiteint(11)网址

Guess You Like

MySQL Table Design okayapi_crm_accountrecordss

MySQL Table Design okayapi_crm_announcements

MySQL Table Design okayapi_crm_caigoutuihuos

MySQL Table Design okayapi_crm_campaigns

MySQL Table Design okayapi_crm_charges

MySQL Table Design okayapi_crm_chargesrecords

MySQL Table Design okayapi_crm_checks

MySQL Table Design okayapi_crm_competitor

MySQL Table Design okayapi_crm_complaints

MySQL Table Design okayapi_crm_contacter

MySQL Table Design okayapi_crm_contactlog

MySQL Table Design okayapi_crm_customer

MySQL Table Design okayapi_crm_dailylogs

MySQL Table Design okayapi_crm_deliverys

MySQL Table Design okayapi_crm_emailgroup

MySQL Table Design okayapi_crm_emailgroupinfo

MySQL Table Design okayapi_crm_expenses

MySQL Table Design okayapi_crm_faq

MySQL Table Design okayapi_crm_faqcategory

MySQL Table Design okayapi_crm_gathers

TOP ↑