Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE weekly_impact_calculations (
- id SERIAL,
- athlete_id integer,
- year_snap integer,
- week_of_year_snap integer,
- date_from date,
- date_until date,
- first_name character varying(200),
- utc_time character varying(10),
- language character(3),
- language_es boolean,
- selected_cause_id integer, --- NUEVAAAAAAAAA
- has_selected_cause boolean,
- has_impact boolean,
- has_pending_donations boolean,
- has_goal boolean,
- progress decimal(10,2), -- double precision
- workouts integer,
- workouts_text character varying(20),
- donated_calories integer,
- donated_calories_text character varying(20),
- steps integer,
- steps_text character varying(20),
- donation_title character varying(30), -- "Donaciones / Donations"
- donations_value decimal(10,2),
- donations_value_text character varying(20),
- points_earned decimal(10,2),
- points_earned_text character varying(20),
- used_points decimal(10,2),
- used_points_text character varying(20),
- available_points decimal(10,2),
- available_points_text character varying(20),
- sponsor_id_1 integer, --- NUEVAAAAAAAAA
- sponsor_id_2 integer, --- NUEVAAAAAAAAA
- sponsor_id_3 integer, --- NUEVAAAAAAAAA
- date_snap timestamp with time zone
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement