public NistDML181() {
super("NistDML181");
Table tableLongNamedPeople = this.createTable("LONG_NAMED_PEOPLE");
tableLongNamedPeople.createColumn("FIRSTNAME", new VarCharDataType(373));
tableLongNamedPeople.createColumn("LASTNAME", new VarCharDataType(373));
tableLongNamedPeople.createColumn("AGE", new IntDataType());
this.createPrimaryKeyConstraint(
tableLongNamedPeople,
tableLongNamedPeople.getColumn("FIRSTNAME"),
tableLongNamedPeople.getColumn("LASTNAME"));
Table tableOrders = this.createTable("ORDERS");
tableOrders.createColumn("FIRSTNAME", new VarCharDataType(373));
tableOrders.createColumn("LASTNAME", new VarCharDataType(373));
tableOrders.createColumn("TITLE", new VarCharDataType(80));
tableOrders.createColumn("COST", new NumericDataType(5, 2));
this.createForeignKeyConstraint(
tableOrders,
Arrays.asList(tableOrders.getColumn("FIRSTNAME"), tableOrders.getColumn("LASTNAME")),
tableLongNamedPeople,
Arrays.asList(
tableLongNamedPeople.getColumn("FIRSTNAME"),
tableLongNamedPeople.getColumn("LASTNAME")));
}
public ArtistTerm() {
super("ArtistTerm");
Table tableArtists = this.createTable("artists");
tableArtists.createColumn("artist_id", new TextDataType());
this.createPrimaryKeyConstraint(tableArtists, tableArtists.getColumn("artist_id"));
Table tableMbtags = this.createTable("mbtags");
tableMbtags.createColumn("mbtag", new TextDataType());
this.createPrimaryKeyConstraint(tableMbtags, tableMbtags.getColumn("mbtag"));
Table tableTerms = this.createTable("terms");
tableTerms.createColumn("term", new TextDataType());
this.createPrimaryKeyConstraint(tableTerms, tableTerms.getColumn("term"));
Table tableArtistMbtag = this.createTable("artist_mbtag");
tableArtistMbtag.createColumn("artist_id", new TextDataType());
tableArtistMbtag.createColumn("mbtag", new TextDataType());
this.createForeignKeyConstraint(
tableArtistMbtag,
tableArtistMbtag.getColumn("artist_id"),
tableArtists,
tableArtists.getColumn("artist_id"));
this.createForeignKeyConstraint(
tableArtistMbtag,
tableArtistMbtag.getColumn("mbtag"),
tableMbtags,
tableMbtags.getColumn("mbtag"));
Table tableArtistTerm = this.createTable("artist_term");
tableArtistTerm.createColumn("artist_id", new TextDataType());
tableArtistTerm.createColumn("term", new TextDataType());
this.createForeignKeyConstraint(
tableArtistTerm,
tableArtistTerm.getColumn("artist_id"),
tableArtists,
tableArtists.getColumn("artist_id"));
this.createForeignKeyConstraint(
tableArtistTerm,
tableArtistTerm.getColumn("term"),
tableTerms,
tableTerms.getColumn("term"));
}
