Tables for File Management

The following changes were made to file management tables.

Also, the file management and folder tables have been combined into a new chapter, File and folder tables.

File_Type Table

File types are now managed solely from the File_Type table.

• The file_ext field now has a string length of 254.

• The doc_type field and the foreign key from this field to the Doc_Type table were removed.

• The following fields were added: edit_level, view_level, print_level, edit_args, view_args, and print_args.

Associated File Type Fields in Multiple Tables

The associated file type fields in the following tables now have a string length of 254:

• Bom_Item_Oper_Spec table: assoc_file_type field

• Ent_File table: file_type field

• Folder_File table: file_type field

• Item_File table: file_type field

• Job table: assoc_file_type field

• Job_Spec table: assoc_file_type field

• Job_Step_File table: assoc_file_type field

• Oper table: assoc_file_type field

• Oper_Ent_Spec table: assoc_file_type field

• Oper_Item_Spec table: assoc_file_type field

• Oper_Step_File table: assoc_file_type field

• Std_Oper table: assoc_file_type field

• Std_Oper_Ent_Spec table: assoc_file_type field

• Std_Oper_Step_File table: assoc_file_type field

• Wo_File table: file_type field

Also, for the tables listed above, the foreign key from the file_type or assoc_file_type field to the Doc_Type table was removed.

Doc_Type, File_Desc, Tool Tables

These tables were removed.