+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_crm_campaigns:/tablelist/okayapi_crm_campaigns.html


-- MySQL Table okayapi_crm_campaigns
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_campaigns` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `campaigns_name` varchar(255) NULL COMMENT '营销活动名称',
    `status` varchar(255) NULL COMMENT '状态',
    `product_id` int(11) NULL COMMENT '产品',
    `campaigns_type` varchar(255) NULL COMMENT '营销活动类型',
    `end_date` datetime NULL COMMENT '结束时间',
    `targetaudience` varchar(255) NULL COMMENT '目标客户',
    `targetsize` int(11) NULL COMMENT '目标大小',
    `description` text NULL COMMENT '描述',
    `deleted` tinyint(4) NULL DEFAULT '0' COMMENT '删除标识:0未删除,1删除',
    `budget` int(11) NULL COMMENT '预算',
    KEY `campaigns_name` (`campaigns_name`),
    KEY `status` (`status`),
    KEY `product_id` (`product_id`),
    KEY `campaigns_type` (`campaigns_type`),
    KEY `end_date` (`end_date`),
    KEY `targetaudience` (`targetaudience`),
    KEY `targetsize` (`targetsize`),
    KEY `description` (`description`),
    KEY `deleted` (`deleted`),
    KEY `budget` (`budget`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
campaigns_namevarchar(255)营销活动名称
statusvarchar(255)状态
product_idint(11)产品
campaigns_typevarchar(255)营销活动类型
end_datedatetime结束时间
targetaudiencevarchar(255)目标客户
targetsizeint(11)目标大小
descriptiontext描述
deletedtinyint(4)0删除标识:0未删除,1删除0
budgetint(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_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

MySQL Table Design okayapi_crm_gathersrecords

TOP ↑