zNWD_Snapshot_AllPartMaster

efacdb_full · Backups, snapshots and deleted-row stores

Type

BASE TABLE

Rows est.

92,508

Size

32.25 MB

Updated

2026-04-03 12:39:19

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	snapshot_id	char(36)	PRI	NO	-	-
2	partnum	varchar(30)	PRI	NO	-	-
3	partdesc	varchar(255)	-	YES	-	-
4	sm	varchar(20)	-	YES	-	-
5	uom	varchar(30)	-	YES	-	-
6	stanmat	double	-	YES	-	-

Name	Unique	Columns
PRIMARY	Yes	snapshot_id, partnum
idx_partnum	No	partnum

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.