 )
 /
 
+CREATE TABLE AM_GRAPHQL_COMPLEXITY (
+    UUID VARCHAR(256),
+    API_ID INTEGER NOT NULL,
+    TYPE VARCHAR(256),
+    FIELD VARCHAR(256),
+    COMPLEXITY_VALUE INTEGER,
+    REVISION_UUID VARCHAR(255),
+    FOREIGN KEY (API_ID) REFERENCES AM_API(API_ID),
+    PRIMARY KEY(UUID)
+)
+/
+
 CREATE TABLE AM_API_REVISION_METADATA (
     API_UUID VARCHAR(64),
     REVISION_UUID VARCHAR(64),

  FOREIGN KEY (API_ID) REFERENCES AM_GW_PUBLISHED_API_DETAILS(API_ID) ON UPDATE CASCADE
)
/
CREATE TABLE AM_SCOPE (
            SCOPE_ID INTEGER NOT NULL,
            NAME VARCHAR2(255) NOT NULL,

    FOR EACH ROW
      BEGIN
        DELETE FROM AM_API_PRODUCT_MAPPING AAPM WHERE AAPM.URL_MAPPING_ID = :OLD.URL_MAPPING_ID;
        DELETE FROM AM_API_RESOURCE_SCOPE_MAPPING AARSM WHERE AARSM.URL_MAPPING_ID = :OLD.URL_MAPPING_ID;
      END;
/
CREATE or REPLACE TRIGGER TRG_DEL_AM_APPLICATION
