FUND

Tables (5)

FARM (farm)

  • FMNUM (농부번호) — NUMBER(5,0) — Primary key — NOT NULL
  • MNUM (회원번호) — NUMBER(5,0)
  • FMNICK (농부닉네임) — VARCHAR2(30 BYTE)
  • FMHP (농부전화번호) — VARCHAR2(4000 BYTE)
  • FMBANK (농부계좌) — VARCHAR2(500 BYTE) DEFAULT NULL
  • FMBANKNAME (예금주)
  • ADNUM (Field)
  • FMCONTENT (Field2)

FUND (fund)

  • FNUM (펀드번호) — NUMBER(5,0) — Primary key — NOT NULL
  • FMNUM (농부번호) — NUMBER(5,0)
  • FSUB (펀드이름) — VARCHAR2(60 BYTE) — NOT NULL
  • FCON (펀드내용) — VARCHAR2(4000 BYTE)
  • FIMG (펀드이미지) — VARCHAR2(255 BYTE)
  • FCURR (펀드현재후원금) — NUMBER(8,0) CHECK(FCURR>=0) DEFAULT 0
  • FGOAL (펀드목표액) — NUMBER(8,0)
  • FSTDATE (펀드등록시작일) — DATE DEFAULT SYSDATE
  • FEDDATE (펀드마감일) — DATE
  • FSTATUS (펀드상태) — NUMBER(1,0) DEFAULT 0

FUNDACCOUNT (fundaccount)

  • FANUM (후원번호) — NUMBER(5,0) — Primary key — NOT NULL
  • FRNUM (보상번호) — NUMBER(6,0) — Foreign key → FUNDREWARD.FRNUM — NOT NULL
  • MNUM (회원번호) — NUMBER(5,0)
  • FAPRICE (후원한가격) — NUMBER(8,0) DEFAULT 0
  • FACOUNT (후원한수량) — NUMBER(5,0) DEFAULT 0
  • FADATE (후원한날짜) — DATE DEFAULT SYSDATE
  • FAMESSAGE (응원메시지) — VARCHAR2(100, BYTE)
  • FASTATUS (후원상태) — NUMBER(2,0) DEFAULT 0

FUNDREWARD (fundreward)

  • FRNUM (보상번호) — NUMBER(6,0) — Primary key — NOT NULL
  • FNUM (펀드번호2) — NUMBER(5,0) — Foreign key → FUND.FNUM — NOT NULL
  • FRPRICE (리워드가격) — NUMBER(6,0)
  • FRCOUNT (리워드수량) — NUMBER(5,0)
  • FRSUB (리워드명) — VARCHAR2(255 BYTE)
  • FRCON (리워드내용) — VARCHAR2(4000 BYTE)
  • FRDATE (리워드날짜) — DATE DEFAULT SYSDATE

MEMBER (member)