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)