Monitoring

Tables (8)

dbo.Account_Member (계정별 멤버)

  • Id — bigint — Primary key — NOT NULL
  • AccountId — bigint — Foreign key → dbo.Monitoring_Account.Id — NOT NULL
  • MemberName — nvarchar(100) — NOT NULL

dbo.Member_Mention (게시글별 멤버 언급수)

  • Id — bigint — Primary key — NOT NULL
  • ContentsId — bigint — Foreign key → dbo.Monitoring_Contents.Id — NOT NULL
  • MemberId — bigint — Foreign key → dbo.Account_Member.Id — NOT NULL
  • MentionCnt — int
  • LastUpdate — datetime

dbo.Monitoring_Account (사이트별 계정)

  • Id — bigint — Primary key — NOT NULL
  • SiteId — bigint — Foreign key → dbo.Monitoring_Site.Id — NOT NULL
  • AccountName — nvarchar(100)
  • InsertDate — datetime
  • CrawlerYN — nvarchar(2) — 크롤링 여부

dbo.Monitoring_Comments (댓글)

  • Id — bigint — Primary key — NOT NULL
  • ContentsId — bigint — Foreign key → dbo.Monitoring_Contents.Id — NOT NULL
  • Comment — nvarchar(MAX) — varchar(MAX) COLLATE Korean_Wansung_CS_AS NUL
  • LikeCnt — bigint
  • PublishDate — nvarchar(20)
  • PostRating — int
  • Translation — nvarchar(MAX)
  • InsertDate — datetime

dbo.Monitoring_Contents (게시글 정보)

  • Id — bigint — Primary key — NOT NULL
  • AccountId — bigint — Foreign key → dbo.Monitoring_Account.Id — NOT NULL
  • ContentsUrl — nvarchar(MAX)
  • Title — nvarchar(500)
  • ReadCnt — bigint
  • ReplyCnt — bigint
  • LikeCnt — bigint
  • PublishDate — nvarchar(100)
  • InsertDate — datetime
  • UpdateDate — datetime

dbo.Monitoring_Sentiment (Vertex AI 감정분석 데이터)

  • Id — bigint — Primary key — NOT NULL
  • Content — nvarchar(MAX)
  • PostRating — int
  • InsertDate — datetime

dbo.Monitoring_Site (사이트 리스트)

  • Id — bigint — Primary key — NOT NULL
  • SiteTitle — nvarchar(100)
  • Address — nvarchar(100)

dbo.TEMP_BulkInsert (댓글 Bulk TEMP)

  • Id — bigint — Primary key — NOT NULL
  • ContentsId — bigint — NOT NULL
  • Comment — nvarchar(MAX) — varchar(MAX) COLLATE Korean_Wansung_CS_AS NUL
  • LikeCnt — bigint
  • PublishDate — nvarchar(20)
  • PostRating — int
  • Translation — nvarchar(MAX)
  • InsertDate — datetime