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