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)