nanumi_raspberry_tunnel
Tables (7)
Action (raspberry device action)
- value (action value) — string — Primary key — NOT NULL
- role_value (role value) — string — Foreign key → Role.value — NOT NULL
- uri_value (uri name) — string — Foreign key → UriStructure.value — NOT NULL
Device (raspberry pi device)
- id (device id) — string — Primary key — NOT NULL
- mac (mac address) — string — NOT NULL
- port (forwarding port) — number
- alias (alias name) — string — NOT NULL
- createdAt (cteate timestamp) — date
- updatedAt (update timestamp) — date
- value (action value) — string — Foreign key → Action.value — NOT NULL
- role_value (role value) — string — Foreign key → Action.role_value — NOT NULL
- uri_value (uri name) — string — Foreign key → Action.uri_value — NOT NULL
FuneralHome (mongo db funeral home)
- id (funeral home id) — string — Primary key — NOT NULL
- device_id (device id) — string — Foreign key → Device.id — NOT NULL
- mongo_id (mongo db _id) — string
- nickname (funeral home nickname) — string
- address (funeral home address) — string
- coordx (funeral home coord x value) — string
- coordy (funeral home coord y value) — string
- name (funeral home name) — string
- phoneNumber (funeral home phone number) — string
- createdAt (create timestamp) — date
- updatedAt (update timestamp) — date
History (device status history)
- id (history id) — string — Primary key — NOT NULL
- device_id (device id) — string — Foreign key → Device.id — NOT NULL
- status (device status) — boolean
- createdAt (cteate timestamp) — date
- updatedAt (update timestamp) — date
Role (raspberry device role)
- value (role value) — string — Primary key — NOT NULL
Room (mongo db room)
- id (room id) — string — Primary key — NOT NULL
- device_id (device id) — string — Foreign key → Device.id — NOT NULL
- funeral_id (funeral home id) — string — Foreign key → FuneralHome.id — NOT NULL
- mongo_id (mongo db _id) — string
- nickname (room nickname) — string
- name (room name) — string
- createdAt (create timestamp) — date
- updatedAt (update timestamp) — date
UriStructure (uri structure)
- value (uri name) — string — Primary key — NOT NULL
- base (base uri) — string
- route (uri route) — string
- structure (raspberry uri structure) — string