rupe_articulos_sice

42024 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ars_id serial 10 nextval('rupe.rupe_articulos_sice_ars_id_seq'::regclass)
rupe_vinculaciones_sice_proveedor.vso_articulo_ars_id fk72750ac8cd078c1f R
ars_codigo_articulo varchar 255 null
ars_codigo_clase varchar 255 null
ars_codigo_familia varchar 255 null
ars_codigo_sub_clase varchar 255 null
ars_codigo_sub_familia varchar 255 null
ars_crea_fecha timestamp 29,6 null
ars_crea_origen int4 10 null
ars_crea_usu varchar 255 null
ars_descripcion varchar 255 null
ars_fecha_baja date 13 null
ars_habilitado bool 1 null
ars_motivo_baja varchar 255 null
ars_ultmod_fecha timestamp 29,6 null
ars_ultmod_origen int4 10 null
ars_ultmod_usu varchar 255 null
ars_version int4 10 null
ars_sub_clase_scs_id int4 10 null
rupe_sub_clases_sice.scs_id fk2fb281c6546d2c7 R

Indexes

Constraint Name Type Sort Column(s)
rupe_articulos_sice_pkey Primary key Asc ars_id
fki_ars_scs_fk Performance Asc ars_sub_clase_scs_id
rupe_ars_unique Must be unique Asc/Asc/Asc/Asc/Asc ars_codigo_familia + ars_codigo_sub_familia + ars_codigo_clase + ars_codigo_sub_clase + ars_codigo_articulo

Relationships