Live DB

Tables (50)

BackUP_ml_Foreign_Genre_Type2_

  • Seqno — bigint — NOT NULL
  • ComID — int
  • GenreName — nvarchar(255)
  • MainGenre — nvarchar(255)
  • SubGenre — nvarchar(255)
  • Genretype — int
  • ParentGenre — int

Bugs_Crawling_Data_List

  • Seqno — bigint — Primary key — NOT NULL
  • Albumid — nvarchar(512)
  • AlbumName — nvarchar(512)
  • AlbumArtist — nvarchar(512)
  • AlbumGenre — nvarchar(512)
  • Cdnumber — nvarchar(512)
  • Tracknumber — nvarchar(512)
  • TrackTitle — nvarchar(512)
  • TrackArtist — nvarchar(512)
  • TrackDuration — nvarchar(512)
  • TrackLink — nvarchar(512)
  • AlbumImageLink — nvarchar(512)
  • UPC — bigint
  • ISRC — nvarchar(512)
  • distalbumcode — nvarchar(512)
  • disttrackcode — nvarchar(512)
  • Trackid — nvarchar(512)
  • distname — nvarchar(512)
  • csdbcheck — int
  • globalservicecheck — int — 해외서비스가능 1, 해외서비스불가 0
  • lyric — text
  • isAdult — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bugs_Tracktitle_divide_temp

  • seqno — int — Primary key — NOT NULL
  • Bugs_crawling_seq — int
  • version_text — nvarchar(512)
  • feat_text — nvarchar(512)
  • with_text — nvarchar(512)
  • genre_text — nvarchar(512)
  • prod_text — nvarchar(512)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

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_Album_Origin_Info

  • Seqno — bigint — Primary key — NOT NULL
  • Distribution_Company_Seqno — bigint
  • State — tinyint — 1 = 업로드, 2 = 검수이동, 3 = 삭제
  • Excel_File_Path — nvarchar(512)
  • Reg_Date — datetime
  • Update_Date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Album_Track_Relation

  • Seqno — int — Primary key — NOT NULL
  • Album_Seqno — int
  • Channel_Company_Seqno — int
  • Copyright_Agreement — int
  • created_at — datetime
  • updated_at — datetime
  • Uploader — nvarchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Music_Register_Request

  • seqno — int — Primary key — NOT NULL
  • dist_request_text — nvarchar(2048)
  • user — nvarchar(30)
  • created_at — datetime
  • updated_at — datetime
  • status — int
  • type — nvarchar(30)
  • reviewalbumseq — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Policy_List

  • seqno — bigint — Primary key — NOT NULL
  • distribution_company_seqno — bigint
  • policy_name — nvarchar(250)
  • status — int
  • created_at — datetime
  • updated_at — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Policy_Management

  • seqno — bigint — Primary key — NOT NULL
  • policy_list_seqno — bigint
  • DistCompanySeqno — int
  • ChannelSeqno — int
  • PolicyName — nvarchar(256)
  • ServicePolicyCode — nvarchar(50)
  • DistRate — int
  • StatementDistCompanySeqno — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Review_Request

  • seqno — int — Primary key — NOT NULL
  • request_text — nvarchar(4000)
  • review_album_seq — int
  • created_at — datetime
  • updated_at — datetime
  • 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 — =

Dist_CMS_Youtube_Content_Items

  • Seqno — bigint — Primary key — NOT NULL
  • Dist_CMS_Youtube_List_Seqno — bigint — Foreign key → Dist_CMS_Youtube_Content_List.Seqno — NOT NULL
  • Track_Name — nvarchar(512)
  • Album_Name — nvarchar(512)
  • Label — nvarchar(256)
  • Distributor — nvarchar(256)
  • Release_Date — date
  • Bugs_ID — int
  • Melon_ID — int
  • Youtube_ID — nvarchar(50)
  • Cover_File_Path — nvarchar(1024)
  • Audio_File_Path — nvarchar(1024)
  • Lyric_File_Path — nvarchar(1024)
  • Artist — nvarchar(512)
  • UPC — nchar(20)
  • ISRC — nchar(20)
  • is_Lyric — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Youtube_Content_Items_Dev

  • Seqno — bigint — Primary key — NOT NULL
  • Dist_CMS_Youtube_List_Seqno — bigint — Foreign key → Dist_CMS_Youtube_Content_List_Dev.Seqno — NOT NULL
  • Track_Name — nvarchar(512)
  • Album_Name — nvarchar(512)
  • Label — nvarchar(256)
  • Distributor — nvarchar(256)
  • Release_Date — date
  • Bugs_ID — int
  • Melon_ID — int
  • Youtube_ID — nvarchar(50)
  • Cover_File_Path — nvarchar(1024)
  • Audio_File_Path — nvarchar(1024)
  • Lyric_File_Path — nvarchar(1024)
  • Artist — nvarchar(512)
  • UPC — nchar(20)
  • ISRC — nchar(20)
  • is_Lyric — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Youtube_Content_List

  • Seqno — bigint — Primary key — NOT NULL
  • Content_List_Code — nvarchar(150)
  • Encoding_Type — tinyint — 0 : 단일 트랙 | 1 : 플레이 리스트
  • Title — nvarchar(250)
  • Discription — nvarchar(1024)
  • Upload_Video_Path — nvarchar(1024)
  • Upload_State — tinyint — 0 : 대기 | 1: 전송 중 | 2 : 완료
  • Upload_Type — tinyint — 1 : 등록 | 3 : 삭제
  • State — tinyint — 1 : 운영 | 0 : 삭제
  • Distribution_Seqno — bigint
  • Reg_Date — datetime
  • Tags — nvarchar(1024)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Youtube_Content_List_Dev

  • Seqno — bigint — Primary key — NOT NULL
  • Content_List_Code — nvarchar(150)
  • Encoding_Type — tinyint — 0 : 단일 트랙 | 1 : 플레이 리스트
  • Title — nvarchar(250)
  • Discription — nvarchar(1024)
  • Upload_Video_Path — nvarchar(1024)
  • Upload_State — tinyint — 0 : 대기 | 1: 전송 중 | 2 : 완료
  • Upload_Type — tinyint — 1 : 등록 | 3 : 삭제
  • State — tinyint — 1 : 운영 | 0 : 삭제
  • Distribution_Seqno — bigint
  • Reg_Date — datetime
  • Tags — nvarchar(1024)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Youtube_Error_Center

  • Seqno — bigint — Primary key — NOT NULL
  • ErrorMessage — text
  • created_at — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Youtube_Musicvideo_ISRC_INCREMENT

  • Seqno — bigint — Primary key — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dist_CMS_Youtube_Whitelist

  • seqno — int — Primary key — NOT NULL
  • youtube_url — nvarchar(256)
  • status — int
  • memo — nvarchar(1024)
  • created_at — datetime
  • updated_at — datetime
  • distribution_seqno — nvarchar(50)
  • admin_memo — nvarchar(1024)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Infra_portlist

  • seqno — int — Primary key — NOT NULL
  • port — int — NOT NULL
  • status — int
  • created_at — datetime
  • updated_at — datetime
  • requester — nvarchar(10)
  • memo — nvarchar(1024)
  • purpose — nvarchar(256)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Account_Management

  • Seqno — bigint — Primary key — NOT NULL
  • Item — nvarchar(128)
  • ID — varchar(128)
  • Password — varchar(128)
  • Site_Url — varchar(128)
  • Type — tinyint — 1 = 자사관련, 2 = 국내관련, 3 = 해외관련, 4 = 기타계정
  • Reg_Date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Album_Share_Percent

  • ml_detail_seq — bigint — Primary key — NOT NULL
  • Copyright_Share_Percent — tinyint
  • Neighboring_Share_Percent — tinyint
  • Performance_Share_Percent — tinyint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Artist_Info

  • Seqno — bigint — Primary key — NOT NULL
  • Artist_Name — nvarchar(128)
  • Artist_Name_ENG — nvarchar(128)
  • Artist_Name_CN — nvarchar(128)
  • Artist_Name_CN_2 — nvarchar(128)
  • Artist_Name_JP — nvarchar(128)
  • IOK_ID — nvarchar(50)
  • Apple_ID — nvarchar(50)
  • Melon_ID — nvarchar(50)
  • Etc — nvarchar(512)
  • State — tinyint
  • Is_Invalid_Apple_ID — bit
  • Is_Create_Apple_Id — bit
  • Is_Black_List — tinyint
  • Apple_Artist_Name — nvarchar(128)
  • Apple_Artist_Name_ENG — nvarchar(128)
  • Apple_Artist_Name_CN — nvarchar(128)
  • Apple_Artist_Name_CN_2 — nvarchar(128)
  • Apple_Artist_Name_JP — nvarchar(128)
  • isPrimary — bit
  • isFeaturing — bit
  • isWith — bit
  • storeURL — nvarchar(512)
  • Reg_Date — datetime
  • Update_Date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Artist_Info_stage

  • Seqno — bigint — NOT NULL
  • Artist_Name — nvarchar(128)
  • Artist_Name_ENG — nvarchar(128)
  • Artist_Name_CN — nvarchar(128)
  • Artist_Name_CN_2 — nvarchar(128)
  • Artist_Name_JP — nvarchar(128)
  • IOK_ID — nvarchar(50)
  • Apple_ID — nvarchar(50)
  • Melon_ID — nvarchar(50)
  • Etc — nvarchar(512)
  • State — tinyint
  • Is_Invalid_Apple_ID — bit
  • Is_Create_Apple_Id — bit
  • Apple_Artist_Name — nvarchar(128)
  • Apple_Artist_Name_ENG — nvarchar(128)
  • Apple_Artist_Name_CN — nvarchar(128)
  • Apple_Artist_Name_CN_2 — nvarchar(128)
  • Apple_Artist_Name_JP — nvarchar(128)
  • Reg_Date — datetime
  • Update_Date — datetime

ML_Artist_Log

  • seqno — int — Primary key — NOT NULL
  • artist_info_seq — int
  • update_user — nvarchar(50)
  • log_info — nvarchar(512)
  • update_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Artist_Role

  • Seqno — bigint — Primary key — NOT NULL
  • Role_Name — nvarchar(128) — NOT NULL
  • Role_Code — nvarchar(128) — NOT NULL
  • Role_Type — int — NOT NULL
  • Role_Parent — bigint — NOT NULL
  • CreateAt — datetime — NOT NULL
  • UpdateAt — datetime — NOT NULL
  • State — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_AuthDPID

  • seqno — bigint — Primary key — NOT NULL
  • ml_vendor_seq — bigint — Foreign key — NOT NULL
  • ml_member_seq — bigint — Foreign key — NOT NULL
  • DDEXPartyId — varchar(64) — NOT NULL
  • DDEXPartyName — varchar(64) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_BlackList_Keyword

  • Seqno — bigint — Primary key — NOT NULL
  • Keyword — nvarchar(250)
  • state — bit
  • insert_User — nvarchar(250)
  • RegDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Board_Info

  • seqno — bigint — Primary key — NOT NULL
  • ml_Detail_Seq — bigint — NOT NULL
  • ml_Site_Seq — bigint — NOT NULL
  • ml_track_seq — bigint
  • BoardNum — varchar(64) — NOT NULL
  • TYPE — varchar(64) — NOT NULL — D: Detail | T : Track
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Board_Info_Type2

  • seqno — bigint — Primary key — NOT NULL
  • ml_Detail_Seq — bigint — Foreign key — NOT NULL
  • ml_Site_Seq — bigint — Foreign key — NOT NULL
  • ml_track_seq — bigint — Foreign key
  • BoardNum — varchar(64) — NOT NULL
  • TYPE — varchar(64) — NOT NULL — D: Detail | T : Track
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_CDDB_Album

  • seqno — bigint — Primary key — NOT NULL
  • UPC — bigint
  • UciCode — varchar(50)
  • Album_Type — int
  • AlbumArtist_Seqno — varchar(1024)
  • AlbumArtist — nvarchar(1024)
  • AlbumArtist_ENG — nvarchar(1024)
  • AlbumArtist_CN — nvarchar(1024)
  • AlbumArtist_JP — nvarchar(1024)
  • Album — nvarchar(1024)
  • Album_ENG — nvarchar(1024)
  • Album_CN — nvarchar(1024)
  • Album_JP — nvarchar(1024)
  • AlbumVersion — varchar(512)
  • DistAlbumCode — varchar(32)
  • ReleaseDate — datetime
  • SaleDate — datetime
  • Country — int
  • AlbumGenre — int
  • PriceCode — int
  • ExcepCountry — text
  • BaseExcepCountry — text
  • Lablename — nvarchar(128)
  • DistComid — bigint
  • featuringartist_Seqno — varchar(1024)
  • featuringartist — nvarchar(1024)
  • featuringartist_ENG — nvarchar(1024)
  • featuringartist_CN — nvarchar(1024)
  • featuringartist_JP — nvarchar(1024)
  • with_artist_Seqno — varchar(1024)
  • with_artist — nvarchar(1024)
  • with_artist_ENG — nvarchar(1024)
  • with_artist_CN — nvarchar(1024)
  • with_artist_JP — nvarchar(1024)
  • Lyricist_Seqno — varchar(1024)
  • Lyricist — nvarchar(1024)
  • Lyricist_ENG — nvarchar(1024)
  • Lyricist_CN — nvarchar(1024)
  • Lyricist_JP — nvarchar(1024)
  • writer_Seqno — varchar(1024)
  • writer — nvarchar(1024)
  • writer_ENG — nvarchar(1024)
  • writer_CN — nvarchar(1024)
  • writer_JP — nvarchar(1024)
  • Arranger_Seqno — varchar(1024)
  • Arranger — nvarchar(1024)
  • Arranger_ENG — nvarchar(1024)
  • Arranger_CN — nvarchar(1024)
  • Arranger_JP — nvarchar(1024)
  • AlbumGenre_Sub — int — 장르(보조)
  • Language — varchar(5)
  • Reg_Date — datetime
  • Is_Time_Release — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_CDDB_Track

  • seqno — bigint — Primary key — NOT NULL
  • ml_album_seqno — bigint — NOT NULL
  • cd_num — int
  • track_seq — int
  • istitle — int
  • distTrackCode — varchar(128)
  • artistname_Seqno — varchar(1024)
  • artistname — nvarchar(1024)
  • artistname_ENG — nvarchar(1024)
  • artistname_CN — nvarchar(1024)
  • artistname_JP — nvarchar(1024)
  • featuringartist_Seqno — varchar(1024)
  • featuringartist — nvarchar(1024)
  • featuringartist_ENG — nvarchar(1024)
  • with_artist_Seqno — varchar(1024)
  • with_artist — nvarchar(1024)
  • with_artist_ENG — nvarchar(1024)
  • TrackName — nvarchar(1024)
  • TrackName_ENG — nvarchar(1024)
  • TrackName_CN — nvarchar(1024)
  • TrackName_JP — nvarchar(1024)
  • TrackVersion — varchar(512)
  • TrackGenre — int
  • Track_Lable — varchar(1024)
  • TrackReleaseDate — datetime
  • UCICode — varchar(128)
  • ISRC — varchar(128)
  • isAdult — int
  • isClassic — int
  • Lyricist_Seqno — varchar(1024)
  • Lyricist — nvarchar(1024) — 작곡가
  • Lyricist_ENG — nvarchar(1024)
  • writer_Seqno — varchar(1024)
  • writer — nvarchar(1024) — 작사가
  • writer_ENG — nvarchar(1024)
  • Arranger — nvarchar(1024) — 편곡자
  • Arranger_ENG — nvarchar(1024)
  • Conductor — varchar(1024) — 지휘자
  • Conductor_ENG — nvarchar(1024)
  • ensemble — nvarchar(1024) — 앙상블
  • ensemble_ENG — nvarchar(1024)
  • soloist — nvarchar(1024)
  • soloist_ENG — nvarchar(1024)
  • symphony — nvarchar(1024) — 교향곡
  • symphony_ENG — nvarchar(1024)
  • DistComid — bigint
  • Is_Country_Exception — bit
  • ExcepCountry — varchar(1024)
  • BaseExcepCountry — varchar(1024)
  • featuringartist_CN — nvarchar(1024)
  • featuringartist_JP — nvarchar(1024)
  • with_artist_CN — nvarchar(1024)
  • with_artist_JP — nvarchar(1024)
  • Lyricist_CN — nvarchar(1024)
  • Lyricist_JP — nvarchar(1024)
  • writer_CN — nvarchar(1024)
  • writer_JP — nvarchar(1024)
  • Arranger_CN — nvarchar(1024)
  • Arranger_JP — nvarchar(1024)
  • TrackGenre_Sub — int — 장르(보조)
  • … +17

ML_Channel_Company

  • Seqno — bigint — Primary key — NOT NULL
  • Company_Name — nvarchar(50)
  • State — tinyint — 1 = 사용, 2 = 삭제
  • Sort_Number — int
  • Area_Type — tinyint — 1 = 해외, 2 = 국내
  • Site_Info_Seqno — bigint
  • Is_Ftp_Service — bit
  • Reg_Date — datetime
  • Update_Date — datetime
  • Is_Time_Release_Support — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Channel_Country_Range

  • Seqno — bigint — Foreign key → ML_Channel_Country_Range.Seqno — NOT NULL
  • Channel_Company_Seqno — bigint
  • CountryName — nvarchar(50)
  • Country — nvarchar(2)
  • created_at — datetime
  • updated_at — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Channel_Distribution_Contract

  • Seqno — bigint — Primary key — NOT NULL
  • Channel_Company_Seqno — bigint
  • Distribution_Company_Seqno — bigint
  • Distribution_Percent — tinyint
  • Statement_Distribution_Company_Seqno — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Channel_Service

  • Seqno — bigint — Primary key — NOT NULL
  • Service_Name — nvarchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Channel_Service_Type

  • Seqno — bigint — Primary key — NOT NULL
  • Service_Type_Name — nvarchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ML_Chart_List

  • Seqno — int — NOT NULL
  • Playlist_Video_ID — nvarchar(300)
  • Chart_Site_Name — nvarchar(500)
  • Chart_Type — nvarchar(10) — D : Daily,w : Weekend , m : Month
  • Reg_date — datetime

ML_Chart_PlayList

  • Seqno — bigint — NOT NULL
  • Track_Seqno — bigint
  • Playlist_Name — nvarchar(300)
  • Playlist_Youtube_id — nvarchar(300)
  • Playlist_Video_Exist — tinyint
  • PlayList_StartDate — datetime
  • PlayList_EndDate — datetime
  • PlayList_Regdate — datetime
  • PlayList_state — tinyint

Ml_apple_ticket_Notes

  • Seqno — bigint — Primary key — NOT NULL
  • Ticket_Seqno — bigint
  • Note — nvarchar(2048)
  • Note_date — datetime
  • Reg_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ml_apple_ticket_management

  • Seqno — bigint — Primary key — NOT NULL
  • TicketID — bigint
  • contentTicketType — nvarchar(256)
  • contentAdamId — nvarchar(256)
  • contentVendorId — nvarchar(256)
  • contentUPC — nvarchar(256)
  • contentType — nvarchar(256)
  • contentLanguage — nvarchar(256)
  • contentGenre — nvarchar(256)
  • name — nvarchar(256)
  • contentProvider — nvarchar(256)
  • openedBy — nvarchar(256)
  • contentTicketState — nvarchar(256)
  • created — datetime
  • lastModified — datetime
  • defectCode — nvarchar(256)
  • Reg_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

artTracks$

  • video_id — nvarchar(255)
  • upc — bigint
  • isrc — nvarchar(255)

failed_jobs

  • id — bigint — Primary key — NOT NULL
  • connection — nvarchar(max) — NOT NULL
  • queue — nvarchar(max) — NOT NULL
  • payload — nvarchar(max) — NOT NULL
  • exception — nvarchar(max) — NOT NULL
  • failed_at — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

jobs

  • id — bigint — Primary key — NOT NULL
  • queue — nvarchar(255) — NOT NULL
  • payload — nvarchar(max) — NOT NULL
  • attempts — tinyint — NOT NULL
  • reserved_at — int
  • available_at — int — NOT NULL
  • created_at — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

knclist

  • seqno — int
  • diskno — int
  • trackno — int
  • genre — nvarchar(255)
  • albumname — nvarchar(255)
  • releasedate — nvarchar(255)
  • albumname_ENG — nvarchar(255)
  • trackname — nvarchar(255)
  • trackname_ENG — nvarchar(255)
  • artistname — nvarchar(255)
  • dummy_knc_artist_code — nvarchar(255)
  • artistname_ENG — nvarchar(255)
  • has_knc_delivered — nvarchar(255)
  • has_etc — nvarchar(255)
  • soribada_apple_reg — nvarchar(255)
  • soribada_apple_service — nvarchar(255)
  • fluxus_service — nvarchar(255)
  • duration — nvarchar(255)
  • media — nvarchar(255)
  • labelname — nvarchar(255)
  • trackcode — nvarchar(255)
  • albumcode — nvarchar(255)
  • ISRC — nvarchar(255)
  • UPC — nvarchar(255)
  • writer — nvarchar(255)
  • lyricist — nvarchar(255)
  • arranger — nvarchar(255)
  • featuring — nvarchar(255)
  • etc — nvarchar(255)
  • ImageFile — nvarchar(255)
  • TrackFile — nvarchar(255)
  • cadelivery — nvarchar(255)
  • TID — nvarchar(255)
  • KID — nvarchar(255)
  • MatchalbumName — nvarchar(255)
  • MatchTrackName — nvarchar(255)
  • findalbumname — nvarchar(255)
  • notexistFile — nvarchar(255)
  • fluxus_ISRC — nvarchar(255)
  • fluxus_UPC — nvarchar(255)
  • transfer_success — nvarchar(255)

knclist2$

  • seqno — int
  • cdnum — int
  • tracknum — int
  • genre — nvarchar(255)
  • albumname — nvarchar(255)
  • Releasedate — datetime
  • albumname_eng — nvarchar(255)
  • trackname — nvarchar(255)
  • trackname_eng — nvarchar(255)
  • artistname — nvarchar(255)
  • artistname_eng — nvarchar(255)
  • TrackFileExist — nvarchar(255)
  • TrackFileExist1 — nvarchar(255)
  • has_soba_apple_delivery — nvarchar(255)
  • has_soba_apple_service — nvarchar(255)
  • 플럭서스 — 서비스
  • duration — nvarchar(255)
  • media — nvarchar(255)
  • labelname — nvarchar(255)
  • disttrackcode — nvarchar(255)
  • distalbumcode — nvarchar(255)
  • ISRC — nvarchar(255)
  • fluxus_isrc — nvarchar(255)
  • UPC — bigint
  • fluxus_upc — bigint
  • write — nvarchar(255)
  • lyricist — nvarchar(255)
  • arranger — nvarchar(255)
  • etc — nvarchar(255)

luminant_uci_label_release_relationship_join_table_lsw

  • seqno — bigint — Primary key — NOT NULL
  • distalbumcode — nvarchar(512)
  • disttrackcode — nvarchar(512)
  • distname — nvarchar(512)
  • ucicode — nvarchar(512)
  • labelname — nvarchar(512)
  • releasedate — nvarchar(512)
  • globalserviceable — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

migrations

  • id — int — Primary key — NOT NULL
  • migration — nvarchar(255) — NOT NULL
  • batch — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ml_apple_ticket_resolution_list

  • seqno — int — Primary key — NOT NULL
  • ticket_id — bigint
  • ticket_label — nvarchar(512)
  • error_type — nvarchar(512)
  • resolution_summary — nvarchar(1024)
  • ticket_type — nvarchar(64)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =