Basic User Table Structure of mysql

Table Name : op_user 

Uses : For any Project to Manage User 

#	Name	Type	Collation	Attributes	Null	Default	Comments	Extra
1	id	int(11)			No	None		AUTO_INCREMENT
2	user_type	varchar(255)	latin1_swedish_ci		No	ADMIN
3	full_name	varchar(255)	latin1_swedish_ci		Yes	NULL
4	user_mobile	varchar(10)	latin1_swedish_ci		Yes	NULL
5	user_name	varchar(30)	latin1_swedish_ci		No	None
6	user_pass	varchar(255)	latin1_swedish_ci		No	None
7	user_email	varchar(255)	latin1_swedish_ci		Yes	NULL
8	doc	date			Yes	NULL
9	status	varchar(255)	latin1_swedish_ci		No	ACTIVE
10	token	varchar(255)	latin1_swedish_ci		Yes	NULL
11	last_login	timestamp			Yes	current_timestamp()
12	created_by	int(11)			Yes	NULL
13	created_at	datetime			Yes	NULL
14	updated_by	int(11)			Yes	NULL
15	updated_at	timestamp			Yes	current_timestamp()

 

CREATE TABLE `op_user` (
  `id` int(11) NOT NULL,
  `user_type` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'ADMIN',
  `full_name` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `user_mobile` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `user_name` varchar(30) CHARACTER SET latin1 NOT NULL,
  `user_pass` varchar(255) CHARACTER SET latin1 NOT NULL,
  `user_email` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `doc` date DEFAULT NULL,
  `status` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'ACTIVE',
  `token` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--

-- Indexes for table `op_user`

--

ALTER TABLE `op_user`

  ADD PRIMARY KEY (`id`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `op_user`

--

ALTER TABLE `op_user`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

COMMIT;