Dolbwahyo

Tables (11)

AirplaneDay_infos

  • id — CHAR(36) — Primary key — NOT NULL
  • dayName — VARCHAR(4)
  • enable — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL

AirplaneTime_infos

  • id — CHAR(36) — Primary key — NOT NULL
  • startTime — VARCHAR(20)
  • endTime — VARCHAR(20)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL

Alarm_infos

  • id — CHAR(36) — Primary key — NOT NULL
  • alarm — VARCHAR(100)
  • jaeSilStatus — INT(11)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL
  • locationID — CHAR(36) — Foreign key → Location_infos.id — NOT NULL

Announcement_Infos

  • id — CHAR(36) — Primary key — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • writer — VARCHAR(36)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME

Fcm_token_infos

  • id — CHAR(36) — Primary key — NOT NULL
  • token — VARCHAR(200)
  • email — VARCHAR(40) — NOT NULL
  • isUsed — TINYINT(1) — NOT NULL
  • deviceID — VARCHAR(200) — NOT NULL
  • platform — VARCHAR(10)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL

Hub_infos

  • id — CHAR(36) — Primary key — NOT NULL
  • hubID — VARCHAR(40) — NOT NULL
  • name — VARCHAR(40) — NOT NULL
  • displaySunBun — INT(11) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • deviceType — VARCHAR(20) — NOT NULL
  • hasSubDevices — TINYINT(1) — NOT NULL
  • modelName — VARCHAR(30) — NOT NULL
  • online — TINYINT(1) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • battery — INT(11) — NOT NULL
  • isUse — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL

JaeSilState_Infos

  • id — CHAR(36) — Primary key — NOT NULL
  • jaeSilStatus — INT(11)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL

Location_infos

  • id — CHAR(36) — Primary key — NOT NULL
  • name — VARCHAR(40)
  • type — VARCHAR(50)
  • displaySunBun — INT(11)
  • requireMotionSensorCount — INT(11)
  • detectedMotionSensorCount — INT(11)
  • requireDoorSensorCount — INT(11)
  • detectedDoorSensorCount — INT(11)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL

Sensor_Event_infos

  • id — CHAR(36) — Primary key — NOT NULL
  • deviceType — VARCHAR(20) — NOT NULL
  • accountID — VARCHAR(40) — NOT NULL
  • event — VARCHAR(40) — NOT NULL
  • state — LONGTEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL
  • sensorID — CHAR(36) — Foreign key → Sensor_Infos.id — NOT NULL
  • locationID — CHAR(36) — Foreign key → Location_infos.id — NOT NULL

Sensor_Infos

  • id — CHAR(36) — Primary key — NOT NULL
  • sensorID — VARCHAR(40) — NOT NULL
  • name — VARCHAR(40) — NOT NULL
  • displaySunBun — INT(11) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • deviceType — VARCHAR(20) — NOT NULL
  • modelName — VARCHAR(30) — NOT NULL
  • online — TINYINT(1) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • battery — INT(11) — NOT NULL
  • isUse — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • userID — CHAR(36) — Foreign key → Users.id — NOT NULL
  • hubID — CHAR(36) — Foreign key → Hub_infos.id — NOT NULL
  • locationID — CHAR(36) — Foreign key → Location_infos.id — NOT NULL

Users

  • id — CHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(40) — NOT NULL
  • password — VARCHAR(100)
  • name — VARCHAR(20) — NOT NULL
  • parentName — VARCHAR(20)
  • parentAge — INT(11)
  • parentPhone — VARCHAR(20)
  • parentSex — INT(11)
  • addr_zip — VARCHAR(20)
  • addr — VARCHAR(100)
  • addr_detail — VARCHAR(100)
  • mobilephone — VARCHAR(20) — NOT NULL
  • tel — VARCHAR(20) — NOT NULL
  • snsId — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • admin — TINYINT(1) — NOT NULL
  • shareKey — CHAR(36) — NOT NULL
  • deviceID — VARCHAR(200) — NOT NULL
  • optionalCheck — TINYINT(1) — NOT NULL
  • sendPushToiletLastUsed — TINYINT(1) — NOT NULL
  • sendPushRefrigeratorLastUsed — TINYINT(1) — NOT NULL
  • sendPushEnteranceEvent — TINYINT(1) — NOT NULL
  • enableAlarm — TINYINT(1) — NOT NULL
  • useAirplaneMode — TINYINT(1) — NOT NULL
  • isRefrigeratorOpened — TINYINT(1) — NOT NULL
  • sendPushRefrigeratorOpened — TINYINT(1) — NOT NULL
  • sendPushEnteranceOpened — TINYINT(1) — NOT NULL
  • refrigeratorAlarmTime — INT(11)
  • toiletAlarmTime — INT(11)
  • entranceOpenedAlarmTime — INT(11)
  • refrigeratorOpenedAlarmTime — INT(11)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME