VoluntaryService
테이블 (18)
Copy Of Untitled2 (Volunteer_Stts_Ctg)
- Key (STTS_NO) — NUMBER(1) — 기본 키 — NOT NULL
- Field (STTS_NAME) — VARCHAR2(30 BYTE)
Copy Of 봉사 프로그램 (Educational_Program)
- PROGRAM_NO — NUMBER(10,0) — 기본 키 — NOT NULL
- PROGRAM_TITLE — VARCHAR2(120 BYTE)
- PROGRAM_CONTENT — CLOB
- Key (RECRUIT_REGION) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- RECRUIT_CNT — NUMBER(4)
- APPLY_CNT — NUMBER(4)
- RECRUIT_BGN_DATE — DATE
- RECRUIT_END_DATE — DATE
- ACT_BGN_DATE — DATE
- ACT_END_DATE — DATE
- ACT_BGN_TIME — NUMBER(2)
- ACT_END_TIME — NUMBER(2)
- MNG_NAME — VARCHAR2(30 BYTE)
- MNG_TEL — VARCHAR2(60 BYTE)
- ACT_PLACE — VARCHAR2(300 BYTE)
- BATTACH_ONAME — VARCHAR2(150 BYTE)
- BATTACH_DATA — BLOB
- BATTCH_TYPE — VARCHAR2(30 BYTE)
- IMG_ONAME — VARCHAR2(150 BYTE)
- IMG_DATA — BLOB
- IMG_TYPE — VARCHAR2(30 BYTE)
- ENABLED — NUMBER(1)
- RECRUIT_STTS — NUMBER(1)
- LOCATION — VARCHAR2(100 BYTE)
Untitled (LikeUnlike)
- Key (BOARD_NO) — NUMBER(10,0) — 외래 키 → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- Field (LIKE_STTS) — NUMBER(1,0)
Untitled (Review_Reply)
- Key (REPLY_NO) — NUMBER(10,0) — 기본 키 — NOT NULL
- Key (BOARD_NO) — NUMBER(10,0) — 외래 키 → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- Field (CONTENT) — CLOB
- Field2 (REPLY_DATE) — DATE
- Key (PRE_REPLY_NO) — NUMBER(10,0) — 외래 키 → Untitled.Key — NOT NULL
Untitled (County)
- Key (COUNTY_NO) — VARCHAR2(30 BYTE) — 기본 키 — NOT NULL
- Key (CITY_NO) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- Field (COUNTY_NAME) — VARCHAR2(30 BYTE)
Untitled (City)
- Key (CITY_NO) — VARCHAR2(30 BYTE) — 기본 키 — NOT NULL
- Field (CITY_NAME) — VARCHAR2(30 BYTE)
Untitled (Member)
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 기본 키 — NOT NULL
- Field (MEMBER_NAME) — VARCHAR2(30 BYTE)
- Field (BIRTH_DATE) — DATE
- Field (MEMBER_PW) — VARCHAR2(100 BYTE)
- Field (POST_NO) — VARCHAR2(10 BYTE)
- Field (ADDRESS) — VARCHAR2(150 BYTE)
- Field (ADDRESS_DETAIL) — VARCHAR2(150 BYTE)
- Field (TEL) — VARCHAR2(60 BYTE)
- Field (EMAIL) — VARCHAR2(50 BYTE)
- Key (AFF_CENTER) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- LOW_CTG_NO (HOPE_CTG) — VARCHAR2(30 BYTE) — 외래 키 → 하위 카테고리.LOW_CTG_NO — NOT NULL
- Field (MENABLED) — NUMBER(1,0)
- Field (MROLE) — VARCHAR2(10 BYTE)
- Field (REG_DATE) — DATE
Untitled (Volunteer_Application_Detail)
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- PROGRAM_NO — NUMBER(10,0) — 외래 키 → 봉사 프로그램.PROGRAM_NO — NOT NULL
- Key (STTS_NO) — NUMBER(1,0) — 외래 키 → Copy Of Untitled2.Key — NOT NULL
- Field (REV_WRITTEN) — NUMBER(1,0)
- Field (BATTACH_ONAME) — VARCHAR2(150 BYTE)
- Field (BATTACH_DATA) — BLOB
- Field (BATTACH_TYPE) — VARCHAR2(30 BYTE)
- Field (REJECT_REASON) — VARCHAR2(50 BYTE)
- Field (REQUEST_DATE) — DATE
- Field (REQUEST_CONTENT) — CLOB
Untitled (Interest_Program)
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- PROGRAM_NO — NUMBER(10,0) — 외래 키 → 봉사 프로그램.PROGRAM_NO — NOT NULL
Untitled (Vol_Review)
- Key (BOARD_NO) — NUMBER(10,0) — 기본 키 — NOT NULL
- PROGRAM_NO — NUMBER(10,0) — 외래 키 → 봉사 프로그램.PROGRAM_NO — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- Field (TITLE) — VARCHAR2(30 BYTE)
- Field (CONTENT) — CLOB
- Field (HIT_CNT) — NUMBER(6,0)
- Field (BOARD_DATE) — DATE
- Field (BATTACH_ONAME) — VARCHAR2(150 BYTE)
- Field (BATTACH_DATA) — BLOB
- Field (BATTACH_TYPE) — VARCHAR2(30 BYTE)
- Field (IMG_ONAME) — VARCHAR2(150 BYTE)
- Field (IMG_DATA) — BLOB
- Field (IMG_TYPE) — VARCHAR2(30 BYTE)
Untitled (Apply_Schedule)
- Key (SCHDULE_NO) — NUMBER(6,0) — 기본 키 — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- PROGRAM_NO — NUMBER(10,0) — 외래 키 → Untitled.PROGRAM_NO — NOT NULL
- Field (APPLY_DATE) — DATE
Untitled (Intergrated_Board)
- Key (BOARD_NO) — NUMBER — 기본 키 — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- Field (TITLE) — VARCHAR2(120 BYTE)
- Field (CONTENT) — CLOB
- Field (BOARD_DATE) — DATE
- Field (HIT_CNT) — NUMBER(6,0)
- Field (ADMIN_REPLY) — CLOB
- Field (BATTACH_ONAME) — VARCHAR2(150 BYTE)
- Field (BATTACH_DATA) — BLOB
- Field (BATTACH_TYPE) — VARCHAR2(30 BYTE)
- Field (IMG_ONAME) — VARCHAR2(150 BYTE)
- Field (IMG_DATA) — BLOB
- Field (IMG_TYPE) — VARCHAR2(30 BYTE)
- Key (BOARD_CTG) — NUMBER(1,0) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Board_Category)
- Key (CTG_NO) — NUMBER(1,0) — 기본 키 — NOT NULL
- Field (CTG_NAME) — VARCHAR2(30 BYTE)
Untitled2 (Education_Application_Detail)
- Key (MEMBER_ID) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- PROGRAM_NO — NUMBER(10,0) — 외래 키 → Copy Of 봉사 프로그램.PROGRAM_NO — NOT NULL
- Key (STTS_NO) — NUMBER(1,0) — 외래 키 → Untitled2.Key — NOT NULL
Untitled2 (Education_Stts_Ctg)
- Key (STTS_NO) — NUMBER(1,0) — 기본 키 — NOT NULL
- Field (STTS_NAME) — VARCHAR2(30 BYTE)
봉사 프로그램 (Volunteer_Program)
- PROGRAM_NO — NUMBER(10,0) — 기본 키 — NOT NULL
- PROGRAM_TITLE — VARCHAR2(120 BYTE)
- RECRUIT_STTS — NUMBER(1)
- ACT_BGN_DATE — DATE
- ACT_END_DATE — DATE
- ACT_BGN_TIME — NUMBER(2)
- ACT_END_TIME — NUMBER(2)
- RECRUIT_BGN_DATE — DATE
- RECRUIT_END_DATE — DATE
- RECRUIT_CNT — NUMBER(4)
- APPLY_CNT — NUMBER(4)
- LOW_CTG_NO (PROGRAM_CTG) — VARCHAR2(30 BYTE) — 외래 키 → 하위 카테고리.LOW_CTG_NO — NOT NULL
- ADULT_POSBL — NUMBER(1)
- TEEN_POSBL — NUMBER(1)
- RECRUIT_NAME — VARCHAR2(60 BYTE)
- ACT_PLACE — VARCHAR2(300 BYTE)
- MNG_NAME — VARCHAR2(30 BYTE)
- MNG_TEL — VARCHAR2(60 BYTE)
- Key (REGION_NO) — VARCHAR2(30 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- BATTACH_ONAME — VARCHAR2(150 BYTE)
- BATTACH_DATA — BLOB
- BATTCH_TYPE — VARCHAR2(30 BYTE)
- IMG_ONAME — VARCHAR2(150 BYTE)
- IMG_DATA — BLOB
- IMG_TYPE — VARCHAR2(30 BYTE)
- LOCATION — VARCHAR2(100 BYTE)
- ENABLED — NUMBER(1)
- PROGRAM_CONTENT (CONTENT) — CLOB
상위 카테고리 (High_Class_Category)
- HIGH_CTG_NO — VARCHAR2(30 BYTE) — 기본 키 — NOT NULL
- HIGH_CTG_NAME — VARCHAR2(30 BYTE)
하위 카테고리 (Low_Class_Category)
- LOW_CTG_NO — VARCHAR2(30 BYTE) — 기본 키 — NOT NULL
- HIGH_CTG_NO — VARCHAR2(30 BYTE) — 외래 키 → 상위 카테고리.HIGH_CTG_NO — NOT NULL
- LOW_CTG_NAME — VARCHAR2(50 BYTE)