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