YaNongJang
Tables (17)
farmRecord (농장 일일 수확량 기록)
- num — number — Primary key — NOT NULL
- fserial (fserial2) — varchar2(100) — Foreign key → ynj_finsert.fserial — NOT NULL
- id — varchar2(100) — Foreign key → ynj_finsert.id — NOT NULL
- fserial — varchar2(100)
- day_fharvest — number
- h_date — date
- fname — varchar2(100)
farmRequest (분양신청)
- num — number — Primary key — NOT NULL
- fserial (fserial2) — varchar2(100) — Foreign key → ynj_finsert.fserial — NOT NULL
- id — varchar2(100) — Foreign key → ynj_finsert.id — NOT NULL
- rtype — varchar2(100)
- loan_date — number
- fuser — varchar2(100)
- state — varchar2(100)
- farm_num — number
- fname — varchar2(100)
- fserial — varchar2(100)
- loan_plus — number
msg (쪽지)
- num — number — Primary key — NOT NULL
- num (num3) — number — Foreign key → ynj_excsell.num — NOT NULL
- id (id2) — varchar2(100) — Foreign key → ynj_excsell.id — NOT NULL
- id (id3) — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- lnum — number — NOT NULL
- sendid — varchar2(100) — NOT NULL
- toid — varchar2(100) — NOT NULL
- content — varchar2(2000)
- state — number
- reg — date
- choose — varchar2(100)
- estate — number
qa (질문게시판)
- num — number — Primary key — NOT NULL
- id — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- subject — varchar2(100)
- reg_date — date
- readcount — number
- writer — varchar2(100)
- content — varchar2(2000)
- ref — number
- re_step — number
- re_level — number
- pw — varchar2(100)
qareply (질문게시판 댓글)
- num — number — Primary key — NOT NULL
- id (id2) — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- id — varchar2(100) — Foreign key → qa.id — NOT NULL
- content — varchar2(2000)
- reg_date — date
- pw — varchar2(100)
- subject — varchar2(100)
- writer — varchar2(100)
warning (농장소개 경고창)
- num — number — Primary key — NOT NULL
- fserial — varchar2(100) — Foreign key → ynj_finsert.fserial — NOT NULL
- id (id2) — varchar2(100) — Foreign key → ynj_finsert.id — NOT NULL
- fnum — varchar2(100)
- fuser — varchar2(1000)
- state — number
- reg — date
weather (날씨)
- num — number — Primary key — NOT NULL
- fserial — varchar2(100) — Foreign key → ynj_finsert.fserial — NOT NULL
- id — varchar2(100) — Foreign key → ynj_finsert.id — NOT NULL
- address — varchar2(100)
- now_temperature — varchar2(100)
- today_weather — varchar2(100)
- today_weather1 — varchar2(100)
- today_weather2 — varchar2(100)
- date1 — varchar2(100)
- date2 — varchar2(100)
- date3 — varchar2(100)
- date4 — varchar2(100)
- date5 — varchar2(100)
- temperature1 — varchar2(100)
- temperature2 — varchar2(100)
- temperature3 — varchar2(100)
- temperature4 — varchar2(100)
- temperature5 — varchar2(100)
- weather_icon1 — varchar2(100)
- weather_icon2 — varchar2(100)
- weather_icon3 — varchar2(100)
- weather_icon4 — varchar2(100)
- weather_icon5 — varchar2(100)
- weather_icon6 — varchar2(100)
- weather_icon7 — varchar2(100)
- weather_icon8 — varchar2(100)
- weather_icon9 — varchar2(100)
- weather_icon10 — varchar2(100)
- weather_icon11 — varchar2(100)
ynj_benefit (회사 이익)
- num — number — Primary key — NOT NULL
- num (num2) — number — Foreign key → farmRecord.num — NOT NULL
- fserial (fserial2) — varchar2(100) — Foreign key → farmRecord.fserial — NOT NULL
- id — varchar2(100) — Foreign key → farmRecord.id — NOT NULL
- serial_num — varchar2(100)
- cbenefit — number
- b_date — date
- fname — varchar2(100)
ynj_crops (작물소개)
- c_name — varchar2(100) — Primary key — NOT NULL
- serial_num — varchar2(100) — Foreign key → ynj_farminfo.serial_num — NOT NULL
- fserial — varchar2(100) — Foreign key → ynj_farminfo.fserial — NOT NULL
- id — varchar2(100) — Foreign key → ynj_farminfo.id — NOT NULL
- id (id2) — varchar2(100) — Foreign key → ynj_farminfo.id — NOT NULL
- c_img — varchar2(100)
- c_crawling — clob
- c_start — number
- c_end — number
- c_area — varchar2(100)
- c_pest — varchar2(1000)
- c_purpose — varchar2(100)
- c_content — varchar2(4000)
ynj_diary (그림 일기)
- num — number — Primary key — NOT NULL
- id (id2) — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- serial_num — varchar2(100)
- diarydate — varchar2(100)
- subject — varchar2(100)
- paint — varchar2(100)
ynj_excsell (판매교환신청게시판)
- num — number — Primary key — NOT NULL
- id — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- writer — varchar2(100)
- img — varchar2(100)
- subject — varchar2(100)
- esel_date — date
- content — varchar2(2000)
- expw — varchar2(100) — NOT NULL
- choose — varchar2(100)
ynj_farminfo (밭정보)
- serial_num — varchar2(100) — Primary key — NOT NULL
- fserial — varchar2(100) — Foreign key → ynj_finsert.fserial — NOT NULL
- id — varchar2(100) — Foreign key → ynj_finsert.id — NOT NULL
- id (id2) — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- num — number — NOT NULL
- fname — varchar2(100)
- farm_num — number
- img — varchar2(100)
- price — number
- space — number
- facility — varchar2(100)
- loan_date — number
- state — number
- expiry_date — varchar2(100)
- partcrop — varchar2(200)
- fuser — varchar2(100)
- fspace1 — number
- fspace2 — number
- ftype — number
- start_date — varchar2(100)
ynj_farmlist (농장 거리 계산)
- id (id2) — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- id (id22) — varchar2(100) — Foreign key → ynj_trafic.id — NOT NULL
- fserial (fserial2) — varchar2(100) — Foreign key → ynj_trafic.fserial — NOT NULL
- id (id4) — varchar2(100) — Foreign key → ynj_trafic.id — NOT NULL
- fnum — varchar2(100) — NOT NULL
- id — varchar2(100) — NOT NULL
- farm_locat — varchar2(2000)
- user_locat — varchar2(2000)
- distanc — varchar2(100)
ynj_finsert (농장 등록)
- fserial — varchar2(100) — Primary key — NOT NULL
- id — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- fuser — varchar2(100) — NOT NULL
- fname — varchar2(100) — NOT NULL
- flocate — varchar2(100) — NOT NULL
- fphone — varchar2(100) — NOT NULL
- fcrop — varchar2(100) — NOT NULL
- ffacility — varchar2(100) — NOT NULL
- fimplement — varchar2(100) — NOT NULL
- fpopular — number
- fprice — number — NOT NULL
- fspace1 — number — NOT NULL
- fspace2 — number
- fpicture — varchar2(300)
- fcount — number
- fkind — varchar2(100) — NOT NULL
- fintro — varchar2(3000)
- fnum — number — NOT NULL
- ftime — date — NOT NULL
- fusing — number
- fbenefit — number
- fharvest — number
ynj_trafic (농장 대중교통 정보)
- id (id2) — varchar2(100) — Foreign key → ynj_user.id — NOT NULL
- fserial (fserial2) — varchar2(100) — Foreign key → ynj_finsert.fserial — NOT NULL
- id (id4) — varchar2(100) — Foreign key → ynj_finsert.id — NOT NULL
- fnum — varchar2(100) — NOT NULL
- id — varchar2(100) — NOT NULL
- farm_locat — varchar2(2000)
- user_locat — varchar2(2000)
- min — varchar2(100)
- trafic — varchar2(100)
ynj_user (유저)
- id — varchar2(100) — Primary key — NOT NULL
- userType — varchar2(100) — NOT NULL
- passwd — varchar2(100) — NOT NULL
- age — number
- phone — varchar2(100)
- sex — varchar2(100)
- name — varchar2(100)
- email — varchar2(100)
- address1 — varchar2(100)
- address2 — varchar2(100)
- document — varchar2(100)
- farmok — varchar2(100)
ynj_userFarm (분양자 밭)
- serial_num — varchar2(100) — Primary key — NOT NULL
- serial_num (serial_num2) — varchar2(100) — Foreign key → ynj_farminfo.serial_num — NOT NULL
- fserial — varchar2(100) — Foreign key → ynj_farminfo.fserial — NOT NULL
- id (id3) — varchar2(100) — Foreign key → ynj_farminfo.id — NOT NULL
- id (id22) — varchar2(100) — Foreign key → ynj_farminfo.id — NOT NULL
- num (num2) — number — Foreign key → farmRequest.num — NOT NULL
- fserial (fserial2) — varchar2(100) — Foreign key → farmRequest.fserial — NOT NULL
- id (id2) — varchar2(100) — Foreign key → farmRequest.id — NOT NULL
- id — varchar2(100)
- plantcrop — varchar2(100)
- cropcount — number
- plantwork — date
- harvest — varchar2(100)
- gtype — number
- cropnum — number