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
Ref	uint64	ref	bigint(20) unsigned	true	parent tag id
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
UserID	uint64	user_id	bigint(20) unsigned	true	createdBy
ArticleTitle	string	article_title	varchar(127)	true
ArticleContent	string	article_content	text	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
UserID	uint64	user_id	bigint(20) unsigned	true	createdBy
CommentTitle	string	comment_title	varchar(127)	true
CommentContent	string	comment_content	text	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