zFCS_master_products

efacdb_full ยท Custom/model/helper tables
Back to EFACS Browser
Type
BASE TABLE
Rows est.
3,283
Size
0.17 MB
Updated
-

Columns

Full schema, no data mutation.
#NameTypeKeyNullableDefaultComment
1partidvarchar(30)PRINO--
2is_activetinyint(1)-NO1-
3status_reasonvarchar(255)-YES--
4created_atdatetime-NOCURRENT_TIMESTAMP-
5updated_atdatetime-NOCURRENT_TIMESTAMP-

Indexes

NameUniqueColumns
PRIMARYYespartid

Foreign Keys

EFACS has few enforced keys; many relationships are conventional.
ColumnReferences
No enforced foreign keys found for this table.