CREATE TABLE hz_location_locales (
    LOCATION_LOCALE_ID         NUMBER(18, 0),
    LOCATION_ID                NUMBER(18, 0)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    CONFLICT_ID                NUMBER(18, 0)    NOT NULL,
    TRANSLITERATION_LANG       VARCHAR2(16)     NOT NULL,
    POSTAL_CODE                VARCHAR2(240),
    POSTAL_PLUS4_CODE          VARCHAR2(80) ,
    STATE                      VARCHAR2(240),
    PROVINCE                   VARCHAR2(240),
    COUNTY                     VARCHAR2(240),
    CITY                       VARCHAR2(240),
    ADDRESS1                   VARCHAR2(960),
    ADDRESS2                   VARCHAR2(960),
    ADDRESS3                   VARCHAR2(960),
    ADDRESS4                   VARCHAR2(960),
    BUILDING                   VARCHAR2(960),
    FLOOR_NUMBER               VARCHAR2(960),
    ADDR_ELEMENT_ATTRIBUTE1    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE2    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE3    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE4    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE5    VARCHAR2(600),
    USER_LAST_UPDATE_DATE      TIMESTAMP(6) ,
    CPDRF_VER_SOR              NUMBER(9, 0) ,
    CPDRF_VER_PILLAR           NUMBER(9, 0) ,
    CPDRF_LAST_UPD             VARCHAR2(60) ,
    LOCATION_LOCALE_ID         NUMBER(18, 0),
    LOCATION_ID                NUMBER(18, 0)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    CONFLICT_ID                NUMBER(18, 0)    NOT NULL,
    TRANSLITERATION_LANG       VARCHAR2(16)     NOT NULL,
    POSTAL_CODE                VARCHAR2(240),
    POSTAL_PLUS4_CODE          VARCHAR2(80) ,
    STATE                      VARCHAR2(240),
    PROVINCE                   VARCHAR2(240),
    COUNTY                     VARCHAR2(240),
    CITY                       VARCHAR2(240),
    ADDRESS1                   VARCHAR2(960),
    ADDRESS2                   VARCHAR2(960),
    ADDRESS3                   VARCHAR2(960),
    ADDRESS4                   VARCHAR2(960),
    BUILDING                   VARCHAR2(960),
    FLOOR_NUMBER               VARCHAR2(960),
    ADDR_ELEMENT_ATTRIBUTE1    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE2    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE3    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE4    VARCHAR2(600),
    ADDR_ELEMENT_ATTRIBUTE5    VARCHAR2(600),
    USER_LAST_UPDATE_DATE      TIMESTAMP(6) ,
    CPDRF_VER_SOR              NUMBER(9, 0) ,
    CPDRF_VER_PILLAR           NUMBER(9, 0) ,
    CPDRF_LAST_UPD             VARCHAR2(60) ,
    CONSTRAINT pk_hz_location_locales PRIMARY KEY (LOCATION_LOCALE_ID, LOCATION_LOCALE_ID)
);
