mysql

Documentation

Index

• func MigrationTables(db *gorm.DB)
• type TblChannel
• type TblChannelCategory
• type TblChannelEntry
• type TblChannelEntryField
• type TblField
• type TblFieldGroup
• type TblFieldOption
• type TblFieldType
• type TblGroupField

Functions

func MigrationTables

func MigrationTables(db *gorm.DB)

MigrateTable creates this package related tables in your database

Types

type TblChannel

type TblChannel struct {
	Id                 int       `gorm:"primaryKey;auto_increment"`
	ChannelName        string    `gorm:"type:varchar(255)"`
	ChannelDescription string    `gorm:"type:varchar(255)"`
	SlugName           string    `gorm:"type:varchar(255)"`
	FieldGroupId       int       `gorm:"type:int"`
	IsActive           int       `gorm:"type:int"`
	IsDeleted          int       `gorm:"type:int"`
	CreatedOn          time.Time `gorm:"type:datetime"`
	CreatedBy          int       `gorm:"type:int"`
	ModifiedOn         time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	ModifiedBy         int       `gorm:"DEFAULT:NULL;type:int"`
	TenantId           int       `gorm:"type:int"`
}

type TblChannelCategory

type TblChannelCategory struct {
	Id         int       `gorm:"primaryKey;auto_increment"`
	ChannelId  int       `gorm:"type:int"`
	CategoryId string    `gorm:"type:varchar(255)"`
	CreatedAt  int       `gorm:"type:int"`
	CreatedOn  time.Time `gorm:"type:datetime"`
	TenantId   int       `gorm:"type:int"`
}

type TblChannelEntry

type TblChannelEntry struct {
	Id              int       `gorm:"primaryKey;auto_increment"`
	Title           string    `gorm:"type:varchar(255)"`
	Slug            string    `gorm:"type:varchar(255)"`
	Description     string    `gorm:"type:text"`
	UserId          int       `gorm:"type:int"`
	ChannelId       int       `gorm:"type:int"`
	Status          int       `gorm:"type:int"` //0-draft 1-publish 2-unpublish
	CoverImage      string    `gorm:"type:varchar(255)"`
	ThumbnailImage  string    `gorm:"type:varchar(255)"`
	MetaTitle       string    `gorm:"type:varchar(255)"`
	MetaDescription string    `gorm:"type:varchar(255)"`
	Keyword         string    `gorm:"type:varchar(255)"`
	CategoriesId    string    `gorm:"type:varchar(255)"`
	RelatedArticles string    `gorm:"type:varchar(255)"`
	Feature         int       `gorm:"DEFAULT:0"`
	ViewCount       int       `gorm:"DEFAULT:0"`
	CreateTime      time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	PublishedTime   time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	ImageAltTag     string    `gorm:"type:varchar(255)"`
	Author          string    `gorm:"type:varchar(255)"`
	SortOrder       int       `gorm:"type:int"`
	Excerpt         string    `gorm:"type:varchar(255)"`
	ReadingTime     int       `gorm:"type:int"`
	Tags            string    `gorm:"type:varchar(255)"`
	CreatedOn       time.Time `gorm:"type:datetime"`
	CreatedBy       int       `gorm:"type:int"`
	ModifiedBy      int       `gorm:"DEFAULT:NULL;type:int"`
	ModifiedOn      time.Time `gorm:"DEFAULT:NULL;type:int"`
	IsActive        int       `gorm:"type:int"`
	IsDeleted       int       `gorm:"DEFAULT:0"`
	DeletedOn       time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	DeletedBy       int       `gorm:"DEFAULT:NULL;type:int"`
	TenantId        int       `gorm:"type:int"`
	ParentId        int       `gorm:"type:int"`
}

type TblChannelEntryField

type TblChannelEntryField struct {
	Id             int       `gorm:"primaryKey;auto_increment"`
	FieldName      string    `gorm:"type:varchar(255)"`
	FieldValue     string    `gorm:"type:varchar(255)"`
	ChannelEntryId int       `gorm:"type:int"`
	FieldId        int       `gorm:"type:int"`
	CreatedOn      time.Time `gorm:"type:datetime"`
	CreatedBy      int       `gorm:"type:int"`
	ModifiedOn     time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	ModifiedBy     int       `gorm:"DEFAULT:NULL;type:int"`
	DeletedBy      int       `gorm:"DEFAULT:NULL;type:int"`
	DeletedOn      time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	TenantId       int       `gorm:"type:int"`
}

type TblField

type TblField struct {
	Id               int       `gorm:"primaryKey;auto_increment"`
	FieldName        string    `gorm:"type:varchar(255)"`
	FieldDesc        string    `gorm:"type:varchar(255)"`
	FieldTypeId      int       `gorm:"type:int"`
	MandatoryField   int       `gorm:"type:int"`
	OptionExist      int       `gorm:"type:int"`
	InitialValue     string    `gorm:"type:varchar(255)"`
	Placeholder      string    `gorm:"type:varchar(255)"`
	OrderIndex       int       `gorm:"type:int"`
	ImagePath        string    `gorm:"type:varchar(255)"`
	DatetimeFormat   string    `gorm:"type:varchar(255)"`
	TimeFormat       string    `gorm:"type:varchar(255)"`
	Url              string    `gorm:"type:varchar(255)"`
	SectionParentId  int       `gorm:"type:int"`
	CharacterAllowed int       `gorm:"type:int"`
	CreatedOn        time.Time `gorm:"type:datetime"`
	CreatedBy        int       `gorm:"type:int"`
	ModifiedOn       time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	ModifiedBy       int       `gorm:"DEFAULT:NULL;type:int"`
	IsDeleted        int       `gorm:"DEFAULT:0"`
	DeletedOn        time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	DeletedBy        int       `gorm:"DEFAULT:NULL;type:int"`
	TenantId         int       `gorm:"type:int"`
}

type TblFieldGroup

type TblFieldGroup struct {
	Id         int       `gorm:"primaryKey;auto_increment"`
	GroupName  string    `gorm:"type:varchar(255)"`
	CreatedOn  time.Time `gorm:"type:datetime"`
	CreatedBy  int       `gorm:"type:int"`
	ModifiedOn time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	ModifiedBy int       `gorm:"DEFAULT:NULL;type:int"`
	IsDeleted  int       `gorm:"DEFAULT:0"`
	DeletedOn  time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	DeletedBy  int       `gorm:"DEFAULT:NULL;type:int"`
	TenantId   int       `gorm:"type:int"`
}

type TblFieldOption

type TblFieldOption struct {
	Id          int       `gorm:"primaryKey;auto_increment"`
	OptionName  string    `gorm:"type:varchar(255)"`
	OptionValue string    `gorm:"type:varchar(255)"`
	FieldId     int       `gorm:"type:int"`
	CreatedOn   time.Time `gorm:"type:datetime"`
	CreatedBy   int       `gorm:"type:int"`
	ModifiedOn  time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	ModifiedBy  int       `gorm:"DEFAULT:NULL;type:int"`
	IsDeleted   int       `gorm:"DEFAULT:0"`
	DeletedOn   time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	DeletedBy   int       `gorm:"DEFAULT:NULL;type:int"`
	TenantId    int       `gorm:"type:int"`
}

type TblFieldType

type TblFieldType struct {
	Id         int       `gorm:"primaryKey;auto_increment"`
	TypeName   string    `gorm:"type:varchar(255)"`
	TypeSlug   string    `gorm:"type:varchar(255)"`
	IsActive   int       `gorm:"type:int"`
	IsDeleted  int       `gorm:"type:int"`
	CreatedBy  int       `gorm:"type:int"`
	CreatedOn  time.Time `gorm:"type:datetime"`
	ModifiedBy int       `gorm:"type:int"`
	ModifiedOn time.Time `gorm:"type:datetime;DEFAULT:NULL"`
	TenantId   int       `gorm:"type:int"`
}

type TblGroupField

type TblGroupField struct {
	Id        int `gorm:"primaryKey;auto_increment"`
	ChannelId int `gorm:"type:int"`
	FieldId   int `gorm:"type:int"`
	TenantId  int `gorm:"type:int"`
}