With Module and application menu

// Define table and application menu details
var tableName = "u_my_custom_table"; // Custom table name
var tableLabel = "My Custom Table"; // Module should have the same label
var appMenuName = "Custom App";
var appOrder = 200; // Order in the menu list
var moduleOrder = 100; // Order in the application menu

// === STEP 1: CREATE TABLE ===
var tableCheck = new GlideRecord('sys_db_object');
tableCheck.addQuery('name', tableName);
tableCheck.query();

var tableSysId;
if (tableCheck.next()) {
    gs.info("Table already exists: " + tableName);
    tableSysId = tableCheck.getValue('sys_id');
} else {
    var table = new GlideRecord('sys_db_object');
    table.initialize();
    table.name = tableName;
    table.label = tableLabel;
    table.super_class = "task"; // Inherits from task table (optional)
    table.is_extendable = true;
    tableSysId = table.insert();
    
    if (tableSysId) {
        gs.info("Table created successfully: " + tableName);
        
        // Add columns to the table
        addColumn(tableName, "u_name", "string", "Name");
        addColumn(tableName, "u_age", "integer", "Age");
        addColumn(tableName, "u_active", "boolean", "Active");
        addColumn(tableName, "u_created_on", "glide_date_time", "Created On");

        gs.info("Columns added successfully.");
        
        // Assign "admin" role to the table
        assignAdminRole(tableSysId, "sys_db_object");
    } else {
        gs.error("Failed to create the table.");
    }
}

// === STEP 2: CREATE APPLICATION MENU ===
var appCheck = new GlideRecord('sys_app_application');
appCheck.addQuery('title', appMenuName);
appCheck.query();

var appSysId;
if (appCheck.next()) {
    gs.info("Application menu already exists: " + appMenuName);
    appSysId = appCheck.getValue('sys_id');
} else {
    var appMenu = new GlideRecord('sys_app_application');
    appMenu.initialize();
    appMenu.title = appMenuName;
    appMenu.active = true;
    appMenu.order = appOrder; // Set menu order
    appSysId = appMenu.insert();
    gs.info("Application menu created: " + appMenuName);

    // Assign "admin" role to the application menu
    assignAdminRole(appSysId, "sys_app_application");
}

// === STEP 3: CREATE MODULE WITH TABLE LABEL ===
var moduleCheck = new GlideRecord('sys_app_module');
moduleCheck.addQuery('title', tableLabel);
moduleCheck.query();

var moduleSysId;
if (moduleCheck.next()) {
    gs.info("Module already exists: " + tableLabel);
} else {
    var module = new GlideRecord('sys_app_module');
    module.initialize();
    module.title = tableLabel; // Module name same as table label
    module.application = appSysId; // Link module to application menu
    module.name = tableName; // Fix: Set the module table field properly
    module.link_type = "LIST"; // Opens a list of records
    module.order = moduleOrder; // Set module order
    moduleSysId = module.insert();
    
    if (moduleSysId) {
        gs.info("Module created with label: " + tableLabel + " and linked to table: " + tableName);
        assignAdminRole(moduleSysId, "sys_app_module");
    }
}

// === FUNCTION TO ADD COLUMNS ===
function addColumn(tableName, columnName, columnType, columnLabel) {
    var column = new GlideRecord('sys_dictionary');
    column.initialize();
    column.name = tableName;
    column.column_label = columnLabel;
    column.column_name = columnName;
    column.internal_type = columnType;
    column.mandatory = false;
    column.insert();
}

// === FUNCTION TO ASSIGN ADMIN ROLE ===
function assignAdminRole(sysId, tableName) {
    var acl = new GlideRecord('sys_security_acl');
    acl.addQuery('name', tableName);
    acl.query();

    if (!acl.hasNext()) {
        var newAcl = new GlideRecord('sys_security_acl');
        newAcl.initialize();
        newAcl.operation = "read"; // Read Access (can also set create, write, delete)
        newAcl.name = tableName;
        newAcl.sys_class_name = "sys_security_acl";
        newAcl.role = "admin"; // Assign admin role
        newAcl.sys_id = sysId;
        newAcl.insert();
        
        gs.info("Admin role assigned to: " + tableName);
    } else {
        gs.info("Admin role already exists for: " + tableName);
    }
}