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