newro

Tables (14)

Untitled (MANAGER_INFO)

  • Key (MANAGER_SN) — INT — Primary key — NOT NULL
  • Field (MANAGER_NM) — VARCHAR
  • Field2 (MANAGER_ID) — VARCAHR
  • Field3 (MANAGER_PWD) — VARCAHR
  • Field4 (MANAGER_PWD_SALT) — VARCAHR
  • Field5 (MANAGER_MOBILE) — VARCAHR
  • Field6 (MANAGER_EMAIL) — VARCAHR
  • Field7 (MANAGER_COMPANY) — VARCAHR
  • Field8 (MANAGER_POSTION) — VARCAHR
  • Field9 (MANAGER_SUB) — VARCAHR
  • Field10 (CREATE_DT) — VARCHAR

Untitled (CODE_INFO)

  • Key (CD_ID) — INT — Primary key — NOT NULL
  • Field (CD_NM) — VARCHAR
  • Field2 (CD_VALUE) — VARCHAR
  • Field3 (GROUP_ID) — VARCHAR
  • Field4 (GROUP_NM) — VARCHAR
  • Field5 (CD_MEMO) — VARCHAR

Untitled (USER_INFO)

  • Key (USER_SN) — INT — Primary key — NOT NULL
  • Field (USER_EMAIL) — VARCAHR
  • Field2 (USER_HP_UID) — VARCHAR
  • Field3 (USER_TOKEN_UID) — VARCHAR
  • Field4 (USER_PUSH_KEY) — VARCHAR
  • Field5 (USER_CREATE_DT) — VARCHAR
  • Field (USER_IPHONE_YN) — CHAR
  • Field (USER_IMAGE_PATH) — VARCHAR

Untitled (LOCK_INFO)

  • Key (LOCK_SN) — INT — Primary key — NOT NULL
  • Key (IOKEY_INSTL_USER_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (LOCK_NM) — VARCHAR
  • Field (LOCK_CREATE_DT) — VARCHAR
  • Field (LOCK_MAP_X) — VARCHAR
  • Field (LOCK_MAP_Y) — VARCHAR
  • Field (IOKEY_NM) — VARCHAR
  • Field (IOKEY_MAC_ADDR) — VARCHAR
  • Field (IOKEY_TMP_PASS) — TEXT
  • Field (IOKEY_INSTL_COMP_DT) — VARCHAR
  • Field (IOKEY_MODEL) — VARCHAR
  • Field (IOKEY_ENC_KEY) — VARCHAR

Untitled (USER_FCLT_MPNG)

  • Key (LOCK_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (USER_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (ROLL_CD) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (NICK_NAME) — VARCHAR
  • Field2 (INOUT_LOG_PUSH_YN) — CHAR
  • Field3 (EVENT_LOG_PUSH_YN) — CHAR
  • Field4 (TMPKEY_USE_YN) — CHAR
  • Field (LOG_VIEW_YN) — CHAR

Untitled (USER_FCLT_USE_LOG)

  • Key (USER_FCLT_USE_LOG_SN) — INT — Primary key — NOT NULL
  • Key (LOG_CD) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (LOCK_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (LOG_DATE) — VARCHAR
  • Field (LOG_SORT_CD) — VARCHAR
  • Field (LOG_MSG) — VARCHAR

Untitled (USER_INVITE_INFO)

  • Key (INVITE_CODE) — VARCHAR — Primary key — NOT NULL
  • Key (ROLL_CD) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (LOCK_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (SEND_USER_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (INVITE_NICK_NAME) — VARCHAR
  • Field (SCHDULE_EFCT_START_DT) — VARCHAR
  • Field (SCHDULE_EFCT_END_DT) — VARCHAR
  • Field (SCHDULE_ROUTINE_YN) — CHAR
  • Field (SCHDULE_DAY_OF_WEEK) — VARCHAR
  • Field (SCHDULE_EFCT_START_TIME) — VARCHAR
  • Field (SCHDULE_EFCT_END_TIME) — VARCHAR
  • Field (INVITE_START_DT) — VARCHAR
  • Field (INVITE_END_DT) — VARCHAR
  • Field (INVITE_COMPLATE_DT) — VARCHAR

Untitled (SCHEDULE_INFO)

  • Key (LOCK_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (USER_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (EFCT_START_DT) — VARCHAR
  • Field (EFCT_END_DT) — VARCHAR
  • Field (ROUTINE_YN) — CHAR
  • Field (DAY_OF_WEEK) — VARCHAR
  • Field (EFCT_START_TIME) — VARCHAR
  • Field (EFCT_END_TIME) — VARCHAR
  • Field (CREATE_DT) — VARCHAR

Untitled (HELP_INFO)

  • Key (HELP_SN) — INT — Primary key — NOT NULL
  • Field (HELP_NM) — VARCHAR
  • Field2 (HELP_DATE) — VARCHAR

Untitled (FQN_INFO)

  • Key (FQA_SN) — INT — Primary key — NOT NULL
  • Key (HELP_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (FQA_NM) — VARCHAR
  • Field2 (FQA_CONTENT) — VARCHAR
  • Field3 (FQA_DATE) — VARCHAR

Untitled (DOORMODEL_INFO)

  • Key (MODEL_SN) — INT — Primary key — NOT NULL
  • Field (MODEL_NM) — VARCHAR
  • Field2 (MODEL_IMG) — VARCHAR
  • Field3 (MODEL_DATE) — VARCHAR

Untitled (MANUAL_INFO)

  • Key (MANUAL_SN) — INT — Primary key — NOT NULL
  • Key (MODEL_SN) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (MANUAL_NM) — VARCHAR
  • Field2 (MANUAL_FILE) — VARCHAR
  • Field3 (MANUAL_DATE) — VARCHAR

Untitled (ENV_MANAGE_INFO)

  • Field (SERVER_VER) — VARCHAR
  • Field2 (ANDROID_VER) — VARCHAR
  • Field3 (IOS_VER) — VARCHAR
  • Field4 (HELP_TEL) — VARCAHR
  • Field5 (HELP_EMAIL) — VARCAHR

Untitled (USER_EMAIL_AUTH)

  • Key (EMAIL_AUTH_LINK) — VARCHAR — Primary key — NOT NULL
  • Key2 (EMAIL_SEND_DT) — VARCHAR — Primary key — NOT NULL
  • Key3 (USER_EMAIL) — VARCAHR — Primary key — NOT NULL
  • Field (EMAIL_USER_JOIN_YN) — CHAR
  • Field (EMAIL_CMPLT_DT) — VARCHAR
  • Field (USER_HP_UID) — VARCHAR
  • Field (USER_PUSH_KEY) — VARCHAR
  • Field (DYNAMIC_UID) — VARCHAR