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