Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
metamod:user_database [2010-03-17 14:01:50] egils |
metamod:user_database [2022-05-31 09:29:32] (current) |
||
---|---|---|---|
Line 13: | Line 13: | ||
==== Database tables ==== | ==== Database tables ==== | ||
- | **User** | + | **UserTable** |
|__U_id__ |A_id |U_name |U_email |U_password |U_institution |U_telephone |U_session | | |__U_id__ |A_id |U_name |U_email |U_password |U_institution |U_telephone |U_session | | ||
Line 47: | Line 47: | ||
- | ==== User ==== | + | ==== UserTable |
^U_id |Unique user id (autoincremented number). Primary key | | ^U_id |Unique user id (autoincremented number). Primary key | | ||
Line 104: | Line 104: | ||
^DSKEY |Dataset key (also called directory key or dirkey) as provided by the user. Single entity | | ^DSKEY |Dataset key (also called directory key or dirkey) as provided by the user. Single entity | | ||
- | ^LOCATION |Location. Single entity. Absolute path to the directory under which all files belonging to the dataset are found. The files may be found directly in the location | + | ^LOCATION |Location. Single entity. Absolute path to the directory under which all files belonging to the dataset are found. The files may be found directly in the location |
^CATALOG |Partial URL to a THREDDS dataset. Single entity. Combined with the file name, this URL can be used to access the content of a file through a TDS server. It can also provide the URL that points to the THREDDS catalog containing the METAMOD dataset. | | ^CATALOG |Partial URL to a THREDDS dataset. Single entity. Combined with the file name, this URL can be used to access the content of a file through a TDS server. It can also provide the URL that points to the THREDDS catalog containing the METAMOD dataset. | | ||
^WMS_URL |URL to the WMS service that can display data from the dataset. Single entity. | | ^WMS_URL |URL to the WMS service that can display data from the dataset. Single entity. | | ||
Line 120: | Line 120: | ||
^DS_id |Dataset this file belongs to. Part of primary key. | | ^DS_id |Dataset this file belongs to. Part of primary key. | | ||
- | ^F_name |Name of file. Part of primary key. | | + | ^F_name |Local path to file. The full path is given by " |
^F_timestamp |Timestamp of last change | | ^F_timestamp |Timestamp of last change | | ||
^F_size |File size (bytes) | | ^F_size |File size (bytes) | | ||
Line 165: | Line 165: | ||
|user_set |Set user properties for the current user |IN: Property name (one of ' | |user_set |Set user properties for the current user |IN: Property name (one of ' | ||
|user_get |Get user properties for the current user. |IN: Property name (one of ' | |user_get |Get user properties for the current user. |IN: Property name (one of ' | ||
- | |user_first |Make the first user in the database the current user. |OUT: true if found, | + | |user_first |Make the first user in the database the current user. |OUT: TRUE if found, |
- | |user_next |Make the next user in the database the current one. |OUT: true if found, | + | |user_next |Make the next user in the database the current one. |OUT: TRUE if found, |
==== Dataset functions ==== | ==== Dataset functions ==== |