holds URL information for external favorites
| Column Name | Type | Length | Nullable | Unicode | Description |
|---|---|---|---|---|---|
| creationDate | bigint | N/A | false | the date and time on which this URL entry was created | |
| host | varchar | 3500 | false | the hostname of the URL such as www.jivesoftware.com | |
| id | bigint | N/A | false | uniquely identifies URL system wide Primary key. | |
| mimeType | varchar | 100 | true | mime type related to the given url | |
| modificationDate | bigint | N/A | false | last modification date of the external URL | |
| path | varchar | 3500 | true | the path of the URL such as /clearspace | |
| port | int | N/A | true | the port of the URL such as 80 | |
| protocol | varchar | 10 | false | the protocol of the URL such as http | |
| query | varchar | 3500 | true | the query string of the URL such as foo=bar | |
| ref | varchar | 3500 | true | the anchor of the URL such as #foo | |
| status | int | N/A | false | ||
| title | varchar | 1000 | true | a title extracted from the url |