Live Main Table

Tables (6)

Dist_CMS_Album_Artist

  • seqno — int — Primary key — NOT NULL
  • dist_cms_albumseqno — int — Foreign key → Dist_CMS_Album_Info.Seqno — NOT NULL
  • artistpart — int
  • artistname_kr — nvarchar(30)
  • artistname_eng — nvarchar(30)
  • artistname_jp — nvarchar(30)
  • artistname_cn_simplified — nvarchar(30)
  • artistname_cn_traditional — nvarchar(30)
  • created_at — datetime
  • updated_at — datetime
  • status — int — active : 1 , deactive : 0
  • appleid — nvarchar(50)
  • is_apply — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Album_Info

  • Seqno — int — Primary key — NOT NULL
  • Album_Name_KR — nvarchar(255)
  • Album_Name_EN — nvarchar(255)
  • Album_Name_JP — nvarchar(255)
  • Album_Name_CN_Simplified — nvarchar(255)
  • Album_Name_CN_Traditional — nvarchar(255)
  • UPC — nvarchar(20) — UPC의 경우 13자리 고정이므로 nchar 문자 13자 강제
  • Dist_Album_Code — nvarchar(50)
  • Album_Version — nvarchar(50)
  • Main_Language — nvarchar(50)
  • Album_Genre — nvarchar(50)
  • Melon_Album_ID — nvarchar(50)
  • Bugs_Album_ID — nvarchar(50)
  • UCI_Code — nvarchar(50)
  • Album_Dist_Com_ID — nvarchar(50)
  • Album_Lable_Name — nvarchar(50)
  • Release_Date — datetime
  • Sale_Date — datetime
  • Is_Time_Release — bit
  • Album_Sale_Price — nchar(20)
  • Sale_Country — nvarchar(50)
  • Excep_Country — nvarchar(50)
  • Memo — nvarchar(512)
  • Album_Cover_Path — nvarchar(100)
  • created_at — datetime
  • updated_at — datetime
  • status — int — 0 : Deactive , 1: Active
  • AlbumDescription — text
  • Excep_Policy_Code — nvarchar(20)
  • P_Line — nvarchar(256)
  • ml_detail_seq — bigint
  • Is_All_Track_Genres_Apply — bit
  • Is_All_Track_Artist_Apply — bit
  • Dist_CMS_Album_Origin_Info_Seqno — bigint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Track_Artist

  • seqno — int — Primary key — NOT NULL
  • dist_cms_albumseqno — int — Foreign key → Dist_CMS_Album_Info.Seqno — NOT NULL
  • dist_cms_trackseqno — int — Foreign key → Dist_CMS_Track_Info.Seqno — NOT NULL
  • artistpart — int
  • artistname_kr — nvarchar(30)
  • artistname_eng — nvarchar(30)
  • artistname_jp — nvarchar(30)
  • artistname_cn_simplified — nvarchar(30)
  • artistname_cn_traditional — nvarchar(30)
  • created_at — datetime
  • updated_at — datetime
  • status — int — active : 1, deactive : 0
  • appleid — nvarchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Track_Info

  • Seqno — int — Primary key — NOT NULL
  • Album_Seqno — int — Foreign key → Dist_CMS_Album_Info.Seqno
  • CD_Number — int
  • Track_Number — int
  • ISRC — nchar(20)
  • Track_Name_KR — nvarchar(255)
  • Track_Name_EN — nvarchar(255)
  • Track_Name_JP — nvarchar(255)
  • Track_Name_CN_Simplified — nvarchar(255)
  • Track_Name_CN_Traditional — nvarchar(255)
  • Dist_Track_Code — nvarchar(50)
  • Audio_Language — nvarchar(50)
  • UCI_Code — nvarchar(50)
  • Track_Genre — nvarchar(50)
  • Melon_Track_ID — nvarchar(50)
  • Bugs_Track_ID — nvarchar(50)
  • Track_Dist_Com_ID — nvarchar(50)
  • Track_Lable_Name — nvarchar(50)
  • Track_Sale_Price — nvarchar(50)
  • Copyright_Ratio — tinyint
  • Performers_Ratio — tinyint
  • Is_Classic — tinyint
  • Is_Adult — tinyint
  • Is_Service — tinyint
  • Youtube_Upload_Type — tinyint
  • Track_Music_File_Path — nvarchar(100)
  • duration — nvarchar(50)
  • Lyric — text
  • created_at — datetime
  • updated_at — datetime
  • status — int — 0: Deactive, 1: Active
  • trackversion — nvarchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Detail_type2

  • seqno — bigint — Primary key — NOT NULL
  • UPC — bigint
  • UciCode — nvarchar(50)
  • Album_Type — int
  • AlbumArtist — nvarchar(1024)
  • AlbumArtist_ENG — nvarchar(1024)
  • Artist_AppleID — bigint
  • Album — nvarchar(1024)
  • Album_ENG — nvarchar(1024)
  • Album_JP — nvarchar(1024)
  • Album_CN — nvarchar(1024)
  • Album_CN_2 — nvarchar(1024)
  • AlbumArtist_JP — nvarchar(1024)
  • AlbumArtist_CN — nvarchar(1024)
  • AlbumArtist_CN_2 — nvarchar(1024)
  • AlbumArtist_Seqno — varchar(1024)
  • AlbumVersion — varchar(512)
  • DistAlbumCode — varchar(50)
  • ReleaseDate — datetime
  • SaleDate — datetime
  • Country — int
  • AlbumGenre — int
  • PriceCode — int
  • ExcepCountry — text
  • BaseExcepCountry — text
  • Lablename — nvarchar(128)
  • Offer — int
  • Preregist — int
  • Default_Pay — int
  • Request_Text — varchar(4096)
  • Report_Text — varchar(4096)
  • CoverPath — varchar(4000)
  • LyricPath — varchar(4000)
  • isAdult — bit
  • isClassic — bit
  • featuringartist_Seqno — varchar(1024)
  • featuringartist — varchar(1024)
  • featuringartist_ENG — varchar(1024)
  • featuringartist_CN — nvarchar(1024)
  • featuringartist_JP — nvarchar(1024)
  • with_artist_Seqno — nvarchar(1024)
  • with_artist — nvarchar(1024)
  • with_artist_ENG — nvarchar(1024)
  • with_artist_CN — nvarchar(1024)
  • with_artist_JP — nvarchar(1024)
  • Lyricist_Seqno — nvarchar(1024)
  • Lyricist — nvarchar(1024)
  • Lyricist_ENG — nvarchar(1024)
  • Lyricist_CN — nvarchar(1024)
  • Lyricist_JP — nvarchar(1024)
  • writer_Seqno — nvarchar(1024)
  • writer — nvarchar(1024)
  • writer_ENG — nvarchar(1024)
  • writer_CN — nvarchar(1024)
  • writer_JP — nvarchar(1024)
  • Arranger_Seqno — nvarchar(1024)
  • Arranger — nvarchar(1024)
  • Arranger_ENG — nvarchar(1024)
  • Arranger_CN — nvarchar(1024)
  • Arranger_JP — nvarchar(1024)
  • … +26

ML_Track_Type2

  • seqno — bigint — Primary key — NOT NULL
  • ml_detail_seq — bigint
  • cd_num — int
  • track_seq — int
  • istitle — int
  • distTrackCode — nvarchar(128)
  • artistname — nvarchar(1024)
  • artistname_ENG — nvarchar(1024)
  • artistname_AppleID — bigint
  • featuringartist — varchar(1024)
  • featuringartist_ENG — nvarchar(1024)
  • featuringartist_AppleID — bigint
  • with_artist — varchar(1024)
  • with_artist_ENG — nvarchar(1024)
  • with_artist_AppleID — bigint
  • TrackName — nvarchar(1024)
  • TrackName_ENG — nvarchar(1024)
  • TrackVersion — nvarchar(512)
  • TrackGenre — int
  • TrackPrice — int
  • Track_Lable — nvarchar(128)
  • TrackReleaseDate — datetime
  • UCICode — nvarchar(128)
  • ISRC — nvarchar(128)
  • isService — int
  • isAdult — int
  • isClassic — int
  • Lyricist — varchar(1024)
  • Lyricist_ENG — nvarchar(1024)
  • writer — varchar(1024)
  • writer_ENG — nvarchar(1024)
  • Arranger — varchar(1024)
  • Arranger_ENG — nvarchar(1024)
  • Conductor — varchar(1024)
  • Conductor_ENG — nvarchar(1024)
  • ensemble — varchar(1024)
  • ensemble_ENG — nvarchar(1024)
  • soloist — varchar(1024)
  • soloist_ENG — nvarchar(1024)
  • symphony — varchar(1024)
  • symphony_ENG — nvarchar(1024)
  • artistname_CN — nvarchar(1024)
  • artistname_JP — nvarchar(1024)
  • TrackName_CN — nvarchar(1024)
  • TrackName_JP — nvarchar(1024)
  • ExcepCountry — varchar(1024)
  • BaseExcepCountry — varchar(1024)
  • artistname_Seqno — nvarchar(1024)
  • featuringartist_Seqno — nvarchar(1024)
  • featuringartist_CN — nvarchar(1024)
  • featuringartist_JP — nvarchar(1024)
  • with_artist_Seqno — nvarchar(1024)
  • with_artist_CN — nvarchar(1024)
  • with_artist_JP — nvarchar(1024)
  • Lyricist_Seqno — nvarchar(1024)
  • Lyricist_CN — nvarchar(1024)
  • Lyricist_JP — nvarchar(1024)
  • writer_Seqno — nvarchar(1024)
  • writer_CN — nvarchar(1024)
  • writer_JP — nvarchar(1024)
  • … +29