okayapi_travel_depot_annuals - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_travel_depot_annuals：/tablelist/okayapi_travel_depot_annuals.html


-- MySQL Table okayapi_travel_depot_annuals
-- From: OkayAPI.com
CREATE TABLE `okayapi_travel_depot_annuals` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `depot_id` int(11) NOT NULL COMMENT '',
    `okayapi_travel_depot_annuals_name` varchar(32) NOT NULL COMMENT '姓名',
    `card_no` varchar(32) NOT NULL DEFAULT '0' COMMENT '身份证',
    `mobile` varchar(20) NOT NULL DEFAULT '0' COMMENT '电话',
    `valid_for` int(11) NOT NULL DEFAULT '1' COMMENT '年限',
    `created` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `updated` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `active` int(11) NOT NULL DEFAULT '0' COMMENT '-1为作废',
    KEY `depot_id` (`depot_id`),
    KEY `okayapi_travel_depot_annuals_name` (`okayapi_travel_depot_annuals_name`),
    KEY `card_no` (`card_no`),
    KEY `mobile` (`mobile`),
    KEY `valid_for` (`valid_for`),
    KEY `created` (`created`),
    KEY `updated` (`updated`),
    KEY `active` (`active`),
    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-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
depot_id	int(11)		否		Normal Index
okayapi_travel_depot_annuals_name	varchar(32)		否	姓名
card_no	varchar(32)	0	否	身份证		0
mobile	varchar(20)	0	否	电话		0
valid_for	int(11)	1	否	年限		1
created	int(11)	0	否			0
updated	int(11)	0	否			0
active	int(11)	0	否	-1为作废		0