CREATE TABLE macdeidiani (
  idmacdeidiani VARCHAR(17)  NOT NULL  ,
  nome VARCHAR(35)  NULL  ,
  ativo BOOL  NULL    ,
PRIMARY KEY(idmacdeidiani));



CREATE TABLE paineldeidiani (
  idpaineldeidiani INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(50)  NULL  ,
  datainicio DATETIME  NULL  ,
  datafim DATETIME  NULL    ,
PRIMARY KEY(idpaineldeidiani));



CREATE TABLE leddeidiani (
  idleddeidiani INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(35)  NULL  ,
  pinor INTEGER UNSIGNED  NULL  ,
  pinog INTEGER UNSIGNED  NULL  ,
  pinob INTEGER UNSIGNED  NULL    ,
PRIMARY KEY(idleddeidiani));



CREATE TABLE combinadeidiani (
  idcombinadeidiani INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  paineldeidiani_idpaineldeidiani INTEGER UNSIGNED  NOT NULL  ,
  macdeidiani_idmacdeidiani VARCHAR(17)  NOT NULL  ,
  leddeidiani_idleddeidiani INTEGER UNSIGNED  NOT NULL  ,
  ledr INTEGER UNSIGNED  NULL  ,
  ledg INTEGER UNSIGNED  NULL  ,
  ledb INTEGER UNSIGNED  NULL    ,
PRIMARY KEY(idcombinadeidiani)  ,
INDEX combinadeidiani_FKIndex1(leddeidiani_idleddeidiani)  ,
INDEX combinadeidiani_FKIndex2(macdeidiani_idmacdeidiani)  ,
INDEX combinadeidiani_FKIndex3(paineldeidiani_idpaineldeidiani),
  FOREIGN KEY(leddeidiani_idleddeidiani)
    REFERENCES leddeidiani(idleddeidiani)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(macdeidiani_idmacdeidiani)
    REFERENCES macdeidiani(idmacdeidiani)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(paineldeidiani_idpaineldeidiani)
    REFERENCES paineldeidiani(idpaineldeidiani)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);