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