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