| Table / |
Column Type |
Column Size |
Null |
References |
Comments |
| Column |
|
|
|
|
|
|
| INSTITUTE |
|
|
|
|
|
| Institute_No |
Char |
5 |
No |
|
Artificial PK |
| Name |
Varchar2 |
25 |
No |
|
|
| |
|
|
|
|
|
| POSITION |
|
|
|
|
|
| Position_No |
Char |
2 |
No |
|
Artificial PK |
| Title |
Varchar2 |
25 |
No |
|
|
| |
|
|
|
|
|
| USERS |
|
|
|
|
|
| User_ID |
Char |
8 |
No |
|
Artificial PK |
| First_Name |
Varchar2 |
15 |
Yes |
|
|
| Last_Name |
Varchar2 |
15 |
No |
|
|
| Email |
Varchar2 |
20 |
No |
|
|
| Street |
Varchar2 |
25 |
Yes |
|
|
| Zip |
Varchar2 |
10 |
Yes |
|
|
| Country |
Varchar2 |
25 |
Yes |
|
|
| Institute_No |
Char |
5 |
Yes |
Institute.Institute_No |
FK |
| Position_No |
Char |
2 |
Yes |
Position.position_No |
FK |
| |
|
|
|
|
|
| MEMBER |
|
|
|
|
|
| Member_ID |
Char |
4 |
No |
|
Artificial PK |
| First_Name |
Varchar2 |
15 |
Yes |
|
|
| Last_Name |
Varchar2 |
15 |
No |
|
|
| Email |
Varchar2 |
20 |
No |
|
|
| Homepage |
Varchar2 |
30 |
Yes |
|
|
| Self_Intro |
Varchar2 |
100 |
Yes |
|
|
| Password |
Char |
6 |
No |
|
|
| Street |
Varchar2 |
25 |
Yes |
|
|
| Zip |
Varchar2 |
10 |
Yes |
|
|
| Country |
Varchar2 |
25 |
Yes |
|
|
| Institute_No |
Char |
5 |
No |
Institute.Institute_No |
FK |
| Position_No |
Char |
2 |
No |
Position.position_No |
FK |
| Sci_Y_N |
Char |
1 |
No |
|
Subtype Discriminator |
| Mod_Y_N |
Char |
1 |
No |
|
Subtype Discriminator |
| |
|
|
|
|
|
| SCIENTIST |
|
|
|
|
|
| Member_ID |
Char |
4 |
No |
Member.Member_ID |
PK & FK |
| |
|
|
|
|
|
| HOLD |
|
|
|
|
|
| Hold_No |
Char |
6 |
No |
|
Artificial PK |
| Date_Start |
Date |
|
No |
|
|
| Date_End |
Date |
|
No |
|
|
| Sci_ID |
char |
4 |
No |
Scientist.Member_ID |
FK |
| |
|
|
|
|
|
| MODERATOR |
|
|
|
|
|
| Mod_ID |
Char |
4 |
No |
Member.Member_ID |
PK & FK |
| |
|
|
|
|
|
| MESSAGE |
|
|
|
|
|
| Message_No |
Char |
4 |
No |
|
Artificial PK |
| Date_Post |
Date |
|
No |
|
|
| Subject |
Varchar2 |
30 |
No |
|
|
| Content |
Varchar2 |
200 |
No |
|
|
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
FK |
| |
|
|
|
|
|
| REPLY |
|
|
|
|
|
| Reply_No |
Char |
4 |
No |
|
Artificial PK |
| Date_Post |
Date |
|
No |
|
|
| Content |
Varchar2 |
200 |
No |
|
|
| Message_No |
Char |
4 |
No |
Message.Message_No |
FK |
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
FK |
| |
|
|
|
|
|
| AREA |
|
|
|
|
|
| Area_No |
Char |
2 |
No |
|
Artificial PK |
| Name |
Varchar2 |
20 |
No |
|
|
| description |
Varchar2 |
40 |
No |
|
|
| |
|
|
|
|
|
| INTERESTS |
|
|
|
|
|
| Area_No |
Char |
2 |
No |
Area.Area_No |
PK & FK |
| Member_ID |
Char |
4 |
No |
Member.Member_ID |
PK & FK |
| |
|
|
|
|
|
| KEYWORD |
|
|
|
|
|
| Keyword_No |
Char |
4 |
No |
|
Artificial_PK |
| Word |
Varchar2 |
20 |
No |
|
|
| |
|
|
|
|
|
| LINK |
|
|
|
|
|
| Link_No |
Char |
3 |
No |
|
Artificial_PK |
| URL |
Varchar2 |
30 |
No |
|
|
| Description |
Varchar2 |
30 |
No |
|
|
| Area_No |
Char |
2 |
No |
Area.Area_No |
FK |
| |
|
|
|
|
|
| LINKWORD |
|
|
|
|
|
| Link_No |
Char |
3 |
No |
Link.Link_No |
PK & FK |
| Keyword_No |
Char |
4 |
No |
Keyword.Keyword_No |
PK & FK |
| |
|
|
|
|
|
| GLEVEL |
|
|
|
|
|
| GLevel_No |
Char |
2 |
No |
|
Artificial_PK |
| Name |
Varchar2 |
20 |
No |
|
|
| |
|
|
|
|
|
| EXPERIMENT |
|
|
|
|
|
| Exp_No |
Char |
4 |
No |
|
Artificial PK |
| Overview |
Varchar2 |
100 |
No |
|
|
| Equipment |
Varchar2 |
100 |
No |
|
|
| Precaution |
Varchar2 |
100 |
No |
|
|
| Description |
Varchar2 |
300 |
No |
|
|
| Edibility |
Char |
1 |
No |
|
|
| Adult_presence |
Char |
1 |
No |
|
|
| Explanation |
Varchar2 |
100 |
No |
|
|
| Reference |
Varchar2 |
100 |
No |
|
|
| Comments |
Varchar2 |
100 |
No |
|
|
| Date_submit |
Date |
|
No |
|
|
| Date_Approve |
Date |
|
No |
|
|
| User_ID |
Char |
8 |
No |
Users.Use_ID |
FK |
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
FK |
| Area_No |
Char |
2 |
No |
Area.Area_No |
FK |
| GLevel_No |
Char |
2 |
No |
Glevel.GLevel_No |
FK |
| |
|
|
|
|
|
| EXPWORD |
|
|
|
|
|
| Exp_No |
Char |
4 |
No |
Experiment.Exp_No |
PK & FK |
| Keyword_No |
Char |
4 |
No |
Keyword.Keyword_No |
PK & Fk |
| |
|
|
|
|
|
| DIRECTORY |
|
|
|
|
|
| Dir_No |
Char |
2 |
No |
|
Artificial PK |
| Dir_Name |
Varchar2 |
20 |
No |
|
|
| |
|
|
|
|
|
| STATUS |
|
|
|
|
|
| Status_No |
Char |
2 |
No |
|
Artificial PK |
| Description |
Varchar2 |
20 |
No |
|
|
| |
|
|
|
|
|
| QUESTION |
|
|
|
|
|
| Question_No |
Char |
8 |
No |
|
Artificial PK |
| Subject |
Varchar2 |
35 |
No |
|
|
| Content |
Varchar2 |
100 |
No |
|
|
| Date_Ask |
Date |
|
No |
|
|
| User_ID |
Char |
8 |
No |
Users.Use_ID |
FK |
| GLevel_No |
Char |
2 |
No |
Glevel.GLevel_No |
FK |
| Area_No |
Char |
2 |
No |
Area.Area_No |
FK |
| Dir_No |
Char |
2 |
No |
Directory.Dir_No |
FK |
| Status_No |
Char |
2 |
No |
Status.Status_No |
FK |
| |
|
|
|
|
|
| QUESWORD |
|
|
|
|
|
| Question_No |
Char |
8 |
No |
Question.Question_No |
PK & FK |
| Keyword_No |
Char |
4 |
No |
Keyword.Keyword_No |
PK & FK |
| |
|
|
|
|
|
| QUESEDIT |
|
|
|
|
|
| Question_No |
Char |
8 |
No |
Question.Question_No |
PK & FK |
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
PK & FK |
| Date_Edit |
Date |
|
No |
|
|
| Change |
Varchar2 |
50 |
No |
|
|
| |
|
|
|
|
|
| PASS |
|
|
|
|
|
| Pass_No |
Char |
5 |
No |
|
Artificial PK |
| Date_Pass |
Date |
|
No |
|
|
| Question_No |
Char |
8 |
No |
Question.Question_No |
FK |
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
FK |
| Sci_ID |
Char |
4 |
No |
Scientist.Member_ID |
FK |
| |
|
|
|
|
|
| DELINQUENCY |
|
|
|
|
|
| Pass_No |
Char |
5 |
No |
Pass.Pass_No |
PK & FK |
| Date_Deliq |
date |
|
No |
|
|
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
FK |
| NextPass_No |
Char |
5 |
No |
Pass.Pass_No |
FK |
| |
|
|
|
|
|
| DEFER |
|
|
|
|
|
| Pass_No |
Char |
5 |
No |
Pass.Pass_No |
PK & FK |
| Date_Defer |
Date |
|
No |
|
|
| Comments |
Varchar2 |
50 |
No |
|
|
| NextPass_No |
Char |
5 |
No |
Pass.Pass_No |
FK |
| |
|
|
|
|
|
| ANSWER |
|
|
|
|
|
| Pass_No |
Char |
5 |
No |
Pass.Pass_No |
PK & FK |
| Date_Answer |
Date |
|
No |
|
|
| Content |
Varchar2 |
1000 |
No |
|
|
| |
|
|
|
|
|
| ANSEDIT |
|
|
|
|
|
| Ans_Pass_No |
Char |
5 |
No |
Answer.Pass_No |
PK & FK |
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
PK & FK |
| Date_Edit |
Date |
|
No |
|
|
| Change |
Varchar2 |
50 |
No |
|
|
| |
|
|
|
|
|
| REJECT |
|
|
|
|
|
| Pass_No |
Char |
5 |
No |
Answer.Pass_No |
PK & FK |
| Date_Reject |
Date |
|
No |
|
|
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
FK |
| NextPass_No |
Char |
5 |
No |
Pass.Pass_No |
FK |
| |
|
|
|
|
|
| RANK |
|
|
|
|
|
| Rank_No |
Char |
1 |
No |
|
PK |
| Description |
Varchar2 |
30 |
No |
|
|
| |
|
|
|
|
|
| ACCEPT |
|
|
|
|
|
| Pass_No |
Char |
5 |
No |
Answer.Pass_No |
PK & FK |
| Date_Accept |
Date |
|
No |
|
|
| Mod_ID |
Char |
4 |
No |
Moderator.Member_ID |
FK |
| Rank_No |
Char |
1 |
Yes |
Rank.Rank_No |
FK |
|
|
|
|
|
|