Uploaded image for project: 'Portal'
  1. Portal
  2. PORTAL-634

MicroserviceData class DB constraints

XMLWordPrintable

      Class: MicroserviceData

      DDL:

      CREATE TABLE ep_microservice (
      id INT(11) NOT NULL AUTO_INCREMENT,
      name VARCHAR(50) NULL DEFAULT NULL,
      description VARCHAR(50) NULL DEFAULT NULL,
      appId INT(11) NULL DEFAULT NULL,
      endpoint_url VARCHAR(200) NULL DEFAULT NULL,
      security_type VARCHAR(50) NULL DEFAULT NULL,
      username 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)
      );

            dmizyn dmizyn
            dmizyn dmizyn
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: