NullCrowd
Tables (29)
APPROVAL_HISTORY
- payment_code — VARCHAR2(250) — Foreign key → Payment.payment_code — NOT NULL — 결제코드
- IS_Approved (is_Approved) — CHAR(1) — NOT NULL — 승인여부
- REFUND_DATE — DATE — 환불일자(환불시)
Alarm
- alarm_code — NUMBER — Primary key — NOT NULL — 알람고유번호(전체발송)
- mem_code — NUMBER — Foreign key → Member.mem_code — NOT NULL — 회원번호(관리자식별)
- content — VARCHAR2(500) — NOT NULL — 내용
- sent_time — DATETIME — NOT NULL — 보낸날짜
- is_Read — CHAR(1) — NOT NULL — 읽음유무
ApproveProject
- project_no (PROJECT_NO) — number — Foreign key → FundingProject.project_no — NOT NULL — 프로젝트번호
- processedDate (processed_Date) — DATE — 처리날짜
- isApproved (is_Approved) — char(1) — NOT NULL — 1:승인 2:반려 3:처리대기(default)
- deniedResaon (denied_Resaon) — varchar2(150) — 반려사유
Authority
- auth_name — VARCHAR2(255) — Primary key — NOT NULL — ROLE_ADMIN, / ROLE_MEMBER
- auth_code — NUMBER — NOT NULL — 1 / 2
COMPANY_FUND (INCOME_PROJECT)
- NO — NUMBER — Primary key — NOT NULL — 시퀀스
- project_no — number — Foreign key → FundingProject.project_no — 프로젝트번호
- INCOME — NUMBER — NOT NULL — 수수료(raisedFund%10) / 멤버십결제 AMOUNT
- INCOME_DATE — DATE — NOT NULL — 최종승인/종료날짜
- INCOME_TYPE — VARCHAR2(10) — NOT NULL — PROJECT / MEMBERSHIP
Com_Comment
- 댓글번호 (comment_no) — number — Primary key — NOT NULL — 댓글번호(시퀀스)
- article_no — number — Foreign key → Community.article_no — NOT NULL — 게시글번호(시퀀스)
- mem_code — number — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- content — varchar2(500) — NOT NULL — 내용
- upload_Date — DATE — NOT NULL — 작성일
Community (Comunity)
- article_no — number — Primary key — NOT NULL — 게시글번호
- mem_code — number — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- TITLE — VARCHAR2(100) — NOT NULL — 제목
- content — VARCHAR2(4000) — NOT NULL — 내용
- upload_date — DATE — 작성일
Coupon
- cou_type — VARCHAR2(250) — Primary key — NOT NULL — 쿠폰종류
- cou_name — VARCHAR2(1000) — NOT NULL — 쿠폰명
- cou_value — NUMBER — NOT NULL — 할인값
- cou_detail — VARCHAR2(5000) — 쿠폰설명
FundRaiser
- raiser_code — number — Foreign key → Member.mem_code — NOT NULL — =member_code
- rai_nickName (rai_nickname) — varchar2(60)
- rai_address — varchar2(250)
- rai_email — varchar2(250)
- rai_phone — varchar2(30)
FundingProject
- project_no (PROJECT_NO) — number — Primary key — NOT NULL — 프로젝트번호
- raiser_code — number — Foreign key → FundRaiser.raiser_code — NOT NULL — =member_code
- title (PJ_TITLE) — varchar2(100) — NOT NULL — =프로젝트이름
- description — varchar2(5000) — NOT NULL — 프로젝트 설명
- fundGoal — number — NOT NULL — 목표금액
- regiDate (REGI_Date) — Date — NOT NULL — 등록날짜
- startDate (start_Date) — Date — NOT NULL — 시작날짜
- endDate (end_Date) — Date — NOT NULL — 종료날짜
- isFundable (is_Fundable) — char(1) — NOT NULL — 후원가능여부
- funderNum — number — NOT NULL — 참여자수
- mainImg (MAINIMG) — varchar2(255) — NOT NULL — 메인이미지도메인
- tel (TEL) — varchar2(30) — NOT NULL — 문의가능번호
- pjEmail (PJ_EMAIL) — varchar2(250) — NOT NULL — 문의가능이메일
- refundRule (REFUND_ROLE) — varchar2(1000) — 환불정책
- videoURL (VIDEO_URL) — varchar2(255) — 메인 동영상 url
- thumnail (THUMNAIL) — varchar2(255) — NOT NULL — 썸네일 url
Likes
- project_no — number — Foreign key → FundingProject.project_no — NOT NULL — 프로젝트번호
- mem_code — number — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
Member
- mem_code — number — Primary key — NOT NULL — 회원번호(시퀀스)
- MEM_EMAIL — varchar2(60) — Foreign key → SIGNUP_TEMP_EMAIL.MEM_EMAIL — 실질적아이디
- auth_name — VARCHAR2(255) — Foreign key → Authority.auth_name — NOT NULL — ROLE_ADMIN, / ROLE_MEMBER
- mem_pwd — varchar2(255) — NOT NULL — 비밀번호
- is_active — char(1) — NOT NULL — (Y->활동중/N->탈퇴)
- regi_date — DATE — NOT NULL — 가입일
- nickName — varchar2(60) — NOT NULL — 닉네임
- recentLogin — DATETIME — NOT NULL — 최근접속기록
Member_Coupon
- mem_code — NUMBER — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- cou_type — VARCHAR2(250) — Foreign key → Coupon.cou_type — NOT NULL — 쿠폰종류
- is_Used (isUsed) — CHAR(1) — NOT NULL — 사용유무
- used_Date — DATE — NOT NULL — 사용날짜
- expire_date — DATE — NOT NULL — 만료기간
- is_Expired — CHAR(1) — NOT NULL — 만료여부
Membership
- Membership_code — Varchar(50) — Primary key — NOT NULL
- mem_code — number — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- 시작일 (start_Date) — DATE — NOT NULL — 시작일
- 만료일 (End_Date) — DATE — NOT NULL — 만료일
- 상태값 (is_Valid) — CAHR(1) — NOT NULL — 적용중여부(Y/N)
Mes_Attachment
- attach_no — NUMBER — Primary key — NOT NULL — 첨부파일번호
- message_code — NUMBER — Foreign key → Messages.message_code — NOT NULL — 시퀀스
- fileName — VARCHAR2(250) — NOT NULL — 파일이름
- url — VARCHAR2(250) — NOT NULL — 파일주소
- hashName (pathName) — VARCHAR2(250) — NOT NULL — 저장이름
MessageBox
- box_type — varchar(1) — Primary key — NOT NULL — 1:member 2:fundraiser 3: 관리자
- mem_code2 (mem_code) — number — Foreign key → Member.mem_code — NOT NULL — 회원번호
Messages
- message_code — NUMBER — Primary key — NOT NULL — 시퀀스
- box_type — VARCHAR2(250) — Foreign key → MessageBox.box_type — NOT NULL — 1:member 2:fundraiser 3: 관리자
- mem_code — NUMBER — Foreign key → MessageBox.mem_code2 — NOT NULL
- title — varchar2(100) — NOT NULL — 제목
- received_time — DATETIME — NOT NULL — 받은날짜
- sentBy — varchar2(30) — NOT NULL — 보낸사람
- content — varchar2(10000) — NOT NULL — 내용
- is_Read — char(1) — NOT NULL — 읽음유무
- is_Deleted — char(1) — NOT NULL — 삭제여부
Notice
- notice_no — number — Primary key — NOT NULL — 공지글번호
- member_code — number — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- notice_title — varchar2(100) — NOT NULL — 제목
- notice_content — varchar2(500) — NOT NULL — 공지내용
- upload_Date — DATETIME — NOT NULL — 공지작성일
- read_Count — number — NOT NULL — 조회수
- Notice_media — Notice_media
Notice_media
- media_no — number — Primary key — NOT NULL — 영상번호시퀀스
- notice_no — number — Foreign key → Notice.notice_no — NOT NULL — 공지글번호
- fileName — varchar2(60) — NOT NULL — 파일이름
- pathName — varchar2(100) — NOT NULL — 저장이름
- is_Deleted — char(1) — NOT NULL — 삭제
- url — varchar2(200) — NOT NULL — url주소
- mediaType — char(1) — NOT NULL — I(image) / V (vedio)
Payment
- payment_code — VARCHAR2(250) — Primary key — NOT NULL — 결제코드
- mem_code — NUMBER — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- AMOUNT — NUMBER — 결제(후원)비용
- is_Couponed — CHAR(1) — 쿠폰사용유무
- PAYED_Date (payed_Date) — DATETIME — NOT NULL — 결제일자
- payment_type — CHAR(1) — NOT NULL — 1:프젝 2:멤버쉽
PersonalInfo
- mem_code — NUMBER — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- NAME — VARCHAR2(15) — NOT NULL — 회원이름
- phone — VARCHAR2(20) — NOT NULL — 회원연락처
- birthdate — DATE — NOT NULL — 회원생일
- address — varchar2(150) — 회원주소
- gender — char(1) — NOT NULL — 회원성별
ProjectFund
- project_no — NUMBER — Foreign key → FundingProject.project_no — NOT NULL — 프로젝트번호
- payment_code — VARCHAR2(250) — Foreign key → Payment.payment_code — NOT NULL — 결제코드
- RAISED_Fund — NUMBER — NOT NULL — 현재모금금액
ProjectReward (PROJECT_REWARD)
- no (NO) — number(2) — Primary key — NOT NULL — 리워드번호
- project_no (PROJECT_NO) — number — Foreign key → FundingProject.project_no — NOT NULL — 프로젝트번호
- name (NAME) — varchar(100) — NOT NULL — 리워드이름
- price (PRICE) — number — NOT NULL — 리워드가격
- content (DETAILS) — varchar(255) — NOT NULL — 리워드내용
Project_Comment
- comment_no — number — Primary key — NOT NULL — 댓글번호
- project_no — number — Foreign key → FundingProject.project_no — NOT NULL — 프로젝트번호
- mem_code — number — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- content — varchar2(500) — NOT NULL — 내용
- upload_Date (uploadDate) — DATE — NOT NULL — 작성일
- is_Deleted — char(1) — 삭제여부
Project_media
- media_no — number — Primary key — NOT NULL — 시퀀스
- project_no — number — Foreign key → FundingProject.project_no — NOT NULL — 프로젝트번호
- fileName — varchar2(60) — 파일이름
- hashName — varchar2(70) — 저장이름
- mediaType — varchar2(50) — 이미지/비디오
- url — varchar2(200) — NOT NULL — 저장url경로
- is_Deleted — CHAR(1) — NOT NULL — 삭제여부
SIGNUP_TEMP_EMAIL
- MEM_EMAIL — varchar2(60) — Primary key — NOT NULL — 실질적아이디
- CHECK_EMAIL — varchar2(40) — NOT NULL — 무작위확인코드
inquiry
- inquiry_no — number — Primary key — NOT NULL — 문의번호
- mem_code — number — Foreign key → Member.mem_code — NOT NULL — 회원번호(시퀀스)
- mem_email — varchar2(60) — NOT NULL — 회원이메일
- inquiry_type — varchar2(30) — NOT NULL — 문의유형
- inquiry_content — varchar2(4000) — NOT NULL — 문의내용
- inquiry_date — date — NOT NULL — 문의날짜
inquiry_Attachment
- attach_no — number — Primary key — NOT NULL — 첨부파일번호
- inquiry_no — number — Foreign key → inquiry.inquiry_no — NOT NULL — 문의번호
- file_name — varchar2(4000) — NOT NULL — 파일이름
- url — varchar2(4000) — NOT NULL — 파일주소
- hash_name — varchar2(4000) — NOT NULL — 저장이름
inquiry_type
- type_no — number — Primary key — NOT NULL
- inquiry_no — number — Foreign key → inquiry.inquiry_no — NOT NULL
- type_name — varchar2(60) — NOT NULL