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