CREATE TABLE nics (
  id SMALLINT(6) NOT NULL AUTO_INCREMENT,
  parent_id SMALLINT(6), 
  Nic_name VARCHAR(8) NOT NULL,
  Nic_type VARCHAR(32) NOT NULL,
  Nic_mac VARCHAR(17) NOT NULL,
  alias_address_count TINYINT(4) NOT NULL,
  slave_nic_count TINYINT(4) NOT NULL,
  PRIMARY KEY(id),
  INDEX nic_info_FKIndex1(parent_id),
  FOREIGN KEY(parent_id)
    REFERENCES nics(id)
      ON DELETE CASCADE
);