Hi,
I should implement a DNN module which makes some statistics about a document within the portal. I'm drawing on Documents Module, whith a difference: I must to create another table in order to store the extracted statistics.
This additional table must be associated to the existing Documents table, so I have thought to specify URL as PrimaryKey in this additional table. It is possible? Is the URL unique?
The additional table should be the following:
| URL |
nvarchar |
250 |
not null - primary key |
| Word |
nvarchar |
50 |
not null - primary key |
| WordCount |
int |
4 |
not null |
And about the FileID? Is it unique also? I have also thought to use FileID rather than URL within tha table above...
Thanks a lot!