TravelCoop

Tables (31)

sequence_table

  • SEQ — int(30) — Primary key — NOT NULL
  • TITLE — varchar(100)
  • CREATED_TIME — datetime

tcm_auth_user

  • AUTH_ID — varchar(10) — Primary key — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • AUTH_TYPE — varchar(1) — NOT NULL
  • CREATED_USER_ID — varchar(50)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_TIME — datetime

tcm_board_auth

  • AUTH_ID — varchar(10) — Foreign key → tcm_auth_user.AUTH_ID — NOT NULL
  • BOARD_SID — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_auth_user.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — varchar(50)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_TIME — datetime

tcm_board_edms

  • EDMS_SID — decimal(18,0) — Primary key — NOT NULL
  • EDMS_SEQ — int(11) — Primary key — NOT NULL
  • BOARD_SID — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • BOARD_SID (CS_SID) — decimal(18, 0) — Foreign key → tcm_cs_master.CS_SID — NOT NULL — 고객지원 마스터 KEY
  • BOARD_SID (HOME_SID) — decimal(18,0) — Foreign key → tcm_home_master.HOME_SID — NOT NULL
  • EDMS_PATH — varchar(400)
  • EDMS_VIEW_NAME — varchar(400)
  • EDMS_SOURCE_NAME — varchar(400)
  • EDMS_EXTENSTION — varchar(20)
  • USABLE_FLAG — varchar(1)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • VISTION_TYPE — varchar(1)

tcm_board_hash

  • BOARD_HASH — varchar(400) — Primary key — NOT NULL
  • BOARD_SID — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • HASH_TYPE — varchar(20)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL

tcm_board_heart

  • BOARD_SID (PARENT_SID) — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL

tcm_board_master

  • BOARD_SID — decimal(18,0) — Primary key — NOT NULL
  • BOARD_TYPE — varchar(20) — NOT NULL
  • BOARD_STATUS — varchar(20) — NOT NULL
  • BOARD_MESSAGE — longtext
  • BOARD_URL — varchar(400)
  • BOARD_OPEN_FLAG — varchar(20)
  • BOARD_WRITE_USER_SID — decimal(18,0) — NOT NULL
  • BOARD_MIN_AMOUNT — int(11)
  • BOARD_MAX_AMOUNT — int(11)
  • BOARD_PROPOSE_AMOUNT — int(11)
  • USABLE_FLAG — varchar(1)
  • BOARD_POST_TIME — datetime — NOT NULL
  • HEART_COUNT — int(11)
  • SCORE_TOTAL — decimal(18,2)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • URL_OGTAG — varchar(400)
  • URL_OGFLAG — varchar(1)

tcm_board_open_relation

  • BOARD_SID — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_board_relation

  • BOARD_SID (CHILD_BOARD_SID) — decimal(18,0) — Primary key — NOT NULL
  • BOARD_SID (PARENT_BOARD_SID) — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • CREATED_TIME — datetime
  • CREATED_USER_ID — varchar(50)

tcm_board_score

  • BOARD_SID — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • BOARD_SCORE — decimal(5,1)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL

tcm_board_travel

  • BOARD_SID — decimal(18,0) — Primary key — NOT NULL
  • BOARD_TYPE — varchar(20) — NOT NULL
  • BOARD_TITLE — varchar(400) — NOT NULL
  • BOARD_MESSAGE — longtext
  • USABLE_FLAG — varchar(1)
  • BOARD_POST_TIME — datetime — NOT NULL
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_code_master

  • CODE_SID — decimal(18, 0) — Primary key — NOT NULL
  • CODE_CLASS — varchar(50) — NOT NULL
  • CODE_CODE — varchar(30) — NOT NULL
  • CODE_NAME — varchar(50) — NOT NULL
  • VALUE1_CHAR — varchar(100) — 관리 항목 값 1 (문자열)
  • VALUE2_CHAR — varchar(100) — 관리 항목 값 2 (문자열)
  • VALUE3_CHAR — varchar(100) — 관리 항목 값 3 (문자열)
  • VALUE4_CHAR — varchar(100) — 관리 항목 값 4 (문자열)
  • VALUE5_CHAR — varchar(100) — 관리 항목 값 5 (문자열)
  • VALUE1_NUMBER — decimal(24, 6) — NOT NULL — 관리 항목 값 1 (숫자)
  • VALUE2_NUMBER — decimal(24, 6) — NOT NULL — 관리 항목 값 2 (숫자)
  • VALUE3_NUMBER — decimal(24, 6) — NOT NULL — 관리 항목 값 3 (숫자)
  • VALUE4_NUMBER — decimal(24, 6) — NOT NULL — 관리 항목 값 4 (숫자)
  • VALUE5_NUMBER — decimal(24, 6) — NOT NULL — 관리 항목 값 5 (숫자)
  • SEQ — int(11) — NOT NULL
  • USABLE_FLAG — varchar(1) — NOT NULL — 사용 가능 여부
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_comment_master

  • COMMENT_SID — decimal(18,0) — Primary key — NOT NULL
  • DEPTH — int(11) — Primary key — NOT NULL
  • SEQ — int(11) — Primary key — NOT NULL
  • BOARD_SID (PARENT_SID) — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • COMMENT_MESSAGE — longtext
  • COMMENT_WRITE_USER_SID — decimal(18,0) — NOT NULL
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_cs_master

  • CS_SID — decimal(18, 0) — Primary key — NOT NULL — 고객지원 마스터 KEY
  • CS_TYPE — varchar(10) — Primary key — NOT NULL — 고객지원 TYPE CS/NOTICE/FAQ
  • CS_TITLE — varchar(50)
  • CS_BODY — longtext
  • CS_TIME — datetime — 문의 일자
  • CS_STATUS — varchar(10) — 1:1문의 STATUS
  • CS_USER_SID — decimal(18, 0) — 1:1문의 USER_SID
  • CS_ANSWER_BODY — longtext — 1:1문의 답변
  • CS_ANSWER_MANAGER — varchar(10) — 1:1문의 답변자 이름
  • CS_ANSWER_SID — decimal(18, 0) — 1:1문의 답변자 KEY
  • CS_ANSWER_TIME — datetime — 1:1문의 답변 시간
  • CS_QNA_TYPE — varchar(10)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_deamon_log

  • LOG_TEXT — varchar(4000)
  • KEY_SID (EDMS_SID) — decimal(18,0) — Foreign key → tcm_board_edms.EDMS_SID — NOT NULL

tcm_follower_relation

  • USER_SID (FOLLOW_USER_SID) — decimal(18, 0) — Primary key — NOT NULL — 팔로우 유저
  • USER_SID (FOLLOWING_USER_SID) — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_home_master

  • HOME_SID — decimal(18,0) — Primary key — NOT NULL
  • HOME_TYPE — varchar(20) — Primary key — NOT NULL
  • POP_TYPE — varchar(20)
  • POP_TEXT — longtext
  • HOME_SEQ — int(20) — NOT NULL
  • USABLE_FLAG — varchar(1)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • VIEW_FLAG — varchar(1)

tcm_interest_base

  • BOARD_SID — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — decimal(18,0)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — decimal(18,0)
  • UPDATED_TIME — datetime

tcm_interest_master

  • INTEREST_SID — decimal(18,0) — Primary key — NOT NULL
  • INTEREST_TITLE — varchar(5) — NOT NULL
  • INTEREST_COLOR — varchar(10) — NOT NULL
  • USABLE_FLAG — varchar(1)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_interest_relation

  • BOARD_SID — decimal(18,0) — Foreign key → tcm_board_master.BOARD_SID — NOT NULL
  • INTEREST_SID — decimal(18,0) — Foreign key → tcm_interest_master.INTEREST_SID — NOT NULL
  • INTEREST_MEMO — varchar(200)
  • USABLE_FLAG — varchar(1)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_language_detail

  • LANGUAGE_SID — decimal(18,0) — Foreign key → tcm_language_master.LANGUAGE_SID — NOT NULL
  • LANGUAGE — varchar(3) — NOT NULL
  • TEXT — varchar(500)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_language_master

  • LANGUAGE_SID — decimal(18,0) — Primary key — NOT NULL
  • CLASS — varchar(50) — NOT NULL
  • TYPE — varchar(10) — NOT NULL
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_message_detail

  • SEQ — int(11) — Primary key — NOT NULL
  • MESSAGE_SID (MESSAGE_SID2) — decimal(18,0) — Foreign key → tcm_message_master.MESSAGE_SID — NOT NULL
  • USER_SID (MY_USER_SID) — decimal(18, 0) — Foreign key → tcm_message_master.USER_SID — NOT NULL — 유저 키
  • MESSAGE_TYPE — varchar(20)
  • MESSAGE_TEXT — longtext
  • SEND_TIME — datetime
  • WRITE_READ_YN — varchar(1)
  • CREATED_USER_ID — varchar(50)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_TIME — datetime
  • REC_READ_YN — varchar(1)

tcm_message_master

  • MESSAGE_SID — decimal(18,0) — Primary key — NOT NULL
  • USER_SID (REC_USER_SID) — decimal(18,0) — Primary key — NOT NULL
  • USER_SID (MY_USER_SID) — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — varchar(50)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_TIME — datetime

tcm_pro_master

  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • USER_CERTI — decimal(18, 0) — NOT NULL
  • USER_BANKBOOK — decimal(18, 0) — NOT NULL
  • USER_CARD — decimal(18, 0)
  • USER_DEPT — varchar(20)
  • USER_COMPANY — varchar(20)
  • USER_ENUM — decimal(12, 0)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL

tcm_pro_temp

  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • TEMP_TYPE — varchar(1) — NOT NULL — I : 전문가 신청 / U : 전문가 정보 수정
  • USER_CERTI — decimal(18, 0) — NOT NULL
  • USER_BANKBOOK — decimal(18, 0) — NOT NULL
  • USER_CARD — decimal(18, 0)
  • USER_DEPT — varchar(20)
  • USER_COMPANY — varchar(20)
  • USER_ENUM — decimal(12, 0)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • NEW_FLAG — varchar(1)

tcm_report_master

  • REPORT_SID — decimal(18,0) — Primary key — NOT NULL
  • REPORT_TYPE — varchar(1) — Primary key — NOT NULL
  • REPORT_CODE — varchar(2) — Primary key — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — varchar(50)
  • CREATED_TIME — datetime
  • UPDATED_USER_ID — varchar(50)
  • UPDATED_TIME — datetime

tcm_travel_user

  • USER_SID — decimal(18, 0) — Primary key — NOT NULL — 유저 키
  • USER_EMAIL — varchar(200) — NOT NULL — 유저 아이디
  • USER_PASSWORD — varchar(4000) — NOT NULL — 유저비밀번호(암호화)
  • USER_NICKNAME — varchar(20) — 유저 닉네임
  • USER_TELNUM — varchar(20) — 유저 전화번호
  • LAST_LOGINTIME — datetime — 마지막 로그인 시간
  • LOGIN_COUNT — int(11) — 로그인 횟수
  • USABLE_FLAG — varchar(1) — 사용여부 탈퇴시 N
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • PASS_AUTH — decimal(6, 0)

tcm_user_field

  • USER_FIELD — varchar(50) — Primary key — NOT NULL — 전문가 관심분야
  • FIELD_TYPE — varchar(10) — Primary key — NOT NULL
  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL

tcm_user_master

  • USER_SID — decimal(18, 0) — Primary key — NOT NULL — 유저 키
  • USER_EMAIL — varchar(200) — NOT NULL — 유저 아이디
  • USER_PASSWORD — varchar(200) — NOT NULL — 유저비밀번호(암호화)
  • USER_NICKNAME — varchar(20) — 유저 닉네임
  • USER_TELNUM — varchar(20) — 유저 전화번호
  • USER_TYPE — varchar(1) — 유저타입 A=여행자,C=전문가,P=관리자
  • LAST_LOGINTIME — datetime — 마지막 로그인 시간
  • LOGIN_COUNT — int(11) — 로그인 횟수
  • USER_SIGN_TYPE — varchar(10) — 로그인 타입 소셜로그인=SOCIAL,그외=DEFAULT
  • SOCIAL_TYPE — varchar(20)
  • USER_OPEN_FLAG — varchar(1) — 공개 비공개 계정 여부 Y/N
  • USABLE_FLAG — varchar(1) — 사용여부 탈퇴시 N
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • PASS_AUTH — decimal(6, 0)
  • TRAVEL_FLAG — varchar(1)

tcm_user_option

  • USER_SID — decimal(18, 0) — Foreign key → tcm_user_master.USER_SID — NOT NULL — 유저 키
  • RETIRE_REASON — varchar(50) — 탈퇴사유
  • RETIRE_DATETIME — datetime — 탈퇴일시
  • BANK_ACCOUNT — varchar(200) — 계좌번호
  • BANK_CODE — varchar(20) — 은행코드
  • BANK_USERNAME — varchar(10) — 예금주
  • BANK_ADDTIME — datetime — 은행입력일시
  • PROFIL_OPEN_CODE — varchar(10) — 프로필 코드 OPEN=공개..코드추가
  • USER_PUSH_TOKEN — varchar(255) — PUSH TOKEN값
  • USER_PUSH_FLAG — varchar(1) — PUSH 사용 여부
  • USER_LANGUAGE_CODE — varchar(3) — 언어코드 현재는 KOR 들어가도록 처리
  • USER_TEXT — longtext — 소개글
  • USER_IMG — decimal(18, 0)
  • CREATED_USER_ID — varchar(50) — NOT NULL
  • CREATED_TIME — datetime — NOT NULL
  • UPDATED_USER_ID — varchar(50) — NOT NULL
  • UPDATED_TIME — datetime — NOT NULL
  • USER_NAME — varchar(20)
  • USER_SEX — varchar(1) — 남,
  • USER_BIRTHDAY — datetime
  • USER_AD_PUSH_FLAG — varchar(1)
  • USER_AD_EMAIL_FLAG — varchar(1)
  • USER_AD_SMS_FLAG — varchar(1)
  • ADMIN_IP_ADDRESS — varchar(20)