GardenBOX_DB_Sensor
Tables (5)
User(WEB) (User)
- ID (아이디) — VARCHAR2(20) — Primary key — NOT NULL
- Nickname (별명) — VARCHAR2(20)
- Name (이름) — VARCHAR2(20)
- Age (나이) — INTEGER(3)
- Field
User_Sensor1_DATA (Sensor #1)
- ID (정렬용) — Primary key — NOT NULL
- ID (아이디) — VARCHAR2(20) — Foreign key → User(WEB).ID — NOT NULL
- Date (측정시간) — DATETIME
- Sensor (센서데이터) — DECIMAL(4,2)
User_Sensor2_DATA (CopyOfUntitled)
- ID (정렬용) — Primary key — NOT NULL
- Date (측정시간) — DATETIME
- Sensor (센서데이터) — DECIMAL(4,2)
User_Sensor3_DATA (Sensor #3)
- ID (정렬용) — Primary key — NOT NULL
- Date (측정시간) — DATETIME
- Sensor (센서데이터) — DECIMAL(4,2)
for_WEB_SERVICE (Untitled)
- Key — Primary key — NOT NULL
- ID (아이디) — VARCHAR2(20) — Foreign key → User(WEB).ID — NOT NULL
- Field
- Field2
- Field3