Database Structure (Partial)
- Paul Macey
Owned by Paul Macey
Jan 14, 2022
1 min read
Loading data...
Table: file
Purpose: track origin of MRI files
Field name | Description | Type (* required) |
|---|---|---|
file_id | key | * INTERGER AUTOINCREMENT |
name | file name | * VARCHAR |
folder | folder (where created) | VARCHAR |
date | time last changed | * DATETIME |
inputfileset_id | files use in creating this file | INTEGER |
batchfileset_id | batch file | INTEGER |
parameters | information on paramaters (text) | VARCHAR |
Table: fileset
Purpose: group files. Each set will consist of multiple file_id’s under the same fileset_id
Field name | Description | Type (* required) |
|---|---|---|
fileset_id | Â | * INTEGER |
file_id | Â | * INTEGER |
Â