zCMP_output_PricesForAPI_20260109_bkp_20260319_185143

efacdb_full · Backups, snapshots and deleted-row stores

Type

BASE TABLE

Rows est.

91,948

Size

10.52 MB

Updated

2026-03-19 18:51:46

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	varchar(30)	-	NO	-	-
2	partdesc	varchar(60)	-	YES	-	-
3	unitprice_obsolete	double	-	NO	-	-
4	price_nogo_raw	decimal(10,2)	-	YES	-	-
5	price_wholesale_raw	decimal(10,2)	-	YES	-	-
6	price_headline_raw	decimal(10,2)	-	YES	-	-
7	price_nogo	decimal(10,2)	-	YES	-	-
8	price_wholesale	decimal(10,2)	-	YES	-	-
9	price_trade	decimal(10,2)	-	YES	-	-
10	price_retail	decimal(10,2)	-	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.