DHR8RMnk

1CREATE TABLE IF NOT EXISTS `user` (
2  `user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3  `first_ name` VARCHAR(45) NOT NULL,
4  `active_status` ENUM('ACTIVE', 'PENDING', 'DEACTIVATED', 'BLOCKED', 'SPAM', 'DELETED') NOT NULL ,
5  UNIQUE INDEX `unique_id_UNIQUE` (`unique_id` ASC),
6  UNIQUE INDEX `email_UNIQUE` (`email` ASC),
7  PRIMARY KEY (`user_id`))
8ENGINE = InnoDB;
9	
10@Entity
11public class User implements OfloyEntity {
12
13@Id
14@GeneratedValue(strategy = IDENTITY)
15@Column(name = "user_id", unique = true, nullable = false)
16private int userId;
17
18//other fields
19
20@Enumerated(EnumType.STRING)
21@Column(name = "active_status", nullable = false, length = 11)
22private UserStatus activeStatus;
23	
24public enum UserStatus {
25
26    ACTIVE,
27    PENDING,
28    DEACTIVATED,
29    BLOCKED,
30    DELETED,
31    SPAM
32}