DROP TABLE tuserinfo;
  

  CREATE TABLE tuserinfo (
  

  usr_orgcode             varchar(12)     NOT NULL,
  

  usr_code                varchar(12)     NOT NULL,
  

  usr_name                varchar(10),
  

  usr_level               varchar(1)      NOT NULL,
  

  usr_reg_date            varchar(14)     NOT NULL,
  

  usr_login_mode          varchar(1)      NOT NULL,
  

  usr_create_date         varchar(14)     NOT NULL,
  

  usr_create_flag         varchar(1)      NOT NULL,
  

  usr_remark1             varchar(32),
  

  usr_remark2             varchar(32),
  

  CONSTRAINT PK_userinfo PRIMARY KEY(usr_code)
  

  );