models

type Article struct {
	ID           int64       `gorm:"column:id;primarykey" json:"id"`
	Kind         string      `gorm:"column:kind;type:varchar(24);not null" json:"kind"`
	URL          string      `gorm:"column:url;type:varchar(256);not null" json:"url"`
	Content      string      `gorm:"column:content;type:text" json:"content"`
	Title        string      `gorm:"column:title;type:varchar(256);not null;uniqueIndex" json:"title"`
	Tags         ArticleTags `gorm:"foreignKey:ArticleID" json:"tags"`
	Created      time.Time   `gorm:"column:created;type:datetime;not null" json:"created"`
	LastModified time.Time   `gorm:"column:last_modified;type:datetime;not null" json:"lastModified"`
}

type ArticleTag struct {
	ID        int64  `gorm:"column:id;primarykey" json:"id"`
	Tag       string `gorm:"column:tag;type:varchar(512);not null" json:"tag"`
	ArticleID int64  `gorm:"column:article_id;type:integer;not null" json:"articleID"`
}

type ArticleTagCountDTO struct {
	Tag   string `gorm:"column:tag" json:"tag"`
	Count int    `gorm:"column:cnt" json:"count"`
}

type ArticleTags []*ArticleTag

type Misc struct {
	ID           int64     `gorm:"column:id;primarykey" json:"id"`
	Key          string    `gorm:"column:key;varchar(60);not null" json:"key"`
	Value        string    `gorm:"column:value;text;not null" json:"value"`
	Created      time.Time `gorm:"column:created;type:datetime;not null" json:"created"`
	LastModified time.Time `gorm:"column:last_modified;type:datetime;not null" json:"lastModified"`
}

type Note struct {
	ID           int64      `gorm:"column:id;primarykey" json:"id"`
	Title        string     `gorm:"column:title;type:varchar(256);not null;uniqueIndex" json:"title"`
	Paragraphs   Paragraphs `gorm:"foreignKey:NoteID" json:"paragraphs"`
	Created      time.Time  `gorm:"column:created;type:datetime;not null" json:"created"`
	LastModified time.Time  `gorm:"column:last_modified;type:datetime;not null" json:"lastModified"`
}

type Notes []*Note

type Paragraph struct {
	ID                int64             `gorm:"column:id;primarykey" json:"id"`
	NoteID            int64             `gorm:"column:note_id;type:integer;not null" json:"noteID"`
	Seq               int               `gorm:"column:seq;type:integer;not null" json:"seq"`
	Content           string            `gorm:"column:content;type:text" json:"content"`
	ReferenceArticles ReferenceArticles `gorm:"foreignKey:ParagraphID" json:"referenceArticles"`
	ReferenceWebs     ReferenceWebs     `gorm:"foreignKey:ParagraphID" json:"referenceWebs"`
	Created           time.Time         `gorm:"column:created;type:datetime;not null" json:"created"`
	LastModified      time.Time         `gorm:"column:last_modified;type:datetime;not null" json:"lastModified"`
}

type Paragraphs []*Paragraph

type ReferenceArticle struct {
	ID           int64     `gorm:"column:id;primarykey" json:"id"`
	ParagraphID  int64     `gorm:"column:paragraph_id;type:integer;not null" json:"paragraphID"`
	ArticleID    int64     `gorm:"column:article_id;type:integer;not null" json:"articleID"`
	Created      time.Time `gorm:"column:created;type:datetime;not null" json:"created"`
	LastModified time.Time `gorm:"column:last_modified;type:datetime;not null" json:"lastModified"`
}

type ReferenceArticles []*ReferenceArticle

type ReferenceWeb struct {
	ID           int64     `gorm:"column:id;primarykey" json:"id"`
	ParagraphID  int64     `gorm:"column:paragraph_id;type:integer;not null" json:"paragraphID"`
	URL          string    `gorm:"column:url;type:varchar(256);not null" json:"url"`
	Created      time.Time `gorm:"column:created;type:datetime;not null" json:"created"`
	LastModified time.Time `gorm:"column:last_modified;type:datetime;not null" json:"lastModified"`
}

type ReferenceWebs []*ReferenceWeb

type Tags []string