/*Column Information For - ectemporal.orvellamadas*/
----------------------------------------------------

Field           Type         Collation          Null    Key     Default              Extra   Privileges                       Comment
--------------  -----------  -----------------  ------  ------  -------------------  ------  -------------------------------  -------
CONSECUTIVO     int(6)       NULL                       PRI     0                            select,insert,update,references         
CVEEXPED        int(6)       NULL                       PRI     0                            select,insert,update,references         
FECHALLAMADA    datetime     NULL                               0000-00-00 00:00:00          select,insert,update,references         
HORALLAMADA     varchar(8)   latin1_swedish_ci                  00:00:00                     select,insert,update,references         
COMENTARIO      mediumtext   latin1_swedish_ci                                               select,insert,update,references         
CVEUSUARIO      varchar(10)  latin1_swedish_ci          MUL                                  select,insert,update,references         
CVESTATUS       int(1)       NULL                               0                            select,insert,update,references         
CVETIPOLLAMADA  int(1)       NULL                               0                            select,insert,update,references         
CVESUCURSAL     char(3)      latin1_swedish_ci  YES             (NULL)                       select,insert,update,references         

/*Index Information For - ectemporal.orvellamadas*/
---------------------------------------------------

Table         Non_unique  Key_name    Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  Null    Index_type  Comment
------------  ----------  ----------  ------------  -----------  ---------  -----------  --------  ------  ------  ----------  -------
orvellamadas           0  PRIMARY                1  CONSECUTIVO  A                  506    (NULL)  (NULL)          BTREE              
orvellamadas           0  PRIMARY                2  CVEEXPED     A                  506    (NULL)  (NULL)          BTREE              
orvellamadas           1  CVEUSUARIO             1  CVEUSUARIO   A                   33    (NULL)  (NULL)          BTREE              

/*DDL Information For - ectemporal.orvellamadas*/
-------------------------------------------------

Table         Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
------------  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
orvellamadas  CREATE TABLE `orvellamadas` (                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
                `CONSECUTIVO` int(6) NOT NULL default '0',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                `CVEEXPED` int(6) NOT NULL default '0',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                `FECHALLAMADA` datetime NOT NULL default '0000-00-00 00:00:00',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
                `HORALLAMADA` varchar(8) NOT NULL default '00:00:00',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                `COMENTARIO` mediumtext NOT NULL,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
                `CVEUSUARIO` varchar(10) NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
                `CVESTATUS` int(1) NOT NULL default '0',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                `CVETIPOLLAMADA` int(1) NOT NULL default '0',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
                `CVESUCURSAL` char(3) default NULL,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                PRIMARY KEY  (`CONSECUTIVO`,`CVEEXPED`),                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                KEY `CVEUSUARIO` (`CVEUSUARIO`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
              ) ENGINE=InnoDB DEFAULT CHARSET=latin1