New DB

Tables (10)

Account

  • seqno — BININT — Primary key — NOT NULL
  • UPC — NVARCHAR(20) — NOT NULL
  • Album_Id — NVARCHAR(20) — NOT NULL
  • ISRC — NVARCHAR(30) — NOT NULL
  • Track_Id — NVARCHAR(20) — NOT NULL
  • Nation — NVARCHAR(20)
  • taxrate — decimal
  • rsrate — decimal
  • fkmprate — decimal
  • fkmp — decimal
  • copyright — decimal
  • connetincome — decimal
  • currency — NVARCHAR(20)
  • beforetaxpayable — decimal
  • aftertaxpayable — decimal
  • grosssale — decimal
  • quantity — decimal
  • channelid — NVARCHAR(30)
  • Channel_Code — INT — NOT NULL
  • Distributor_Code — INT — NOT NULL
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

Album

  • Album_Id — BININT — Primary key — NOT NULL
  • Artist_Id — NVARCHAR(20) — Foreign key → Album_Artist.Artist_Id — NOT NULL
  • Album_Id (Album_Id2) — INT — Foreign key → Album_Artist.Album_Id — NOT NULL
  • Track_Id — INT — Foreign key → Album_Artist.Track_Id — NOT NULL
  • seqno — BININT — Foreign key → Album_Artist.seqno — NOT NULL
  • Album_Cover_Path — NVARCHAR(100) — NOT NULL
  • Album_Genre — NVARCHAR(1500) — NOT NULL
  • Album_Name — NVARCHAR(1500) — NOT NULL
  • Album_Artist — NVARCHAR(1500) — NOT NULL
  • UPC — NVARCHAR20)
  • UCI-Code — NVARCHAR(50)
  • Dist_Album_Code — NVARCHAR(50) — NOT NULL
  • Album_Dist_Com_Name — NVARCHAR(100) — NOT NULL
  • Album_Agency_Com_Name — NVARCHAR(100) — NOT NULL
  • Album_Type — CHAR(1)
  • Album_Version — NVARCHAR(50) — NOT NULL
  • Album_Status — CHAR(1)
  • Album_Description — TEXT
  • Album_Lable_Name — NVARCHAR(50)
  • Main_Language — NVARCHAR(50) — NOT NULL
  • Album_Sale_Price — NVARCHAR(20) — NOT NULL
  • Disc_Count — INT
  • Track_Count — INT
  • Album_Dist_Com_ID — INT — NOT NULL
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

Album_Artist

  • Artist_Id — NVARCHAR(20) — Primary key — NOT NULL
  • Album_Id — INT — Primary key — NOT NULL
  • Track_Id — INT — Primary key — NOT NULL
  • seqno — BININT — Primary key — NOT NULL
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

Artist

  • Artist_Id — NVARCHAR(20) — Primary key — NOT NULL
  • Artist_Id (Artist_Id2) — NVARCHAR(20) — Foreign key → Album_Artist.Artist_Id — NOT NULL
  • Album_Id (Album_Id2) — INT — Foreign key → Album_Artist.Album_Id — NOT NULL
  • Track_Id (Track_Id2) — INT — Foreign key → Album_Artist.Track_Id — NOT NULL
  • seqno — BININT — Foreign key → Album_Artist.seqno — NOT NULL
  • Artist_Name — NVARCHAR(750) — NOT NULL
  • Artist_Profile_Image — NVARCHAR(250)
  • Nationality — NVARCHAR(20)
  • Brith_Ymd — NVARCHAR(19)
  • Death_Ymd — NVARCHAR(19)
  • Birth_Country — NVARCHAR(250)
  • Kor_Name — NVARCHAR(150)
  • Eng_Name — NVARCHAR(150)
  • Jpn_Name — NVARCHAR(150)
  • Chn_Name — NVARCHAR(150)
  • Artist_Name_Index — NVARCHAR(6)
  • Debut_Ymd — NVARCHAR(19)
  • Debut_Track_Id — INT
  • Debut_Track_Title — NVARCHAR(750)
  • Debut_Album_Id — INT
  • Debut_Album_Title — NVARCHAR(750)
  • Gender — NVARCHAR(8)
  • MAINPART — NVARCHAR(150)
  • MAINACTION — NVARCHAR(150)
  • MULTIACTION — NVARCHAR(150)
  • Active_Period — NVARCHAR(450)
  • Genre_Name_List — NVARCHAR(750)
  • Keyword — NVARCHAR(4000)
  • Is_Disply — CHAR(1)
  • Artist_DisplayName — NVARCHAR(750)
  • Artist_Main_Song — NVARCHAR(1500)
  • Contact_Number — NVARCHAR(1500)
  • Artist_Agency — NVARCHAR(1500)
  • Apple_Id — INT
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

Channel_Company

  • seqno — BININT — Primary key — NOT NULL
  • Artist_Id — NVARCHAR(20) — Foreign key → Meta_Transfer.Artist_Id — NOT NULL
  • seqno (seqno42) — BININT — Foreign key → XML_Form.seqno — NOT NULL
  • Channel_Name — BININT — NOT NULL
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

Crawling_Data

  • seqno — BININT — Primary key — NOT NULL
  • channel — INT — NOT NULL
  • Album_Id — INT — NOT NULL
  • Track_Id — INT — NOT NULL
  • AlbumArtist — NVARCHAR(1500) — NOT NULL
  • TrackArtist — NVARCHAR(1500) — NOT NULL
  • CD_Num — INT
  • Track_Num — INT
  • Is_Adult — CHAR(1)
  • Lyrics — TEXT
  • duration — NVARCHAR(50)
  • Album_Cover_Path — NVARCHAR(100)
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

Meta_Transfer

  • seqno — BININT — Primary key — NOT NULL
  • Track_Id — BININT — Foreign key → Track.Track_Id — NOT NULL
  • Album_Id — BININT — Foreign key → Track.Album_Id — NOT NULL
  • Artist_Id — NVARCHAR(20) — Foreign key — NOT NULL
  • Album_Id (Album_Id2) — INT — Foreign key — NOT NULL
  • Track_Id (Track_Id2) — INT — Foreign key — NOT NULL
  • seqno (seqno2) — BININT — Foreign key — NOT NULL
  • seqno (seqno22) — BININT — Foreign key — NOT NULL
  • seqno (seqno3) — BININT — Foreign key — NOT NULL
  • seqno (seqno4) — BININT — Foreign key → Account.seqno — NOT NULL
  • Channel_Company_Seqno — BININT — NOT NULL
  • DDEXPartyID — ' — NOT NULL
  • DDEXPartyName — NVARCHAR(64) — NOT NULL
  • Channel_DDEXPartyID — ' — NOT NULL
  • Channel_DDEXPartyName — NVARCHAR(64) — NOT NULL
  • Dist_DDEXPartyID — ' — NOT NULL
  • Dist_DDEXPartyName — NVARCHAR(64) — NOT NULL
  • filesize — BININT — NOT NULL
  • FileMD5 — NVARCHAR(246) — NOT NULL
  • PriceCode — NVARCHAR(246) — NOT NULL
  • TransferType — ' — NOT NULL
  • duration — NVARCHAR(24) — NOT NULL
  • CD_Num — INT — NOT NULL
  • Track_Num — INT — NOT NULL
  • UPC — NVARCHAR20) — NOT NULL
  • ISRC — NVARCHAR(20) — NOT NULL
  • Album_Name_KR — NVARCHAR(255) — NOT NULL
  • Album_Name_EN — NVARCHAR(255)
  • Track_Name_KR — NVARCHAR(255) — NOT NULL
  • Track_Name_EN — NVARCHAR(255)
  • Album_Genre — NVARCHAR(255) — NOT NULL
  • Track_Genre — NVARCHAR(255) — NOT NULL
  • Album_Genre_Sub — NVARCHAR(255) — NOT NULL
  • Track_Genre_Sub — NVARCHAR(255) — NOT NULL
  • Is_Title — CHAR(1) — NOT NULL
  • Is_Classic — CHAR(1) — NOT NULL
  • Album_Dist_Com_Name — NVARCHAR(100) — NOT NULL
  • Album_Agency_Com_Name — NVARCHAR(100) — NOT NULL
  • Track_Dist_Com_Name — NVARCHAR(100) — NOT NULL
  • Release_Date — NVARCHAR(19) — NOT NULL
  • Sale_Date — NVARCHAR(19) — NOT NULL
  • Track_Release_Date — NVARCHAR(19) — NOT NULL
  • Sale_Country — NVARCHAR(50) — NOT NULL
  • Is_Service — CHAR(1) — NOT NULL
  • Is_Adult — CHAR(1) — NOT NULL
  • Is_TimeRelease — CHAR(1) — NOT NULL
  • MainLanguage — NVARCHAR(50) — NOT NULL
  • Audio_Language — NVARCHAR(50) — NOT NULL
  • Album_Sale_Price — NVARCHAR(19) — NOT NULL
  • Track_Sale_Price — NVARCHAR(50) — NOT NULL
  • Excep_Country — NVARCHAR(1000)
  • Track_Version — NVARCHAR(50)
  • Album_Version — NVARCHAR(50)
  • Dist_Album_Code — NVARCHAR(50)
  • Dist_Track_Code — NVARCHAR(50)
  • Is_Transfer — CHAR(1) — NOT NULL
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL

Meta_Transfer_Artist

  • seqno — BININT — Primary key — NOT NULL
  • seqno (seqno2) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • Track_Id — BININT — Foreign key → Meta_Transfer.Track_Id — NOT NULL
  • Album_Id — BININT — Foreign key → Meta_Transfer.Album_Id — NOT NULL
  • Artist_Id — NVARCHAR(20) — Foreign key → Meta_Transfer.Artist_Id — NOT NULL
  • Album_Id (Album_Id2) — INT — Foreign key → Meta_Transfer.Album_Id — NOT NULL
  • Track_Id (Track_Id2) — INT — Foreign key → Meta_Transfer.Track_Id — NOT NULL
  • seqno (seqno22) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • seqno (seqno222) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • seqno (seqno3) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • seqno (seqno4) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • Meta_Transfer_seqno — INT — NOT NULL
  • PART_Type — INT — NOT NULL
  • Language_Type — INT — NOT NULL
  • Artist_Name — NVARCHAR(1500) — NOT NULL
  • Apple_Id — INT
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

Track

  • Track_Id — BININT — NOT NULL
  • Album_Id — BININT — NOT NULL
  • Track_Name — NVARCHAR(1500) — NOT NULL
  • CD_Num — INT — NOT NULL
  • Track_Num — INT — NOT NULL
  • Dist_Track_Code — NVARCHAR(50)
  • Track_Genre — NVARCHAR(1500)
  • Sale_Country — NVARCHAR(50) — NOT NULL
  • Track_Artist — NVARCHAR(1500) — NOT NULL
  • Lyricist — NVARCHAR(1500)
  • Composer — NVARCHAR(1500)
  • Arranger — NVARCHAR(1500)
  • ISRC — NVARCHAR(20) — NOT NULL
  • UCI_Code — NVARCHAR(50)
  • Is_Adult — CHAR(1)
  • Is_Service — CHAR(1)
  • Release_Date — datetime — NOT NULL
  • Sale_Date — datetime — NOT NULL
  • Service_Code — NVARCHAR(50)
  • Feat_Artist — NVARCHAR(1500)
  • Prod_Artist — NVARCHAR(1500)
  • With_Artist — NVARCHAR(1500)
  • Conductor — NVARCHAR(1500)
  • Ensemble — NVARCHAR(1500)
  • Soloist — NVARCHAR(1500)
  • Symphony — NVARCHAR(1500)
  • Lyrics — TEXT
  • Audio_Language — NVARCHAR(50)
  • Track_Version — NVARCHAR(100)
  • Sale_Country — NVARCHAR(50)
  • Excep_Country — NVARCHAR(1000)
  • Track_Sale_Price — NVARCHAR(50)
  • Track_Lable_Name — NVARCHAR(50)
  • duration — NVARCHAR(50)
  • Track_Music_File_Path — NVARCHAR(100) — NOT NULL
  • Is_Classic — CHAR(1)
  • Is_Title — CHAR(1)
  • Track_Dist_Com_ID — INT — NOT NULL
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

XML_Form

  • seqno — BININT — Primary key — NOT NULL
  • seqno (seqno2) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • Track_Id — BININT — Foreign key → Meta_Transfer.Track_Id — NOT NULL
  • Album_Id — BININT — Foreign key → Meta_Transfer.Album_Id — NOT NULL
  • Artist_Id — NVARCHAR(20) — Foreign key → Meta_Transfer.Artist_Id — NOT NULL
  • Album_Id (Album_Id2) — INT — Foreign key → Meta_Transfer.Album_Id — NOT NULL
  • Track_Id (Track_Id2) — INT — Foreign key → Meta_Transfer.Track_Id — NOT NULL
  • seqno (seqno22) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • seqno (seqno222) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • seqno (seqno3) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • seqno (seqno4) — BININT — Foreign key → Meta_Transfer.seqno — NOT NULL
  • Channel_Company_Seqno — BININT — NOT NULL
  • Seq — INT — NOT NULL
  • Language_Type — INT — NOT NULL
  • Artist_Name — NVARCHAR(1500) — NOT NULL
  • Insertid — NVARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime