package model

import "time"

/******sql******
CREATE TABLE `account` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `last_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT NULL,
  `gender` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `account_username_uindex` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
******sql******/
// Account [...]
type Account struct {
	ID          int        `gorm:"primaryKey;column:id;type:int;not null" json:"id"`
	FirstName   string     `gorm:"column:first_name;type:varchar(20);not null" json:"firstName"`
	LastName    string     `gorm:"column:last_name;type:varchar(20);not null" json:"lastName"`
	Username    string     `gorm:"unique;column:username;type:varchar(20);not null" json:"username"`
	Password    string     `gorm:"column:password;type:varchar(20);not null" json:"password"`
	Phone       string     `gorm:"column:phone;type:varchar(20)" json:"phone"`
	Email       string     `gorm:"column:email;type:varchar(30)" json:"email"`
	Enabled     bool       `gorm:"column:enabled;type:tinyint(1)" json:"enabled"`
	Gender      string     `gorm:"column:gender;type:varchar(10)" json:"gender"`
	CreatedTime *time.Time `gorm:"column:created_time;type:timestamp;default:CURRENT_TIMESTAMP" json:"createdTime"`
	UpdatedTime *time.Time `gorm:"column:updated_time;type:timestamp;default:CURRENT_TIMESTAMP" json:"updatedTime"`
}