KINOKO ERD

Tables (12)

Compost_image (Untitled6)

  • compostimg_id (Key) — INT — Primary key — NOT NULL
  • compostimg_userid (user_no) — INT — Foreign key → User.user_no — NOT NULL
  • compostimg_url (Field2) — VARCHAR(100) — NOT NULL
  • compostimg_date (Field) — TIMESTAMP — NOT NULL

Date (Untitled8)

  • date_id (Key) — INT — Primary key — NOT NULL
  • date_userid (user_no) — INT — Foreign key → User.user_no — NOT NULL
  • date_start (Field) — TIMESTAMP
  • date_end (Field2) — TIMESTAMP — NOT NULL

Growth_Rate (Untitled9)

  • gr_id (Key) — INT — Primary key — NOT NULL
  • gr_userid (user_no) — INT — Foreign key → User.user_no — NOT NULL
  • gr_prgid (Field) — INT — NOT NULL
  • gr_value (Field2) — INT — NOT NULL

Help (Untitled11)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — VARCHAR(20) — NOT NULL
  • effect (Field2) — VARCHAR(500) — NOT NULL
  • environment (Field3) — VARCHAR(500) — NOT NULL
  • thumnail (Field4) — VARCHAR(100)
  • date (Field5) — TIMESTAMP — NOT NULL

Machine (Untitled2)

  • machine_id — INT — Primary key — NOT NULL
  • machine_userid (user_id) — INT — Foreign key → User.user_no — NOT NULL
  • machine_name (Field3) — VARCHAR(30)
  • machine_prgid (Field5) — INT — NOT NULL
  • machine_pin (Field) — INT — NOT NULL
  • machine_ison — VARCHAR(5) — NOT NULL
  • machine_ip (Field2) — VARCHAR(18)
  • machine_isPresence (Field4) — VARCHAR(5) — NOT NULL — 0 : 없음 1 : 있음

Mushroom (Untitled3)

  • mr_id (Key) — INT — Primary key — NOT NULL
  • mr_prgid (prg_id) — INT — Foreign key → Program.prg_id — NOT NULL
  • mr_size (Field2) — INT — NOT NULL
  • mr_imgid (Field) — INT — NOT NULL
  • mr_status (Field3) — VARCHAR(15) — NOT NULL — complete 수확 harvest 생장완료 whiteflower 백화고 growing 생장중
  • mr_growth (Field4) — INT — NOT NULL
  • mr_date (Field5) — TIMESTAMP — NOT NULL

Mushroom_image (Untitled4)

  • mushimg_id (Key) — INT — Primary key — NOT NULL
  • mushimg_mrid (Key2) — INT — Foreign key → Mushroom.mr_id — NOT NULL
  • mushimg_url (Field2) — VARCHAR(100) — NOT NULL
  • mushimg_date (Field) — INT — NOT NULL

Pin (Untitled7)

  • pin_value (Key) — INT — Primary key — NOT NULL
  • pin_machineid (machine_id) — INT — Foreign key → Machine.machine_id — NOT NULL
  • pin_pw (Field2) — VARCHAR(16) — NOT NULL

Program (Untitled)

  • prg_id — INT — Primary key — NOT NULL
  • prg_userid (user_no) — INT — Foreign key → User.user_no — NOT NULL
  • prg_machineid (Field7) — INT — NOT NULL
  • prg_dateid (Field4) — INT — NOT NULL
  • prg_name (Field6) — VARCHAR(30)
  • prg_type (Field) — VARCHAR(15) — NOT NULL — Shiitake 표고 WhiteFlower 백화고 costom 커스텀
  • prg_water (Field2) — INT — NOT NULL
  • prg_sunshine (Field3) — INT — NOT NULL
  • prg_count (Field8) — INT — NOT NULL
  • prg_conpostname (Field9) — VARCHAR(30)
  • prg_period (Field10) — INT — NOT NULL

Setting_data (Untitled5)

  • setting_id (Key) — INT — Primary key — NOT NULL
  • setting_prgid (prg_id) — INT — Foreign key → Program.prg_id — NOT NULL
  • setting_value (Field2) — INT — NOT NULL
  • setting_type (Field) — VARCHAR(12) — NOT NULL — Temperature : 온도 humidity : 습도
  • setting_date (Field3) — TIMESTAMP

Token (Untitled10)

  • id (Key) — INT — Primary key — NOT NULL
  • user_no (user_no2) — INT — Foreign key → User.user_no — NOT NULL
  • login_date (Field) — TIMESTAMP — NOT NULL
  • logout_date (Field2) — TIMESTAMP — NOT NULL
  • token (Field3) — VARCHAR(60) — NOT NULL

User (기기)

  • user_no — INT — Primary key — NOT NULL
  • user_id — VARCHAR(20) — NOT NULL
  • user_email — VARCHAR(30) — NOT NULL
  • user_date (Field2) — TIMESTAMP — NOT NULL
  • user_lastlogout (Field) — TIMESTAMP
  • user_machineid (Field3) — INT — NOT NULL