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

Package com.foundationdb.ais.model.aisb2

Class com.foundationdb.ais.model.aisb2.NewAISBuilder

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

com.foundationdb.ais.model.aisb2.NewAISBuilder.table()
Starts creating a new table using the default schema. @param table the table's name @return the new table's builder

        //primary key (table_schema, table_name)
        //foreign_key (table_schema) references SCHEMATA (schema_name)
        //foreign key (character_set_schema, character_set_name) references CHARACTER_SETS
        //foreign key (collations_schema, collation_name) references COLLATIONS
        //foreign key (storage_name) references STORAGE_TREES
        builder.table(COLUMNS)
                .colString("table_catalog", IDENT_MAX, true)
                .colString("table_schema", IDENT_MAX, false)
                .colString("table_name", IDENT_MAX, false)
                .colString("column_name", IDENT_MAX, false)
                .colBigInt("ordinal_position", false)

View Full Code Here

        //primary key(table_schema, table_name, column_name)
        //foreign key(table_schema, table_name) references TABLES (table_schema, table_name)
        //foreign key (type) references TYPES (type_name)
        //foreign key (character_set_schema, character_set_name) references CHARACTER_SETS
        //foreign key (collation_schema, collation_name) references COLLATIONS
        builder.table(TABLE_CONSTRAINTS)
                .colString("constraint_catalog", IDENT_MAX, true)
                .colString("constraint_schema", IDENT_MAX, false)
                .colString("constraint_name", GROUPING_CONSTRAINT_MAX, false)
                .colString("table_catalog", IDENT_MAX, true)
                .colString("table_schema", IDENT_MAX, false)

View Full Code Here

                .colString("is_deferrable", YES_NO_MAX, false)
                .colString("initially_deferred", YES_NO_MAX, false)
                .colString("enforced", YES_NO_MAX, false);
        //primary key (constraint_schema, constraint_table, constraint_name)
        //foreign key (table_schema, table_name) references TABLES
        builder.table(REFERENTIAL_CONSTRAINTS)
            .colString("constraint_catalog", IDENT_MAX, true)
            .colString("constraint_schema", IDENT_MAX, false)
            .colString("constraint_name", IDENT_MAX, false)
            .colString("unique_constraint_catalog", IDENT_MAX, true)
            .colString("unique_constraint_schema", IDENT_MAX, false)

View Full Code Here

            .colString("match_option", DESCRIPTOR_MAX, false)
            .colString("update_rule", DESCRIPTOR_MAX, false)
            .colString("delete_rule", DESCRIPTOR_MAX, false);
        //foreign key (constraint_schema, constraint_name)
        //    references TABLE_CONSTRAINTS (constraint_schema, constraint_name)
        builder.table(GROUPING_CONSTRAINTS) 
                .colString("root_table_catalog", IDENT_MAX, true)
                .colString("root_table_schema", IDENT_MAX, false)
                .colString("root_table_name", IDENT_MAX, false)
                .colString("constraint_catalog",IDENT_MAX, true)
                .colString("constraint_schema", IDENT_MAX, false)

View Full Code Here

                .colString("unique_catalog", IDENT_MAX, true)
                .colString("unique_schema", IDENT_MAX, true)
                .colString("unique_constraint_name", GROUPING_CONSTRAINT_MAX, true);
        //foreign key (constraint_schema, constraint_name)
        //    references TABLE_CONSTRAINTS (constraint_schema, constraint_name)
        builder.table(KEY_COLUMN_USAGE)
            .colString("constraint_catalog", IDENT_MAX, true)
            .colString("constraint_schema", IDENT_MAX, false)
            .colString("constraint_name", GROUPING_CONSTRAINT_MAX, false)
            .colString("table_catalog", IDENT_MAX, true)
            .colString("table_schema", IDENT_MAX, false)

View Full Code Here

            .colString("column_name", IDENT_MAX, false)
            .colBigInt("ordinal_position", false)
            .colBigInt("position_in_unique_constraint", true);
        //primary key  (constraint_schema, constraint_name, column_name),
        //foreign key (constraint_schema, constraint_name) references TABLE_CONSTRAINTS
        builder.table(INDEXES)
                .colString("table_catalog", IDENT_MAX, true)
                .colString("table_schema", IDENT_MAX, false)
                .colString("table_name", IDENT_MAX, false)
                .colString("index_name", IDENT_MAX, false)
                .colString("constraint_catalog", IDENT_MAX, true)

View Full Code Here

                .colString("index_method", IDENT_MAX, true);
        //primary key(table_schema, table_name, index_name)
        //foreign key (constraint_schema, constraint_name)
        //    references TABLE_CONSTRAINTS (constraint_schema, constraint_name)
        //foreign key (table_schema, table_name) references TABLES (table_schema, table_name)
        builder.table(INDEX_COLUMNS)
                .colString("index_table_catalog", IDENT_MAX, true)
                .colString("index_table_schema", IDENT_MAX, false)
                .colString("index_table_name", IDENT_MAX, false)
                .colString("index_name", IDENT_MAX, false)
                .colString("column_catalog", IDENT_MAX, true)

View Full Code Here

        //primary key(index_table_schema, index_table, index_name, column_schema, column_table, column_name)
        //foreign key(index_table_schema, index_table_name, index_name)
        //    references INDEXES (table_schema, table_name, index_name)
        //foreign key (column_schema, column_table, column_name)
        //    references COLUMNS (table_schema, table_name, column_name)
        builder.table(SEQUENCES)
                .colString("sequence_catalog", IDENT_MAX, true)
                .colString("sequence_schema", IDENT_MAX, false)
                .colString("sequence_name", IDENT_MAX, false)
                .colString("data_type", DESCRIPTOR_MAX, false)
                .colBigInt("start_value", false)

View Full Code Here

                .colString("cycle_option", YES_NO_MAX, false)
                .colString("storage_name", IDENT_MAX, false);
        //primary key (sequence_schema, sequence_name)
        //foreign key (data_type) references type (type_name)
                
        builder.table(VIEWS)
                .colString("table_catalog", IDENT_MAX,true)
                .colString("table_schema", IDENT_MAX, false)
                .colString("table_name", IDENT_MAX, false)
                .colText("view_definition", false)
                .colString("check_option", DESCRIPTOR_MAX, false)

View Full Code Here

                .colString("is_trigger_deletable", YES_NO_MAX, false)
                .colString("is_trigger_insertable_into", YES_NO_MAX, false);
        //primary key(table_schema, table_name)
        //foreign key(table_schema, table_name) references TABLES (table_schema, table_name)


        builder.table(VIEW_TABLE_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

0 1 2 3 4 5 6 7 8 9

TOP

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.