text: 
  
  -------------------------------------------------------------------------------
  --  user account
  -------------------------------------------------------------------------------
  CREATE TABLE USER_ACCOUNT(
          ID BIGINT NOT NULL,
  	USERNAME VARCHAR(50),
  	PASSWORD VARCHAR(50),
  	SCOPE_ID VARCHAR(50),
  	USER_BASE_ID BIGINT,
  	TYPE_ID BIGINT,
          CONSTRAINT PK_USER_ACCOUNT PRIMARY KEY(ID),
          CONSTRAINT FK_USER_ACCOUNT_TYPE FOREIGN KEY(TYPE_ID) REFERENCES USER_ACCOUNT_TYPE(ID),
          CONSTRAINT FK_USER_ACCOUNT_USER_BASE FOREIGN KEY(USER_BASE_ID) REFERENCES USER_BASE(ID)
  );
  
  