generator client { provider = "prisma-client-js" } datasource db { provider = "mysql" } enum artist_info_active { N Y // - @map("-") } enum artist_info_artist_type { artist film_collection tv_artist } enum product_display_artists_display_artist_role { featuring primary feature_to_primary } enum project_deletions { Y N } enum project_user_type { oa alw system } enum releases_album_download { Y N } enum releases_compilation { Y N } enum releases_deletions { Y N } enum releases_digital_only { Y N } enum releases_display { Y N } enum releases_distribution { digital phys_digital @map("phys/digital") ondemand } enum releases_est { Y N } enum releases_europe_public_domain { Y N } enum releases_itunes_previewable { yes no } enum releases_karaoke { Y N } enum releases_new_release { New Catalog Reissue Direct_To_Video Sports Slate Non_Slate Sports_Top_Tier } enum releases_not_for_distribution { AccountingDummy TVSeasonAccountingDummy CatalogDuplicate EditoriallySuspectContent YouTubeRemap NotforFurtherDistribution iTunesRingtone N LabelRCRevenueDummy IncompleteAssets PhysicalProduct SwitchboardDummy SMEAnalyticsDummy MissingAssets AWALNotOurDistribution KNRAccountingDummy ReviewedWontDeliver BulkIngestInProgress } enum releases_product_format { Single EP LP Double_LP @map("Double LP") Boxset } enum releases_release_status { orchard_processing label_confirmation transfer_to_content label_processing in_content } enum releases_sync_only { Y N } enum releases_territory { worldwide us_only other } enum releases_trackdown_black_list { Y N } enum releases_unknown_artist { Y N } enum releases_vod { Y N } enum track_bonus { Y N } enum track_credit { orig_comp another_comp } enum track_dig_distribution_type { digital_mobile digital_only mobile_only } enum track_display_artists_display_artist_role { featuring primary feature_to_primary } enum track_dpd_license { yes no } enum track_explicit_lyrics { N Y C } enum track_hidden { N I U V } enum track_mechanical { yes no } enum track_offer_type { all album_download_only track_download_only track_download_stream album_track_download album_download_stream stream_only none } enum track_preorder_only { Y N } enum track_publishing_admin { Y N } enum track_purchasable { Y N } enum track_recommended { Y N } enum track_royalty_collection { Y N } enum track_sample { Y N } enum track_stereo_or_mono { stereo mono surround @map("5_1_surround") } enum track_sync_admin { Y N } enum track_third_party_publisher { Y N } enum track_track_type { music video } enum track_us_publishing_obligation { Composition ControlledByYourLabel PublicDomain } enum track_youtube_matches { Monetize Don_t_Monetize @map("Don_t Monetize") Take_Down @map("Take Down") } enum track_youtube_uploads { Fingerprint_Only @map("Fingerprint Only") Public Private } model artist_info { artist_id Int @id @default(autoincrement()) @db.UnsignedInt url String? @db.VarChar(128) when_entered DateTime @default(dbgenerated("'0000-00-00 00:00:00'")) @db.DateTime(0) entered_by String @db.VarChar(64) description String? @db.Text name String? @db.VarChar(255) vendor_id Int? @db.UnsignedInt last_updated DateTime? @default(now()) @db.Timestamp(0) join_artist_id Int? @db.UnsignedInt myspace_url String? @db.VarChar(255) myspace_id Int? @db.UnsignedInt address_city String? @db.VarChar(30) address_state Int? @db.UnsignedInt address_other_state String? @db.VarChar(30) orchard_country Int? @db.UnsignedInt active artist_info_active? @default(dbgenerated("-")) tms_id String? @db.VarChar(25) primary_photo_id Int? @db.UnsignedInt address_zip String? @db.VarChar(30) youtube_mytourdate_url String? @db.VarChar(255) twitter_mytourdate_url String? @db.VarChar(255) artist_email String? @db.VarChar(128) artist_type artist_info_artist_type @default(artist) unique_show_id String? @db.VarChar(64) isni_id String? @db.VarChar(255) unique_artist_id Int? @db.UnsignedInt @@unique([vendor_id, name], map: "uidx_vendor_name") @@index([primary_photo_id], map: "FK_artist_info_primary_photo") @@index([unique_artist_id], map: "FK_unique_artist") @@index([name], map: "artist_name") @@index([orchard_country], map: "orchard_country") @@index([artist_id, name, vendor_id], map: "pk_artist_name_vendor_id") @@index([vendor_id], map: "vendor_id") } model contributors { id Int @id @default(autoincrement()) @db.UnsignedInt name String @db.VarChar(255) vendor_id Int @db.UnsignedInt subaccount_id Int @default(0) @db.UnsignedInt spotify_id String? @db.VarChar(50) apple_music_id String? @db.VarChar(50) neo4j_participant_uuid String? @db.VarChar(36) global_participant_uuid String? @db.VarChar(36) spotify_artist_key String? @db.VarChar(29) artist_info_id Int? @db.UnsignedInt created_at DateTime @default(now()) @db.Timestamp(0) updated_at DateTime @default(now()) @db.Timestamp(0) @@index([artist_info_id], map: "idx_contributors_artist_info_id") @@index([neo4j_participant_uuid], map: "idx_contributors_neo4j_uuid") } model release_artist { release_artist_id Int @id @default(autoincrement()) @db.UnsignedInt upc BigInt @default(0) @db.UnsignedBigInt role String @default("performer") @db.VarChar(25) release_id Int @db.UnsignedInt artist_name String @db.VarChar(255) url String? @db.VarChar(156) artist_info_id Int? @db.UnsignedInt @@index([artist_info_id], map: "fk_release_artist_to_artist_info") @@index([release_id], map: "release_id") @@index([upc], map: "upc") } model releases { release_id Int @id @default(autoincrement()) @db.UnsignedInt last_updated DateTime? @default(now()) @db.Timestamp(0) upc BigInt @unique(map: "upc") @default(0) @db.UnsignedBigInt display_upc String? @db.VarChar(20) artist_id Int? subaccount_id Int? @db.UnsignedInt vendor_release_identifier String? @db.VarChar(32) release_name String? @db.VarChar(255) label String? @db.VarChar(255) description String? @db.Text release_date DateTime? @db.Date listprice Float? @db.Float sellprice Float? @db.Float display releases_display @default(Y) deletions releases_deletions @default(N) distribution releases_distribution @default(digital) applfees Float? @db.Float referral_id String? @db.VarChar(35) date_added_REMOVE DateTime? @db.DateTime(0) genre_id Int? @db.UnsignedTinyInt format String? @db.VarChar(16) distribution_format_id Int? @db.UnsignedTinyInt orig_release_year Int? @db.UnsignedSmallInt promocode String? @db.VarChar(20) c_line String? @db.VarChar(255) manufacturer_upc String? @db.VarChar(16) album_download releases_album_download? @default(Y) download_price Float? @db.Float priority Int? @default(3) @db.UnsignedTinyInt territory releases_territory? sale_start_date DateTime? @db.Date vod_start_date DateTime? @db.Date original_release_date DateTime? @db.Date vendor_catalog_number String? @db.VarChar(20) language_id String? @db.VarChar(8) promobox_no String? @db.VarChar(30) additional_id Int? dracatalog Int? channel_id Int? product_type_id Int? @default(1) @db.UnsignedTinyInt trackdown_black_list releases_trackdown_black_list? @default(N) not_for_distribution releases_not_for_distribution? @default(N) europe_public_domain releases_europe_public_domain? karaoke releases_karaoke? unknown_artist releases_unknown_artist? new_release releases_new_release? product_format releases_product_format? product_code String? @db.VarChar(128) special_instructions String? @db.Text promos_number Int? promo_upc BigInt? sync_only releases_sync_only? @default(N) country_of_origin Int? short_synopsis String? @db.Text keywords String? @db.VarChar(255) production_co String? @db.VarChar(80) preorder_date DateTime? @default(dbgenerated("'1900-01-01'")) @db.Date amd_id String? @db.VarChar(80) wholesale_price_tier String? @db.VarChar(100) season Int? episode Int? production_number Int? network String? @db.VarChar(80) genre_note String? @db.Text physical_release_date DateTime? @db.Date theatrical_release_date DateTime? @db.Date original_digital_release_date DateTime? @db.Date est releases_est? vod releases_vod? rsd_comment String? @db.Text int_mkt_manager Int? @db.UnsignedInt tms_id String? @db.VarChar(25) brand String? @db.VarChar(80) digital_only releases_digital_only? @default(N) product_subtype_id Int? version String? @db.VarChar(255) ingestion_completed DateTime? @db.DateTime(0) release_status releases_release_status @default(orchard_processing) meta_language String? @db.VarChar(8) itunes_previewable releases_itunes_previewable? subtitle_language_id String? @db.VarChar(8) compilation releases_compilation? @default(N) project_id BigInt @db.UnsignedBigInt p_line String? @db.VarChar(255) delivered_version String? @db.VarChar(255) @@index([distribution_format_id], map: "FK_distribution_format_id") @@index([product_subtype_id], map: "FK_releases_product_subtype_id") @@index([product_type_id], map: "FK_releases_product_type_id") @@index([project_id], map: "FK_releases_project_id") @@index([subaccount_id], map: "FK_releases_subaccount") @@index([subtitle_language_id], map: "FK_subtitle_languauge_code") @@index([additional_id], map: "additional_id") @@index([artist_id], map: "artist_id") @@index([date_added_REMOVE], map: "date_added") @@index([display_upc], map: "display_upc") @@index([genre_id], map: "genre_id") @@index([ingestion_completed], map: "ingestion_completed") @@index([int_mkt_manager], map: "int_mkt_manager") @@index([last_updated], map: "last_updated") @@index([manufacturer_upc], map: "manufacturer_upc") @@index([product_code], map: "product_code") @@index([release_name], map: "release_name") @@index([vendor_catalog_number], map: "vendor_catalog_number") } model product_contributors { id Int @id @default(autoincrement()) @db.UnsignedInt product_id Int @db.UnsignedInt contributor_id Int @db.UnsignedInt contributor_role_id Int @db.UnsignedInt sequence_number Int @default(0) @db.UnsignedInt created_at DateTime @default(now()) @db.Timestamp(0) updated_at DateTime @default(now()) @db.Timestamp(0) @@unique([product_id, contributor_id, contributor_role_id], map: "unique_product_contributor") @@unique([product_id, sequence_number], map: "unique_product_sequence") @@index([contributor_id], map: "fk_product_contributors_contributor_id") @@index([contributor_role_id], map: "fk_product_contributors_contributor_role_id") } model product_display_artists { id Int @id @default(autoincrement()) @db.UnsignedInt product_id Int @db.UnsignedInt contributor_id Int @db.UnsignedInt display_artist_role product_display_artists_display_artist_role sequence_number Int @default(0) @db.UnsignedInt @@unique([product_id, sequence_number], map: "unique_product_sequence") @@index([contributor_id], map: "fk_product_display_artists_contributor_id") } model project { project_id BigInt @id @default(autoincrement()) @db.UnsignedBigInt project_code String? @db.VarChar(20) vendor_id Int @db.UnsignedInt subaccount_id Int @db.UnsignedInt project_name String @db.VarChar(255) created_date_utc DateTime @db.DateTime(6) updated_date_utc DateTime @db.DateTime(6) correlation_id String? @db.VarChar(100) artist_id Int? @db.UnsignedInt description String? @db.Text last_modified_by Int? user_type project_user_type? deletions project_deletions @default(N) @@unique([project_code, vendor_id, subaccount_id], map: "project_idx1") @@index([artist_id], map: "idx_artist_id") @@index([vendor_id, subaccount_id, created_date_utc], map: "project_idx2") @@index([subaccount_id], map: "project_subaccount_idx3") } model track_artist { id Int @id @default(autoincrement()) @db.UnsignedInt track_id Int @db.UnsignedInt type String @default("performer") @db.VarChar(50) name String @db.VarChar(255) artist_info_id Int? @db.UnsignedInt @@index([artist_info_id], map: "fk_track_artist_to_artist_info") @@index([track_id], map: "track_id") } model track { track_name String? @db.VarChar(255) upc BigInt? cd Int? @db.UnsignedTinyInt track_id Int? @db.UnsignedSmallInt orchdmclip String? @db.VarChar(50) sample track_sample @default(N) dmclips String? @db.VarChar(255) isrc String? @db.VarChar(16) id Int @id @default(autoincrement()) @db.UnsignedInt length_minute Int? @db.UnsignedSmallInt length_seconds Int? @db.UnsignedSmallInt writer String? @db.VarChar(255) credit track_credit? @default(orig_comp) mechanical track_mechanical? @default(no) publisher String? @db.VarChar(50) publish_company String? @db.VarChar(50) dpd_license track_dpd_license? @default(no) explicit_lyrics track_explicit_lyrics? @default(N) version String? @db.VarChar(255) purchasable track_purchasable? @default(Y) download_price Float? @db.Float p_line String? @db.VarChar(255) hidden track_hidden? offer_type track_offer_type? @default(all) dig_distribution_type track_dig_distribution_type? @default(digital_mobile) third_party_publisher track_third_party_publisher? @default(N) royalty_collection track_royalty_collection? @default(Y) publishing_admin track_publishing_admin? @default(N) sync_admin track_sync_admin? @default(Y) additional_id Int? track_type track_track_type? @default(music) mp3_url String? @db.VarChar(255) stereo_or_mono track_stereo_or_mono? bonus track_bonus @default(N) recommended track_recommended? @default(N) youtube_matches track_youtube_matches @default(Monetize) youtube_uploads track_youtube_uploads? preorder_only track_preorder_only? @default(N) original_file_name String? @db.VarChar(250) release_id Int @db.UnsignedInt last_updated DateTime @default(now()) @db.Timestamp(0) meta_language String? @db.VarChar(8) preview_start_time Int? closed_caption_exists Boolean? closed_caption_reason_id Int? @db.SmallInt vendor_track_identifier String? @db.VarChar(32) recording_country Int? @db.SmallInt recording_year Int? @db.SmallInt original_track_id Int? @db.UnsignedInt us_publishing_obligation track_us_publishing_obligation? track_credit Unsupported("set('orig_comp','another_comp')")? @@index([closed_caption_reason_id], map: "FK_closed_caption_reasons") @@index([additional_id], map: "additional_id") @@index([isrc], map: "isrc") @@index([last_updated], map: "last_updated") @@index([release_id], map: "release_id") @@index([track_name], map: "track_name") @@index([upc, cd, track_id], map: "upc") } model track_contributors { id Int @id @default(autoincrement()) @db.UnsignedInt track_id Int @db.UnsignedInt contributor_id Int @db.UnsignedInt contributor_role_id Int @db.UnsignedInt sequence_number Int @default(0) @db.UnsignedInt created_at DateTime @default(now()) @db.Timestamp(0) updated_at DateTime @default(now()) @db.Timestamp(0) @@unique([track_id, contributor_id, contributor_role_id], map: "unique_track_contributor") @@unique([track_id, sequence_number], map: "unique_track_sequence") @@index([contributor_id], map: "fk_track_contributors_contributor_id") @@index([contributor_role_id], map: "fk_track_contributors_contributor_role_id") } model track_display_artists { id Int @id @default(autoincrement()) @db.UnsignedInt track_id Int @db.UnsignedInt contributor_id Int @db.UnsignedInt display_artist_role track_display_artists_display_artist_role sequence_number Int @default(0) @db.UnsignedInt @@unique([track_id, sequence_number], map: "unique_track_sequence") @@index([contributor_id], map: "fk_track_display_artists_contributor_id") } model track_writer { track_writer_id Int @id @default(autoincrement()) @db.UnsignedInt writer_name String @db.VarChar(255) upc BigInt @db.UnsignedBigInt cd Int @db.UnsignedTinyInt track_id Int @db.UnsignedSmallInt unique_track_id Int @db.UnsignedInt artist_info_id Int? @db.UnsignedInt label_participant_id Int? @@index([artist_info_id], map: "fk_track_writer_to_artist_info") @@index([upc], map: "fk_track_writer_to_releases") @@index([unique_track_id], map: "unique_track_id") }