mysql> desc RequestData; +-------------------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+---------------+------+-----+---------+----------------+ | RequestId | int(11) | NO | PRI | NULL | auto_increment | | RegistrationNo | varchar(64) | YES | MUL | | | | RequestTime | int(11) | YES | MUL | 0 | | | RequestType | int(11) | YES | MUL | 0 | | | PolicyClassId | int(11) | YES | MUL | 0 | | | CertSerialNumber | varchar(64) | YES | MUL | | | | CommonName | varchar(128) | YES | MUL | | | | EMailId | varchar(128) | YES | MUL | | | | OrgName | varchar(128) | YES | MUL | | | | Status | int(11) | YES | MUL | 0 | | | RevReason | int(11) | YES | | 0 | | | RejReason | varchar(256) | YES | | | | | ResponseTime | int(11) | YES | | 0 | | | ValidFrom | int(11) | YES | | 0 | | | ValidTo | int(11) | YES | MUL | 0 | | | AdminId | int(11) | YES | | 0 | | | AdminIdInternalVal1 | int(11) | YES | MUL | 0 | | | AdminIdInternalVal2 | int(11) | YES | MUL | 0 | | | ChallengePhrase | varchar(128) | YES | MUL | | | | VERAId | int(11) | YES | MUL | 0 | | | CsrType | int(11) | YES | | 0 | | | Validity | int(11) | YES | | 0 | | | ValidityType | int(11) | YES | | 0 | | | PickupTime | int(11) | YES | MUL | 0 | | | ApprovalTime | int(11) | YES | MUL | 0 | | | IdVal | varchar(64) | YES | MUL | NULL | | | IdLen | int(11) | YES | | 0 | | | ServerId | int(11) | YES | MUL | 0 | | | DNDetails | varchar(2048) | YES | | | | | OSDetails | varchar(256) | YES | | | | | CertStatus | int(11) | YES | | 0 | | | ErrorString | varchar(256) | YES | | | | | CheckerAdminId | int(11) | YES | | 0 | | | CheckerApprovalTime | int(11) | YES | MUL | 0 | | | RootMakerAdminId | int(11) | YES | | 0 | | | RootMakerApprovalTime | int(11) | YES | MUL | 0 | | | IPAddress | varchar(32) | YES | | | | | DocStatus | int(11) | YES | | 0 | | | RootCheckerAdminId | int(11) | YES | | 0 | | | RootCheckerApprovalTime | int(11) | YES | MUL | 0 | | +-------------------------+---------------+------+-----+---------+----------------+ 40 rows in set (0.00 sec)