| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | Warehouse identifier for this entry. |
| Name | VARCHAR | VARCHAR2(255) | No | Name of the database. |
| Version | VARCHAR | VARCHAR2(50) | Yes | Version of the database described by this warehouse dataset; in practice, this can be
populated
with whatever the user chooses to put in it from the command line arguments |
| ReleaseDate | DATETIME | DATE | Yes | Date that the original database was first released. |
| LoadDate | DATETIME | DATE | No | Date that the load of this data set into the warehouse began. |
| ChangeDate | DATETIME | DATE | Yes | Date of the last change to this dataset, or the date the load completed if no changes have occurred. NULL means that the is currently loading, or a fatal error occurred on the load. NOTE: This feature is not supported by most loaders until version 4.0. |
| HomeURL | VARCHAR | VARCHAR2(255) | Yes | Web address of the home page of the original database. |
| QueryURL | VARCHAR | VARCHAR2(255) | Yes | A URL at which we can retrieve objects in this database via the WWW by substituting the unique ID of the object we wish to retrieve for the string "%s" in the query URL. An example URL is: http://database.university.edu/get-object/5050%s |
| LoadedBy | VARCHAR | VARCHAR2(255) | Yes | The name (or username) of the person who loaded this dataset. NOTE: This feature is not supported by most loaders until version 4.0. At that time, this column should be required. |
| Application | VARCHAR | VARCHAR2(255) | Yes | The name of the application that created this dataset. NOTE: This feature is not supported by most loaders until version 4.0. At that time, this column should be required. |
| ApplicationVersion | VARCHAR | VARCHAR2(255) | Yes | The version of the application that created this dataset. NOTE: This feature is not supported by most loaders until version 4.0. At that time, this column should be required. |
| Name | Columns |
|---|---|
| DATASET_NAME_Version | Name,Version |