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)