Project

General

Profile

Bug #824 » moveFrameworkDD.html

Michael Lee, 11/11/2003 12:59 PM

 
1
<table border="1" cellspacing="0" cellpadding="0">
2
<tr><th>TableName</th><th>FieldName</th><th>Nulls</th><th>dataType</th><th>FieldSize</th><th>key</th><th>References</th><th>ClosedList</th><th>FieldNotes</th></tr>
3
<tr style="background-color:#FFFFCC"><td>datasetObs</td><td>datasetObs_ID</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
4
<tr><td>datasetObs</td><td>userDataset_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>userDataset.userDataset_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
5
<tr style="background-color:#FFFFCC"><td>datasetObs</td><td>obsAccessionCode</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>accessionCode for observation that is part of dataset: used instead of observation_ID to allow observations from any database</td></tr>
6
<tr><td>datasetObs</td><td>datasetObsStart</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
7
<tr style="background-color:#FFFFCC"><td>datasetObs</td><td>datasetObsStop</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
8
<tr><td>datasetObs</td><td>notes</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
9
<tr style="background-color:#FFFFCC"><td>embargo</td><td>embargo_ID</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
10
<tr><td>embargo</td><td>plot_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>plot.PLOT_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
11
<tr style="background-color:#FFFFCC"><td>embargo</td><td>embargoReason</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>yes</td><td>Author stipulation,Rare species,Landownership,Bad data,Other</td></tr>
12
<tr><td>embargo</td><td>embargoStart</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
13
<tr style="background-color:#FFFFCC"><td>embargo</td><td>embargoStop</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
14
<tr><td>embargo</td><td>defaultStatus</td><td>yes</td><td>Long Integer</td><td>4</td><td>n/a</td><td>n/a</td><td>yes</td><td>1-7, according to confidStatus values</td></tr>
15
<tr style="background-color:#FFFFCC"><td>user</td><td>user_ID</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
16
<tr><td>user</td><td>party_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>party.PARTY_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
17
<tr style="background-color:#FFFFCC"><td>user</td><td>password</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
18
<tr><td>user</td><td>permission_type</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>yes</td><td>1=registered, 2= certified, 3=professional</td></tr>
19
<tr style="background-color:#FFFFCC"><td>user</td><td>begin_time</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
20
<tr><td>user</td><td>last_connect</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
21
<tr style="background-color:#FFFFCC"><td>user</td><td>ticket_count</td><td>yes</td><td>Long Integer</td><td>4</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>number of connects.</td></tr>
22
<tr><td>user</td><td>institution</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
23
<tr style="background-color:#FFFFCC"><td>user</td><td>email_address</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
24
<tr><td>user</td><td>preferred_name</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>name the user wishes to be called in correspondence</td></tr>
25
<tr style="background-color:#FFFFCC"><td>user</td><td>remote_address</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>ip address</td></tr>
26
<tr><td>userCertification</td><td>userCertification_id</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
27
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>user_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>user.user_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
28
<tr><td>userCertification</td><td>current_cert_level</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>yes</td><td>2= certified, 3=professional</td></tr>
29
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>highest_degree</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
30
<tr><td>userCertification</td><td>degree_year</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
31
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>degree_institution</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
32
<tr><td>userCertification</td><td>current_institution</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
33
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>current_position</td><td>yes</td><td>Text</td><td>200</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
34
<tr><td>userCertification</td><td>esa_certified</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
35
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>prof_experience_doc</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
36
<tr><td>userCertification</td><td>relevant_pubs</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
37
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>veg_sampling_doc</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
38
<tr><td>userCertification</td><td>veg_analysis_doc</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
39
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>usnvc_experience_doc</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
40
<tr><td>userCertification</td><td>vegbank_experience_doc</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
41
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>plotdb_experience_doc</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
42
<tr><td>userCertification</td><td>nvc_exp_region_a</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
43
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>nvc_exp_vegetation_a</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
44
<tr><td>userCertification</td><td>nvc_exp_floristics_a</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
45
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>nvc_exp_usnvc_a</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
46
<tr><td>userCertification</td><td>esa_sponsor_name_a</td><td>yes</td><td>Text</td><td>120</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
47
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>esa_sponsor_email_a</td><td>yes</td><td>Text</td><td>120</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
48
<tr><td>userCertification</td><td>peer_review</td><td>yes</td><td>Text</td><td>10</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
49
<tr style="background-color:#FFFFCC"><td>userCertification</td><td>additional_statements</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
50
<tr><td>userDataset</td><td>userDataset_ID</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
51
<tr style="background-color:#FFFFCC"><td>userDataset</td><td>user_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>user.user_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
52
<tr><td>userDataset</td><td>datasetStart</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
53
<tr style="background-color:#FFFFCC"><td>userDataset</td><td>datasetStop</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
54
<tr><td>userDataset</td><td>AccessionCode</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>each dataset has an accession code to allow links to groups of plots (since URLs are limited in length)</td></tr>
55
<tr style="background-color:#FFFFCC"><td>userDataset</td><td>datasetName</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
56
<tr><td>userDataset</td><td>datasetDescription</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
57
<tr style="background-color:#FFFFCC"><td>userDataset</td><td>datasetType</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>open</td><td>don't know what values might be here, but category seems useful</td></tr>
58
<tr><td>userDataset</td><td>datasetSharing</td><td>yes</td><td>Text</td><td>30</td><td>n/a</td><td>n/a</td><td>yes</td><td>public, private, password</td></tr>
59
<tr style="background-color:#FFFFCC"><td>userDataset</td><td>datasetPassword</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
60
<tr><td>userNotify</td><td>userNotify_ID</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
61
<tr style="background-color:#FFFFCC"><td>userNotify</td><td>user_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>user.user_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
62
<tr><td>userNotify</td><td>notifyName</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
63
<tr style="background-color:#FFFFCC"><td>userNotify</td><td>notifyDescription</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
64
<tr><td>userNotify</td><td>notifyStart</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
65
<tr style="background-color:#FFFFCC"><td>userNotify</td><td>notifyStop</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
66
<tr><td>userNotify</td><td>lastCheckDate</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>date that user was last notified- only notify of information after this date</td></tr>
67
<tr style="background-color:#FFFFCC"><td>userNotify</td><td>notifySQL</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>SQL to get information that user wants</td></tr>
68
<tr><td>userPermission</td><td>userPermission_ID</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
69
<tr style="background-color:#FFFFCC"><td>userPermission</td><td>embargo_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>embargo.embargo_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
70
<tr><td>userPermission</td><td>user_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>user.user_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
71
<tr style="background-color:#FFFFCC"><td>userPermission</td><td>permissionStart</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
72
<tr><td>userPermission</td><td>permissionStop</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
73
<tr style="background-color:#FFFFCC"><td>userPermission</td><td>permissionStatus</td><td>yes</td><td>Long Integer</td><td>4</td><td>n/a</td><td>n/a</td><td>yes</td><td>0-6, according to confidStatus values</td></tr>
74
<tr><td>userPermission</td><td>permissionNotes</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
75
<tr style="background-color:#FFFFCC"><td>userQuery</td><td>userQuery_ID</td><td>no</td><td>Long Integer</td><td>4</td><td>PK</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
76
<tr><td>userQuery</td><td>user_ID</td><td>yes</td><td>Long Integer</td><td>4</td><td>FK</td><td>user.user_ID</td><td>&nbsp;</td><td>&nbsp;</td></tr>
77
<tr style="background-color:#FFFFCC"><td>userQuery</td><td>queryStart</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
78
<tr><td>userQuery</td><td>queryStop</td><td>yes</td><td>Date/Time</td><td>8</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
79
<tr style="background-color:#FFFFCC"><td>userQuery</td><td>accessionCode</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
80
<tr><td>userQuery</td><td>queryName</td><td>yes</td><td>Text</td><td>100</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
81
<tr style="background-color:#FFFFCC"><td>userQuery</td><td>queryDescription</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
82
<tr><td>userQuery</td><td>querySQL</td><td>yes</td><td>Memo</td><td>0</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
83
<tr style="background-color:#FFFFCC"><td>userQuery</td><td>queryType</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>yes</td><td>seems useful, but I don't know what values</td></tr>
84
<tr><td>userQuery</td><td>querySharing</td><td>yes</td><td>Text</td><td>30</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
85
<tr style="background-color:#FFFFCC"><td>userQuery</td><td>queryPassword</td><td>yes</td><td>Text</td><td>50</td><td>n/a</td><td>n/a</td><td>&nbsp;</td><td>&nbsp;</td></tr>
86
</table>
(2-2/2)