DW Loader Analysis - Map out Data For Marathon Match Challenges To Data warehouse tables

Background

Previously, all Marathon Matches are running through our legacy Competition Engine and accessed by https://community.topcoder.com/longcontest/. And there are a Loader (https://github.com/topcoder-platform/tc-website-shared/blob/dev/src/main/com/topcoder/shared/util/dwload/TCLoadLong.java) which aggregate and load data into DW datasource for displaying at https://www.topcoder.com/members/petr/details/?track=DATA_SCIENCE&subTrack=MARATHON_MATCH

The new situation is,  we are going to run a new type of Challenge for Marathon Matches outside the Competition Engine but inside Challenge Engine, like for First2Finish, Code etc. It will go throught the same processes (phases) as other challenge types, util winner is selected.

So we'd like also aggregate this data into DW database for Marathon matches, and it will display at https://www.topcoder.com/members/petr/details/?track=DATA_SCIENCE&subTrack=MARATHON_MATCH

Requirements

For this challenge, we'd like to 

1. Understand how data are saved in tcs_catalog database for created Marathon Match Challenges.
You can create Marathon Match challenges as following
-  Follow https://github.com/appirio-tech/tc-common-tutorials/tree/master/docker/direct-app to run Direct and Online Review locally.
- Create Marathon Match Challenges in Direct App, selecting Marathon Matches type.
- Activate and move phases util the Marathon Match Challenges are completed, using Online Review to shorten phases to get move faster.
- Understand tables used in tcs_catalog database, you can also see https://github.com/topcoder-platform/tc-database-scripts/

2. Understand tables in data warehouse for saving data related to marathon matches with logic used in https://github.com/topcoder-platform/tc-website-shared/blob/dev/src/main/com/topcoder/shared/util/dwload/TCLoadLong.java

3. Properly mapping out the data in tables of tcs_catalog database to the related tables of data warehouse database used by TCLoadLong.

4.  For fields in tables of data warehouse, which can not be populated because of missing data, please clearly specify and notes.

Final Submission Guidelines

- Clear Documentation Describes
-- What are the related tables for saving data used for Marathon Match Challenges
-- What are the related tables used for Marahon Matches in data warehouse database.
-- How fields of the two databases are mapped, so we can use in the future to populate the fields correspondingly
-- What fields in tables of data warehouse database can not be populated due to missing data in tcs_catalog database.