test
Tables (36)
TH_BASS_APP_LOG_HIST
- LOG_SN — CHARACTER — Primary key — NOT NULL
- REQ_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- REQ_URI — CHARACTER — NOT NULL
- ATTR_VAL1 — CHARACTER
- ATTR_VAL2 — CHARACTER
TH_BASS_MEMBER_AGRE_HIST
- MEMBER_ID — CHARACTER — Foreign key → TN_BASS_MEMBER_INFO.MEMBER_ID — NOT NULL
- AGRE_IEM_CODE — CHARACTER — NOT NULL — 서비스이용동의, 개인정보이용동의 구성 항목
- AGRE_AT — CHARACTER — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TH_BASS_MEMBER_WRKPLC_HIST
- MEMBER_ID — CHARACTER — Primary key — NOT NULL
- BLDG_ID — CHARACTER — Primary key — NOT NULL — 빌딩그룹 : 그룹ID
- FLOOR_ID — CHARACTER — Primary key — NOT NULL
- SPCE_ID — CHARACTER — Primary key — NOT NULL
- MAIN_WRKPLC_AT — CHARACTER — NOT NULL — default 'N'
- CHOISE_WRKPLC_AT — CHARACTER — NOT NULL — default 'N'
- CHOISE_DT — TIMESTAMP — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TH_BASS_PUSH_RECPTN_HIST
- MEMBER_ID — CHARACTER — Primary key — NOT NULL
- PUSH_SN — CHARACTER
- PUSH_SJ — CHARACTER — NOT NULL
- PUSH_CN — CHARACTER — NOT NULL
- PROCESS_TY — CHARACTER — NOT NULL — 확인 : C , 삭제 : D, 미확인:U
- SEND_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- CNFIRM_DT — TIMESTAMP — YYYYMMDDHHmm
- DELETE_DT — TIMESTAMP
- SVC_MENU_ID — CHARACTER — model param custom1으로 보냄
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP
- CUSTOM2 — CHARACTER — 해당 서비스 key 값
TH_BASS_SMS_CRTFC_HIST
- MOBL_PHON_NO — CHARACTER — NOT NULL
- SMS_CRTFC_NO — CHARACTER — NOT NULL
- CRTFC_REQUST_TIME — DATE — NOT NULL
- CRTFC_AT — CHARACTER — NOT NULL — default 'N'
- CRTFC_TIME — DATE
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
TH_BASS_WETHER_FRCST_1H_HIST
- GRID_X — CHARACTER — Primary key — NOT NULL
- GRID_Y — CHARACTER — Primary key — NOT NULL
- COLCT_DT — CHARACTER — Primary key — NOT NULL — YYYYMMDDHH24MI
- T1H — CHARACTER
- RN1 — CHARACTER
- SKY — CHARACTER
- UUU — CHARACTER
- VVV — CHARACTER
- REH — CHARACTER
- PTY — CHARACTER
- LGT — CHARACTER
- VEC — CHARACTER
- WSD — CHARACTER
- DATA_TY — CHARACTER — NOT NULL — 기상청수집: 1, 데이터복제 : 2
- BASE_DATE — CHARACTER — NOT NULL — 기상청 발표일자
- BASE_TIME — CHARACTER — NOT NULL — 기상청 발표시간
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
TH_BASS_WETHER_FRCST_3H_HIST
- GRID_X — CHARACTER — Primary key — NOT NULL
- GRID_Y — CHARACTER — Primary key — NOT NULL
- COLCT_DT — CHARACTER — Primary key — NOT NULL — YYYYMMDDHH24MI
- POP — CHARACTER
- PTY — CHARACTER
- R06 — CHARACTER
- REH — CHARACTER
- S06 — CHARACTER
- SKY — CHARACTER
- T3H — CHARACTER
- TMN — CHARACTER
- TMX — CHARACTER
- UUU — CHARACTER
- VVV — CHARACTER
- WAV — CHARACTER
- VEC — CHARACTER
- WSD — CHARACTER
- DATA_TY — CHARACTER — NOT NULL — 기상청수집: 1, 데이터복제 : 2
- BASE_DATE — CHARACTER — NOT NULL — 기상청 발표일자
- BASE_TIME — CHARACTER — NOT NULL — 기상청 발표시간
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
TH_FAA_BBS_GOOD_HIST
- MEMBER_ID — CHARACTER — Primary key — NOT NULL
- POST_ID — CHARACTER — Foreign key → TN_FAA_BBS.POST_ID — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
TH_FAA_BBS_READER_HIST
- READER_ID — CHARACTER — Primary key — NOT NULL
- WRTER_ID — CHARACTER — Primary key — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
TH_FAA_MEMBER_LEND_HIST
- LEND_HIST_SN — CHARACTER — Primary key — NOT NULL
- BLDG_ID — CHARACTER — NOT NULL
- IEM_NO — CHARACTER — NOT NULL
- IEM_TY_CODE — CHARACTER — NOT NULL
- BLDG_GROUP_ID — CHARACTER
- LEND_STTUS_CODE — CHARACTER — NOT NULL — 접수: 1, 대여: 2, 취소: 3 , 반납: 4, 시간초과취소:5
- APLY_DT — TIMESTAMP — NOT NULL
- APLY_END_DT — TIMESTAMP — YYYYMMDDHH24mi
- LEND_DT — TIMESTAMP — YYYYMMDDHH24mi
- RTURN_PREARNGE_DT — TIMESTAMP — YYYYMMDDHH24mi
- RTURN_DT — TIMESTAMP — YYYYMMDDHH24mi
- CANCEL_DT — TIMESTAMP — YYYYMMDDHH24mi
- LENDER_ID — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHH24mi
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHH24mi
TH_FAA_VOC_RCEPT_HIST
- VOC_RCEPT_NO — CHARACTER — Primary key — NOT NULL — VOC 접수번호
- VOC_MANAGE_UNIT — CHARACTER — VOC 관리단위
- AG_BLDG_ID — CHARACTER — 엣지건물ID
- BLDG_ID — CHARACTER
- FLOOR_ID — CHARACTER — 엣지코드
- FLOOR_NM — CHARACTER
- SPAC_CODE — CHARACTER — 엣지코드
- SPAC_DETAIL_INFO — CHARACTER
- RCEPT_DETAIL_INFO — CHARACTER — 더할말 있어요
- RCEPT_CHNL_CODE — CHARACTER — 엣지에서 모바일 코드 신규 생성예정
- RCEPT_DIV_CODE — CHARACTER — 엣지코드 접수경로 (VOC:11)
- VOC_PROC_STAT — CHARACTER — 엣지코드
- APLCNT_ID — CHARACTER — NOT NULL
- APLCNT_NM — CHARACTER — 엣지 신고자명
- MOBLPHON_NO — CHARACTER
- REQUST_CMPNY_DETAIL — CHARACTER
- CSTMR_TY_CODE — CHARACTER — 엣지코드
- VOC_TY_CODE — CHARACTER — 엣지코드
- EQP_TY_CODE — CHARACTER — 엣지코드
- RCEPT_DT — TIMESTAMP — YYYYMMDDHHmm
- PROCESS_COMPT_DT — TIMESTAMP — YYYYMMDDHHmm
- PROCESS_RESULT — CHARACTER — 처리결과내용
- RESULT_IMG1 — CLOB
- RESULT_IMG2 — CLOB
- RESULT_IMG3 — CLOB
- RESULT_IMG4 — CLOB
- SENARIO_ID — CHARACTER
- SENARIO_NM — CHARACTER — 요청내용
- MEMBER_EVL_SCORE — CHARACTER — 별점: 0~5
- MEMBER_STSFDG_CN — CHARACTER — 사용자 만족도 내용
- OPETR_CODE — CHARACTER — 엣지코드
- SVC_MENU_ID — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
- INPUT_FLOOR_NM — CHARACTER — 사용자가 입력한 층 정보
- FLOOR_TY — CHARACTER
- ZXSTAT — CHARACTER
- ZXMSGS — CHARACTER
TH_FAA_VOTE_FEED_HIST
- VOTE_SN — CHARACTER — Foreign key → TN_FAA_VOTE_MASTER.VOTE_SN — NOT NULL
- FEED_CN — CHARACTER — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
TH_FAA_VOTE_PARTCPTN_HIST
- VOTE_HIST_SN — CHARACTER — Primary key — NOT NULL
- VOTE_SN — CHARACTER — NOT NULL
- IEM_ID — CHARACTER — NOT NULL
- MEMBER_ID — CHARACTER — NOT NULL
- VOTE_DT — TIMESTAMP — YYYYMMDDHHmm
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_ATCH_FILE_INFO
- ATCH_GROUP_ID — CHARACTER
- FILE_SN — CHARACTER
- FILE_NM — CHARACTER
- FILE_DATA — CLOB
- SORT_ORDR — NUMERIC(3, 0)
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_BLDG_ADI_INFO
- BLDG_ID — CHARACTER — Foreign key → TN_BASS_BLDG_GROUP_INFO.BLDG_GROUP_ID — NOT NULL — 빌딩그룹 : 그룹ID
- BLDG_NM — CHARACTER — NOT NULL
- ADRES — CHARACTER
- OWNER_NM — CHARACTER
- LA — CHARACTER — NOT NULL — 자리수 변경
- LO — CHARACTER — NOT NULL — 자리수 변경
- GRID_X — CHARACTER — 기상청 위도 격자
- GRID_Y — CHARACTER — 기상청 경도 격자
- ATCH_GROUP_ID — CHARACTER
- DEPT_NM — CHARACTER
- BPLC_NM — CHARACTER
- VOC_MNGMT_UNIT — CHARACTER
- AG_BLDG_ID — CHARACTER
- HELP_DESK_TEL — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_BLDG_FLOOR_INFO
- BLDG_GROUP_ID — CHARACTER — Foreign key → TN_BASS_BLDG_GROUP_INFO.BLDG_GROUP_ID — NOT NULL — 빌딩그룹 : 그룹ID
- AG_FLOOR_TY — CHARACTER — F1, F2 .... B1, B2
- AG_FLOOR_ID — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_BLDG_GROUP_INFO
- BLDG_GROUP_ID — CHARACTER — Primary key — NOT NULL — 빌딩, 층, 공간 ID
- BLDG_GROUP_NM — CHARACTER — NOT NULL
- BLDG_GROUP_LEVEL_CODE — CHARACTER — NOT NULL — 90: 빌딩그룹, 100: 빌딩, 110: 층, 120: 공간
- PARNTS_GROUP_ID — CHARACTER
- SORT_ORDR — NUMERIC(3, 0)
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_BLDG_NOTICE
- NOTICE_ID — CHARACTER — Primary key — NOT NULL
- NOTICE_SJ — CHARACTER — NOT NULL
- NOTICE_CN — CHARACTER — NOT NULL
- BLDG_ID — CHARACTER
- DISP_AT — CHARACTER — NOT NULL — default 'N'
- ATCH_IMAGE_ID — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_BLDG_SPCE_INFO
- SPCE_ID — CHARACTER — Foreign key → TN_BASS_BLDG_GROUP_INFO.BLDG_GROUP_ID — NOT NULL — 빌딩그룹 : 그룹ID
- TAG_ID — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_BLDG_STORE_INFO
- STORE_ID — CHARACTER — Primary key — NOT NULL
- BLDG_ID — CHARACTER — Foreign key → TN_BASS_BLDG_GROUP_INFO.BLDG_GROUP_ID — NOT NULL
- STORE_TY_CODE — CHARACTER — NOT NULL — 식당/아케이드: 01,편의/기타: 02
- STORE_NM — CHARACTER — NOT NULL
- LC_NM — CHARACTER
- TEL — CHARACTER
- SORT_ORDR — NUMERIC(3, 0) — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_BLDG_SVC_MENU
- BLDG_ID — CHARACTER — Foreign key → TN_BASS_BLDG_GROUP_INFO.BLDG_GROUP_ID — NOT NULL — 빌딩그룹 : 그룹ID
- SVC_MENU_ID — CHARACTER — Foreign key → TN_BASS_MOBILE_SVC_MENU.SVC_MENU_ID — NOT NULL — 공통코드로 생성 후 취사 선택
- USE_AT — CHARACTER — NOT NULL — default 'Y'
- DISP_AT — CHARACTER — NOT NULL — default 'Y'
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_MEMBER_INFO
- MEMBER_ID — CHARACTER — Primary key — NOT NULL — 비밀번호 변경을 이메일로 할 경우 MEMBER_ID 사이즈를 CARATER VARING 50으로 변경
- PASSWORD — CHARACTER — NOT NULL
- MEMBER_NM — CHARACTER — NOT NULL
- MEMBER_NC_NM — CHARACTER — NOT NULL
- PROFILE_PICTURE — CLOB
- MOBL_PHON_NO — CHARACTER — NOT NULL
- GENDER — CHARACTER — NOT NULL — 남자: M, 여자: F
- MEMBER_TY_CODE — CHARACTER — NOT NULL — 공간매니저 : 10000 서비스매니저: 20000 콜센터관리자: 31000 특수관계자 : 32000 일반사용자 : 40000
- MVN_CMPNY_CODE — CHARACTER
- ATMC_LOGIN_AT — CHARACTER — NOT NULL — default 'N'
- DRMNCY_AT — CHARACTER — NOT NULL — default 'N' <-일배치 고려
- DRMNCY_APPN_DT — TIMESTAMP — YYYYMMDDHHmm
- LAST_LOGIN_DT — TIMESTAMP — YYYYMMDDHHmm
- RSA_KEY — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
- USE_AT — CHARACTER — NOT NULL
- SECESSION_AT — CHARACTER — NOT NULL
- SECESSION_DT — TIMESTAMP
TN_BASS_MEMBER_PUSH_RECPTN_TRGTER_INFO
- MEMBER_ID — CHARACTER — Foreign key → TN_BASS_MEMBER_INFO.MEMBER_ID — NOT NULL
- PUSH_TY_CODE — CHARACTER — NOT NULL — PH001:더워요추워요, PH002:내자리톡톡
- PUSH_AT — CHARACTER — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
TN_BASS_MEMBER_TOKEN_INFO
- MEMBER_ID — CHARACTER — Primary key — NOT NULL
- TOKEN — VARCHAR(200) — NOT NULL
- TOKEN_TY — CHARACTER — NOT NULL — FCM : 1, JWT : 2
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP
TN_BASS_MOBILE_SVC_MENU
- SVC_MENU_ID — CHARACTER — Primary key — NOT NULL — 공통코드로 생성 후 취사 선택
- SVC_NM — CHARACTER — NOT NULL
- SVC_DC — CHARACTER
- SORT_ORDR — NUMERIC(3, 0) — NOT NULL
- USE_AT — CHARACTER — NOT NULL — default 'Y'
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_BASS_TMPR_PASSWORD_ISSU
TN_FAA_APP_VERSION
- PLATFORM_TYPE — CHARACTER — NOT NULL — android, iOS
- PACKAGE_VERSION — CHARACTER — NOT NULL
- DOWNLOAD_URL — CHARACTER
TN_FAA_BBS
- POST_ID — CHARACTER — Primary key — NOT NULL
- WRTER_ID — CHARACTER — NOT NULL
- BLDG_GROUP_ID — CHARACTER
- POST_SJ — CHARACTER
- POST_CN — CHARACTER
- POST_TY — CHARACTER — NOT NULL — B: 게시글, C: 댓글, R: 댓글 답변
- NOTICE_TY — CHARACTER — NOT NULL — 0: 공지아님, 1: 서비스공지, 2. 시스템공지
- EXPSR_AT — CHARACTER — NOT NULL — Y / N
- COMMANT_POST_ID — CHARACTER
- REPLAY_POST_ID — CHARACTER
- ATCH_GROUP_ID — CHARACTER
- DELETE_AT — CHARACTER — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_FAA_CNTNTS_MART
- CNTNTS_ID — CHARACTER — Primary key — NOT NULL
- PARNTS_CNTNTS_ID — CHARACTER — NOT NULL
- CNTNTS_CN — CHARACTER — NOT NULL
- CNTNTS_VALUE — VARCHAR(200)
- INDID_TP_CODE — CHARACTER — DOM type
- SORT_ORDR — NUMERIC(3, 0) — NOT NULL
- USE_AT — CHARACTER — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_FAA_LEND_IEM_INFO
- BLDG_ID — CHARACTER — Primary key — NOT NULL
- IEM_NO — CHARACTER — Primary key — NOT NULL — 대여 아이템 일련번호
- IEM_TY_CODE — CHARACTER — Primary key — NOT NULL — IEM01: 우산, IEM02: 공구
- LEND_POSBL_AT — CHARACTER — 'Y' : 가능, 'N' : 불가능
- LEND_STTUS_CODE — CHARACTER — NOT NULL — 접수: 1, 대여: 2, 취소: 3 , 반납: 4
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
- LAST_LEND_HIST_SN — CHARACTER — 최종 사용자 대여 이력 번호
TN_FAA_SENARIO
- SENARIO_ID — CHARACTER — Primary key — NOT NULL
- SENARIO_NM — CHARACTER
- SVC_MENU_ID — CHARACTER
- VOC_TY_CODE — CHARACTER
- EQP_TY_CODE — CHARACTER
- VOC_REQUST_STAT — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- HELP_CODE — CHARACTER — NOT NULL — 코드그룹 : F104
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_FAA_SENARIO_DEFAULT_IEM
- SENARIO_ID — CHARACTER — Foreign key → TN_FAA_SENARIO.SENARIO_ID — NOT NULL
- VOC_COLUMN_NM — CHARACTER — NOT NULL
- CNTNTS_VALUE — CHARACTER — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP
TN_FAA_SENARIO_STEP
- SENARIO_ID — CHARACTER — Foreign key → TN_FAA_SENARIO.SENARIO_ID — NOT NULL
- STEP_ID — CHARACTER
- STEP_CN — CHARACTER
- STEP_ORDR — NUMERIC(3, 0) — NOT NULL
- START_STEP_AT — CHARACTER
- END_STEP_AT — CHARACTER
- VOC_COLUMN_NM — CHARACTER
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_FAA_STEP_CNTNTS
- SENARIO_ID — CHARACTER — Foreign key → TN_FAA_SENARIO_STEP.SENARIO_ID — NOT NULL
- CNTNTS_ID — CHARACTER
- STEP_ID — CHARACTER — Foreign key → TN_FAA_SENARIO_STEP.STEP_ID
- NEXT_STEP_ID — CHARACTER
- CNTNTS_CN — CHARACTER
- CNTNTS_VALUE — VARCHAR(200) — 컨텐츠가 VOC로 전달 될 값
- INDID_TY_CODE — CHARACTER — DOM type
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_FAA_VOTE_IEM
- IEM_ID — CHARACTER — Primary key — NOT NULL
- VOTE_SN — CHARACTER — Foreign key → TN_FAA_VOTE_MASTER.VOTE_SN — NOT NULL
- IEM_NM — CHARACTER — NOT NULL
- SORT_ORDR — NUMERIC(3, 0) — NOT NULL
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm
TN_FAA_VOTE_MASTER
- VOTE_SN — CHARACTER — Primary key — NOT NULL — HHmmss + UUID
- SRVC_MENU_ID — CHARACTER
- ITNC_ID — CHARACTER
- ITNC_DT — TIMESTAMP — YYYYMMDDHHmm
- BEGIN_DT — TIMESTAMP — YYYYMMDDHHmm
- END_DT — TIMESTAMP — YYYYMMDDHHmm
- END_AT — CHARACTER — NOT NULL — N: 진행, Y : 종료
- BLDG_ID — CHARACTER
- FLOOR_ID — CHARACTER
- SPCE_ID — CHARACTER
- VOC_RCEPT_NO — CHARACTER
- FEED_IEM_CODE — CHARACTER — 피드백 선택 코드 아이디
- FEED_CN — CHARACTER
- FEED_DT — TIMESTAMP
- REG_ID — CHARACTER — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL — YYYYMMDDHHmm
- MOD_ID — CHARACTER
- MOD_DT — TIMESTAMP — YYYYMMDDHHmm