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