PJ2IoT
Tables (6)
Detail (detail)
- Function No (fun_no) — NUM — Foreign key → Function.Function No — NOT NULL
- Object No (obj_no) — NUM — Foreign key → Object.Object No — NOT NULL
- Family No (fa_no) — NUM — Foreign key → Family.Family No — NOT NULL
- Start (start) — time
- End (end) — time
- Status (status) — boolean
- Condition On (con_on) — VARCHAR(30)
- Condition Off (con_off) — VARCHAR(30)
Family (family)
- Family No (fa_no) — NUM — Primary key — NOT NULL
- ID (id) — VARCHAR(30)
- Password (pwd) — VARCHAR(60)
- Map (map) — IMG
Find stuff (find_stuff)
- Stuff No (stuff_no) — NUM — Primary key — NOT NULL
- User no (user_no) — NUM — Foreign key → User.User no — NOT NULL
- Stuff Name (stuff_name) — VARCHAR(30)
- Stuff img (stuff_img) — img
- x — NUM
- y — NUM
Function (function)
- Function No (fun_no) — NUM — Primary key — NOT NULL
- Function Name (fun_name) — VARCHAR(30)
Object (object)
- Object No (obj_no) — NUM — Primary key — NOT NULL
- Object Name (obj_name) — VARCHAR(30)
User (user)
- User no (user_no) — NUM — Primary key — NOT NULL
- Family No (fa_no) — NUM — Foreign key → Family.Family No — NOT NULL
- Name (name) — VARCHAR(30)
- Email (email) — VARCHAR(30)