Smart Sook-Sook Database Model

Tables (3)

Farm (농장_정보)

  • FID (농장 고유 아이디) — serial — Primary key — NOT NULL
  • UID (사용자 참조 아이디) — serial — Foreign key → User.UID — NOT NULL
  • FarmName (농장명) — character varying(20) — NOT NULL
  • FarmSize (농장면적) — real(20)
  • FarmPostCode (농장우편번호) — integer(10)
  • FarmAddress (농장주소) — character varying(200)
  • FarmNumber (농장연락처) — character varying(20)

User (사용자)

  • UID (사용자 고유 아이디) — serial — Primary key — NOT NULL
  • UserCode (사용자 코드) — character varying(10) — NOT NULL
  • UserName (사용자 명) — character varying(50) — NOT NULL
  • Email (이메일) — character varying(100) — NOT NULL
  • Password (비밀번호) — character varying(50) — NOT NULL
  • PostCode (우편번호) — integer(10) — NOT NULL
  • Addresss (주소) — character varying(200) — NOT NULL
  • PhoneNumber (휴대폰 번호) — character varying(20) — NOT NULL
  • PhoneVerified (인증여부) — boolean — NOT NULL
  • ProfileUrl (프로필이미지) — character varying(200)
  • Disable (비활성화여부) — boolean — NOT NULL
  • Withdrawal (탈퇴여부) — boolean — NOT NULL
  • CreateDate (가입일자) — timestamp[0] — NOT NULL
  • UpdateDate (수정일자) — timestamp[0] — NOT NULL
  • LoginDate (로그인일자) — timestamp[0] — NOT NULL
  • PushAlarm (푸쉬알람여부) — boolean — NOT NULL
  • SmsAlarm (SMS알람여부) — boolean — NOT NULL
  • CallAlarm (유선알람여부) — boolean — NOT NULL
  • Advertisements (광고수신) — boolean — NOT NULL
  • PersonalInformation (개인정보제공동의) — boolean — NOT NULL

plant (시설_정보)

  • PID (시설 고유 아이디) — serial — Primary key — NOT NULL
  • FID (농장 참조 아이디) — serial — Foreign key → Farm.FID — NOT NULL
  • UID (사용자 참조 아이디) — serial — Foreign key → Farm.UID — NOT NULL
  • PlantType (시설유형) — character varying(20) — NOT NULL — code
  • PlantWidth (시설폭) — real(10)
  • PlantHeight (시설측고) — real(10)
  • PlantLeght (시설길이) — real(20)
  • PlantLatitude (시설위도) — numeric(20,10)
  • PlantLongitude (시설경도) — numeric(20,10)
  • CultivationType (재배유형) — character varying(20)
  • CultivationArea (재벼면적) — real(20)
  • MajorItem (대표품목) — character varying(20)
  • MajorVariety (대표품종) — character varying(20)