Definition

Diagram

Category

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
Ref	uint64	ref	bigint(20) unsigned	true	parent category id
CategoryName	string	category_name	varchar(127)	true
Status	int	status	int(10)	true	-1 deleted 0 pendding 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

Tag

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
TagName	string	tag_name	varchar(127)	true
Status	int	status	int(10)	true	-1 deleted 0 pendding 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

Article

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
CategoryID	uint64	category_id	bigint(20) unsigned	true
ArticleName	string	article_name	varchar(127)	true
Status	int	status	int(10)	true	-1 deleted 0 pendding 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

ArticleTag

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ArticleID	uint64	article_id	bigint(20) unsigned	true
TagID	uint64	tag_id	bigint(20) unsigned	true

Comment

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
ArticleID	uint64	article_id	bigint(20) unsigned	true
CommentName	string	comment_name	varchar(127)	true
Status	int	status	int(10)	true	-1 deleted 0 pendding 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false