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