팜팜
테이블 (20)
TBL_ADVANTAGE
- ADV_KEY — NUMBER(10,0)
- MEM_ID — VARCHAR2(30 BYTE)
- ADV_REASON — NUMBER(3,0)
- ADV_POINT — NUMBER(3,0)
- ADV_REGDATE — DATE
TBL_AUCTION
- AUC_NO — VARCHAR2(15 BYTE)
- STOCK_NO — VARCHAR2(15 BYTE)
- AUC_TITLE — VARCHAR2(100 BYTE)
- AUC_STARTPRICE — NUMBER(20,0)
- AUC_NOWPRICE — NUMBER(20,0)
- AUC_FINALPRICE — NUMBER(20,0)
- AUC_STATUS — NUMBER(3,0)
- AUC_REGDATE — DATE
- AUC_ENDDATE — DATE
- AUC_JOIN — NUMBER(10,0)
- AUC_CONTENT — VARCHAR2(500 BYTE)
TBL_BOARD
- BOA_ID — NUMBER(5,0)
- MEM_ID — VARCHAR2(30 BYTE)
- BOA_SUBJECT — VARCHAR2(50 BYTE)
- BOA_CONTENT — VARCHAR2(500 BYTE)
- BOA_READCNT — NUMBER(10,0)
- BOA_REGDATE — DATE
- BOA_IP — VARCHAR2(15 BYTE)
- BOA_CATEGORY — NUMBER(3,0)
- BOA_IMAGE — VARCHAR2(50 BYTE)
TBL_COMMENT
- CM_NO — NUMBER(10,0)
- BOA_ID — NUMBER(5,0)
- MEM_ID — VARCHAR2(30 BYTE)
- CM_CONTENT — VARCHAR2(1000 BYTE)
- CM_REGDATE — DATE
TBL_DELIVERY
- DE_NO — VARCHAR2(15 BYTE)
- MEM_ID — VARCHAR2(30 BYTE)
- ORDER_NO — VARCHAR2(15 BYTE)
- DE_ADDRESS — VARCHAR2(255 BYTE)
- DE_STATUS — NUMBER(3,0)
- DE_ARRDATE — DATE
TBL_DOORG
- DOFORM_ID — NUMBER(10,0)
- DOORG_NAME — VARCHAR2(100 BYTE)
- DOORG_HP — VARCHAR2(20 BYTE)
- DOORG_ADDRESS — VARCHAR2(255 BYTE)
- DOORG_PERSON — VARCHAR2(30 BYTE)
- DOORG_ACCOUNT — NUMBER(20,0)
- DOORG_TITLE — VARCHAR2(100 BYTE)
- DOORG_CONTENT — VARCHAR2(1000 BYTE)
- DOORG_IMAGE — VARCHAR2(1000 BYTE)
- DOORG_REGDATE — DATE
TBL_FARM
- FARM_KEY — NUMBER(10,0)
- MEM_ID — VARCHAR2(30 BYTE)
- FARM_ADV — NUMBER(3,0)
- FARM_REGDATE — DATE
- FARM_STATUS — NUMBER(3,0)
TBL_FPLAN
- FARM_KEY — NUMBER(10,0)
- FPLAN_PLAN — VARCHAR2(1000 BYTE)
- FPLAN_CAPITAL — NUMBER(20,0)
- FPLAN_USE — VARCHAR2(1000 BYTE)
- FPLAN_ADDRESS — VARCHAR2(255 BYTE)
- FPLAN_TITLE — VARCHAR2(100 BYTE)
- FPLAN_DETAIL — VARCHAR2(1000 BYTE)
TBL_FUND
- FUND_NO — VARCHAR2(15 BYTE)
- STOCK_NO — VARCHAR2(15 BYTE)
- FUND_TITLE — VARCHAR2(100 BYTE)
- FUND_PRICE — NUMBER(20,0)
- FUND_STATUS — NUMBER(3,0)
- FUND_REGDATE — DATE
- FUND_ENDDATE — DATE
- FUND_JOIN — NUMBER(10,0)
- FUND_CONTENT — VARCHAR2(500 BYTE)
TBL_IOT
- MF_KEY — NUMBER(10,0)
- IOT_TEMP — VARCHAR2(200 BYTE)
- IOT_SOILHUMI — VARCHAR2(200 BYTE)
- IOT_VIDEO — VARCHAR2(200 BYTE)
- IOT_DATE — DATE
TBL_JOIN
- JOIN_NO — NUMBER(10,0)
- MEM_ID — VARCHAR2(30 BYTE)
- FUND_NO — VARCHAR2(15 BYTE)
- AUC_NO — VARCHAR2(15 BYTE)
- JOIN_REGDATE — DATE
- JOIN_AUCPRICE — NUMBER(20,0)
- JOIN_FUNDPRICE — NUMBER(20,0)
TBL_LETTERS
- BOA_ID — NUMBER(5,0)
- LETTER_ID — VARCHAR2(30 BYTE)
TBL_MEMBER
- MEM_ID — VARCHAR2(30 BYTE)
- MEM_PWD — VARCHAR2(50 BYTE)
- MEM_NAME — VARCHAR2(30 BYTE)
- MEM_HP — VARCHAR2(13 BYTE)
- MEM_EMAIL — VARCHAR2(30 BYTE)
- MEM_ADDRESS — VARCHAR2(255 BYTE)
- MEM_GRADE — NUMBER(3,0)
- MEM_ADV — NUMBER(3,0)
- MEM_REGDATE — DATE
- MEM_DROP — VARCHAR2(3 BYTE)
TBL_MEMDO
- DONA_NO — VARCHAR2(15 BYTE)
- DOFORM_ID — NUMBER(10,0)
- MEM_ID — VARCHAR2(30 BYTE)
- DONA_PRICE — NUMBER(20,0)
- DONA_DATE — DATE
TBL_MEMFARM
- MF_KEY — NUMBER(10,0)
- MEM_ID — VARCHAR2(30 BYTE)
- WFARMINFO_KEY — NUMBER(10,0)
- MF_LOCATION — NUMBER(4,0)
- MF_REGDATE — DATE
TBL_ORDER
- ORDER_NO — VARCHAR2(15 BYTE)
- MEM_ID — VARCHAR2(30 BYTE)
- STOCK_NO — VARCHAR2(15 BYTE)
TBL_ORINFO
- ORINFO_NO — NUMBER(15,0)
- ORDER_NO — VARCHAR2(15 BYTE)
- ORDER_KG — NUMBER(5,0)
- ORDER_EA — NUMBER(5,0)
- ORDER_STATUS — NUMBER(3,0)
- ORDER_DATE — DATE
- ORDER_KIND — NUMBER(3,0)
TBL_PAY
- PAY_NO — NUMBER(15,0)
- ORDER_NO — VARCHAR2(15 BYTE)
- PAY_PRICE — NUMBER(20,0)
- PAY_STATUS — NUMBER(3,0)
- PAY_DATE — DATE
TBL_STOCK(상품) (TBL_STOCK)
- STOCK_NO — VARCHAR2(15 BYTE)
- FARM_KEY — NUMBER(10,0)
- STOCK_NAME — VARCHAR2(100 BYTE)
- STOCK_DETAIL — VARCHAR2(200 BYTE)
- STOCK_KG — NUMBER(10,0)
- STOCK_EA — NUMBER(5,0)
- STOCK_PRICE — NUMBER(10,0)
- STOCK_IMAGE — VARCHAR2(100 BYTE)
- STOCK_KIND — NUMBER(3,0)
- STOCK_REGDATE — NUMBER(1,0)
TBL_WFARMINFO
- WFARMINFO_KEY — NUMBER(10,0)
- FARM_KEY — NUMBER(10,0)
- WFARMINFO_TITLE — VARCHAR2(200 BYTE)
- WFARMINFO_ADDRESS — VARCHAR2(500 BYTE)
- WFARMINFO_PRICE — NUMBER(20,0)
- WFARMINFO_STATUS — NUMBER(3,0)
- WFARMINFO_REGDATE — DATE
- WFARMINFO_IMAGE — VARCHAR2(100 BYTE)
- WFARMINFO_INTRODUCE — VARCHAR2(1000 BYTE)
- WFARMINFO_ROW — NUMBER(3,0)
- WFARMINFO_COL — NUMBER(3,0)