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 — =