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)