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