style24.doc/산출물/2.분석/01.마스터테이블(로딩용)/TB_COLOR.sql

/* 그룹색상 */
INSERT INTO TB_COMMON_CODE VALUES ('G072','GL','골드','#FEAC00','Y',1, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','GR','그레이','#808080','Y',2, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','BL','블루','#00A1E9','Y',3, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','PU','퍼플','#5D0053','Y',4, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','GN','그린','#008337','Y',5, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','NA','네이비','#001F4B','Y',6, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','BE','베이지','#CC9B4E','Y',7, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','BR','브라운','#964B00','Y',8, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','OR','오렌지','#F56600','Y',9, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','KH','카키','#665B09','Y',10, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','PI','핑크','#EB3E8D','Y',11, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','DE','데님','#0D3EA3','Y',12, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','YE','옐로우','#FFF100','Y',13, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','RE','레드','#E70012','Y',14, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','BK','블랙','#000000','Y',15, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','SL','실버','#D0D0D0','Y',16, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','WH','화이트','#FFFFFF','Y',17, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','LR','바이올렛','#D3C6FB','Y',18, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','MI','민트','#2DB6AE','Y',19, 6, NOW(), 6, NOW());
INSERT INTO TB_COMMON_CODE VALUES ('G072','ZZ','혼합/기타','','Y',20, 6, NOW(), 6, NOW());


/* 색상*/
INSERT INTO TB_COLOR VALUES ('1B','LIGHT BROWN','라이트 브라운','#A9764E','','BR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('1M','MELANGE GREY','멜란지 그레이','#6A6C6E','','GR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('AG','ANTIQUE GOLD','앤틱골드','#CCA63D','','GL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('AP','APRICOT PINK','살구핑크','','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('AS','ANTIQUE SILVER','앤틱실버','#D5D5D5','','SL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BB','BLUE BLACK','블루 블랙','','','BK','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BC','BRICK','브릭','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BE','BEIGE','베이지','#CC9B4E','','BE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BG','BURGUNDY','버건디','#5E0010','','RE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BK','BLACK','블랙','#000000','','BK','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BL','BLUE','블루','#00A1E9','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BM','BLACK NICKEL(OPA)','흑니켈유광','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BN','BLACK NICKEL(NONE)','흑니켈무광','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BR','BROWN','브라운','#964B00','','BR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('BS','BASIC','혼합','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CA','CAMEL','카멜','#DB8612','','BR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CB','COBALT VIOLET','청보라','','','LR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CC','COBALT BLUE','청블루','#0047ab','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CE','CREAM','크림','#FFF4D4','','WH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CG','COBALT GREAN','청그린','','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CH','CHARCOAL GREY','차콜 그레이','#2B2D2F','','GR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CM','CHARCOAL MELANGE','챠콜 멜란지','','','NA','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CO','COBALT BLUE','코발트 블루','#0047AB','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CP','CORAL PINK','코랄 핑크','#FF8874','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('CR','CORAL','코랄','#FF4500','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DB','DARK BEIGE','다크 베이지','#9E7639','','BE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DE','DENIM BLUE','데님(청)','#002C91','','DE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DF','DENIM GRAY','데님(그레이)','#5F6670','','DE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DG','DARK GREEN','다크 그린','#2F4F4F','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DI','DARK INDIGO','다크 인디고','','','','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DK','DARK KHAKI','다크 카키','#4E4608','','KH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DL','DARK CAMEL','다크 카멜','','','BR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DN','DARK NAVY','다크 네이비','#031430','','NA','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DO','DARK ORANGE','다크 오렌지','#D27E3F','','OR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DP','DARK PINK','다크 핑크','#E5007F','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('DR','DARK RED','다크 레드','#A40E16','','RE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('EG','EMERALD GREEN','에메랄드그린','#019E97','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('FC','FUCHSIA','후크시아','','','','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('FT','FANTA','환타','#F56600','','OR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('GB','GRAY BLUE','그레이 블루','#63A9C2','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('GL','GOLD','골드','#FEAC00','','GL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('GN','GREEN','그린','#008337','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('GP','GRAY PURPLE','그레이 퍼플','#5B3F6E','','PU','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('GR','GREY','그레이','#808080','','GR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('HP','HOT PINK','핫 핑크','','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('IC','ICE','아이스','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('ID','INDIGO','인디고','#003F75','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('IP','INDIAN PINK','인디 핑크','#E8C0C2','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('IV','IVORY','아이보리','#FFFDD2','','','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('JB','JET BLACK','제트 블랙','#000000','','BK','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('KB','KHAKI BROWN','카키 브라운','','','BR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('KG','KHAKI GREY','카키 그레이','','','GR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('KH','KHAKI','카키','#665B09','','KH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LA','LIGHT GREY','라이트 그레이','#D3D3D3','','GR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LB','LIGHT BEIGE','라이트 베이지','#EACDA1','','BE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LD','LIGHT RED','라이트 레드','','','RE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LE','LEMON','레몬','#FEF552','','YE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LG','LIGHT GREEN','라이트 그린','#AFD25E','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LI','LIME','라임','#BFFF00','','','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LK','LIGHT KHAKI','라이트 카키','#A4A386','','KH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LM','LIGHT MOCHA','라이트 모카','','','BR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LN','LIGHT NAVY','라이트 네이비','','','NA','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LO','LIGHT ORANGE','라이트 오렌지','#F88C44','','OR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LP','LIGHT PINK','라이트 핑크','#F49EC3','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LR','LILAC','라일락','#D3C6FB','','LR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LV','LIGHT VIOLET','라이트 바이올렛','','','LR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('LY','LIGHT YELLOW','라이트 옐로우','#FFFFE0','','YE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MB','MELANGE BLUE','멜란지 블루','','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MG','MELANGE BEIGE','멜란지 베이지','','','BE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MI','MINT','민트','#2DB6AE','','MI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MK','MELANGE KHAKI','멜란지 카키','','','KH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('ML','MARINE','마린','#4B15F0','','MI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MM','MELANGE MINT','멜란지 민트','','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MN','MELANGE NAVY','멜란지 네이비','','','NA','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MO','MOCHA','모카','','','BR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MP','MELANGE PINK','멜란지 핑크','#CD739C','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MS','MUSTARD','머스타드','#DB9A00','','YE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('MT','MINT','민트','#2DB6AE','','MI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('NA','NAVY','네이비','#001F4B','','NA','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('NM','NICKEL(OPA)','니켈유광','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('NN','NICKEL(NONE)','니켈무광','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OB','AQUA BLUE','아쿠아 블루','#02BED9','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OC','OCHER','오커','','','','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OG','OLIVE GREEN','올리브 그린','#685F00','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OK','OLIVE KHAKI','올리브 카키','#685F00','','KH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OL','OLIVE','올리브','#A19600','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OM','OATMEAL','오트밀','#E0D1AA','','BE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OR','ORANGE','오렌지','#F56600','','OR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('OW','OFF WHITE','오프 화이트','#FBF5E5','','WH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PB','DEEP BLUE','딥 블루','#00007C','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PE','PEACH','피치','#FFE5B4','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PG','DEEP GREEN','딥 그린','#003E0B','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PI','PINK','핑크','#EB3E8D','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PO','DEEP ORANGE','딥 오렌지','','','OR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PP','DEEP PINK','딥 핑크','#E5007F','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PR','DEEP GRAY','딥 그레이','#36342E','','GR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PU','PURPLE','퍼플','#5D0053','','PU','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PV','DEEP VIOLET','딥 바이올렛','#1A003D','','LR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('PY','DEEP YELLOW','딥 옐로우','','','YE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('RB','ROYAL BLUE','로얄 블루','#01308A','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('RD','ROSE GOLD','로즈골드','','','GL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('RE','RED','레드','#E70012','','RE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('RP','ROSE PINK','로즈핑크','#B97383','','PI','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('RW','RAW','로우','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('SB','SKY BLUE','스카이 블루','#87CEEB','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('SD','SAND','샌드','#FAD978','','','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('SL','SILVER','실버','#D0D0D0','','SL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('ST','STRIPE','스트라이프','','','ZZ','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('TB','TURKY BLUE','터키 블루','','','BL','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('VO','VIOLET','바이올렛','#300088','','LR','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('WG','WHITE GRAY','화이트 그레이','','','','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('WH','WHITE','화이트','#FFFFFF','','WH','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('WI','WINE','와인','#8A2033','','RE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('YE','YELLOW','옐로우','#FFF100','','YE','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('YG','YELLOW GREEN','옐로우 그린','#CED519','','GN','Y', 6, NOW(), 6, NOW());
INSERT INTO TB_COLOR VALUES ('ZZ','MIX','혼합','','','ZZ','Y', 6, NOW(), 6, NOW());