Create Table pt (pt_pk Int Primary Key, f2 Varchar(12), f3 Double);

Create Table ct (
  ct_id Int Primary Key, f2 Double, f3 Varchar(6), 
  ct_fk Int, 
  FOREIGN KEY(ct_fk) REFERENCES pt(pt_pk)
);



mysql> Desc pt;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| pt_pk | int(11)     | NO   | PRI | NULL    |       |
| f2    | varchar(12) | YES  |     | NULL    |       |
| f3    | double      | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+

mysql> Desc ct;
+-------+------------+------+-----+---------+-------+
| Field | Type       | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| ct_id | int(11)    | NO   | PRI | NULL    |       |
| f2    | double     | YES  |     | NULL    |       |
| f3    | varchar(6) | YES  |     | NULL    |       |
| ct_fk | int(11)    | YES  | MUL | NULL    |       |
+-------+------------+------+-----+---------+-------+

mysql> show create table pt\G
       Table: pt
Create Table: CREATE TABLE `pt` (
  `pt_pk` int(11) NOT NULL,
  `f2` varchar(12) DEFAULT NULL,
  `f3` double DEFAULT NULL,
  PRIMARY KEY (`pt_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

mysql> show create table ct\G
*************************** 1. row ***************************
       Table: ct
Create Table: CREATE TABLE `ct` (
  `ct_id` int(11) NOT NULL,
  `f2` double DEFAULT NULL,
  `f3` varchar(6) DEFAULT NULL,
  `ct_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`ct_id`),
  KEY `ct_fk` (`ct_fk`),
  CONSTRAINT `ct_ibfk_1` FOREIGN KEY (`ct_fk`) REFERENCES `pt` (`pt_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1