트래픽논리
테이블 (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