43. Signup API + User table creation in MySQL | Spring Boot Expert Tutorial | Code Simple

Hi All,

This video covers end to end process involving in creating a new api which is SignUp API. Starting from Table design, Table creation, Entity/domain class creation, repo class, service class and controller class.

User Table columns:

1. id
2. name
3. email_id
4. phone_number
5. password
6. is_active
7. user_type
8. login_count
9. login_at
10. sso_type -- oauth (google, twitter, facebook, github,...)
11. created_at
12. updated_at
13. Gender


User table DDL:
CREATE TABLE `bookstoredb`.`user` ( `id` BIGINT NOT NULL , `name` VARCHAR(100) NOT NULL , `gender` VARCHAR(20) NULL , `email_id` VARCHAR(100) NOT NULL , `phone_number` VARCHAR(20) NOT NULL , `password` VARCHAR(100) NOT NULL , `user_type` VARCHAR(20) NOT NULL DEFAULT 'NORMAL' , `is_active` BOOLEAN NOT NULL DEFAULT TRUE , `sso_type` VARCHAR(20) NULL , `login_at` DATETIME NULL , `login_count` INT NOT NULL DEFAULT '0' , `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`), UNIQUE `email_id_unique` (`email_id`), UNIQUE `phone_number_unique` (`phone_number`)) ENGINE = InnoDB;

ALTER TABLE `user` CHANGE `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT;

Git link for this project:
https://github.com/cbesangeeth/book-store-api

#signup #user #table #creation #mysql #api #springboot #codesimple #tamil #tutorial