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