card

Tables (4)

card_usage_metrics

  • metric_id — BIGINT
  • user_id — BIGINT
  • base_month — VARCHAR(6)
  • use_count_credit_last1m — FLOAT
  • use_amt_install_last1m — FLOAT
  • balance_credit_r3m — FLOAT
  • reward_ratio_r3m — FLOAT

segments

  • segment_id — INT
  • segment_name — VARCHAR(100)
  • description — TEXT

user_segment_results

  • result_id — BIGINT
  • user_id — BIGINT
  • segment_id — INT
  • assigned_date — DATE

users

  • user_id — BIGINT
  • name — VARCHAR(100)
  • gender — CHAR(1)
  • birth_year — INT
  • signup_date — DATE