베리어프리
테이블 (26)
TB_BRANCH
- BRN_ID — int — 기본 키 — NOT NULL
- BRN_SECT — nvarchar(10)
- BRN_TYPE — nvarchar(10)
- BRN_CODE — nvarchar(3)
- BRN_NAME — nvarchar(20)
- BRN_DESC — ntext
- PARKING_YN — nvarchar(1)
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_EVENT
- EVENT_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- EVENT_SECT — nvarchar(10)
- EVENT_TYPE — nvarchar(10)
- MAIN_CATE — nvarchar(10)
- EVENT_NAME — nvarchar(100)
- SCH_SDAY — nvarchar(8)
- SCH_EDAY — nvarchar(8)
- EVENT_STIME — nvarchar(8)
- EVENT_ETIME — nvarchar(8)
- PLAY_TIME — int
- EVENT_DESC — ntext
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_EVENT_FILE
- FILE_ID — int — 기본 키 — NOT NULL
- EVENT_ID — int — 외래 키 → TB_EVENT.EVENT_ID — NOT NULL
- FILE_SECT — nvarchar(10)
- FILE_TYPE — nvarchar(10)
- FILE_NAME — nvarchar(50)
- FILE_REALNAME — nvarchar(100)
- FILE_SIZE — int
- FILE_WIDTH — int
- FILE_HEIGHT — int
- FILE_EXT — nvarchar(10)
- FILE_PATH — nvarchar(100)
- DB_STATUS — nvarchar(1)
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_EVENT_ORDER
- INFO_ID — int — 기본 키 — NOT NULL
- SCH_ID — int — 외래 키 → TB_EVENT_SCH_GROUP.SCH_ID — NOT NULL
- EVENT_ID — int — 외래 키 → TB_EVENT.EVENT_ID — NOT NULL
- ORDER_NUM — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_EVENT_SCH_GROUP
- SCH_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- SCH_SECT — nvarchar(10)
- SCH_TYPE — nvarchar(10)
- SCH_NAME — nvarchar(50)
- SCH_COLOR — nvarchar(50)
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — smalldatetime
- UPD_DATE — smalldatetime
- DEL_DATE — smalldatetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_EVENT_SCH_KIOSK
- INFO_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- SCH_ID — int
- KIOSK_CODE — nvarchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_KIOSK
- KIOSK_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- STORE_ID — int
- KIOSK_SECT — nvarchar(10)
- KIOSK_TYPE — nvarchar(10)
- KIOSK_NAME — nvarchar(50)
- KIOSK_CODE — nvarchar(50)
- KIOSK_STATUS — nvarchar(1)
- KIOSK_PASSWD — nvarchar(10)
- KIOSK_DIRECT — nvarchar(1)
- KIOSK_DIVISION — nvarchar(50)
- FLOOR_CODE — nvarchar(5)
- POS_X — int
- POS_Y — int
- SCH_WEEK — nvarchar(100)
- SCH_TYPE — nvarchar(100)
- SCH_TIME — nvarchar(100)
- IP_ADDR — nvarchar(50)
- MAC_ADDR — nvarchar(50)
- KIOSK_CPU — int
- KIOSK_MEM — int
- FILE_PATH — nvarchar(100)
- SCREEN_SHOT — nvarchar(50)
- KIOSK_DESC — ntext
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- LAST_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_LOG_REPORT
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- KIOSK_CODE — nvarchar(50)
- LOG_SECT — nvarchar(10)
- LOG_TYPE — nvarchar(10)
- MENU_CODE — nvarchar(10)
- STORE_ID — int
- CON_ID — int
- LOG_DATE — nvarchar(8)
- LOG_CNT — int
- TIME_00 — int
- TIME_01 — int
- TIME_02 — int
- TIME_03 — int
- TIME_04 — int
- TIME_05 — int
- TIME_06 — int
- TIME_07 — int
- TIME_08 — int
- TIME_09 — int
- TIME_10 — int
- TIME_11 — int
- TIME_12 — int
- TIME_13 — int
- TIME_14 — int
- TIME_15 — int
- TIME_16 — int
- TIME_17 — int
- TIME_18 — int
- TIME_19 — int
- TIME_20 — int
- TIME_21 — int
- TIME_22 — int
- TIME_23 — int
TB_LOG_REPORT_TMP
- KIOSK_CODE — nvarchar(10)
- LOG_SECT — nvarchar(10)
- LOG_TYPE — nvarchar(10)
- MENU_CODE — nvarchar(10)
- STORE_ID — int
- CON_ID — int
- LOG_DATE — nvarchar(14)
- REG_DATE — datetime
TB_LOG_SPEECH
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- KIOSK_CODE — nvarchar(10)
- STATUS — nvarchar(10)
- LOG_DATE — nvarchar(40)
- TEXT — ntext
- INTENT — nvarchar(100)
- ENTITY — nvarchar(100)
- ERROR_CODE — nvarchar(100)
TB_MEMBER
- MEMBER_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- STORE_ID — int
- MEMBER_SECT — nvarchar(10)
- MEMBER_TYPE — nvarchar(10)
- MEMBER_IDNAME — nvarchar(100)
- MEMBER_NAME — nvarchar(50)
- MEMBER_PASSWD — nvarchar(300)
- MEMBER_AUTH — nvarchar(10)
- MEMBER_PHONE — nvarchar(50)
- MEMBER_DESC — ntext — NOT NULL
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- LOGIN_DATE — datetime
- PW_FST_STATUS — nvarchar(1)
- PW_CHG_DATE — datetime
- IS_KIOSK_AGREE — nchar(10)
- IS_PRIVATE_AGREE — nchar(10)
- IS_BIOINFO_AGREE — nchar(10)
- SMS_NUMBER — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_MEMBER_FILE
- FILE_ID — int — 기본 키 — NOT NULL
- MEMBER_ID — int — 외래 키 → TB_MEMBER.MEMBER_ID — NOT NULL
- FILE_SECT — nvarchar(10)
- FILE_TYPE — nvarchar(10)
- FILE_NAME — nvarchar(50)
- FILE_REALNAME — nvarchar(100)
- FILE_SIZE — int
- FILE_WIDTH — int
- FILE_HEIGHT — int
- FILE_EXT — nvarchar(10)
- FILE_PATH — nvarchar(100)
- DB_STATUS — nvarchar(1)
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_MEMBER_LOG
- LOG_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- MEMBER_ID — int — 외래 키 → TB_MEMBER.MEMBER_ID — NOT NULL
- LOG_SECT — nvarchar(10)
- LOG_TYPE — nvarchar(10)
- LOG_CODE — nvarchar(10)
- LOG_MSG — nvarchar(100)
- CODE_ID — int
- LOG_ACT — nvarchar(10)
- REMOTE_IP — nvarchar(50)
- REG_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_MEMBER_TMP
- SMS_NUMBER — int
- MEMBER_IDNAME — nvarchar(50)
TB_NODE
- NODE_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- NODE_NUM — int — NOT NULL
- SCENARIO_ID — int — NOT NULL
- NODE_DEPTH — int — NOT NULL
- PARENT_NODE — int
- INTENT — nvarchar(50)
- ENTITY — nvarchar(50)
- NODE_SECT — nvarchar(10)
- NODE_TYPE — nvarchar(10)
- NODE_NAME — nvarchar(50)
- NODE_DESC — ntext
- NODE_DESC_SIGN — ntext
- NODE_DESC_BRAILLE — ntext
- NODE_DESC_DISPLAY — ntext
- NODE_GROUP — int
- NODE_TOP — nvarchar(10)
- NODE_LEFT — nvarchar(10)
- SEARCH_SECT — nvarchar(10)
- MAIN_CATE_CODE — nvarchar(10)
- SUB_CATE_CODE — nvarchar(10)
- SEARCH_FLOOR — nvarchar(10)
- SEARCH_NAME — nvarchar(100)
- DISPLAY_ID — nvarchar(100)
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_NOTICE
- NOTICE_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- NOTICE_SECT — nvarchar(10)
- NOTICE_TYPE — nvarchar(10)
- MAIN_CATE — nvarchar(10)
- NOTICE_NAME — nvarchar(100)
- SCH_SDAY — nvarchar(8)
- SCH_EDAY — nvarchar(8)
- NOTICE_STIME — nvarchar(8)
- NOTICE_ETIME — nvarchar(8)
- PLAY_TIME — int
- NOTICE_DESC_KOR — ntext
- NOTICE_DESC_ENG — ntext
- NOTICE_DESC_CHN — ntext
- NOTICE_DESC_JPN — ntext
- NOTICE_DESC_KOR_EME — ntext
- NOTICE_DESC_ENG_EME — ntext
- NOTICE_DESC_CHN_EME — ntext
- NOTICE_DESC_JPN_EME — ntext
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_OPTION
- OPTION_ID — int — 기본 키 — NOT NULL
- NODE_ID — int — 외래 키 → TB_NODE.NODE_ID — NOT NULL
- OPTION_NUM — int — NOT NULL
- OPTION_SECT — nvarchar(10)
- OPTION_TYPE — nvarchar(10)
- OPTION_NAME — nvarchar(50)
- OPTION_DESC — ntext
- OPTION_CHILDRENS — nvarchar(500)
- DB_STATUS — nvarchar(1)
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_PROGRAM
- PROGRAM_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- PROGRAM_SECT — nvarchar(10)
- PROGRAM_TYPE — nvarchar(10)
- PROGRAM_NAME — nvarchar(100)
- PROGRAM_ARGUMENT — nvarchar(50)
- PROGRAM_WORKPATH — nvarchar(50)
- PROGRAM_DESC — nvarchar(200)
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_PROGRAM_FILE
- FILE_ID — int — 기본 키 — NOT NULL
- PROGRAM_ID — int — 외래 키 → TB_PROGRAM.PROGRAM_ID — NOT NULL
- FILE_SECT — nvarchar(10)
- FILE_TYPE — nvarchar(10)
- FILE_NAME — nvarchar(100)
- FILE_REALNAME — nvarchar(200)
- FILE_VER — nvarchar(50)
- FILE_VER_DESC — nvarchar(200)
- FILE_SIZE — int
- FILE_EXT — nvarchar(10)
- USE_YN — nvarchar(1)
- FILE_PATH — nvarchar(200)
- DB_STATUS — nvarchar(1)
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_PUBLIC
- PUBLIC_ID — int — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- PUBLIC_SECT — nvarchar(100)
- PUBLIC_TYPE — nvarchar(10)
- PUBLIC_CATE — nvarchar(100)
- MOVE_FLOOR — nvarchar(100)
- MOVE_DIRECTION — nvarchar(10)
- FLOOR_CODE — nvarchar(10)
- PUBLIC_NAME — nvarchar(50)
- PUBLIC_STATUS — nvarchar(10)
- PUBLIC_AREA — nvarchar(20)
- PUBLIC_INFO — nvarchar(100)
- SUB_CATE — nvarchar(50)
- POS_X — int
- POS_Y — int
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
TB_SCENARIO
- SCENARIO_ID — int — 기본 키 — NOT NULL
- BRN_ID (BRN_ID2) — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- SCENARIO_SECT — nvarchar(10)
- SCENARIO_TYPE — nvarchar(10)
- MAIN_CATE — nvarchar(10)
- SCENARIO_NAME — nvarchar(100)
- SCH_SDAY — nvarchar(8)
- SCH_EDAY — nvarchar(8)
- SCENARIO_STIME — nvarchar(8)
- SCENARIO_ETIME — nvarchar(8)
- PLAY_TIME — int
- SCENARIO_DESC — ntext
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_SETTING
- SET_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- SET_SECT — nvarchar(10)
- SET_TYPE — nvarchar(10)
- SET_CODE — nvarchar(50)
- SET_DIVISION — nvarchar(50)
- FILE_NAME — nvarchar(50)
- FILE_REALNAME — nvarchar(200)
- FILE_SIZE — int
- FILE_WIDTH — int
- FILE_HEIGHT — int
- FILE_EXT — nvarchar(10)
- FILE_PATH — nvarchar(200)
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_STORE
- STORE_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- STORE_SECT — nvarchar(10)
- STORE_TYPE — nvarchar(10)
- STORE_NAME_KOR — ntext
- STORE_NAME_ENG — ntext
- STORE_NAME_CHN — ntext
- STORE_NAME_JPN — ntext
- POP_STATUS — nvarchar(1)
- RS_STATUS — nvarchar(1)
- RS_BREAK_STATUS — nvarchar(1)
- STORE_CODE — nvarchar(10)
- CATE_CODE — nvarchar(10)
- SUBCATE_CODE — nvarchar(10)
- FLOOR_CODE — nvarchar(10)
- DISPLAY_TYPE — nvarchar(5)
- CLICK_TYPE — nvarchar(5)
- SEARCH_TYPE — nvarchar(5)
- STORE_SERVICETIME — nvarchar(100)
- STORE_WEEKENDTIME — nvarchar(100)
- STORE_ORDERTIME — nvarchar(100)
- STORE_BREAKTIME — nvarchar(100)
- STORE_PHONE — nvarchar(50)
- FONT_SIZE — int
- POS_X — int
- POS_Y — int
- POS_HELP_X — int
- POS_HELP_Y — int
- STORE_DESC_KOR — ntext
- STORE_DESC_ENG — ntext
- STORE_DESC_CHN — ntext
- STORE_DESC_JPN — ntext
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- LAST_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_STORE_FILE
- FILE_ID — int — 기본 키 — NOT NULL
- STORE_ID — int — 외래 키 → TB_STORE.STORE_ID — NOT NULL
- FILE_SECT — nvarchar(10)
- FILE_TYPE — nvarchar(10)
- FILE_NAME — nvarchar(50)
- FILE_REALNAME — nvarchar(200)
- FILE_SIZE — int
- FILE_WIDTH — int
- FILE_HEIGHT — int
- FILE_EXT — nvarchar(10)
- FILE_PATH — nvarchar(100)
- DB_STATUS — nvarchar(1)
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_USER
- USER_ID — int — 기본 키 — NOT NULL
- BRN_ID (BRN_ID2) — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- STORE_ID — int
- USER_SECT — nvarchar(10)
- USER_TYPE — nvarchar(10)
- USER_IDNAME — nvarchar(100)
- USER_NAME — nvarchar(50)
- USER_PASSWD — nvarchar(300)
- USER_AUTH — nvarchar(10)
- USER_PHONE — nvarchar(50)
- USER_DESC — ntext — NOT NULL
- DB_STATUS — nvarchar(1)
- REG_ID — int
- UPD_ID — int
- DEL_ID — int
- REG_DATE — datetime
- UPD_DATE — datetime
- DEL_DATE — datetime
- LOGIN_DATE — datetime
- PW_FST_STATUS — nvarchar(1)
- PW_CHG_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TB_USER_LOG
- LOG_ID — int — 기본 키 — NOT NULL
- BRN_ID — int — 외래 키 → TB_BRANCH.BRN_ID — NOT NULL
- USER_ID — int
- LOG_SECT — nvarchar(10)
- LOG_TYPE — nvarchar(10)
- LOG_CODE — nvarchar(10)
- LOG_MSG — nvarchar(100)
- CODE_ID — int
- LOG_ACT — nvarchar(10)
- REMOTE_IP — nvarchar(50)
- REG_DATE — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =