Solicitud de ayuda en tablas

[[José Luis Garcí]]

Para que quede un poco más claro lo que solicito pongo la DLL de mi tbla Clientes de mi programa

Código Delphi [-]
/******************************************************************************/
/*                  Generated by IBExpert 30/07/2011 9:20:06                  */
/******************************************************************************/



/******************************************************************************/
/*                                   Tables                                   */
/******************************************************************************/



CREATE TABLE CLIENTES (
    CODIGO             CODIGO NOT NULL /* CODIGO = VARCHAR(20) NOT NULL */,
    FECHA_ALTA         DFECHA /* DFECHA = DATE */,
    NIF_CIF            DVARCHAR12NIFCIF /* DVARCHAR12NIFCIF = VARCHAR(15) */,
    NOMBRE_COMERCIAL   DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    DIRECCION          DVCHAR50 /* DVCHAR50 = VARCHAR(50) */,
    CODIGO_POSTAL      DVARCHAR5 /* DVARCHAR5 = VARCHAR(5) */,
    POBLACION          DVARCHAR30 /* DVARCHAR30 = VARCHAR(30) */,
    PROVINCIA          DVARCHAR30 /* DVARCHAR30 = VARCHAR(30) */,
    WEB                DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    EMAIL_1            DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    EMAIL_2            DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    BANCO              DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    ENTIDAD            DCHAR4 /* DCHAR4 = CHAR(4) */,
    OFICINA            DCHAR4 /* DCHAR4 = CHAR(4) */,
    DIGITO_CONTROL     DCHAR2 /* DCHAR2 = CHAR(2) */,
    NUMERO_CUENTA      CHAR10NCC /* CHAR10NCC = CHAR(10) */,
    TELEFONO_1         DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    TELEFONO_2         DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    FAX                DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    MOVIL              DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    PERSONA_CONTACTO   DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    EMAIL_PC           DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    MOVIL_PC           DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    FORMA_PAGO         DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    FECHAS_PAGO        DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    CONFIANZA          DNIVEL /* DNIVEL = CHAR(1) DEFAULT '0' NOT NULL CHECK (VALUE IN('0','1','2','3','4','5','6','7','8','9')) */,
    LIMITE_CREDITO     DIMPORTE /* DIMPORTE = NUMERIC(15,3) */,
    PENDIENTE_PAGO     DIMPORTE /* DIMPORTE = NUMERIC(15,3) */,
    AVISOS             DMEMO /* DMEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */,
    OBSERVACIONES      DMEMO /* DMEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */,
    NOTAS              DMEMO /* DMEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */,
    IMAGEN             DIMAGEN /* DIMAGEN = BLOB SUB_TYPE 0 SEGMENT SIZE 80 */,
    RAPEL              DLOGICO /* DLOGICO = CHAR(2) DEFAULT 'NO' NOT NULL CHECK (VALUE IN('SI','Si','si','NO','No','no')) */,
    GRUPO              DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    PAIS               DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    IMPUESTOS          DLOGICO /* DLOGICO = CHAR(2) DEFAULT 'NO' NOT NULL CHECK (VALUE IN('SI','Si','si','NO','No','no')) */,
    REQ                DLOGICO /* DLOGICO = CHAR(2) DEFAULT 'NO' NOT NULL CHECK (VALUE IN('SI','Si','si','NO','No','no')) */,
    TIPO_IMP           DDECIMAL /* DDECIMAL = NUMERIC(2,2) */,
    DTO                DDECIMAL /* DDECIMAL = NUMERIC(2,2) */,
    TARIFA             INTEGER,
    DIAS_PRESENTACION  DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
    SECTOR             DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
    AGENTE             DCLAVE /* DCLAVE = VARCHAR(20) */,
    CUMP_PC            DFECHA /* DFECHA = DATE */
);




/******************************************************************************/
/*                                Primary Keys                                */
/******************************************************************************/

ALTER TABLE CLIENTES ADD CONSTRAINT PK_CLIENTES PRIMARY KEY (CODIGO);


/* Fields descriptions */

COMMENT ON COLUMN CLIENTES.CONFIANZA IS 
'COMFIANZA  PARA CONTROL DE AVISOS Y LIMITES DE CREDITO';



/******************************************************************************/
/*                                 Privileges                                 */
/******************************************************************************/