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