DbWrench Documentation: MRE

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

dtcnpa

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	dtcnpID	Integer				contrapd.ID
	contrap	Integer				contrap.ID (no.contrasena)
	facprov	Integer				facprov.ID (factura proveedor)
	abonado	Decimal(12, 2)				Valor abonado a esta factura
	ntrx	Integer				ntrx.ID (si actualiza)

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_contrasd_contras	compras.contras	compras.dtcnpa	contrID	contrap
fk_contrasd_facprove	compras.facprove	compras.dtcnpa	facprID	facprov
fk_contrasd_transacciones	mantenimiento.transacciones	compras.dtcnpa	transID	ntrx

Parent Relations (none)

Triggers (none)

Used in Diagrams

Diagram Name

Compras