okayapi_travel_agent_users - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_travel_agent_users：/tablelist/okayapi_travel_agent_users.html


-- MySQL Table okayapi_travel_agent_users
-- From: OkayAPI.com
CREATE TABLE `okayapi_travel_agent_users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `agent_id` int(8) NOT NULL COMMENT '',
    `okayapi_travel_agent_users_name` varchar(100) NOT NULL COMMENT '',
    `idcard_no` varchar(50) NOT NULL COMMENT '',
    `guide_no` varchar(50) NOT NULL COMMENT '导游号',
    `active` int(1) NOT NULL DEFAULT '1' COMMENT '-1 锁定',
    `created` bigint(12) NOT NULL DEFAULT '0' COMMENT '',
    KEY `agent_id` (`agent_id`),
    KEY `okayapi_travel_agent_users_name` (`okayapi_travel_agent_users_name`),
    KEY `idcard_no` (`idcard_no`),
    KEY `guide_no` (`guide_no`),
    KEY `active` (`active`),
    KEY `created` (`created`),
    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-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
agent_id	int(8)		否		Normal Index
okayapi_travel_agent_users_name	varchar(100)		否
idcard_no	varchar(50)		否
guide_no	varchar(50)		否	导游号
active	int(1)	1	否	-1 锁定		1
created	bigint(12)	0	否			0