x_pedidoprojeto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idx_pedidoprojeto int8 19 null
x_pedidoprojeto_aud.idx_pedidoprojeto Implied Constraint R
idx_projetovertical int8 19 √ null
x_projetovertical.idx_projetovertical fk_cfy5bcu3l6c735p2etqx91gxm R
idpedido int8 19 √ null
pedido.idpedido fk_t0afknfcsjl78s2w72l8vvfxh R
idcolecao int8 19 √ null
colecao.idcolecao fk_8dvcghvqbtdu5djfc3msd7kad R
descricao varchar 200 √ null
codigo varchar 80 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pke85e8e57 Primary key Asc idx_pedidoprojeto
idx23daf752 Performance Asc idpedido
idxc5656108 Performance Asc idcolecao
idxe7edc034 Performance Asc idx_projetovertical
idxwsversao_e85e8e57 Performance Desc wsversao
uca721d2a5 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation