BRT API
Tables (7)
schema_mapping.sensor_info (센서정보)
- Sensor Info UUID (siuuid) — UUID — Primary key — NOT NULL
- User PK (useruuid) — UUID — Foreign key → schema_user.users.User PK — NOT NULL
- Sensor Name (name) — VARCHAR(150) — NOT NULL
- Sensor Icon (icon) — TEXT
- Rester Date (wdate) — DATETIME — NOT NULL
schema_mapping.sensor_mapping (센서매핑)
- Sensor Mapping UUID (smuuid) — UUID — Primary key — NOT NULL
- Sensor Info UUID (siuuid) — UUID — Foreign key → schema_mapping.sensor_info.Sensor Info UUID — NOT NULL
- Node UUID (nodeuuid) — UUID — Foreign key → schema_user.nodes.Node UUID — NOT NULL
schema_user.farms (농장)
- Farm UUID (farmuuid) — UUID — Primary key — NOT NULL
- User PK (useruuid) — UUID — Foreign key → schema_user.users.User PK — NOT NULL
- Farm Name (name) — VARCHAR(150) — NOT NULL
- Farm Address (address) — TEXT — JSON
- Farm Phone (phone) — VARCHAR(20)
- Rester Date (wdate) — DATETIME — NOT NULL
schema_user.nodes (노드)
- Node UUID (nodeuuid) — UUID — Primary key — NOT NULL
- Farm UUID (farmuuid) — UUID — Foreign key → schema_user.farms.Farm UUID — NOT NULL
- Node Name (name) — VARCHAR(150) — NOT NULL
- Node Description (description) — TEXT
- Rester Date (wdate) — DATETIME — NOT NULL
schema_user.users (회원)
- User PK (useruuid) — UUID — Primary key — NOT NULL
- ID (userid) — VARCHAR(150) — NOT NULL
- Password (pwd) — VARCHAR(150) — NOT NULL
- Email (email) — VARCHAR(100) — NOT NULL
- NickName (nickname) — VARCHAR(50)
- Phone (phone) — VARCHAR(20)
- Rester Date (wdate) — DATETIME — NOT NULL
sensor (센서기록)
- Sensor Info UUID (siuuid) — UUID — Foreign key → schema_mapping.sensor_mapping.Sensor Info UUID — NOT NULL
- Node UUID (nodeuuid) — UUID — Foreign key → schema_mapping.sensor_mapping.Node UUID — NOT NULL
- Fields (fields) — fields — NOT NULL — 센서값
- Time (time) — time
token (인증토큰)
- Key (useruuid)
- value (random)