Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. CREATE TABLE weekly_impact_calculations (
  3.  id                 SERIAL,
  4.  athlete_id         integer,
  5.  year_snap          integer,
  6.  week_of_year_snap  integer,
  7.  date_from         date,
  8.  date_until        date,
  9.  first_name         character varying(200),
  10.  utc_time           character varying(10),
  11.  language           character(3),
  12.  language_es        boolean,
  13.  selected_cause_id  integer, --- NUEVAAAAAAAAA
  14.  has_selected_cause boolean,
  15.  has_impact         boolean,
  16.  has_pending_donations boolean,
  17.  has_goal           boolean,
  18.  progress           decimal(10,2), -- double precision
  19.  workouts           integer,
  20.  workouts_text      character varying(20),
  21.  donated_calories   integer,
  22.  donated_calories_text  character varying(20),
  23.  steps              integer,
  24.  steps_text         character varying(20),
  25.  donation_title     character varying(30), -- "Donaciones / Donations"
  26.  donations_value    decimal(10,2),
  27.  donations_value_text character varying(20),
  28.  points_earned      decimal(10,2),
  29.  points_earned_text character varying(20),
  30.  used_points        decimal(10,2),
  31.  used_points_text   character varying(20),
  32.  available_points   decimal(10,2),
  33.  available_points_text character varying(20),
  34.  sponsor_id_1       integer,  --- NUEVAAAAAAAAA
  35.  sponsor_id_2       integer,  --- NUEVAAAAAAAAA
  36.  sponsor_id_3       integer,  --- NUEVAAAAAAAAA
  37.  date_snap          timestamp with time zone
  38. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement