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



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



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



CREATE TABLE combinadavi (
  idcombinadavi INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  paineldavi_idpaineldavi INTEGER UNSIGNED  NOT NULL  ,
  macdavi_idmacdavi VARCHAR(17)  NOT NULL  ,
  leddavi_idleddavi INTEGER UNSIGNED  NOT NULL  ,
  ledr INTEGER UNSIGNED  NULL  ,
  ledg INTEGER UNSIGNED  NULL  ,
  ledb INTEGER UNSIGNED  NULL    ,
PRIMARY KEY(idcombinadavi)  ,
INDEX combinadavi_FKIndex1(leddavi_idleddavi)  ,
INDEX combinadavi_FKIndex2(macdavi_idmacdavi)  ,
INDEX combinadavi_FKIndex3(paineldavi_idpaineldavi),
  FOREIGN KEY(leddavi_idleddavi)
    REFERENCES leddavi(idleddavi)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(macdavi_idmacdavi)
    REFERENCES macdavi(idmacdavi)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(paineldavi_idpaineldavi)
    REFERENCES paineldavi(idpaineldavi)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);