package sqlx

import (
	"database/sql"
	"time"
)

type ModelTime struct {
	CreatedAt time.Time `form:"-" json:"created_at" db:"created_at" time_format:"2006-01-02 15:04:05"`
	UpdatedAt time.Time `form:"-" json:"updated_at" db:"updated_at" time_format:"2006-01-02 15:04:05"`
}

type Moments struct {
	Id           int    `form:"id" json:"id" db:"id"`
	UserId       int    `form:"user_id" json:"user_id" db:"user_id"`
	Content      string `form:"content" json:"content" db:"content"`
	CommentTotal int    `form:"comment_total" json:"comment_total" db:"comment_total"`
	LikeTotal    int    `form:"like_total" json:"like_total" db:"like_total"`
	Status       int    `form:"status" json:"status" db:"status"`
	ModelTime
}

type Photos struct {
	Id       int    `form:"id" json:"id" db:"id"`
	MomentId int    `form:"moment_id" json:"moment_id" db:"moment_id"`
	Url      string `form:"url" json:"url" db:"url"`
	ModelTime
}

type Users struct {
	Id          int            `form:"id" json:"id" d:"id"`
	Name        string         `form:"name" json:"name" d:"name"`
	Status      int            `form:"status" json:"status" d:"status"`
	SuccessTime sql.NullString `form:"-" json:"success_time" d:"success_time"`
	CreatedAt   time.Time      `form:"-" json:"created_at" d:"created_at" time_format:"2006-01-02 15:04:05"`
	UpdatedAt   time.Time      `form:"-" json:"updated_at" d:"updated_at" time_format:"2006-01-02 15:04:05"`
}