VMA_SYSTEM
Tables (13)
CorpInfo (tb_corpinfo)
- id (object id) — object — Primary key — NOT NULL
- code_corp (사업자 코드) — integer — Primary key — NOT NULL
- managers (관리자 목록) — json
- Field
Userinfo (tb_userinfo)
- id (object id) — object — Primary key — NOT NULL
- userid (email or id) — text — Primary key — NOT NULL
- password — text
- joindate (join date) — datetime
- code_nation (nation code) — integer
- code_corp (corporation code) — integer
- name (이름) — text
- id_telegram (텔레그램 id) — text
- ukey
- id (object id2) — object — Foreign key → CorpInfo.id — NOT NULL
- code_corp (사업자 코드) — integer — Foreign key → CorpInfo.code_corp — NOT NULL
admin_telegram (tb_admin_telegram)
- id (object id) — object — Primary key — NOT NULL
- id_t (텔레그램 id) — text — Primary key — NOT NULL
- first_name (이름) — text
- last_name (성) — text
- Field
black_ip
- id (object id) — object — Primary key — NOT NULL
- ip (ipaddress) — text — Primary key — NOT NULL
- type — integer
- name — text
gwinfo (tb_gwinfo)
- id (object id) — object — Primary key — NOT NULL
- gwid (gateway id) — text — Primary key — NOT NULL
- id (object id2) — object — Foreign key → black_ip.id — NOT NULL
- ip (ipaddress) — text — Foreign key → black_ip.ip — NOT NULL
- joindate (join date) — datetime
- code_nation (nation code) — integer
- code_corp (corporation code) — integer
- ip (ip address) — text
- status_conn (연결 상태) — integer
- address (주소 또는 위치) — text
- Field
msg (tb_msg)
- id (object id) — object — Primary key — NOT NULL
- msgid (message id) — integer — Primary key — NOT NULL
- code_corp (사업자 코드) — integer
- type (기상, 일반메시지, sos 등) — integer
- issueddate (메시지 발생 날짜) — datetime
- receivedate (메시지 수신 시각(서버기준)) — datetime
- rfid (RF id (목적지 또는 출발지)) — integer
- owner (발생지 (서버 or 선박 등)) — integer
- validstatus (유효상태) — Boolean
- ref (기상메시지 상세) — json — Foreign key → weather_msg reference.ref — NOT NULL
- ref2 (일반메시지 상세) — json — Foreign key → n_msg reference.ref2 — NOT NULL
n_msg reference (json_ref_n_msg)
- ref2 (Key) — Primary key — NOT NULL
- txtMsg (매시지 내용) — text
- subtype (메시지분류) — integer
usage_gw_info
- id (object id) — object — Primary key — NOT NULL
- gwid (gateway id) — text — Primary key — NOT NULL
- id (object id2) — object — Foreign key → vessel_status_lastest.id — NOT NULL
- rfid (RF id) — integer — Foreign key → vessel_status_lastest.rfid — NOT NULL
- rssi_lv (rssi level) — integer
vessel_info (tb_vessel_info)
- id (object id) — object — Primary key — NOT NULL
- vid (vessel id) — integer — Primary key — NOT NULL
- rfid (어선 RF id) — integer
- code_nation (국가 코드) — integer
- code_corp (사업자 코드) — integer
- name (선박 이름) — text
- name_owner (선주 이름) — text
- phone_owner (선주 전화번호) — text
- cell_phone_owver (선주 폰번호) — text
- port_name (등록 항구 이름) — text
- port_address (등록 항구 주소) — text
- crew_cnt (선원 수) — integer
- total_ton (선박급 (톤)) — float
- creationtime (Field)
- rfid (최근상태 링크) — integer — Foreign key → vessel_status_lastest.rfid — NOT NULL
- vid (vessel id2) — integer — Foreign key → vessel_reginfo.vid — NOT NULL
vessel_reginfo (tb_vessel_reginfo)
- id (object id) — object — Primary key — NOT NULL
- vid (vessel id) — integer — Primary key — NOT NULL
- rfid (rf id) — integer
- regdate (최초 등록 날짜) — datetime
- updatedate (갱신 날짜) — datetime
- validdate (유효기간) — datetime
- validstatus (유효상태) — Boolean
- Field
vessel_status_lastest (tb_vessel_pos_lastest)
- id (object id) — object — Primary key — NOT NULL
- rfid (RF id) — integer — Primary key — NOT NULL
- latitude (위도 (도단위)) — float
- longitude (경도(도단위)) — float
- speed (속도(knot)) — float
- heading (방향) — integer
- batt (배터리 잔량(%)) — integer
- status_port (입출항상태) — integer
- sos (sos 상태) — Boolean
- fwver (revision) — text
- usage_gw (array) — json arr
- status_service (enable/disable) — text
vessel_status_log (CopyOftb_vessel_pos_lastest)
- id (object id) — object — Primary key — NOT NULL
- rfid (RF id) — integer
- latitude (위도 (도단위)) — float
- longitude (경도(도단위)) — float
- speed (속도(knot)) — float
- heading (방향) — integer
- batt (배터리 잔량(%)) — integer
- status_port (입출항상태) — integer
- sos (sos 상태) — Boolean
- fwver (revision) — text
- Field
- rfid (RF id..) — integer — Foreign key → vessel_info.id — NOT NULL
weather_msg reference (json_ref_weather_msg)
- ref (Key) — Primary key — NOT NULL
- icon (날씨 아이콘) — integer
- precipitation_amount (강수량(mm)) — integer
- temperature (기온(섭씨)) — integer
- wind_direction (풍향) — text(3)
- wind_speed (Field) — Integer
- humidity (습도(%)) — integer
- wave_height (파고(m)) — integer
- txtMsg (메시지내용) — text
- command (메시지구별) — Integer