i2-bill-erp/model/sys_user.sql

CREATE TABLE `sys_user` (
  `id` varchar(36) NOT NULL,
  `login_id` varchar(36) NOT NULL,
  `password` varchar(36) NOT NULL,
  `name` varchar(100) NOT NULL,
  `full_name` varchar(100) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `org_id` varchar(36) DEFAULT NULL,
  `gender` int(11) NOT NULL,
  `type` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `domain` varchar(50) NOT NULL,
  `create_by` varchar(36) NOT NULL,
  `create_time` datetime NOT NULL,
  `last_update_by` varchar(36) NOT NULL,
  `last_update_time` bigint(20) NOT NULL,
  `del_flag` tinyint(2) NOT NULL DEFAULT '0',
  `temp_id` varchar(36) DEFAULT NULL,
  `temp_value` text,
  `address` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;