SemiProject( 77ㅑ 조)

테이블 (7)

ACTIVITY

  • ACT_NO — NUMBER — 기본 키 — NOT NULL — 활동번호(PK)
  • ACT_NAME — NVARCHAR2(10) — NOT NULL — 활동이름

BOARD_IMG

  • IMG_NO — NUMBER — NOT NULL
  • IMG_PATH — VARCHAR2(200) — NOT NULL
  • IMG_ORIGINAL_NAME — NVARCHAR2(50) — NOT NULL
  • IMG_RENAME — NVARCHAR2(50) — NOT NULL
  • IMG_ORDER — NUMBER
  • BOARD_NO — NUMBER — NOT NULL
  • BOARD_NO (BOARD_NO2) — NUMBER — 외래 키 → QNABOARD.BOARD_NO — NOT NULL — 게시글번호(PK)

COMMENT

  • COMMENT_NO — NUMBER — 기본 키 — NOT NULL — 댓글
  • COMMENT_CONTENT — NVARCHAR2(500) — NOT NULL
  • COMMENT_WRITE_DATE — DATE — NOT NULL — 댓글
  • COMMENT_DEL_FL — CHAR(1) — NOT NULL — 댓글
  • MEMBER_NO — NUMBER — 외래 키 → MEMBER.MEMBER_NO — NOT NULL — 회원번호
  • BOARD_NO — NUMBER — 외래 키 → QNABOARD.BOARD_NO — NOT NULL — 게시글번호(PK)
  • ORIGINAL_COMMENT_NO — NUMBER — 외래 키 → COMMENT.COMMENT_NO — 부모댓글

MEMBER

  • MEMBER_NO — NUMBER — 기본 키 — NOT NULL — 회원번호
  • MEMBER_ID — VARCHAR2(30) — NOT NULL
  • MEMBER_NAME — NVARCHAR2(10) — NOT NULL — 회원이름
  • MEMBER_EMAIL — NVARCHAR2(50) — NOT NULL — 회원
  • MEMBER_PW — NVARCHAR2(150) — NOT NULL — 회원
  • MEMBER_TEL — CHAR(11) — NOT NULL — 회원
  • MEMBER_ADDRESS — NVARCHAR2(150) — 회원
  • ENROLL_DATE — DATE — NOT NULL — 가입날짜
  • MEMBER_DEL_FL — CHAR(1) — NOT NULL — 회원탈퇴여부
  • AUTHORITY — NUMBER — NOT NULL — 회원권한(1:일반회원

MONEY_DONATION

  • MONEY_DONATION_NO — NUMBER — 기본 키 — NOT NULL — 후원신청번호
  • MONEY_DONATION_TOTAL — NUMBER — 후원총금액
  • MEMBER_NO — NUMBER — 외래 키 → MEMBER.MEMBER_NO — NOT NULL — 회원번호
  • MEMBER_EMAIL — NVARCHAR2(50) — NOT NULL
  • MEMBER_TEL — CHAR(11) — NOT NULL

QNABOARD

  • BOARD_NO — NUMBER — 기본 키 — NOT NULL — 게시글번호(PK)
  • BOARD_TITLE — NVARCHAR2(100) — NOT NULL — 게시글
  • BOARD_CONTENT — NVARCHAR2(2000) — NOT NULL — 게시글
  • BOARD_WRITE_DATE — DATE — NOT NULL — 게시글
  • BOARD_UPDATE_DATE — DATE — 게시글
  • READ_COUNT — NUMBER — NOT NULL — 조회수
  • BOARD_DEL_FL — CHAR(1) — NOT NULL — 게시글
  • MEMBER_NO — NUMBER — 외래 키 → MEMBER.MEMBER_NO — NOT NULL — 회원번호

VOLUNTEERLIST

  • MEMBER_NO — NUMBER — 외래 키 → MEMBER.MEMBER_NO — NOT NULL — 회원번호
  • VOLUNTEER_NO — NUMBER — 외래 키 → ACTIVITY.ACT_NO — NOT NULL — 봉사번호(PK)
  • REGISTRY_DATE — DATE — NOT NULL — 봉사신청일
  • MEMBER_NAME — NVARCHAR2(10) — NOT NULL
  • MEMBER_TEL — CHAR(11) — NOT NULL
  • FIELD — NVARCHAR2(30)
  • ORDER_NO — NUMBER — NOT NULL