Skip to content

CloudBread database design

Jump to bottom Edit New page
YoonSeok Hong edited this page Aug 2, 2017 · 26 revisions

CloudBread Database Table Lists

Member table

Column name Logical type Physical Type PK, Index, Constraint Default Value Note
MemberID string nvarchar(256) PK, NC Index MemberID
MemberPWD string nvarchar(256) CloudBread v2 is using external authentication provider(Facebook, Twitter, Microsoft ID, Google ID).
EmailAddress string nvarchar(450) NC Index, Unique Email address
EmailConfirmedYN bool nvarchar(40) N Email address confirm flag
PhoneNumber1 string nvarchar(50) Phone number1
PhoneNumber2 string nvarchar(50) Phone number1
PINumber string nvarchar(100) SSN PI number
Name1 string nvarchar(100) NC Index Name1
Name2 string nvarchar(100) Name2
Name3 string nvarchar(100) Name3
DOB string nvarchar(50) YYYYMMDD
RecommenderID string nvarchar(256) Recursive - recommended MemberID
MemberGroup string nvarchar(50) Admin page management purpose.
LastDeviceID string nvarchar(128) NC Index Last login device ID
LastIPaddress string nvarchar(128) Last login IP address
LastLoginDT datetime nvarchar(64) Last login datetime
LastLogoutDT datetime nvarchar(64) Last logout datetime
LastMACAddress string nvarchar(128) Last login MAC address
AccountBlockYN bool nvarchar(40) Account blocked flag
AccountBlockEndDT datetime nvarchar(64) Account block expire date
AnonymousYN bool nvarchar(40) Using anonymous login flag
3rdAuthProvider string nvarchar(128) 3rd party authentication provider name
3rdAuthID string nvarchar(256) NC Index 3rd party authentication ID
3rdAuthParam string nvarchar(256) 3rd party authentication related parameter
PushNotificationID string nvarchar(512) NC Index Push registration ID
PushNotificationProvider string nvarchar(256) Push provider
PushNotificationGroup string nvarchar(256) Push group(tag purpose)
sCol1 string nvarchar(MAX)
sCol2 string nvarchar(MAX)
sCol3 string nvarchar(MAX)
sCol4 string nvarchar(MAX)
sCol5 string nvarchar(MAX)
sCol6 string nvarchar(MAX)
sCol7 string nvarchar(MAX)
sCol8 string nvarchar(MAX)
sCol9 string nvarchar(MAX)
sCol10 string nvarchar(MAX)
TimeZoneID string nvarchar(40) NE Korea Standard Time Member UTC convert purpose TimeZone. https://msdn.microsoft.com/en-us/library/gg154758.aspx
HideYN bool nvarchar(1) NE N Hide YN flag - admin purpose
DeleteYN bool nvarchar(1) NE N Delete YN flag - admin purpose - make actual deletion in monthly batch
CreatedAt datetimeoffset(7) datetimeoffset(7) C Index / NE (sysutcdatetime()) Data created datetime
UpdatedAt datetimeoffset(7) datetimeoffset(7) NE (sysutcdatetime()) Last data modified datetime
DataFromRegion string nvarchar(64) NE Data from region - Reserved for "Cirrus" project - global data replication purpose
DataFromRegionDT string datetimeoffset(7) NE Processed datetime - Reserved for "Cirrus" project - global data replication purpose

AdminMember table

Column name Logical Type Physical Type PK, Index, Constraint Default Value description
AdminMemberID string nvarchar(128) PK, NC Index Admin ID
AdminMemberPWD string nvarchar(128) CloudBread v2 is using external authentication provider(Facebook, Twitter, Microsoft ID, Google ID). Hash encryption
AdminMemberEmail string nvarchar(128) NC Index, Unique Email address
IDCreateAdminMember string nvarchar(128) ID Creator ID
AdminGroup string nvarchar(40) Admin group : Admin, Operator, Reader
TimeZoneID string nvarchar(40) Korea Standard Time Member UTC convert purpose TimeZone.
PINumber string nvarchar(50) SSN PID
Name1 string nvarchar(50) NC Index Name 1
Name2 string nvarchar(50) Name 2
Name3 string nvarchar(50) Name 3
DOB string nvarchar(16) YYYYMMDD
LastIPaddress string nvarchar(32) Last login IP address
LastLoginDT datetime nvarchar(32) Last login datetime
LastLogoutDT datetime nvarchar(32) Last logout datetime
sCol1 string nvarchar(MAX)
sCol2 string nvarchar(MAX)
sCol3 string nvarchar(MAX)
sCol4 string nvarchar(MAX)
sCol5 string nvarchar(MAX)
sCol6 string nvarchar(MAX)
sCol7 string nvarchar(MAX)
sCol8 string nvarchar(MAX)
sCol9 string nvarchar(MAX)
sCol10 string nvarchar(MAX)
DeleteYN bool nvarchar(1) NE N DeleteYN
HideYN bool nvarchar(1) NE N HideYN
CreatedAt datetimeoffset(7) datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetimeoffset(7) datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT string datetimeoffset(7) NE DataFromRegionDT

MemberItemPurchase table

Column name Logical Type Physical SQL Type PK, Index, Constraint Default Value Description
MemberItemPruchaseID string nvarchar(128) PK, NC Index (newid()) Prefer GUID
MemberID string nvarchar(256) NC Index Logical FK
ItemListID string nvarchar(128) NC Index Logical FK
PurchasePrice int64 nvarchar(50) Purchase price
PurchaseQuantity string nvarchar(512) Purchase quantity
PGinfo1 string nvarchar(512) Paygate info1
PGinfo2 string nvarchar(512) Paygate info2
PGinfo3 string nvarchar(512) Paygate info3
PGinfo4 string nvarchar(512) Paygate info4
PGinfo5 string nvarchar(512) Paygate info5
PurchaseDeviceID string nvarchar(128) NC Index Purchase device ID
PurchaseDeviceIPAddress string nvarchar(64) purchase device IP address
PurchaseDeviceMACAddress string nvarchar(128) Purchase device MAC address
PurchaseDT datetime nvarchar(64) (sysutcdatetime()) Purchase datetime
PurchaseCancelYN bool nvarchar(40) N Purchase cancel flag
PurchaseCancelDT datetime nvarchar(64) Purchase cancel datetime
PurchaseCancelingStatus string nvarchar(40) Purchase cancel satus code 0 - OK(default) / 1 - return done / 2 -user requested return / 3 - return process on going / you could set up your status code by yourself.
PurchaseCancelReturnedAmount int64 nvarchar(50) Purchase cancel return price
PurchaseCancelDeviceID string nvarchar(128) NC Index Purchase cancel device ID
PurchaseCancelDeviceIPAddress string nvarchar(64) Purchase cancel device IP address
PurchaseCancelDeviceMACAddress string nvarchar(128) Purchase cancel device MAC address
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
PurchaseCancelConfirmAdminMemberID string nvarchar(256) NE Purchase cancel approved admin member ID
HideYN bool nvarchar(1) NE N HideYN
DeleteYN bool nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT string datetimeoffset(7) NE DataFromRegionDT

ItemList table

Column name Logical Type Physical Type PK, Index, Constraint Default Value Description
ItemListID string nvarchar(128) PK, NC Index (newid()) Item ID
ItemName string nvarchar(12) NC Index, Unique Item name
ItemDescription string nvarchar(4000) Item description
ItemPrice int64 nvarchar(50) Item price
ItemSellPrice int64 nvarchar(50) Item sell price
ItemCategory1 string nvarchar(100) NC Index Item category 1
ItemCategory2 string nvarchar(100) NC Index Item category 2
ItemCategory3 string nvarchar(100) NC Index Item category 3
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
IteamCreateAdminID string nvarchar(128) NE Item created admin member ID
IteamUpdateAdminID string nvarchar(128) NE Item last modified admin member ID
HideYN bool nvarchar(1) NE N HideYN
DeleteYN bool nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT string datetimeoffset(7) NE DataFromRegionDT

MemberItems table

Column name Logical Physical PK, Index, Constraint Default Value note
MemberItemID string nvarchar(128) PK, NC Index (newid()) Member item ID
MemberID string nvarchar(256) NC Index Member ID - FK
ItemListID string nvarchar(128) NC Index Item ID - FK
ItemCount bigint nvarchar(40) Item count number
ItemStatus string nvarchar(50) Item stats (damaged or something - check multiple item YN)
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
HideYN bool nvarchar(1) NE N HideYN
DeleteYN bool nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT string datetimeoffset(7) NE DataFromRegionDT

MemberGameInfo table

Column name logical Physical PK, Index, Constraint Default Value note
MemberID string nvarchar(256) PK, NC Index Member ID
Level int nvarchar(40) Game level
Exps int64 nvarchar(50) Exp point. Level up measure point for level up, save at client side.(level2 = exp 300 / level3 - exp 500) Everytime getting exp point, compare level up measure point at client side.
Points int64 nvarchar(50) Game point data - used for leader board and redis rank service
UserSTAT1 string nvarchar(max) Save members various game status 1
UserSTAT2 string nvarchar(max) Save members various game status 2
UserSTAT3 string nvarchar(max) Save members various game status 3
UserSTAT4 string nvarchar(max) Save members various game status 4
UserSTAT5 string nvarchar(max) Save members various game status 5
UserSTAT6 string nvarchar(max) Save members various game status 6
UserSTAT7 string nvarchar(max) Save members various game status 7
UserSTAT8 string nvarchar(max) Save members various game status 8
UserSTAT8 string nvarchar(max) Save members various game status 9
UserSTAT10 string nvarchar(max) Save members various game status 10
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
HideYN bool nvarchar(1) NE N HideYN
DeleteYN bool nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT string datetimeoffset(7) NE DataFromRegionDT

MemberGameInfoStages table

Column name logical Physical PK, Index, Constraint Default Value note
MemberGameInfoStageID string nvarchar(128) PK, NC Index (newid()) Member Stage ID
MemberID string nvarchar(256) NC Index Member ID - FK
StageName string nvarchar(100) Stage Name
StageStatus string nvarchar(40) Satge status. You can set this data by yourself to indentify the status.
Category1 string nvarchar(80) Stage category 1
Category2 string nvarchar(80) Stage category 2
Category3 string nvarchar(80) Stage category 3
Mission1 string nvarchar(80) Stage mession or mission result 1
Mission2 string nvarchar(80) Stage mession or mission result 2
Mission3 string nvarchar(80) Stage mession or mission result 3
Mission4 string nvarchar(80) Stage mession or mission result 4
Mission5 string nvarchar(80) Stage mession or mission result 5
Points int nvarchar(50) Stage point
StageStat1 string nvarchar(max) Stage status 1
StageStat2 string nvarchar(max) Stage status 2
StageStat3 string nvarchar(max) Stage status 3
StageStat4 string nvarchar(max) Stage status 4
StageStat5 string nvarchar(max) Stage status 5
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
HideYN bool nvarchar(1) NE N HideYN
DeleteYN bool nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT string datetimeoffset(7) NE DataFromRegionDT

GiftDepository table

Column name logical Physical PK, Index, Constraint Default Value Note
GiftDepositoryID string nvarchar(128) PK, NC Index (newid()) Gift Depository ID
ItemListID string nvarchar(128) NC Index Item ID - FK
ItemCount bigint nvarchar(40) item count number
FromMemberID string nvarchar(256) NC Index From member ID - FK
ToMemberID string nvarchar(256) NC Index Send to member ID - FK
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
SentMemberYN bool nvarchar(40) NE N Gift sented to friend YN flag
HideYN bool nvarchar(1) NE N HideYN
DeleteYN bool nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT datetime datetimeoffset(7) NE DataFromRegionDT

Notices table

Column name Logical Physical PK, Index, Constraint Default Value note
NoticeID string nvarchar(128) PK, NC Index (newid()) Notice ID
NoticeCategory1 string nvarchar(50) Notice Category 1 - Popup notice, System maintenance notice, General notice and etc. - you can set it by yourself.
NoticeCategory2 string nvarchar(50) Notice Category 2
NoticeCategory3 string nvarchar(50) Notice Category 3
TargetGroup string nvarchar(50) Admin created group for notice target
TargetOS string nvarchar(50) Target OS. Android or iOS …
TargetDevice string nvarchar(80) Target Device. Galaxy or …
NoticeImageLink string nvarchar(512) Notice image link. Upload image on Blob strorage with Azure Storage Explorer and then set the link(optional use - CDN endpoint)
Title string nvarchar(100) Notice title
Content string nvarchar(4000) Notice content and image links
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
NoticeDurationFrom datetime datetimeoffset(7) NE No encryption / Notice start datetime. It's used for where condition of procedure.
NoticeDurationTo datetime datetimeoffset(7) NE NE / Notice end datetime. It's used for where condition of procedure.
OrderNumber int int NE 0 No encryption. Notice order number. Used by procedure order by clause.
CreateAdminID string nvarchar(128) NC Index, NE Create admin member ID
HideYN Bool nvarchar(1) NE N HideYN
DeleteYN Bool nvarchar(1) NE N DeleteYN
CreatedAt datetimeoffset(7) datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetimeoffset(7) datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT string datetimeoffset(7) NE DataFromRegionDT

GameEvents table

Column name Logical Physical PK, Index, Constraint Default Value note
GameEventID string nvarchar(128) PK, NC Index (newid()) Event ID
eventCategory1 string nvarchar(50) Event Category 1 - You can set by yourself.
eventCategory2 string nvarchar(50) Event Category 2
eventCategory3 string nvarchar(50) Event Category 3
ItemListID string nvarchar(128) NC index item ID - FK
ItemListName string nvarchar(100) Item came
ItemListDescription string nvarchar(4000) Item description
ItemCount string nvarchar(50) Item count number
ItemStatus string nvarchar(50) Item status
TargetGroup string nvarchar(50) Target group made by admin member
TargetOS string nvarchar(40) Target OS - iOS, Android…
TargetDevice string nvarchar(80) Target device - Galaxy …
EventImageLink string nvarchar(512) Event image link. Upload image on Blob strorage with Azure Storage Explorer and then set the link(optional use - CDN endpoint)
Title string nvarchar(100) Event title
Content string nvarchar(4000) Event contents
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
CreateAdminID string nvarchar(128) NE Create admin member ID
HideYN string nvarchar(1) NE N HideYN
DeleteYN string nvarchar(1) NE N DeleteYN
OrderNumber string int NE 0 No encryption. Notice order number. Used by procedure order by clause.
EventDurationFrom datetime datetimeoffset(7) NC index - Between No encryption - event start datetime
EventDurationTo datetime datetimeoffset(7) NC index - Between No encryption - event end datetime
CreatedAt datetimeoffset(7) datetimeoffset(7) C index (sysutcdatetime()) CreatedAt
UpdatedAt datetimeoffset(7) datetimeoffset(7) (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) DataFromRegion
DataFromRegionDT string datetimeoffset(7) DataFromRegionDT

GameEvents table

Column name Logical Physical PK, Index, Constraint Default Value note
GameEventID string nvarchar(128) PK, NC Index (newid()) Event ID
eventCategory1 string nvarchar(50) Event Category 1 - You can set by yourself.
eventCategory2 string nvarchar(50) Event Category 2
eventCategory3 string nvarchar(50) Event Category 3
ItemListID string nvarchar(128) NC index item ID - FK
ItemListName string nvarchar(100) Item came
ItemListDescription string nvarchar(4000) Item description
ItemCount string nvarchar(50) Item count number
ItemStatus string nvarchar(50) Item status
TargetGroup string nvarchar(50) Target group made by admin member
TargetOS string nvarchar(40) Target OS - iOS, Android…
TargetDevice string nvarchar(80) Target device - Galaxy …
EventImageLink string nvarchar(512) Event image link. Upload image on Blob strorage with Azure Storage Explorer and then set the link(optional use - CDN endpoint)
Title string nvarchar(100) Event title
Content string nvarchar(4000) Event contents
sCol1 string nvarchar(max)
sCol2 string nvarchar(max)
sCol3 string nvarchar(max)
sCol4 string nvarchar(max)
sCol5 string nvarchar(max)
sCol6 string nvarchar(max)
sCol7 string nvarchar(max)
sCol8 string nvarchar(max)
sCol9 string nvarchar(max)
sCol10 string nvarchar(max)
CreateAdminID string nvarchar(128) NE Create admin member ID
HideYN string nvarchar(1) NE N HideYN
DeleteYN string nvarchar(1) NE N DeleteYN
OrderNumber string int NE 0 No encryption. Notice order number. Used by procedure order by clause.
EventDurationFrom datetime datetimeoffset(7) NC index - Between No encryption - event start datetime
EventDurationTo datetime datetimeoffset(7) NC index - Between No encryption - event end datetime
CreatedAt datetimeoffset(7) datetimeoffset(7) C index (sysutcdatetime()) CreatedAt
UpdatedAt datetimeoffset(7) datetimeoffset(7) (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) DataFromRegion
DataFromRegionDT string datetimeoffset(7) DataFromRegionDT

Coupon table

Column name Logical Physical PK, Index, Constraint Default Value note
CouponID string nvarchar(128) PK, NC Index (newid()) Coupon ID
CouponCategory1 string nvarchar(50) Coupon Category 1 - You can set by yourself.
CouponCategory2 string nvarchar(50) Coupon Category 2
CouponCategory3 string nvarchar(50) Coupon Category 3
ItemListID string nvarchar(128) NC index Item ID - FK
ItemCount string nvarchar(50) Item count number
ItemStatus string nvarchar(50) Item status
TargetGroup string nvarchar(50) Admin create target group
TargetOS string nvarchar(50) Target OS - Android, iOS…
TargetDevice string nvarchar(80) Target device - Galaxy …
Title string nvarchar(100) Coupon title
Content string nvarchar(4000) Coupon content
sCol1 string nvarchar(MAX)
sCol2 string nvarchar(MAX)
sCol3 string nvarchar(MAX)
sCol4 string nvarchar(MAX)
sCol5 string nvarchar(MAX)
sCol6 string nvarchar(MAX)
sCol7 string nvarchar(MAX)
sCol8 string nvarchar(MAX)
sCol9 string nvarchar(MAX)
sCol10 string nvarchar(max)
CouponDurationFrom datetime datetimeoffset(7) NC Index, NE - Between No encryption - coupon start datetime
CouponDurationTo datetime datetimeoffset(7) NC Index, NE - Between No encryption - coupon end datetime
OrderNumber int int NE 0 No encryption. Notice order number. Used by procedure order by clause.
DupeYN bool nvarchar(1) NE N No Encryption. Not just for one member but also, resusable for everone. Duplication YN flag. For the onetime usage, set it N or multiple use by other member set it Y
CreateAdminID string nvarchar(128) NE Create admin ID
HideYN bool nvarchar(1) NE N HideYN
DeleteYN bool nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT datetime datetimeoffset(7) NE DataFromRegionDT

CouponMember table

Column name Logical Physical PK, Index, Constraint Default Value Note
CouponMemberID string nvarchar(128) PK, NC Index (newid()) Coupon meber ID
CouponID string nvarchar(128) NC index Coupon ID - FK
MemberID string nvarchar(256) NC index Member ID - FK
sCol1 string nvarchar(MAX)
sCol2 string nvarchar(MAX)
sCol3 string nvarchar(MAX)
sCol4 string nvarchar(MAX)
sCol5 string nvarchar(MAX)
sCol6 string nvarchar(MAX)
sCol7 string nvarchar(MAX)
sCol8 string nvarchar(MAX)
sCol9 string nvarchar(MAX)
sCol10 string nvarchar(MAX)
HideYN string nvarchar(1) NE N HideYN
DeleteYN string nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) C Index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT datetime datetimeoffset(7) NE DataFromRegionDT

MemberAccountBlockLog table

Column name Logical Physical PK, Index, Constraint Default Value Note
MemberAccountBlockID nvarchar(128) PK, NC Index (newid()) Member account block ID
MemberID nvarchar(256) NC index Member ID - FK
MemberAccountBlockReasonCategory1 nvarchar(50) Block reason 1 - abusing or insulting ..
MemberAccountBlockReasonCategory2 nvarchar(50) Block reason 2
MemberAccountBlockReasonCategory3 nvarchar(50) Block reason 3
MemberAccountBlockReason nvarchar(1000) Account block reason
MemberAccountBlockProcess nvarchar(50) Accunt block process - starting block, block released, un block …
sCol1 nvarchar(MAX)
sCol2 nvarchar(MAX)
sCol3 nvarchar(MAX)
sCol4 nvarchar(MAX)
sCol5 nvarchar(MAX)
sCol6 nvarchar(MAX)
sCol7 nvarchar(MAX)
sCol8 nvarchar(MAX)
sCol9 nvarchar(MAX)
sCol10 nvarchar(MAX)
CreateAdminID nvarchar(128) NC index, NE Create admin member ID
HideYN nvarchar(1) NE N HideYN
DeleteYN nvarchar(1) NE N DeleteYN
CreatedAt datetime datetimeoffset(7) c index, NE (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) NE (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) NE DataFromRegion
DataFromRegionDT datetime datetimeoffset(7) NE DataFromRegionDT

ServerInfo table

Column name Logical Physical PK, Index, Constraint Default Value Note
InfoID string nvarchar(128) PK, NC Index (newid()) Server info ID
ServerLists string nvarchar(256) Use for multiple server cluster service
Version string nvarchar(50) Version info setting for your game
ResourceLink string nvarchar(4000) Resource or asset download links. Split the files resource file list and utilize Azure CDN.
EULAText string nvarchar(8000) EULA text usage
CreatedAt datetime datetimeoffset(7) C Index (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) (sysutcdatetime()) UpdatedAt
DataFromRegion string nvarchar(64) DataFromRegion
DataFromRegionDT datetime datetimeoffset(7) DataFromRegionDT

StatData table

Column name Logical Physical PK, Index, Constraint Default Value Note
StatID string nvarchar(50) PK, NC Index (newid()) Statistics ID
CategoryName string nvarchar(256) C Index Statistics group name
CountNum int bigint number data
Fields string nvarchar(4000) field name
Groups string nvarchar(100) cohort group name
CreatedAt datetime datetimeoffset(7) NC Index (sysutcdatetime()) CreatedAt
UpdatedAt datetime datetimeoffset(7) (sysutcdatetime()) UpdatedAt
Add a custom footer

logo

Introduce

Tutorial

Documents

API Reference

Official Translation Kor

소개

튜토리얼

Official Translation JPN

紹介

テュートリアル

Clone this wiki locally