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