drawing_files

efacdb_full ยท Live EFACS mirror

Drawing number to file-name mapping used by part image/CAD lookup tools.

Back to EFACS Browser
Type
BASE TABLE
Rows est.
14,662
Size
1.52 MB
Updated
-

Columns

Full schema, no data mutation.
#NameTypeKeyNullableDefaultComment
1drawing_numbervarchar(50)PRINO--
2filenamevarchar(255)MULNO--

Indexes

NameUniqueColumns
PRIMARYYesdrawing_number
idx_drawing_numberNodrawing_number
idx_filenameNofilename

Foreign Keys

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