common_event
Tables (8)
EventRouletteUseLog (tb_event_roulette_use_log)
- seq — bigint — Primary key — NOT NULL
- accNum — bigint — NOT NULL
- id — nvarchar(20)
- gameCode — nvarchar(20)
- eventCode — nvarchar(20) — NOT NULL
- platform — nvarchar(20)
- rank — tinyInt
- itemId — int — NOT NULL
- itemCount — int — NOT NULL
- beforeRouletteCount — int
- afterRouletteCount — int
- regDate — datetime — NOT NULL
- ip — nvarchar(20)
tb_event_option
- seq — bigint — Primary key — NOT NULL
- gameCode — nvarchar(20)
- eventCode — nvarchar(20) — NOT NULL
- name — nvarchar(100) — NOT NULL
- value — nvarchar(100) — NOT NULL
tb_event_roulette
- Key — bigint — Primary key — NOT NULL
- accNum — bigint — NOT NULL
- gameCode — bigint
- eventCode — bigint — NOT NULL
- rouletteAcqCount — int — NOT NULL
- rouletteUseCount — int — NOT NULL
tb_ro1_vip_async2_log
- seq — BIGINT — Primary key — NOT NULL
- rank — INT — NOT NULL
- eventCode — NVARCHAR(20) — NOT NULL
- gameCode — NVARCHAR(20) — NOT NULL
- name — NVARCHAR(200) — NOT NULL
- itemId — INT — NOT NULL
- itemCount — INT — NOT NULL
- rate — FLOAT — NOT NULL
tb_roulette_item (tb_event_roulette_item)
- seq — BIGINT — Primary key — NOT NULL
- rank — INT — NOT NULL
- eventCode — NVARCHAR(20) — NOT NULL
- gameCode — NVARCHAR(20) — NOT NULL
- name — NVARCHAR(200) — NOT NULL
- itemId — INT — NOT NULL
- itemCount — INT — NOT NULL
- rate — FLOAT — NOT NULL
tb_vip_user_regist
- seq — BIGINT — Primary key — NOT NULL
- vip_seq — BIGINT — NOT NULL
- regDate — DATETIME — NOT NULL
tb_vip_user_regist_prize
- seq — BIGINT — Primary key — NOT NULL
- accNum — bigint — NOT NULL
- userId — nvarchar(50)
- gameCode — nvarchar(20) — NOT NULL
- gradeYear — int — NOT NULL
- isUse — BIT — NOT NULL
vipUser (tb_vip_user)
- seq — bigint — Primary key — NOT NULL
- accNum — bigint — NOT NULL
- userId — nvarchar(50)
- gameNum — nvarchar(20) — NOT NULL
- eventCode — nvarchar(20) — NOT NULL
- grade — nvarchar(20)
- birthMonth — tinyInt — NOT NULL
- gradeYear — int