Skip to content

Instantly share code, notes, and snippets.

@georgiee
Created July 23, 2014 14:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save georgiee/427e2f97fdd0aa341d60 to your computer and use it in GitHub Desktop.
Save georgiee/427e2f97fdd0aa341d60 to your computer and use it in GitHub Desktop.
epf
==> ./artist <==
#export_dateartist_idnameis_actual_artistview_urlartist_type_id
#primaryKey:artist_id
#dbTypes:BIGINTINTEGERVARCHAR(1000)BOOLEANVARCHAR(1000)INTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./artist_application <==
#export_dateartist_idapplication_id
#primaryKey:artist_idapplication_id
#dbTypes:BIGINTINTEGERINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./artist_collection <==
#export_dateartist_idcollection_idis_primary_artistrole_id
#primaryKey:artist_idcollection_id
#dbTypes:BIGINTINTEGERINTEGERBOOLEANINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./artist_song <==
#export_dateartist_idsong_id
#primaryKey:artist_idsong_id
#dbTypes:BIGINTINTEGERINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./artist_translation <==
#export_dateartist_idlanguage_codeis_pronunciationtranslationtranslation_type_id
#primaryKey:artist_idlanguage_codetranslation_type_id
#dbTypes:BIGINTINTEGERVARCHAR(20)BOOLEANVARCHAR(1000)INTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./artist_type <==
#export_dateartist_type_idnameprimary_media_type_id
#primaryKey:artist_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)INTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./artist_video <==
#export_dateartist_idvideo_idis_primary_artistrole_id
#primaryKey:artist_idvideo_id
#dbTypes:BIGINTINTEGERINTEGERBOOLEANINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./collection <==
#export_datecollection_idnametitle_versionsearch_termsparental_advisory_idartist_display_nameview_urlartwork_urloriginal_release_dateitunes_release_datelabel_studiocontent_provider_namecopyrightp_linemedia_type_idis_compilationcollection_type_id
#primaryKey:collection_id
#dbTypes:BIGINTINTEGERVARCHAR(1000)VARCHAR(1000)VARCHAR(3000)INTEGERVARCHAR(1000)VARCHAR(1000)VARCHAR(1000)DATETIMEDATETIMEVARCHAR(1000)VARCHAR(1000)VARCHAR(4000)VARCHAR(4000)INTEGERBOOLEANINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./collection_song <==
#export_datecollection_idsong_idtrack_numbervolume_numberpreorder_only
#primaryKey:collection_idsong_id
#dbTypes:BIGINTINTEGERINTEGERINTEGERINTEGERBOOLEAN
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./collection_translation <==
#export_datecollection_idlanguage_codeis_pronunciationtranslationtranslation_type_id
#primaryKey:collection_idlanguage_codetranslation_type_id
#dbTypes:BIGINTINTEGERVARCHAR(20)BOOLEANVARCHAR(1000)INTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./collection_type <==
#export_datecollection_type_idname
#primaryKey:collection_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./collection_video <==
#export_datecollection_idvideo_idtrack_numbervolume_numberpreorder_only
#primaryKey:collection_idvideo_id
#dbTypes:BIGINTINTEGERINTEGERINTEGERINTEGERBOOLEAN
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./device_type <==
#export_datedevice_type_idname
#primaryKey:device_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./genre <==
#export_dategenre_idparent_idname
#primaryKey:genre_id
#dbTypes:BIGINTINTEGERINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./genre_application <==
#export_dategenre_idapplication_idis_primary
#primaryKey:genre_idapplication_id
#dbTypes:BIGINTINTEGERINTEGERBOOLEAN
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./genre_artist <==
#export_dategenre_idartist_idis_primary
#primaryKey:genre_idartist_id
#dbTypes:BIGINTINTEGERINTEGERBOOLEAN
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./genre_collection <==
#export_dategenre_idcollection_idis_primary
#primaryKey:genre_idcollection_id
#dbTypes:BIGINTINTEGERINTEGERBOOLEAN
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./genre_imix <==
#export_dategenre_idimix_id
#primaryKey:genre_idimix_id
#dbTypes:BIGINTINTEGERINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./genre_video <==
#export_dategenre_idvideo_idis_primary
#primaryKey:genre_idvideo_id
#dbTypes:BIGINTINTEGERINTEGERBOOLEAN
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./imix <==
#export_dateimix_idtitledescriptionstorefront_idrating_averagerating_countitunes_release_dateimix_type_idview_url
#primaryKey:imix_id
#dbTypes:BIGINTINTEGERVARCHAR(1000)LONGTEXTINTEGERDECIMAL(4,3)INTEGERDATETIMEINTEGERVARCHAR(1000)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./imix_type <==
#export_dateimix_type_idname
#primaryKey:imix_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./key_value <==
#export_datekey_value_
#primaryKey:key_
#dbTypes:BIGINTVARCHAR(100)VARCHAR(100)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./media_type <==
#export_datemedia_type_idname
#primaryKey:media_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./mix <==
#export_datemix_idmix_collection_idnamedescriptionrankview_url
#primaryKey:mix_id
#dbTypes:BIGINTINTEGERINTEGERVARCHAR(1000)LONGTEXTINTEGERVARCHAR(1000)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./mix_collection <==
#export_datemix_collection_idtitlestorefront_idparental_advisory_idmix_category_namemix_type_iditunes_release_dateview_urlartwork_url_largeartwork_url_small
#primaryKey:mix_collection_id
#dbTypes:BIGINTINTEGERVARCHAR(1000)INTEGERINTEGERVARCHAR(1000)INTEGERDATETIMEVARCHAR(1000)VARCHAR(1000)VARCHAR(1000)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./mix_type <==
#export_datemix_type_idname
#primaryKey:mix_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./parental_advisory <==
#export_dateparental_advisory_idname
#primaryKey:parental_advisory_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./role <==
#export_daterole_idname
#primaryKey:role_id
#dbTypes:BIGINTINTEGERVARCHAR(400)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./song <==
#export_datesong_idnametitle_versionsearch_termsparental_advisory_idartist_display_namecollection_display_nameview_urloriginal_release_dateitunes_release_datetrack_lengthcopyrightp_linepreview_urlpreview_length
#primaryKey:song_id
#dbTypes:BIGINTINTEGERVARCHAR(1000)VARCHAR(1000)VARCHAR(1000)INTEGERVARCHAR(1000)VARCHAR(1000)VARCHAR(1000)DATETIMEDATETIMEBIGINTVARCHAR(4000)VARCHAR(4000)VARCHAR(1000)BIGINT
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./song_imix <==
#export_datesong_idimix_id
#primaryKey:song_idimix_id
#dbTypes:BIGINTINTEGERINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./song_mix <==
#export_datesong_idmix_id
#primaryKey:song_idmix_id
#dbTypes:BIGINTINTEGERINTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./song_translation <==
#export_datesong_idlanguage_codeis_pronunciationtranslationtranslation_type_id
#primaryKey:song_idlanguage_codetranslation_type_id
#dbTypes:BIGINTINTEGERVARCHAR(20)BOOLEANVARCHAR(1000)INTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./storefront <==
#export_datestorefront_idcountry_codename
#primaryKey:storefront_id
#dbTypes:BIGINTINTEGERVARCHAR(10)VARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./translation_type <==
#export_datetranslation_type_idname
#primaryKey:translation_type_id
#dbTypes:BIGINTINTEGERVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./video <==
#export_datevideo_idnametitle_versionsearch_termsparental_advisory_idartist_display_namecollection_display_namemedia_type_idview_urlartwork_urloriginal_release_dateitunes_release_datestudio_namenetwork_namecontent_provider_nametrack_lengthcopyrightp_lineshort_descriptionlong_descriptionepisode_production_number
#primaryKey:video_id
#dbTypes:BIGINTINTEGERVARCHAR(1000)VARCHAR(1000)VARCHAR(1000)INTEGERVARCHAR(1000)VARCHAR(1000)INTEGERVARCHAR(1000)VARCHAR(1000)DATETIMEDATETIMEVARCHAR(1000)VARCHAR(1000)VARCHAR(1000)BIGINTVARCHAR(4000)VARCHAR(1000)VARCHAR(4000)LONGTEXTVARCHAR(200)
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
==> ./video_translation <==
#export_datevideo_idlanguage_codeis_pronunciationtranslationtranslation_type_id
#primaryKey:video_idlanguage_codetranslation_type_id
#dbTypes:BIGINTINTEGERVARCHAR(20)BOOLEANVARCHAR(1000)INTEGER
#exportMode:FULL
##legal: IMPORTANT: The Apple Enterprise Partner Feed and data incorporated therein ("EPF")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment