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