Funding

Tables (6)

fund_comment (펀딩댓글)

  • comment_id (펀딩댓글 key) — Primary key — NOT NULL
  • post_id (Key2) — int — Foreign key → fund_post.post_id — NOT NULL
  • comment_memo (코멘트내용)

fund_entry (펀딩참가자)

  • entry_id (펀딩참가자 key) — int — Primary key — NOT NULL
  • post_id (Key2) — int — Foreign key → fund_post.post_id — NOT NULL
  • u_id (Key3) — Foreign key → ns_member.u_id — NOT NULL
  • reward_id (리워드키) — Foreign key → fund_reward.reward_id — NOT NULL
  • entry_id (참가자아이디)
  • entry_name (참가자이름)
  • entry_regdate (참가등록시간)
  • Field4
  • Field5

fund_payment (펀딩결제)

  • payment_id (펀딩 결제 key) — Primary key — NOT NULL
  • entry_id (Key2) — int — Foreign key → fund_entry.entry_id — NOT NULL
  • post_id (Key22) — int — Foreign key → fund_entry.post_id — NOT NULL
  • u_id (Key3) — Foreign key → fund_entry.u_id — NOT NULL
  • reward_id (리워드키) — Foreign key → fund_entry.reward_id — NOT NULL
  • payment_type (결재타입(카드:C,무통장:B))
  • payment_number (카드번호 or 계좌번호)
  • payment_name (카드종류 or 은행명)
  • payment_status (결재정상처리여부)
  • payment_regdate (결제등록시간)

fund_post (펀딩포스트)

  • post_id (펀딩포스트 key) — int — Primary key — NOT NULL
  • post_category (펀드카테고리) — int
  • post_title (펀딩제목) — varchar(255)
  • post_about (펀드에 대해서) — varchar(255)
  • post_story (펀딩스토리) — varchar(255)
  • post_plan (펀딩계획) — varchar(255)
  • post_detail (펀딩세부사항)
  • post_movieurl (동영상주소)
  • post_periodstart (펀딩기간(시작))
  • post_periodend (펀딩기간(종료))
  • post_goalmoney (펀딩목표금액)
  • post_success (펀딩성공여부)

fund_reward (펀딩 리워드)

  • reward_id (리워드키) — Primary key — NOT NULL
  • post_id (Key) — int — Foreign key → fund_post.post_id — NOT NULL
  • reward_money (리워드금액)
  • reward_detail (리워드내용)

ns_member (회원정보)

  • u_id (Key) — Primary key — NOT NULL
  • id (Field)