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