okayapi_crm_memdays - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_memdays：/tablelist/okayapi_crm_memdays.html


-- MySQL Table okayapi_crm_memdays
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_memdays` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NULL COMMENT '标题',
    `customer` varchar(255) NULL COMMENT '客户',
    `memdays_type` varchar(255) NULL COMMENT '纪念日类型',
    `memdays_day` varchar(255) NULL COMMENT '纪念日',
    `calendar_type` varchar(255) NULL COMMENT '阳历/阴历',
    `deleted` tinyint(4) NULL DEFAULT '0' COMMENT '删除标识，0-未删除，1-删除',
    `memo` int(11) NULL COMMENT '备注',
    KEY `title` (`title`),
    KEY `customer` (`customer`),
    KEY `memdays_type` (`memdays_type`),
    KEY `memdays_day` (`memdays_day`),
    KEY `calendar_type` (`calendar_type`),
    KEY `deleted` (`deleted`),
    KEY `memo` (`memo`),
    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-7 of 7 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
title	varchar(255)		是	标题
customer	varchar(255)		是	客户
memdays_type	varchar(255)		是	纪念日类型
memdays_day	varchar(255)		是	纪念日
calendar_type	varchar(255)		是	阳历/阴历
deleted	tinyint(4)	0	否	删除标识，0-未删除，1-删除	0
memo	int(11)		是	备注