aandaluz
public text v1 · immutable/*Column Information For - echistoria.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 - echistoria.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 474 (NULL) (NULL) BTREE
orvellamadas 0 PRIMARY 2 CVEEXPED A 474 (NULL) (NULL) BTREE
orvellamadas 1 CVEUSUARIO 1 CVEUSUARIO A 24 (NULL) (NULL) BTREE
/*DDL Information For - echistoria.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