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

  • Field — VARCHAR(255)

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