Package com.foundationdb.ais.model.aisb2

Examples of com.foundationdb.ais.model.aisb2.NewAISBuilder.table()


                .colString("table_schema", IDENT_MAX, false)
                .colString("table_name", IDENT_MAX, false);
        //foreign key(view_schema, view_name) references VIEWS (schema_name, table_name)
        //foreign key(table_schema, table_name) references TABLES (schema_name, table_name)

        builder.table(VIEW_COLUMN_USAGE)
                .colString("view_catalog", IDENT_MAX, true)
                .colString("view_schema", IDENT_MAX, false)
                .colString("view_name", IDENT_MAX, false)
                .colString("table_catalog", IDENT_MAX, true)
                .colString("table_schema", IDENT_MAX, false)
View Full Code Here


                .colString("table_name", IDENT_MAX, false)
                .colString("column_name", IDENT_MAX, false);
        //foreign key(view_schema, view_name) references VIEWS (schema_name, table_name)
        //foreign key(table_schema, table_name, column_name) references COLUMNS
        builder.table(ROUTINES)
                .colString("specific_catalog", IDENT_MAX,true)
                .colString("specific_schema", IDENT_MAX, false)
                .colString("specific_name", IDENT_MAX, false)
                .colString("routine_catalog", IDENT_MAX, true)
                .colString("routine_schema", IDENT_MAX, false)
View Full Code Here

                .colSystemTimestamp("created", true)
                .colSystemTimestamp("last_updated", true)
                .colString("new_savepoint_level", YES_NO_MAX,true);
        //primary key(routine_schema, routine_name)

        builder.table(PARAMETERS)
                .colString("specific_catalog", IDENT_MAX,true)
                .colString("specific_schema", IDENT_MAX, false)
                .colString("specific_name", IDENT_MAX, false)
                .colString("parameter_name", IDENT_MAX, true)
                .colBigInt("ordinal_position", false)
View Full Code Here

                .colString("parameter_default", PATH_MAX, true);
        //primary key(specific_schema, specific_name, parameter_name, ordinal_position)
        //foreign key(routine_schema, routine_name) references ROUTINES (routine_schema, routine_name)
        //foreign key (type) references TYPES (type_name)

        builder.table(JARS)
                .colString("jar_catalog", IDENT_MAX, true)
                .colString("jar_schema", IDENT_MAX, false)
                .colString("jar_name", IDENT_MAX, false)
                .colString("java_path", PATH_MAX, true);
        //primary key(jar_schema, jar_name)
View Full Code Here

                .colString("jar_schema", IDENT_MAX, false)
                .colString("jar_name", IDENT_MAX, false)
                .colString("java_path", PATH_MAX, true);
        //primary key(jar_schema, jar_name)

        builder.table(ROUTINE_JAR_USAGE)
                .colString("specific_catalog", IDENT_MAX, true)
                .colString("specific_schema", IDENT_MAX, false)
                .colString("specific_name", IDENT_MAX, false)
                .colString("jar_catalog", IDENT_MAX, true)
                .colString("jar_schema", IDENT_MAX, false)
View Full Code Here

                .colString("jar_schema", IDENT_MAX, false)
                .colString("jar_name", IDENT_MAX, false);
        //foreign key(specific_schema, specific_name) references ROUTINES (specific_schema, specific_name)
        //foreign key(jar_schema, jar_name) references JARS (jar_schema, jar_name)

        builder.table(SCRIPT_ENGINES)
                .colInt("engine_id", false)
                .colString("engine_name", IDENT_MAX, false)
                .colString("engine_version", IDENT_MAX, false)
                .colString("language_name", IDENT_MAX, false)
                .colString("language_version", IDENT_MAX, false);
View Full Code Here

                .colString("engine_version", IDENT_MAX, false)
                .colString("language_name", IDENT_MAX, false)
                .colString("language_version", IDENT_MAX, false);
        //primary key(engine_id)

        builder.table(SCRIPT_ENGINE_NAMES)
                .colString("name", IDENT_MAX, false)
                .colInt("engine_id", false);
        //foreign key (engine_id) references SCRIPT_ENGINES (engine_id)

        builder.table(TYPES)
View Full Code Here

        builder.table(SCRIPT_ENGINE_NAMES)
                .colString("name", IDENT_MAX, false)
                .colInt("engine_id", false);
        //foreign key (engine_id) references SCRIPT_ENGINES (engine_id)

        builder.table(TYPES)
            .colString("type_name", IDENT_MAX, false)
            .colString("type_category", IDENT_MAX, false)
            .colString("type_bundle_name", IDENT_MAX)
            .colString("attribute_1", IDENT_MAX)
            .colString("attribute_2", IDENT_MAX)
View Full Code Here

            .colInt("fixed_length")
            .colInt("postgres_oid")
            .colInt("jdbc_type_id")
            .colString("indexable", YES_NO_MAX);

        builder.table(TYPE_BUNDLES)
            .colString("type_bundle_name", IDENT_MAX, false)
            .colString("bundle_guid", IDENT_MAX, false);
       
        builder.table(TYPE_ATTRIBUTES)
            .colString("type_name", IDENT_MAX, false)
View Full Code Here

        builder.table(TYPE_BUNDLES)
            .colString("type_bundle_name", IDENT_MAX, false)
            .colString("bundle_guid", IDENT_MAX, false);
       
        builder.table(TYPE_ATTRIBUTES)
            .colString("type_name", IDENT_MAX, false)
            .colString("attribute_name", IDENT_MAX, false);
       
        return builder.ais(false);
    }
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.