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