mySQL choosing proper data types?

[*TeKKeD*]

I have two tables, once is called departments, and the other is a seciton, when creating these tables i wanted to know what should i be looking for since each table will have it's onw primary key and an forign key...here's my structure so far:

CREATE TABLE `dept` (
`dept_id` int(11) NOT NULL auto_increment,
`dept_name` varchar(255) NOT NULL default '',
`section_id` varchar(255) NOT NULL default '',
PRIMARY KEY (`dept_id`)
) TYPE=MyISAM

=------------------------------------------------=

CREATE TABLE `section` (
`section_id` int(11) NOT NULL auto_increment,
`section_name` varchar(255) NOT NULL default '',
`dept_id` varchar(255) NOT NULL default '',
PRIMARY KEY (`section_id`)
) TYPE=MyISAM



----------------------------------------------

I want to know if i have the data types i have choosen are the right ones???

[AdamGundry]

The foreign keys should probably be the same type as the associated primary key, i.e. int(11) rather than strings.

Adam