[[Category:TABLAS]]
== Descripción ==
Container de cabecera de bocetos. Es parte del conjunto de la estructura '''Bocetos'''

*[[TABLA:bocetoscab]]
**[[TABLA:bocetosdet]]
***[[TABLA:bocetossbs]]

== Composición ==
== SQL ==
<pre>
delimiter $$

CREATE TABLE `bocetoscab` (
  `BocetoID` char(8) NOT NULL DEFAULT '',
  `ModuloID` char(8) NOT NULL,
  `BocetoDSC` varchar(80) NOT NULL,
  `BocetoVW` varchar(45) DEFAULT NULL,
  `BocetoVH` varchar(45) DEFAULT NULL,
  `BocetoIMG` blob,
  `BocetoATH` varchar(10) NOT NULL,
  `BocetoFec` date NOT NULL,
  `BocetoEstado` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`BocetoID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$

CREATE
DEFINER=`sas_admin`@`%`
TRIGGER `fzggestion`.`Baja_Boceto`
AFTER DELETE ON `fzggestion`.`bocetoscab`
FOR EACH ROW
BEGIN
    DELETE
        FROM bocetosdet
        WHERE bocetosdet.BocetoID=OLD.BocetoID;
END
$$
</pre>
== Triggers ==
*Alta
**[[TRIG:bocetoscab.Baja_Boceto]]
<pre>
delimiter $$

CREATE
DEFINER=`sas_admin`@`%`
TRIGGER `fzggestion`.`Baja_Boceto`
AFTER DELETE ON `fzggestion`.`bocetoscab`
FOR EACH ROW
BEGIN
    DELETE
        FROM bocetosdet
        WHERE bocetosdet.BocetoID=OLD.BocetoID;
END
$$
</pre>

== Bitácora ==
*20121201
**Alta
== Uso ==
== URL ==