1

Tables (7)

tblConnectHangfireScheduleJobMapping

  • HangfireId — varchar(32) — Primary key — NOT NULL
  • BaseId — varchar(32) — NOT NULL
  • JobType — int — NOT NULL
  • RegisteredDate — datetime — NOT NULL

tblContest

  • ContestSeq — int — Primary key — NOT NULL
  • Title — nvarchar(60) — NOT NULL
  • HostName — nvarchar(20) — NOT NULL
  • HostSite — nvarchar(100)
  • Description — nvarchar(max)
  • NoticeDate — DateTime — NOT NULL
  • SubmissionDate — DateTime — NOT NULL
  • EvaluationDate — DateTime — NOT NULL
  • AnnouncementDate — DateTime — NOT NULL
  • ClosedDate — DateTime — NOT NULL
  • CheckLikesDate — bit — NOT NULL
  • LikesDate — DateTime
  • Visibility — int — NOT NULL
  • UploadItemType — int — NOT NULL
  • NumberOfWorkType — int — NOT NULL
  • OpenDate — DateTime
  • RegisteredBy — int — NOT NULL
  • RegisteredDate — DateTime — NOT NULL
  • ChangedBy — int
  • ChangedDate — DateTime
  • ImageFileName — nvarchar(256) — NOT NULL
  • ImageFilePath — nvarchar(256) — NOT NULL

tblContestAward

  • AwardId — varchar(32) — Primary key — NOT NULL
  • ContestSeq — int — NOT NULL
  • Title — nvarchar(50) — NOT NULL
  • BadgeId — int
  • Member — int — NOT NULL
  • Sort — int — NOT NULL

tblContestAwardLayout

  • LayoutId — varchar(32) — Primary key — NOT NULL
  • ContestSeq — int — NOT NULL
  • LayoutType — int — NOT NULL
  • AwardId — varchar(32) — NOT NULL
  • RegisteredBy — int — NOT NULL
  • RegisteredDate — DateTime — NOT NULL

tblContestChangeHistory

  • Seq — int — Primary key — NOT NULL
  • ContestSeq — int — NOT NULL
  • ChangedBy — int — NOT NULL
  • ChangedDate — DateTime — NOT NULL

tblMarketPlace

  • ItemId — varchar(32) — Primary key — NOT NULL
  • IsTemp — bit — Primary key — NOT NULL
  • Type — int — NOT NULL
  • Name — nvarchar(256)
  • ImageSeq — int — NOT NULL
  • CategoryId — varchar(32)
  • ItemCode — varchar(32)
  • Description — nvarchar(max)
  • Rejection — nvarchar(4000)
  • Selection — bit — NOT NULL
  • OriginalPrice — decimal(18, 2)
  • SalesPrice — decimal(18, 2)
  • Status — int — NOT NULL
  • RegisteredBy — int — NOT NULL
  • RegisteredDate — datetime — NOT NULL
  • ChangeBy — int
  • ChangeDate — datetime
  • ConfirmBy — int
  • ConfirmDate — datetime
  • AdminChangeBy — int
  • AdminChangeDate — datetime
  • CollectionId — nvarchar(40) — NOT NULL
  • CollectionItemIndex — int — NOT NULL
  • Version — int — NOT NULL
  • IsPhysicalProduction — bit — NOT NULL
  • PrcingType — int — NOT NULL
  • DailyWeekGroup — int — NOT NULL
  • ItemNumber — bigint — NOT NULL
  • DailyMonthGroup — int — NOT NULL
  • ZipStatus — int
  • comment — nvarchar(4000) — varchar(4000) NUL
  • AutoPublish — bit
  • MDPick — bit — NOT NULL
  • CopiedLikeCount — int — Do not use it for anything other than sorting and filtering.
  • CopiedViewCount — int — Do not use it for anything other than sorting and filtering.
  • CopiedBasePrice — decimal(18, 2) — Do not use it for anything other than sorting and filtering.
  • MetaversStatus — int
  • PlatformId — char(5)
  • ContestStatus — int — NOT NULL
  • IsMetavers — bit
  • IsConvertingSuccess — bit
  • IGNORE_DUP_KEY — =
  • FILLFACTOR — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • IGNORE_DUP_KEY — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • IGNORE_DUP_KEY — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tblMarketPlaceContestItem

  • ItemId — varchar(32) — Primary key — NOT NULL
  • ContestSeq — int — NOT NULL
  • LikeCount — int
  • AwardId — varchar(32)
  • LayoutId — varchar(32)
  • LayoutRegisteredDate — DateTime
  • UserId — int
  • ImageFileName — nvarchar(256)
  • ImageFilePath — nvarchar(256)
  • Name — nvarchar(256)