트래픽논리

테이블 (8)

account_group_code (Untitled5)

  • account_group_code (Key) — char — 기본 키 — NOT NULL
  • char_group_code_desc (Field) — varchar

ccu (Untitled)

  • device_id (Key) — 기본 키 — NOT NULL
  • server_id (Key2) — 기본 키 — NOT NULL
  • game_id (Key4) — 외래 키 → game_id.game_id — NOT NULL
  • base_time (Field) — timestamp
  • ccu (Field2) — bigint

dau (Untitled2)

  • base_date (Key3) — date — 기본 키 — NOT NULL
  • account_group_code (Key) — char — 외래 키 → account_group_code.account_group_code — NOT NULL
  • game_id (Key2) — char — 외래 키 → game_id.game_id — NOT NULL
  • au (Field) — bigint

device (Untitled7)

  • device_id (int) — char — 기본 키 — NOT NULL
  • account_id (Key) — bigint — 외래 키 → master_snapshot.account_id — NOT NULL
  • game_id (Key3) — char — 외래 키 → master_snapshot.game_id — NOT NULL
  • device_desc (Field) — varchar

game_id (Untitled6)

  • game_id (Key) — char — 기본 키 — NOT NULL
  • game_desc (Field) — varchar

master_snapshot (Untitled3)

  • account_id (Key) — bigint — 기본 키 — NOT NULL
  • game_id (Key3) — char — 외래 키 → game_id.game_id — NOT NULL
  • last_login_date (int) — date
  • llast_login_date (date) — date
  • first_login-date (Field3) — date

retention (Untitled4)

  • term (Key) — char — 기본 키 — NOT NULL
  • base_date (Key4) — date — 기본 키 — NOT NULL
  • accoup_group_code (Key3) — char — 외래 키 → account_group_code.account_group_code — NOT NULL
  • game_id (Key2) — char — 외래 키 → game_id.game_id — NOT NULL
  • last_au (Field) — bigint
  • this_au (Field2) — bigint

server (Untitled8)

  • server_id (int) — char — 기본 키 — NOT NULL
  • account_id (Key) — bigint — 외래 키 → master_snapshot.account_id — NOT NULL
  • game_id (Key3) — char — 외래 키 → master_snapshot.game_id — NOT NULL
  • server_desc (Field) — varchar