db_models

Documentation

Index

• type Locations
• type Orders
• type OrdersLogs
• type Routines
• type RoutinesLogs
• type Schedules
• type SchedulesLogs
• type Users
• type UsersLogs

Types

type Locations

type Locations struct {
	LocationId   int    `json:"locationId"`
	LocationName string `json:"locationName"`
}

type Orders

type Orders struct {
	ScheduleID           int    `json:"scheduleId"`
	OrderID              int    `json:"orderId" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	OrderType            string `json:"orderType"`
	OrderCreatedType     string `json:"orderCreatedType"`
	OrderCreatedBy       int    `json:"orderCreatedBy"`
	OrderStatus          string `json:"orderStatus"`
	OrderStartTime       string `json:"startTime" gorm:"type:date;column:order_start_time"`
	ActualArrivalTime    string `json:"actualArrivalTime" gorm:"type:date;column:actual_arrival_time"`
	StartLocationID      int    `json:"startLocationId"`
	StartLocationName    string `json:"startLocationName" gorm:"<-:false"`
	EndLocationID        int    `json:"endLocationId"`
	EndLocationName      string `json:"endLocationName" gorm:"<-:false"`
	ExpectedStartTime    string `json:"expectedStartTime" gorm:"type:date;column:expected_start_time"`
	ExpectedDeliveryTime string `json:"expectedDeliveryTime" gorm:"type:date;column:expected_delivery_time"`
	ExpectedArrivalTime  string `json:"expectedArrivalTime" gorm:"type:date;column:expected_arrival_time"`
	ProcessingStatus     string `json:"processingStatus"`
	FailedReason         string `json:"failedReason"`
	LastUpdateTime       string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
	LastUpdateBy         int    `json:"lastUpdateBy"`
}

type OrdersLogs

type OrdersLogs struct {
	Id                   int    `json:"id" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	ScheduleID           int    `json:"scheduleId"`
	OrderID              int    `json:"orderId"`
	OrderType            string `json:"orderType"`
	OrderCreatedType     string `json:"orderCreatedType"`
	OrderCreatedBy       int    `json:"orderCreatedBy"`
	OrderStatus          string `json:"orderStatus"`
	OrderStartTime       string `json:"startTime" gorm:"type:date;column:order_start_time"`
	ActualArrivalTime    string `json:"actualArrivalTime" gorm:"type:date;column:actual_arrival_time"`
	StartLocationID      int    `json:"startLocationId"`
	EndLocationID        int    `json:"endLocationId"`
	ExpectedStartTime    string `json:"expectedStartTime" gorm:"type:date;column:expected_start_time"`
	ExpectedDeliveryTime string `json:"expectedDeliveryTime" gorm:"type:date;column:expected_delivery_time"`
	ExpectedArrivalTime  string `json:"expectedArrivalTime" gorm:"type:date;column:expected_arrival_time"`
	ProcessingStatus     string `json:"processingStatus"`
	FailedReason         string `json:"failedReason"`
	LastUpdateTime       string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
	LastUpdateBy         int    `json:"lastUpdateBy"`
}

type Routines

type Routines struct {
	RoutineID            int    `json:"routineId" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	OrderType            string `json:"orderType"`
	RoutinePattern       string `json:"routinePattern"`
	RoutineCreatedBy     int    `json:"routineCreatedBy"`
	IsActive             bool   `json:"isActive" gorm:"type:boolean"`
	NumberOfAmrRequire   int    `json:"numberOfAmrRequire"`
	StartLocationID      int    `json:"startLocationId"`
	StartLocationName    string `json:"startLocationName" gorm:"<-:false"`
	EndLocationID        int    `json:"endLocationId"`
	EndLocationName      string `json:"endLocationName" gorm:"<-:false"`
	ExpectedStartTime    string `json:"expectedStartTime" gorm:"type:date;column:expected_start_time"`
	ExpectedDeliveryTime string `json:"expectedDeliveryTime" gorm:"type:date;column:expected_delivery_time"`
	LastUpdateTime       string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
	LastUpdateBy         int    `json:"lastUpdateBy"`
}

type RoutinesLogs

type RoutinesLogs struct {
	ID                   int    `json:"Id" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	RoutineID            int    `json:"routineId"`
	OrderType            string `json:"orderType"`
	RoutinePattern       string `json:"routinePattern"`
	IsActive             bool   `json:"isActive" gorm:"type:boolean"`
	NumberOfAmrRequire   int    `json:"numberOfAmrRequire"`
	StartLocationID      int    `json:"startLocationId"`
	ExpectedStartTime    string `json:"expectedStartTime"`
	EndLocationID        int    `json:"endLocationId"`
	ExpectedDeliveryTime string `json:"expectedDeliveryTime"`
	LastUpdateTime       string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
	LastUpdateBy         int    `json:"lastUpdateBy"`
}

type Schedules

type Schedules struct {
	ScheduleID         int    `json:"scheduleId" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	ScheduleStatus     string `json:"scheduleStatus"`
	ScheduleCraeteTime string `json:"scheduleCreateTime" gorm:"type:date;column:schedule_create_time"`
	OrderType          string `json:"orderType"`
	NumberOfAmrRequire int    `json:"numberOfAmrRequire"`
	LastUpdateTime     string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
	LastUpdateBy       int    `json:"lastUpdateBy"`
}

type SchedulesLogs

type SchedulesLogs struct {
	Id                 int    `json:"id" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	ScheduleID         int    `json:"scheduleId"`
	ScheduleStatus     string `json:"scheduleStatus"`
	ScheduleCraeteTime string `json:"scheduleCreateTime" gorm:"type:date;column:schedule_create_time"`
	OrderType          string `json:"orderType"`
	NumberOfAmrRequire int    `json:"numberOfAmrRequire"`
	LastUpdateTime     string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
	LastUpdateBy       int    `json:"lastUpdateBy"`
}

type Users

type Users struct {
	UserId          int    `json:"userId" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	Username        string `json:"username" gorm:"type:string;column:username"`
	Password        string `json:"password" gorm:"type:string;column:password"`
	UserType        string `json:"userType" gorm:"type:string;column:user_type"`
	Token           string `json:"token"`
	TokenExpiryTime string `json:"tokenExpiryTime" gorm:"type:date;column:token_expiry_time"`
	LastLoginTime   string `json:"lastLoginTime" gorm:"type:date;column:last_login_time"`
	LastLogoutTime  string `json:"lastLogoutTime" gorm:"type:date;column:last_logout_time"`
	CreateTime      string `json:"createTime" gorm:"type:date;column:create_time"`
	DutyLocationId  int    `json:"dutyLocationId"`
	LastUpdateTime  string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
}

type UsersLogs

type UsersLogs struct {
	Id              int    `json:"id" sql:"AUTO_INCREMENT" gorm:"primary_key"`
	UserId          int    `json:"userId"`
	Username        string `json:"username" gorm:"type:string;column:username"`
	Password        string `json:"password" gorm:"type:string;column:password"`
	UserType        string `json:"userType" gorm:"type:string;column:user_type"`
	Token           string `json:"token"`
	TokenExpiryTime string `json:"tokenExpiryTime" gorm:"type:date;column:token_expiry_time"`
	LastLoginTime   string `json:"lastLoginTime" gorm:"type:date;column:last_login_time"`
	LastLogoutTime  string `json:"lastLogoutTime" gorm:"type:date;column:last_logout_time"`
	CreateTime      string `json:"createTime" gorm:"type:date;column:create_time"`
	LastUpdateTime  string `json:"lastUpdateTime" gorm:"type:date;column:last_update_time"`
	DutyLocationId  int    `json:"dutyLocationId"`
}