okayapi_dberp_admin - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_dberp_admin：/tablelist/okayapi_dberp_admin.html


-- MySQL Table okayapi_dberp_admin
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_admin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `admin_group_id` int(11) NULL COMMENT '',
    `admin_name` varchar(100) NULL COMMENT '',
    `admin_passwd` varchar(72) NULL COMMENT '',
    `admin_email` varchar(100) NULL COMMENT '',
    `admin_state` tinyint(2) NULL DEFAULT '1' COMMENT '',
    `admin_add_time` int(10) NULL COMMENT '',
    `admin_old_login_time` int(10) NULL COMMENT '',
    `admin_new_login_time` int(10) NULL COMMENT '',
    KEY `admin_group_id` (`admin_group_id`),
    KEY `admin_name` (`admin_name`),
    KEY `admin_passwd` (`admin_passwd`),
    KEY `admin_email` (`admin_email`),
    KEY `admin_state` (`admin_state`),
    KEY `admin_add_time` (`admin_add_time`),
    KEY `admin_old_login_time` (`admin_old_login_time`),
    KEY `admin_new_login_time` (`admin_new_login_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'DBErp进销存-管理员';

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	Demo Data
admin_group_id	int(11)		否
admin_name	varchar(100)		否
admin_passwd	varchar(72)		否
admin_email	varchar(100)		否
admin_state	tinyint(2)	1	否	1
admin_add_time	int(10)		否
admin_old_login_time	int(10)		是
admin_new_login_time	int(10)		是