zCMP_workings_YearOfOrderItems_WithPeriod

efacdb_full · Custom/model/helper tables

Type

BASE TABLE

Rows est.

24,347

Size

2.52 MB

Updated

2026-04-03 14:25:49

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	varchar(30)	-	NO		-
2	dueperiodnum	bigint	-	YES	-	-
3	traderquantity	double	-	YES	-	-
4	price_min	double	-	YES	-	-
5	price_avg	double	-	YES	-	-
6	price_max	double	-	YES	-	-

Name	Unique	Columns
No indexes found.

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.