Start with StartDate, ClientName, Filename, Path, Attributes, MediaName,
MediaCoordinates. (PartNumber, NumParts). In the steps below, ``Create new''
means to create a new record whether or not it is unique. ``Create unique''
means each record in the database should be unique. Thus, one must first
search to see if the record exists, and only if not should a new one be
created, otherwise the existing RecordId should be used.
- Create new Job record with StartDate; save JobId
- Create unique Media record; save MediaId
- Create unique Client record; save ClientId
- Create unique Filename record; save FilenameId
- Create unique Path record; save PathId
- Create unique Attribute record; save AttributeId
store ClientId, FilenameId, PathId, and Attributes
- Create new File record
store JobId, AttributeId, MediaCoordinates, etc
- Repeat steps 4 through 8 for each file
- Create a JobMedia record; save MediaId
- Update Job record filling in EndDate and other Job statistics
Kern Sibbald
2010-08-30