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