zCRU_Parts

efacdb_full · Custom/model/helper tables

Type

BASE TABLE

Rows est.

93,658

Size

8.52 MB

Updated

2026-04-03 13:50:32

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partnum	varchar(30)	PRI	NO	-	-
2	partdesc	varchar(60)	-	YES	-	-
3	sm	varchar(12)	-	YES	-	-
4	uom	varchar(30)	-	YES	-	-
5	purchasecost	double	-	NO	0	-
6	warning	varchar(60)	-	YES		-

Name	Unique	Columns
PRIMARY	Yes	partnum
zCRU_idx_parts_partnum	Yes	partnum

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.