tela world

Tables (47)

Untitled (sensor_type)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — text

Untitled (sensor_category)

  • Key (id) — int — Primary key — NOT NULL
  • Field (company_id) — int — Foreign key → Untitled.Field
  • Field (name) — text

Untitled (sensor_data)

  • Key (id) — text — Foreign key → sensor_list.id — NOT NULL
  • id (Key2) — bigint — Foreign key → sensor_list.protocol_id — NOT NULL
  • Field (습도) — double
  • Field (온도) — double
  • Field (압력) — double
  • Field (조도) — double
  • Field (시간) — timestamp
  • Field — timestamp

Untitled (sensor_company)

  • Field (id) — int — Primary key
  • Field (name) — text

Untitled4 (gateway_item)

  • id (gateway_id) — bigint — Foreign key → gateWay.id — NOT NULL
  • Key (endnode_id) — bigint — Foreign key → endnode_list.Key — NOT NULL

app_version

  • version — text
  • platform — text
  • required — boolean
  • reg_date — timestamp

area

  • id — bigint — Primary key
  • id (place_id) — bigint — Foreign key → place.id
  • name — varchar(255)
  • description — text
  • identify — text
  • use_reservation — boolean

area_file (area_sensor)

  • id (area_id) — bigint — Foreign key → area.id
  • originalname — text
  • key — text
  • location — location
  • mimetype — text
  • size — double
  • created_at — timestamp

area_file

  • id (area_id) — bigint — Foreign key → area.id
  • originalname — text
  • key — text
  • location — text
  • mimetype — text
  • size — float8
  • created_at — timestamp

area_member

  • user_id — uuid — Foreign key → user.id — NOT NULL
  • area_id — bigint — Foreign key → area.id
  • status — int4
  • type — int4

area_sensor (Untitled3)

  • sensor_id — int — Foreign key → sensor_list.id — NOT NULL
  • area_id — bigint — Foreign key → area.id

connection

  • user_id — uuid — NOT NULL
  • timestamp — timestamp
  • socket — text — NOT NULL

country_code

  • id — int4 — Primary key — NOT NULL
  • name — text
  • code — text
  • icon — text

endnode_list

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (dev_eui) — string
  • Field (dev_s_key) — string
  • Field (name) — string
  • Field (description) — string
  • Field (status) — int
  • Field (started_at) — timestamp
  • Field (ended_at) — timestamp
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

event

  • id — uuid — Primary key — NOT NULL
  • timestamp — timestamp
  • type — text
  • from — text
  • to — text
  • content — text
  • workboard_id — bigint — NOT NULL

gateWay (gateway_list)

  • id — bigint — Primary key — NOT NULL
  • id (place_id) — bigint — Foreign key → place.id
  • mac (gateway_id) — string
  • Field (name) — string
  • Field (description) — string
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (coordinates) — geometry
  • Field (api) — string
  • Field (token) — string

invitation

  • phone — text
  • email — text
  • user_id — uuid — NOT NULL
  • invited_at — timestamp
  • workboard_id — bigint

language_code

  • code — text — Primary key — NOT NULL
  • name — text

message

  • id — uuid — Primary key — NOT NULL
  • created_at — timestamp
  • edited_at — timestamp
  • deleted_at — timestamp
  • from — text
  • to — text
  • content — text
  • type — text
  • target_id — bigint

message_export_log

  • id — uuid — Primary key — NOT NULL
  • id (workboard_id) — bigint — Foreign key → workboard.id
  • user_id — uuid — NOT NULL
  • expired_at — timestamp — NOT NULL

message_file

  • id (message_id) — uuid — Foreign key → message.id — NOT NULL
  • workboard_id — bigint — NOT NULL
  • originalname — text
  • key — text
  • location — text
  • mimetype — text
  • size — float8
  • created_at — timestamp

message_link

  • id (message_id) — uuid — Foreign key → message.id — NOT NULL
  • workboard_id — bigint — NOT NULL
  • link — text

message_map

  • id (message_id) — uuid — Foreign key → message.id — NOT NULL
  • workboard_id — bigint — NOT NULL
  • coordinates — geometry
  • address — varchar(255)

notification

  • id — uuid — Primary key — NOT NULL
  • type — text — NOT NULL
  • to — text — NOT NULL
  • from — text
  • created_at — timestamp
  • checked — timestamp
  • noti_type — text
  • workboard_id — bigint
  • message_id — uuid
  • calendar_id — bigint

place

  • id — bigint — Primary key
  • name — varchar(255)
  • address1 — text
  • address2 — text
  • address3 — text
  • address4 — text
  • address5 — text
  • address_detail — text
  • coordinates — geometry
  • created_at — timestamp
  • chainz_user_id — uuid — NOT NULL

place_file

  • id — bigint — Foreign key → place.id — NOT NULL
  • originalname — text
  • key — text
  • location — text
  • mimetype — text
  • size — float8
  • created_at — timestamp

place_group

  • id — bigint — Primary key
  • name — varchar(255)

place_group_item

  • id (place_id) — bigint — Foreign key → place.id
  • id (place_group_id) — bigint — Foreign key → place_group.id

place_member

  • id (place_id) — bigint — Foreign key → place.id — NOT NULL
  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • status — int4
  • type — int4

recommend_place

  • id — bigint — Primary key
  • id (place_id) — bigint — Foreign key → place.id

role

  • id — int4 — Primary key — NOT NULL
  • name — varchar(10)
  • permit — int4

sensor_list

  • id — bigint — Primary key — NOT NULL
  • category_id — int — Foreign key → Untitled.Key — NOT NULL
  • type_id — bigint — Foreign key → Untitled.Key — NOT NULL
  • protocol_id — bigint — Foreign key → sensor_protocol.id — NOT NULL
  • name — text
  • description — text
  • sensor_id — text — NOT NULL
  • latitude — double
  • longitude — double
  • created_at — timestamp
  • updated_at — timestamp
  • status — int

sensor_protocol (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • (type) — text

user

  • id — uuid — Primary key — NOT NULL
  • id (status_id) — int4 — Foreign key → user_status.id — NOT NULL
  • name — varchar(255)
  • phone — varchar(128) — NOT NULL
  • email — varchar(255) — NOT NULL
  • role_id — int4 — NOT NULL
  • country_id — int4 — NOT NULL
  • status_msg — text
  • created_at — timestamp
  • deleted_at — timestamp
  • verified — int4
  • active — int4
  • last_login — timestamp
  • language — text
  • business_reg_num — text

user_fcmtoken

  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • token — text
  • device_id — text
  • platform — text
  • device_model — text
  • device_version — text
  • app_version — text
  • reg_date — timestamp
  • mod_date — timestamp
  • login — boolean
  • badge — int4 — NOT NULL
  • notification — int4 — NOT NULL
  • start_time — time — NOT NULL
  • end_time — time — NOT NULL

user_member

  • member_id — uuid — Primary key
  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • status — int4

user_picture_file

  • user_id — uuid — Foreign key → user.id — NOT NULL
  • originalname — text
  • key — text
  • location — text
  • mimetype — text
  • created_at — timestamp
  • size — float8

user_place_favorite

  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • id (place_id) — bigint — Foreign key → place.id
  • id (place_group_id) — bigint — Foreign key → place_group.id

user_place_group

  • id (place_group_id) — bigint — Foreign key → place_group.id
  • id (user_id) — uuid — Foreign key → user.id — NOT NULL

user_status

  • id — int4 — Primary key — NOT NULL
  • name — text

verify_code

  • key — text — Primary key — NOT NULL
  • date — timestamp — NOT NULL
  • code — varchar(6) — NOT NULL
  • expiredSec — int — NOT NULL
  • success — boolean — NOT NULL
  • success_time — timestamp

workboard

  • id — bigint — Primary key
  • id (area_id) — bigint — Foreign key → area.id
  • id (place_id) — bigint — Foreign key → area.id
  • name — varchar(255)
  • description — text
  • protected — boolean
  • status — int4
  • created_at — timestamp
  • closed_at — timestamp
  • restored_at — timestamp
  • calendar_bg — varchar(13)

workboard_announcement

  • id — bigint — Primary key
  • id (workboard_id) — bigint — Foreign key → workboard.id
  • user_id — uuid — NOT NULL
  • content — text
  • created_at — timestamp
  • updated_at — timestamp
  • show — boolean

workboard_announcement_file

  • id (workboard_announcement_id) — bigint — Foreign key → workboard_announcement.id
  • originalname — text
  • key — text
  • location — text
  • mimetype — text
  • size — float8
  • created_at — timestamp

workboard_bookmark

  • message_id — uuid — Primary key — NOT NULL
  • id (workboard_id) — bigint — Foreign key → workboard.id
  • created_at — timestamp

workboard_participant

  • id (workboard_id) — bigint — Foreign key → workboard.id
  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • host — boolean
  • status — int4
  • favorite — boolean
  • alarm — boolean
  • visited_at — timestamp

workboard_sensor (Untitled2)

  • workboard_id — bigint — Foreign key → workboard.id
  • sensor_id — text — Foreign key → sensor_list.id — NOT NULL