Oulim
Tables (18)
TBL_ADMIN_ACCOUNT
- AdminNo — NUMBER
- AdminId — VARCHAR2(20) — NOT NULL
- AdminPw — VARCHAR2(20) — NOT NULL
- AdminEmail — VARCHAR2(50) — NOT NULL
TBL_COMMUNITY_COMMENT
- ReplyNo — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- PostNo — NUMBER
- UserNickName — VARCHAR2(50)
- ReplyContent — VARCHAR2(100) — NOT NULL
- PostDate — DATE — NOT NULL
TBL_COMMUNITY_POST
- PostNo — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- PostTitle — VARCHAR2(100) — NOT NULL
- PostContent — VARCHAR2(4000) — NOT NULL
- PostDate — DATE — NOT NULL
- ViewCount — NUMBER — NOT NULL
TBL_CURRENCY
- PointId — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- TotalPoint — NUMBER — NOT NULL
TBL_KKOMI
- KkomiNo — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- Point — NUMBER
- KkomiLev — NUMBER — NOT NULL
- KkomiExp — NUMBER — NOT NULL
TBL_LOG_POINT
- LogNo — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo — NOT NULL
- PointId — NUMBER — Foreign key → TBL_CURRENCY.PointId
- ChangePoint — NUMBER
- Reason — VARCHAR2(50)
TBL_MISSION
- MissionNo — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- MissionName — VARCHAR2(30) — NOT NULL
- MissionDetail — VARCHAR2(50) — NOT NULL
- MissionCount — NUMBER — NOT NULL
- MissionReward — VARCHAR2(30) — NOT NULL
- MissionUseItem — NUMBER — NOT NULL
- MissionLastChange — DATE
TBL_NORMAL_USER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- UserNickname — VARCHAR2(20) — NOT NULL
- UserPhoneNum — VARCHAR2(20) — NOT NULL
- UserAddress — VARCHAR2(20)
- UserAddressDetail — VARCHAR2(20)
- UserPostNum — VARCHAR2(6)
- UserVolunRecommend — NUMBER
TBL_ORGAN
- OrganNo — NUMBER
- OrganName — VARCHAR2(50) — NOT NULL
- OrganCertNum — VARCHAR2(20) — NOT NULL
TBL_ORGAN_CERT
- CertifyNum — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo — NOT NULL
- OrganNo — NUMBER — Foreign key → TBL_ORGAN.OrganNo — NOT NULL
- CertifyFile — BLOB — NOT NULL
TBL_ORGAN_USER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- OrganNo — NUMBER — Foreign key → TBL_ORGAN.OrganNo — NOT NULL
TBL_POST_IMAGE
- ImageNo — NUMBER
- PostNo — NUMBER — Foreign key → TBL_COMMUNITY_POST.PostNo — NOT NULL
- PostImgFile — BLOB — NOT NULL
TBL_POST_LIKE
- PostLikeNo — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- PostNo — NUMBER — Foreign key → TBL_COMMUNITY_POST.PostNo
TBL_RANKING
- UserNo — NUMBER
- Ranking — NUMBER — NOT NULL
- UserNickName — VARCHAR2(20) — NOT NULL
- RankPoint — NUMBER — NOT NULL
- KkomiLevel — NUMBER — NOT NULL
TBL_REWARD_STORAGE
- ItemNo — NUMBER
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- ItemDetail — VARCHAR2(200) — NOT NULL
- ItemCount — NUMBER
- UseItem — NUMBER — NOT NULL
TBL_USER
- UserNo — NUMBER
- UserName — VARCHAR2(20) — NOT NULL
- UserID — VARCHAR2(20) — NOT NULL
- UserPw — VARCHAR2(20) — NOT NULL
- UserBirth — VARCHAR2(10) — NOT NULL
- UserEmail — VARCHAR2(50) — NOT NULL
- UserType — NUMBER(1) — NOT NULL
- UserStatus — NUMBER(1) — NOT NULL
TBL_VOLUN_ACTIVITY
- VolunActNo — NUMBER
- VolunActTitle — VARCHAR2(50) — NOT NULL
- VolunAct_Recru_Begin — DATE — NOT NULL
- VolunAct_Recru_End — DATE — NOT NULL
- VolunAct_Proc_Begin — DATE — NOT NULL
- VolunAct_Proc_End — DATE — NOT NULL
- Point — NUMBER — NOT NULL
- VolunAct_Begin_Time — NUMBER(2) — NOT NULL
- VolunAct_End_Time — NUMBER(2) — NOT NULL
- VolunAct_Act_Type — NUMBER(2) — NOT NULL
- VolunAct_Age_Group — NUMBER(1) — NOT NULL
- VolunAct_Organ_No — NUMBER — Foreign key → TBL_ORGAN.OrganNo — NOT NULL
- VolunAct_Address — VARCHAR2(20) — NOT NULL
- VolunAct_Address_Detail — VARCHAR2(20) — NOT NULL
- VolunAct_PostNum — VARCHAR2(6) — NOT NULL
- VolunAct_Recru_Max_Count — NUMBER(2) — NOT NULL
- VolunAct_Detail — VARCHAR2(4000)
TBL_VOLUN_APPLY
- VolunActNo — NUMBER — Foreign key → TBL_VOLUN_ACTIVITY.VolunActNo
- UserNo — NUMBER — Foreign key → TBL_USER.UserNo
- VolunAct_ApplyDate — DATE — NOT NULL
- VolunAct_ApplyStatus — NUMBER(1) — NOT NULL
- VolunAct_Attendance — NUMBER(1) — NOT NULL