11175
(-- --)
1
Hi,
Newbie question (i hope)
2 tables (no rails specs)
CREATE TABLE `werelddelen` (
`id` smallint(2) unsigned NOT NULL auto_increment,
`naam` varchar(50) default NULL,
`naam_en` varchar(50) default NULL,
`zoeknaam` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `zoeknaam` (`zoeknaam`)
)
CREATE TABLE `landen` (
`landcode` char(2) NOT NULL default '',
`naam` varchar(50) NOT NULL,
`naam_en` varchar(50) NOT NULL,
`alt_naam` varchar(200) NOT NULL,
`landafk` char(3) default NULL,
`land_zoeknaam` varchar(100) NOT NULL default '',
`werelddeel_id` tinyint(2) unsigned default NULL COMMENT
'wereldelen.id',
PRIMARY KEY (`landcode`),
KEY `land_zoeknaam` (`land_zoeknaam`),
KEY `werelddeel_id` (`werelddeel_id`)
)
How can realize a one to many relationship between this tables.(cannot
change column-names, because this is our central company database)
1)Werelddelen(continents) can have more than 1 land(countries)
2)Land only can have 1 werelddeel(continent)
Grtz..remco
Hi,
Newbie question (i hope)
2 tables (no rails specs)
CREATE TABLE `werelddelen` (
`id` smallint(2) unsigned NOT NULL auto_increment,
`naam` varchar(50) default NULL,
`naam_en` varchar(50) default NULL,
`zoeknaam` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `zoeknaam` (`zoeknaam`)
)
CREATE TABLE `landen` (
`landcode` char(2) NOT NULL default '',
`naam` varchar(50) NOT NULL,
`naam_en` varchar(50) NOT NULL,
`alt_naam` varchar(200) NOT NULL,
`landafk` char(3) default NULL,
`land_zoeknaam` varchar(100) NOT NULL default '',
`werelddeel_id` tinyint(2) unsigned default NULL COMMENT
'wereldelen.id',
PRIMARY KEY (`landcode`),
KEY `land_zoeknaam` (`land_zoeknaam`),
KEY `werelddeel_id` (`werelddeel_id`)
)
How can realize a one to many relationship between this tables.(cannot
change column-names, because this is our central company database)
1)Werelddelen(continents) can have more than 1 land(countries)
2)Land only can have 1 werelddeel(continent)
You want a belongs_to and a has_many. You can use the foreign_key
option to tell it to use the werelddeel_id column.
Fred