scy

Tables (22)

ALARM

  • ALARM_NO — NUMBER
  • ALARM_CONTENT — VARCHAR2(2000) — NOT NULL
  • ALARM_DATE — DATE
  • ALARM_STATUS — VARCHAR2(20)
  • MEMBER_NO — NUMBER — NOT NULL
  • DONATION_NO — NUMBER — NOT NULL
  • VOLUNTEER_NO — NUMBER — NOT NULL
  • REVIEW_NO — NUMBER — NOT NULL
  • USAGE_NO — NUMBER — NOT NULL
  • RATE_NO — NUMBER — NOT NULL
  • EVENT_NO — NUMBER — NOT NULL
  • CS_NO — NUMBER — NOT NULL
  • PAYMENT_NO — NUMBER — NOT NULL
  • NOTICE_NO — NUMBER — NOT NULL
  • ASK_NO — NUMBER — NOT NULL

ASK

  • ASK_NO — NUMBER
  • ASK_TITLE — VARCHAR2(100) — NOT NULL
  • ASK_CONTENT — VARCHAR2(1000) — NOT NULL
  • AENROLL_DATE — DATE
  • AMODI_DATE — DATE
  • ASK_STATUS — VARCHAR2(20)
  • ASK_FILE — VARCHAR2(200)
  • MEMBER_NO — NUMBER — NOT NULL

CATEGORY

  • CATEGORY_NO — NUMBER
  • CATEGORY_NAME — VARCHAR2(50) — NOT NULL
  • PARENT_CATEGORY_NO — NUMBER — NOT NULL

CUSTOMER_SERVICE

  • CS_NO — NUMBER
  • CHAT_CONTENT — VARCHAR2(2000) — NOT NULL
  • CUSTOMER_SERVICE_ENROLL_DT — DATE
  • CHAT_END_DT — DATE
  • CHAT_ROMM_STATUS — CHAR(1)
  • MGR_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL

DONATION

  • DONATION_NO — NUMBER
  • DAGENCY_NAME — VARCHAR2(50) — NOT NULL
  • DAGENCY_TEL — NUMBER — NOT NULL
  • DAHEAD_NAME — VARCHAR2(50) — NOT NULL
  • DONATION_PERIOD — DATE
  • DONATION_PLACE — VARCHAR2(100) — NOT NULL
  • DENROLL_DATE — DATE
  • DONATION_DELETE_STATUS — CHAR(1)
  • DCOM_STATUS — CHAR(1)
  • DONATION — _AMOUNT" — NOT NULL
  • DMODI_DATE — DATE
  • DONATION_NUM — NUMBER — NOT NULL
  • DONATION_VIEW — NUMBER
  • DONATION_TITLE — VARCHAR2(200) — NOT NULL
  • DONATION_CONTENT — VARCHAR2(2000) — NOT NULL
  • DONATION_ATTACHMENT — VARCHAR2(200)
  • MEMBER_NO — NUMBER — NOT NULL
  • CATEGORY_NO — NUMBER — NOT NULL
  • HASHTAG_NO — NUMBER — NOT NULL

EMAIL_CERTIFICATION

  • MEMBER_NO — NUMBER — NOT NULL
  • CERTIFICATION_NO — VARCHAR2(10) — NOT NULL
  • EMAIL_ISSUE_DT — DATE

EVENT

  • EVENT_NO — NUMBER
  • EVENT_TITLE — VARCHAR2(200) — NOT NULL
  • EVENT_CONTENT — VARCHAR2(2000) — NOT NULL
  • ENROLL_DT — DATE
  • MODI_DT — DATE
  • EVENT_VIEWS — NUMBER
  • DELETE_STATUS — CHAR(1)
  • EVENT_IMG — VARCHAR2(200)
  • MGR_NO — NUMBER — NOT NULL

EVENT_REGISTER

  • EVENT_REGITER_NO — NUMBER
  • MEMBER_NO — NUMBER — NOT NULL
  • EVENT_NO — NUMBER — NOT NULL

FAVORITES

  • FAV_NO — NUMBER
  • FAV_STATUS — CHAR(1)
  • MEMBER_NO — NUMBER — NOT NULL
  • DONATION_NO — NUMBER — NOT NULL
  • VOLUNTEER_NO — NUMBER — NOT NULL

HASHTAG

  • HASHTAG_NO — NUMBER
  • TAG_NAME — VARCHAR2(10)

MANAGER

  • MGR_NO — NUMBER
  • MGR_NAME — VARCHAR2(50) — NOT NULL
  • MGR_EMAIL — VARCHAR2(50) — NOT NULL
  • MGR_ID — VARCHAR2(50) — NOT NULL
  • MGR_PW — VARCHAR2(200) — NOT NULL
  • MGR_NICKNAME — VARCHAR2(100) — NOT NULL
  • MGR_TEL — CHAR(11) — NOT NULL
  • MGR_PROFILE_IMG — VARCHAR2(200)
  • MGR_PERMISSION — CHAR(1) — NOT NULL

MAP

  • MAP_NO — NUMBER
  • CATEGORY_NO — NUMBER — NOT NULL
  • VOLUNTEER_NO — NUMBER — NOT NULL

MEMBER

  • MEMBER_NO — NUMBER
  • MEMBER_ID — VARCHAR2(50) — NOT NULL
  • MMEBER_PW — VARCHAR2(200) — NOT NULL
  • MEMBER_NAME — VARCHAR2(50) — NOT NULL
  • MEMBER_NICK — VARCHAR2(50) — NOT NULL
  • MEMBER_TEL — NUMBER — NOT NULL
  • MEMBER_ADDR — VARCHAR2(200) — NOT NULL
  • SIGNUP_TYPE — CHAR(1) — NOT NULL
  • MEMBER_ENROLL_DT — DATE
  • MEMBER_SECESSION_FL — CHAR(1)
  • PROFILE_IMG — VARCHAR2(200)
  • DA_TYPE — CHAR(1) — NOT NULL
  • SAVED_MONEY — NUMBER

MYACTIVE

  • MYACT_NO — NUMBER
  • VOLCOM_STATUS — CHAR
  • DONATION_NO — NUMBER — NOT NULL
  • VOLUNTEER_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • EVENT_NO — NUMBER — NOT NULL

NOTICE

  • NOTICE_NO — NUMBER
  • NOTICE_TITLE — VARCHAR2(200) — NOT NULL
  • NOTICE_CONTENT — VARCHAR2(2000) — NOT NULL
  • NOTICE_ENROLL_DT — DATE
  • NMODI_DATE — DATE
  • NOTICE_VIEWS — NUMBER
  • NDELETE_STATUS — CHAR(1)
  • MGR_NO — NUMBER — NOT NULL

PARENT_CATEGORY

  • PARENT_CATEGORY_NO — NUMBER
  • PARENT_CATEGORY_NAME — VARCHAR2(10)
  • SUB_CATEGORY_NO — NUMBER — NOT NULL

PAYMENT

  • PAYMENT_NO — NUMBER
  • PAYMENT_TYPE — VARCHAR2(20) — NOT NULL
  • PAYMENT_DATE — DATE
  • PAYMENT_PRICE — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • DONATION_NO — NUMBER — NOT NULL

RATE

  • RATE_NO — NUMBER
  • RATE_NAME — VARCHAR2(20) — NOT NULL
  • RENEWAL_DATE — DATE
  • DONATION_RATE — VARCHAR2(20) — NOT NULL
  • VOLUNTEER_RATE — VARCHAR2(20) — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL

RESERVES

  • USAGE_NO — NUMBER
  • USAGE_PRICE — VARCHAR2(1000)
  • USAGE_DATE — DATE
  • MEMBER_NO — NUMBER — NOT NULL
  • DONATION_NO — NUMBER — NOT NULL

REVIEW

  • REVIEW_NO — NUMBER
  • REVIEW_CONTENT — VARCHAR2(1000) — NOT NULL
  • REVIEW_DATE — DATE
  • REV_UPDATE_DATE — DATE
  • REVIEW_STATUS — CHAR
  • REVIEW_TITLE — VARCHAR2(50) — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • DONATION_NO — NUMBER — NOT NULL
  • VOLUNTEER_NO — NUMBER — NOT NULL

SUB_CATEGORY

  • SUB_CATEGORY_NO — NUMBER
  • SUB_CATEGORY_NAME — VARCHAR2(50) — NOT NULL

VOLUNTEER

  • VOLUNTEER_NO — NUMBER
  • VAGENCY_NAME — VARCHAR2(100) — NOT NULL
  • VAGENCY_TEL — CHAR(11) — NOT NULL
  • VHEAD_NAME — VARCHAR2(100) — NOT NULL
  • VOLUNTEER_PERIOD — DATE — NOT NULL
  • VOLUNTEER_PLACE — VARCHAR2(100) — NOT NULL
  • VENROLL_DATE — DATE
  • VDELETE_STATUS — CHAR(1)
  • VCOM_STATUS — CHAR(1)
  • VMODI_DATE — DATE
  • VOLUNTEER_NUM — NUMBER — NOT NULL
  • VREAD_COUNT — NUMBER
  • VOLUNTEER_TITLE — VARCHAR2(100) — NOT NULL
  • VOLUNTEER_CONTENT — VARCHAR2(2000) — NOT NULL
  • VOLUNTEER_ATTACHEMENT — VARCHAR2(500)
  • MEMBER_NO — NUMBER — NOT NULL
  • CATEGORY_NO — NUMBER — NOT NULL
  • HASHTAG_NO — NUMBER — NOT NULL