If you want to version the files, you have to make your own table for that and join to the FileTable using stream_id as the primary key in the FileTable. The 17 columns are:
- stream_id (uniqueidentifier, not null)
- file_stream (varbinary(max), null)
- name (nvarchar(255), not null)
- path_locator (PK, hierarchyid, not null)
- parent_path_locator (FK, Computed, hierarchyid, null)
- file_type (Computed, nvarchar(255), null)
- cached_file_size (datetimeoffset(7), not null)
- creation_time (datetimeoffset(7), not null)
- last_write_time (datetimeoffset(7), null)
- last_access_time (bit, not null)
- is_directory (bit, not null)
- is_offline (bit, not null)
- is_hidden (bit, not null)
- is_readonly (bit, not null)
- is_archive (bit, not null)
- is_system (bit, not null)
- is_temporary (bit, not null)
No comments:
Post a Comment