create table PATROLER
(
  DBID         NUMBER(19) primary key not null,
  ACCOUNTSTATE VARCHAR2(255 CHAR),
  AGE          VARCHAR2(255 CHAR),
  PASSWORD     VARCHAR2(255 CHAR),
  PHONENUM     VARCHAR2(255 CHAR),
  SEX          VARCHAR2(255 CHAR),
  USERNAME     VARCHAR2(255 CHAR),
  REGION_ID    NUMBER(19) constraint FK78D2BBF9F8AE8D35 references REGION (DBID)
);