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