create table REGION
(
  DBID          NUMBER(19)  primary key not null,
  NAME          VARCHAR2(255 CHAR),
  PARENT_ID     NUMBER(19) constraint FK8FDB1AF46FA6C7BF references REGION (DBID),
  REGIONTYPE_ID NUMBER(19) constraint FK8FDB1AF42ABBC995 references REGIONTYPE (DBID)
);