CREATE TABLE pat (
  pat_id int(11) NOT NULL AUTO_INCREMENT,
  pat_name varchar(255) DEFAULT NULL,
  PRIMARY KEY (pat_id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci;

CREATE TABLE pat_det (
  ptd_id int(11) NOT NULL AUTO_INCREMENT,
  ptd_pat_id int(11) DEFAULT NULL,
  ptd_name varchar(255) DEFAULT NULL,
  PRIMARY KEY (ptd_id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci;

ALTER TABLE pat_det
ADD CONSTRAINT FK_pat_det_ptd_pat_id FOREIGN KEY (ptd_pat_id)
REFERENCES pat (pat_id);

CREATE TABLE mat (
  mat_id int(11) NOT NULL AUTO_INCREMENT,
  mat_name varchar(255) DEFAULT NULL,
  mat_pat_id int(11) NOT NULL,
  PRIMARY KEY (mat_id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci;

CREATE TABLE mat_det (
  mtd_id int(11) NOT NULL AUTO_INCREMENT,
  mtd_mat_id int(11) DEFAULT NULL,
  mtd_name varchar(255) DEFAULT NULL,
  PRIMARY KEY (mtd_id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci;

ALTER TABLE mat_det
ADD CONSTRAINT FK_mat_det_mtd_mat_id FOREIGN KEY (mtd_mat_id)
REFERENCES mat (mat_id);