endpoint_url VARCHAR(200) NULL DEFAULT NULL,
security_type VARCHAR(50) NULL DEFAULT NULL,
username VARCHAR(50) NULL DEFAULT NULL,
- password VARCHAR(50) NULL DEFAULT NULL,
+ password VARCHAR(50) NOT NULL,
active CHAR(1) NOT NULL DEFAULT 'Y',
PRIMARY KEY (id),
CONSTRAINT FK_FN_APP_EP_MICROSERVICE FOREIGN KEY (appId) REFERENCES fn_app (app_id)
id INT(11) NOT NULL AUTO_INCREMENT,
ext_app_name VARCHAR(50) NOT NULL,
username VARCHAR(50) NOT NULL,
- password VARCHAR(50) NOT NULL,
+ password VARCHAR(50) null default null,
active_yn char(1) NOT NULL default 'Y',
PRIMARY KEY (id)
);