• tl_name varchar(255) primaryKey The unique tool name with extension
• tl_size int file size
• tl_num_inputs tinyint number of possible inputs
• tl_inputs varchar(255) dataType key of accepted input types comma separated, semicolon separated between num inputs
  • *example: first input takes fast-a (1) or .txt (0), second takes only .dat (4)
  • *tl_inputs = 1,0;4
• tl_output int unsigned the dataType key for the output file
• tl_description tinyblob text description entered on upload
• tl_user int unsigned the user key for the user who uploaded the file
• tl_user_text varchar(255) The user name for the uploader
• tl_timestamp char(14) The time uploaded according to mediaWiki's form of timestamp.

This is esentailly an enumeration and listing in the database.

• dt_key int unsigned primary key The dataType key autoincrement
• dt_name varchar(255) unique The unique dataType name. (at least the most commonly accepted name)

• da_key int unsigned primaryKey a numeric key, autoincrement
• da_name varchar(255) unique unique name with extension
• da_size int file size
• da_type int unsigned dataType key
• da_description tinyblob a description, will reference it's creation piping if autogenerated result
• da_source enum('result', 'upload') autogenerated result or an original upload?
• da_user int unsigned user key for the user who uploaded or ran the creating tool
• da_user_text varchar(255) the user name
• da_timestamp char(14) the time uploaded according to mediaWiki's form of timestamp.

AiptasiaWiki