T_CONVENIO_CLIENTE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CD_CLIENTE DOUBLE PRECISION 15 null
T_CLIENTE.CD_CLIENTE FK_CLI_CON_CLI R
CD_CONVENIO DOUBLE PRECISION 15 null
T_CONVENIO.CD_CONVENIO FK_COM_CON_CLI R
CD_FUNCIONARIO VARCHAR 20 null
ID_BLOQUEIO_CONVENIO CHAR 1 null
DS_BLOQUEIO_CONVENIO VARCHAR 200 null
VL_LIMITE DOUBLE PRECISION 15 null

Indexes

Constraint Name Type Sort Column(s)
FK_CLI_CON_CLI Performance Asc CD_CLIENTE
FK_COM_CON_CLI Performance Asc CD_CONVENIO
RDB$PRIMARY22 Must be unique Asc/Asc CD_CLIENTE + CD_CONVENIO

Relationships