nhn

Tables (4)

CONNECT_DEVICE (CONNECT_INFO)

  • Key (device_id) — long — Foreign key → DEVICE.Key — NOT NULL
  • Key (entrance_id) — long — Foreign key → ENTRANCE.Key — NOT NULL
  • Field (registe_date) — varchar

DEVICE

  • Key (id) — long — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (model) — varchar
  • Field (sdk_version) — varchar
  • Field (ssaid) — varchar
  • Field (uid) — varchar
  • Field (status) — varchar
  • Field (memo) — varchar

ENTRANCE

  • Key (id) — long — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (ip) — varchar
  • Field (position) — varchar
  • Field (guide_text) — varchar
  • Field (registrant) — varchar

VISITOR

  • Key (id) — long — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (cno) — varchar
  • Field (email) — varchar
  • Field2 (reason) — varchar
  • Field (face_id) — varchar
  • Field (id_card_sno) — varchar
  • Field (confirm_yn) — char
  • Field (regist_date) — varchar