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