CREATE TABLE REVIEW_DATA
(
  RULE               VARCHAR2(100 CHAR),
  MATCH_GROUP_ID     NUMBER,
  PRIORITYSCORE      NUMBER,
  SOURCE_SYS_CD      VARCHAR2(20 CHAR),
  REL_SOURCE_SYS_CD  VARCHAR2(20 CHAR),
  SRC_REL            VARCHAR2(41 CHAR),
  SRC_REL_VAL        VARCHAR2(17 BYTE),
  SOURCE_SYS_IDS     VARCHAR2(20 CHAR),
  GOLD_ID            NUMBER
)

  
begin 
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)', 1, 680, 'SITE', 'SITE', 
    '1039698~416581', 'SOURCE_SYS_ID', '1039698', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)', 1, 680, 'SITE', 'SITE', 
    '1039698~416581', 'REL_SOURCE_SYS_ID', '416581', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)+E(CTRY_CD)', 1, 770, 'SITE', 'SITE', 
    '1039698~992894', 'SOURCE_SYS_ID', '1039698', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)+E(CTRY_CD)', 1, 770, 'SITE', 'SITE', 
    '1039698~992894', 'REL_SOURCE_SYS_ID', '992894', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_HQ_NM)', 1, 660, 'SITE', 'SITE', 
    '1039698~454932', 'SOURCE_SYS_ID', '1039698', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_HQ_NM)', 1, 660, 'SITE', 'SITE', 
    '1039698~454932', 'REL_SOURCE_SYS_ID', '454932', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(FFN)', 1, 460, 'SITE', 'SITE', 
    '421185~416581', 'SOURCE_SYS_ID', '421185', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(FFN)', 1, 460, 'SITE', 'SITE', 
    '421185~416581', 'REL_SOURCE_SYS_ID', '416581', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(FFN)+E(CTRY_CD)', 1, 500, 'SITE', 'SITE', 
    '421185~992894', 'SOURCE_SYS_ID', '421185', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(FFN)+E(CTRY_CD)', 1, 500, 'SITE', 'SITE', 
    '421185~992894', 'REL_SOURCE_SYS_ID', '992894', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_HQ_NM)', 1, 660, 'SITE', 'SITE', 
    '410250~454932', 'SOURCE_SYS_ID', '410250', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_HQ_NM)', 1, 660, 'SITE', 'SITE', 
    '410250~454932', 'REL_SOURCE_SYS_ID', '454932', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)', 1, 680, 'SITE', 'SITE', 
    '416581~503398', 'SOURCE_SYS_ID', '416581', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)', 1, 680, 'SITE', 'SITE', 
    '416581~503398', 'REL_SOURCE_SYS_ID', '503398', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)+E(CTRY_CD)', 1, 770, 'SITE', 'SITE', 
    '992894~503398', 'SOURCE_SYS_ID', '992894', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)+E(CTRY_CD)', 1, 770, 'SITE', 'SITE', 
    '992894~503398', 'REL_SOURCE_SYS_ID', '503398', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)+E(CTRY_CD)', 1, 770, 'SITE', 'SITE', 
    '810793~860421', 'SOURCE_SYS_ID', '810793', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)+E(CTRY_CD)', 1, 770, 'SITE', 'SITE', 
    '810793~860421', 'REL_SOURCE_SYS_ID', '860421', 1691134);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)', 1, 680, 'SITE', 'SITE', 
    '691581~922433', 'SOURCE_SYS_ID', '691581', 1686735);
Insert into REVIEW_DATA
   (RULE, MATCH_GROUP_ID, PRIORITYSCORE, SOURCE_SYS_CD, REL_SOURCE_SYS_CD, 
    SRC_REL, SRC_REL_VAL, SOURCE_SYS_IDS, GOLD_ID)
 Values
   ('E(ST_B_NM)', 1, 680, 'SITE', 'SITE', 
    '691581~922433', 'REL_SOURCE_SYS_ID', '922433', 1792130);
    
 commit;
end ;