zFCS_master_products

efacdb_full · Custom/model/helper tables

Type

BASE TABLE

Rows est.

3,283

Size

0.17 MB

Updated

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	varchar(30)	PRI	NO	-	-
2	is_active	tinyint(1)	-	NO	1	-
3	status_reason	varchar(255)	-	YES	-	-
4	created_at	datetime	-	NO	CURRENT_TIMESTAMP	-
5	updated_at	datetime	-	NO	CURRENT_TIMESTAMP	-

Name	Unique	Columns
PRIMARY	Yes	partid

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.