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)