Crawler_Site
Tables (13)
dbo.Crawler_Comment (댓글)
- Id — bigint — Primary key — NOT NULL
- ContentsId — bigint — Foreign key → dbo.Crawler_Contents.Id — NOT NULL
- Comment — nvarchar(MAX) — varchar(MAX) COLLATE Korean_Wansung_CI_AS NUL
- PublishDate — nvarchar(100)
- LikeCnt — int
- InsertDate — datetime
dbo.Crawler_Contents (게시글)
- Id — bigint — Primary key — NOT NULL
- SiteId — bigint — Foreign key → dbo.Crawler_Site.Id — NOT NULL
- BoardNum — nvarchar(255)
- BoardName — nvarchar(100) — 게시판명
- Title — nvarchar(MAX)
- Contents — nvarchar(MAX)
- ReadCnt — int
- LikeCnt — int
- ReplyCnt — int
- PublishDate — nvarchar(100)
- InsertDate — datetime
- UpdateDate — datetime
dbo.Crawler_Keyword (키워드)
- Id — bigint — Primary key — NOT NULL
- SiteId — bigint — Foreign key → dbo.Crawler_Site.Id — NOT NULL
- PressCampaignId — bigint — Foreign key → dbo.PressCampaign.Id — NOT NULL
- Keyword — nvarchar(255)
- SongTitle — nvarchar(255)
- Album — nvarchar(255)
- SubKeyword — nvarchar(500)
- DeleteYn — nvarchar(5)
- InsertDate — datetime
dbo.Crawler_Keyword_Comment (키워드 댓글)
- Id — bigint — Primary key — NOT NULL
- ContentsId — bigint — Foreign key → dbo.Crawler_Keyword_Contents.SiteId — NOT NULL
- PressCampaignId — bigint — Foreign key → dbo.Crawler_Keyword_Contents.KeywordId — NOT NULL
- Comment — nvarchar(MAX) — varchar(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NUL
- PublishDate — nvarchar(100)
- LikeCnt — int
- PostRating — int
dbo.Crawler_Keyword_Contents (키워드 게시글)
- Id — bigint — Primary key — NOT NULL
- SiteId — bigint — Foreign key → dbo.Crawler_Site.Id — NOT NULL
- KeywordId — bigint — Foreign key → dbo.Crawler_Keyword.PressCampaignId — NOT NULL
- BoardNum — nvarchar(100)
- BoardName — nvarchar(100)
- Keyword — nvarchar(100)
- ContentsUrl — nvarchar(255)
- Title — nvarchar(MAX)
- Contents — nvarchar(MAX)
- ReadCnt — int
- LikeCnt — int
- ReplyCnt — int
- PublishDate — nvarchar(100)
- InsertDate — datetime
- UpdateDate — datetime
- PostRating — int
dbo.Crawler_Keyword_Melon (멜론 키워드 차트)
- Id — bigint — Primary key — NOT NULL
- SiteId — bigint — Foreign key → dbo.Crawler_Site.Id — NOT NULL
- SA_Type — nvarchar(100)
- Keyword — nvarchar(100)
- Title — nvarchar(255)
- LikeCnt — bigint
- PublishDate — nvarchar(100)
- InsertDate — datetime
dbo.Crawler_Melon (멜론 차트)
- Id — bigint — Primary key — NOT NULL
- SiteId — bigint — Foreign key → dbo.Crawler_Site.Id — NOT NULL
- Type — nvarchar(100)
- AggregateTime — nvarchar(100)
- Ranking — bigint
- RankChange — nvarchar(100)
- SongTitle — nvarchar(100)
- Album — nvarchar(100)
- Artist — nvarchar(100)
- LikeCnt — bigint
- InsertDate — datetime
dbo.Crawler_Naver ([언론] 네이버 뉴스)
- Id — bigint — Primary key — NOT NULL
- KeywordId — bigint — Foreign key → dbo.Crawler_Keyword.PressCampaignId — NOT NULL
- Keyword — nvarchar(255)
- MediaCompany — nvarchar(100)
- Title — nvarchar(MAX)
- Url — nvarchar(MAX)
- PublishDate — nvarchar(255)
- InsertDate — datetime
- DeleteYn — nvarchar(5)
dbo.Crawler_News (구글 뉴스)
- Id — bigint — Primary key — NOT NULL
- SiteId — bigint — Foreign key → dbo.Crawler_Site.Id — NOT NULL
- Title — nvarchar(MAX)
- Url — nvarchar(MAX)
- PublishDate — nvarchar(100)
- InsertDate — datetime
dbo.Crawler_Site
- Id — bigint — Primary key — NOT NULL
- SiteTitle — nvarchar(255)
- Address — nvarchar(255)
dbo.Excluded_Words (제외 단어)
- Id — bigint — NOT NULL
- Word — nvarchar(100)
- InsertDate — datetime
dbo.PressCampaign
- Id — bigint — Primary key — NOT NULL
- CustomerName — nvarchar(255)
- Title — nvarchar(255)
- StartDate — datetime
- EndDate — datetime
- DeleteYn — nvarchar(5)
- InsertDate — datetime
- InsertUserId — int
- UpdateDate — datetime
- UpdateUserId — int
dbo.WordCloud (WordCloud)
- Id — bigint — Primary key — NOT NULL
- Keyword — nvarchar(100)
- Word — nvarchar(100)
- WordCnt — bigint
- PublishDate — nvarchar(100)
- InsertDate — datetime