CREATE TABLE MyappType (
Id INTEGER NOT NULL UNIQUE
# ...
);
CREATE TABLE AvailableMyapp (
MyappTypeId INTEGER NOT NULL,
FOREIGN KEY(MyappTypeId) REFERENCES MyappType(Id)
# ...
);
####
DBIx::Class::Schema::Loader::make_schema_at(
'Myapps::Model::Schema',
skip_load_external => 1,
naming => {
monikers => 'preserve',
#relationships => 'current',
column_accessors => 'preserve',
},
);
####
...
__PACKAGE__->has_many(
"available_myapps",
"Myapps::Model::Schema::Result::AvailableMyapp",
{
"foreign.MyappTypeId" => "self.Id",
},
{
"cascade_copy" => "0",
"cascade_delete" => "0",
},
);
####
...
__PACKAGE__->belongs_to(
"myapp_type",
"Myapps::Model::Schema::Result::MyappType",
{
"Id" => "MyappTypeId",
},
{
"is_deferrable" => "0",
"on_delete" => "NO ACTION",
"on_update" => "NO ACTION",
},
);