cjom
Tables (43)
BR_TLS_AUTH_CONFIG
- USER_ID — varchar(20) — Primary key — NOT NULL
- AUTH_CODE — varchar(30) — Primary key — NOT NULL
- USER_CODE — int — NOT NULL
- AUTH_DC — varchar(200)
- RUSERID — int
- RDATETIME — datetime
- UUSERID — int
- UDATETIME — datetime
BR_TLS_AUTH_INFO
- AUTH_CODE — varchar(30) — Primary key — NOT NULL
- AUTH_NM — varchar(60) — NOT NULL
- AUTH_DC — varchar(200)
- RUSERID — int
- RDATETIME — datetime
- UUSERID — int
- UDATETIME — datetime
BR_TLS_AUTH_PROGRAM
- AUTH_CODE — varchar(30) — Primary key — NOT NULL
- PROGRAM_FILE_NM — varchar(60) — Primary key — NOT NULL
- URL — varchar(200)
- AUTH_YN — varchar(5)
- AUTH_READ — varchar(5)
- AUTH_WRITE — varchar(5)
- AUTH_DELETE — varchar(5)
- RUSERID — int
- RDATETIME — datetime
- UUSERID — int
- UDATETIME — datetime
BR_TLS_BANNER_MST
- BANNER_MST_ID — int — Primary key — NOT NULL
- TITLE — varchar(50)
- GB_CODE — varchar(10)
- GROUP_YN — varchar(1)
- BANNER_SECTION — varchar(100)
- BANNER_IMAGE — varchar(255)
- BANNER_DC — varchar(255)
- URL — varchar(255)
- URL_TARGET — char(1)
- DISPLAY_GRADE_A_YN — char(1)
- DISPLAY_GRADE_B_YN — char(1)
- DISPLAY_GRADE_C_YN — char(1)
- DISPLAY_GRADE_D_YN — char(1)
- DISPLAY_YN — char(1)
- DISPLAY_TYPE — char(1)
- START_DATE — datetime
- END_DATE — datetime
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_BANNER_SUB
- BANNER_SUB_ID — int — Primary key — NOT NULL
- BANNER_MST_ID — int — Primary key — NOT NULL
- BANNER_IMAGE — varchar(255)
- BANNER_DC — varchar(255)
- SORT_SEQ — int
- URL — varchar(255)
- URL_TARGET — char(1)
- DISPLAY_GRADE_A_YN — char(1)
- DISPLAY_GRADE_B_YN — char(1)
- DISPLAY_GRADE_C_YN — char(1)
- DISPLAY_GRADE_D_YN — char(1)
- DISPLAY_YN — char(1)
- DISPLAY_TYPE — char(1)
- START_DATE — datetime
- END_DATE — datetime
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_BBS
- BBS_CODE — int — Primary key — NOT NULL
- BBS_ID — varchar(50)
- BBS_NM — varchar(50)
- BBS_GB_CD — varchar(10)
- BBS_GB_NM — varchar(50)
- USE_YN — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_CATEGORY
- COMPANY_CODE — int — Primary key — NOT NULL
- CATEGORY_CODE — varchar(48) — Primary key — NOT NULL
- UPPER_CATEGORY_CODE — varchar(48) — Primary key — NOT NULL
- CATEGORY_NM — varchar(255) — NOT NULL
- SORT_SEQ — int — NOT NULL
- USE_YN — char(1)
- DISPLAY_RANK — varchar(24)
- DISPLAY_RANK_SUB_YN — char(1)
- PC_DISPLAY_YN — char(1)
- MOBILE_DISPLAY_YN — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_CATEGORY_B2C
- COMPANY_CODE — int — Primary key — NOT NULL
- CATEGORY_CODE — varchar(48) — Primary key — NOT NULL
- UPPER_CATEGORY_CODE — varchar(48) — Primary key — NOT NULL
- CATEGORY_NM — varchar(255) — NOT NULL
- SORT_SEQ — int — NOT NULL
- USE_YN — char(1)
- DISPLAY_RANK — varchar(24)
- DISPLAY_RANK_SUB_YN — char(1)
- PC_DISPLAY_YN — char(1)
- MOBILE_DISPLAY_YN — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_CATEGORY_GROUP
- GB_CODE — varchar(10) — Primary key — NOT NULL
- GROUP_ID — int — Primary key — NOT NULL
- GROUP_NM — varchar(60)
- SORT_SEQ — int
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_CHANNEL
- CHANNEL_CD — varchar(10) — NOT NULL
BR_TLS_CUSTOMER
- COMPANY_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int — Primary key — NOT NULL
- CUST_ID — varchar(30) — NOT NULL
- CUST_PW — varchar(100) — NOT NULL
- PRE_CUSTOMER_CODE — varchar(50)
- PRE_DE — char(1)
- PRE_JU — char(2)
- GT_CUSTOMER_TYPE — char(6)
- PROGRAM_AUTH — varchar(6)
- CUSTOMER_NM — varchar(50)
- CUSTOMER_TEL — varchar(15)
- CUSTOMER_FAX — varchar(15)
- GT_AREA — char(6)
- CUSTOMER_POST — varchar(7)
- CUSTOMER_ADDR1 — varchar(100)
- CUSTOMER_ADDR2 — varchar(100)
- CUSTOMER_EMAIL — varchar(70)
- GT_CUSTOMER_LEVEL — char(6)
- PART_CODE — int
- COURSE_CODE — int
- REGIST_NUM — varchar(20)
- PRINT_NM — varchar(50)
- PRINT_BOSS — varchar(20)
- PRINT_POST — varchar(7)
- PRINT_ADDR1 — varchar(100)
- PRINT_ADDR2 — varchar(100)
- PRINT_STATUS — varchar(50)
- PRINT_TYPE — varchar(100)
- CUSTOMER_PAY_DAY — varchar(10)
- CUSTOMER_CREDIT_MONTH — money
- CUSTOMER_CREDIT_DAY — money
- CUSTOMER_CREDIT_PRE — money
- USER_CODE — int
- USE_YN — char(1)
- CHARGE_NM — varchar(20)
- CHARGE_TEL — varchar(15)
- SMS_YN — char(1)
- MEMO — varchar(1000)
- NOTE — varchar(1000)
- CUSTOMER_CARGO — varchar(100)
- CALL_MONEY_DAY — nchar(2)
- SHIP_NOTE — varchar(1000)
- SHIP_SORT — int
- GT_ADD_SALE_RATE — char(6)
- BOJOONG_DAY — varchar(10)
- GT_GIVE_TYPE — char(6)
- BUSINESS_PLACE_TYPE_CD — varchar(6)
- BIZ_TYPE_CD — varchar(6)
- EMAIL_YN — varchar(1)
- HP_TEL — varchar(50)
- CONFIRM_YN — char(1)
- CEO_POST — varchar(7)
- CEO_ADDR1 — varchar(100)
- CEO_ADDR2 — varchar(100)
- CEO_ADDR3 — varchar(100)
- TAXBILL_EMAIL — varchar(100)
- NW_MEMBER_YN — varchar(1)
- MEMBER_STATUS_CD — varchar(2)
- CUSTOMER_ADDR_ROAD_YN — char(1)
- PRINT_ADDR_ROAD_YN — char(1)
- … +73
BR_TLS_DELIVERY_USER
- DLVY_CODE — int — Primary key — NOT NULL
- DLVY_ID — varchar(20) — NOT NULL
- DLVY_PW — varchar(100) — NOT NULL
- DLVY_PW_S — varchar(100)
- DLVY_NM — varchar(20) — NOT NULL
- DLVY_CP — varchar(15)
- NOTE — varchar(1000)
- USE_YN — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_DESIGN_SETTING
- SITE_CODE — int — Primary key — NOT NULL
- LOGO_TOP_IMAGE — varchar(255)
- LOGO_BOTTOM_IMAGE — varchar(255)
- SIDE_LEFT_OPEN_YN — char(1)
- SIDE_RIGHT_OPEN_YN — char(1)
- RDATETIME — datetime
- RUSERID — varchar(20)
- UDATETIME — datetime
- UUSERID — varchar(20)
BR_TLS_FAQ
- FAQ_CODE — int — Primary key — NOT NULL
- FAQ_GB_CD — varchar(10)
- TITLE — varchar(100)
- CONTENTS — varchar(5000)
- USE_YN — varchar(1)
- USE_TYPE — char(1)
- DEL_YN — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- SALE_CHANNEL_CD — varchar(20)
BR_TLS_LOGIN_LOG
- RDATETIME — datetime — Primary key — NOT NULL
- USER_CODE — int — Primary key — NOT NULL
- COMPANY_CODE — int
- USER_TYPE — char(1)
- USER_ID — varchar(30)
- USER_NM — varchar(100)
- USER_IP — nchar(50)
- USER_DEVICE — varchar(6)
- CHANNEL — varchar(20)
BR_TLS_MAIL_AUTO_MANAGE
- CHANNEL_CD — varchar(10) — Primary key — NOT NULL
- MAIL_GB_CD — int — Primary key — NOT NULL
- MAIL_TYPE_CODE — int — Primary key — NOT NULL
- MAIL_TYPE_NM — varchar(50)
- AUTO_SEND_YN — varchar(1)
- SEND_EMAIL — varchar(100)
- MAIL_TITLE — varchar(100)
- MAIL_CONTENT — varchar(MAX)
- MEMBER_SEND_YN — varchar(1)
- MANAGER_SEND_YN — varchar(1)
- RDATETIME — datetime
- RUSERID — varchar(20)
- UDATETIME — datetime
- UUSERID — varchar(20)
BR_TLS_MAIL_LOG
- MAIL_CODE — int — Primary key — NOT NULL
- ORDER_CODE — int
- MAIL_TYPE_CODE — int
- RESULT_YN — varchar(10)
- SEND_DAY — varchar(20)
- SEND_EMAIL — varchar(50)
- SEND_TITLE — varchar(500)
- SEND_CONTENT — varchar(MAX)
- SENDER_CODE — int
- SENDER_ID — varchar(20)
- SENDER_NM — varchar(100)
- SEND_STNDRD — varchar(100)
- RECEIVER_EMAIL — varchar(50)
- RECEIVER_CODE — int
- RECEIVER_ID — varchar(20)
- RECEIVER_NM — varchar(100)
- AUTO_SEND_YN — varchar(1)
- RDATETIME — datetime
- RUSERID — varchar(20)
- UDATETIME — datetime
- UUSERID — varchar(20)
BR_TLS_MAIN_DISPLAY
- DISP_CODE — int — Primary key — NOT NULL
- GB_CODE — varchar(10)
- GROUP_YN — varchar(1)
- DISP_NM — varchar(100) — NOT NULL
- DISP_DC — varchar(100)
- DISP_CNT — int
- VERTICAL — int
- HORIZONTAL — int
- USE_YN — varchar(1)
- RUSERID — int
- RDATETIME — datetime
- UUSERID — int
- UDATETIME — datetime
- TAB_CODE — varchar(1)
- DISP_SUB_NM — varchar(100)
BR_TLS_MENU_INFO
- MENU_NO — numeric(20,0) — Primary key — NOT NULL
- UPPER_MENU_NO — numeric(20,0)
- MENU_NM — varchar(60) — NOT NULL
- PROGRAM_FILE_NM — varchar(60) — NOT NULL
- MENU_ORDER — numeric(5,0) — NOT NULL
- MENU_DC — varchar(250)
- USE_YN — char(1)
- RUSERID — int
- RDATETIME — datetime
- UUSERID — int
- UDATETIME — datetime
BR_TLS_MIDDLEMAN
- COMPANY_CODE — int — NOT NULL
- USER_CODE — int — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- USER_PW — varchar(100) — NOT NULL
- USER_PW_S — varchar(100)
- USER_NM — varchar(20) — NOT NULL
- USER_BIZ_NM — varchar(100) — NOT NULL
- USER_POST — varchar(7)
- USER_ADDR1 — varchar(100)
- USER_ADDR2 — varchar(100)
- USER_TEL — varchar(15)
- USER_CP — varchar(15)
- USER_RRN — varchar(14)
- MOVE_IN_NUM — int
- SERVICE_CODE — int
- REGIST_NUM — varchar(20)
- BIZ_POST — varchar(7)
- BIZ_ADDR1 — varchar(100)
- BIZ_ADDR2 — varchar(100)
- BIZ_TEL — varchar(15)
- BIZ_FAX — varchar(15)
- PERMIT_NUM — varchar(20)
- MIDDLEMAN_CODE — int
- CORP_CODE — int
- CORP_NM — varchar(20)
- NOTE — varchar(1000)
- USE_YN — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- COLOR — varchar(10)
- sort — varchar(2)
BR_TLS_NOTICE
- NOTICE_CODE — int — Primary key — NOT NULL
- NOTICE_DAY — varchar(10)
- USER_CODE — int — NOT NULL
- USER_NM — varchar(50)
- TITLE — varchar(50)
- CONTENTS — text
- VIEW_CNT — int
- FILE1_PATH — varchar(100)
- FILE1_NAME — varchar(100)
- FILE2_PATH — varchar(100)
- FILE2_NAME — varchar(100)
- FILE3_PATH — varchar(100)
- FILE3_NAME — varchar(100)
- FILE4_PATH — varchar(100)
- FILE4_NAME — varchar(100)
- LINK_URL — varchar(255)
- USE_TYPE — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- FIXED — varchar(1)
- SALE_CHANNEL_CD — varchar(20)
BR_TLS_ORDER_TEMP
- TIMESTAMP_CODE — varchar(30) — NOT NULL
- CUSTOMER_CODE — int
- ISM_CUSTOMER_CODE — int
- USER_TYPE — char(1)
- SHOP_CODE — int
- PRODUCT_CODE — int
- NEGO_PRICE — float
- ORDER_NEGO — float
- UNIT_PRICE — float
- UNIT_COST — float
- ORDER_CNT — int
- WIRE — int
- ORDER_AMOUNT — float
- REPRESENT_YN — varchar(1)
- GT_ORDER_STATE — char(6)
- GT_TRANSPORT — char(6)
- TRANS_NM — varchar(50)
- TRANS_TEL — varchar(15)
- TRANS_POST — varchar(7)
- TRANS_ADDR1 — varchar(200)
- TRANS_ADDR2 — varchar(200)
- TRANS_ARRIVAL_DAY — varchar(15)
- TRANS_ARRIVAL_TIME — varchar(15)
- TRANS_MEMO — varchar(2000)
- TRANS_EMAIL — varchar(50)
- TRANS_COST_FLAG — varchar(1)
- POST_NM — varchar(50)
- POST_TEL — varchar(15)
- CARGO_CODE — int
- COURSE_CODE — int
- TACBEINFO — varchar(20)
- QUICKINFO — varchar(20)
- CUST_COMP_CODE — int
- CUST_COMP_NM — varchar(50)
- CUST_COMP_TEL — varchar(15)
- NOTE — varchar(2000)
- SOT_YN — varchar(1)
- PAYMENT_WAY_CD — varchar(6)
- PAYMETHOD — varchar(10)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- TAXBILL_ISSUE_STATUS — varchar(1)
- GT_PRODUCT_TYPE — varchar(6)
- ORDER_COST — float
- BUY_NEGO — float
- CALL_ORDER_DAY — varchar(10)
- TRANS_COST — float
- JOB_MEMO — varchar(1000)
- CUST_MEMO — varchar(1000)
- PAY_DAY — varchar(10)
- LC_CODE — int
- GT_LC_TYPE — varchar(6)
- GT_KEEP_TYPE — varchar(6)
- GT_QUICKTYPE — varchar(6)
BR_TLS_PAYMENT_LOG
- LOG_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int — NOT NULL
- ORDER_CODE — int
- PAY_TYPE — varchar(30)
- ORDER_AMOUNT — float
- REFUND_AMOUNT — float
- PAYMENT_WAY_CD — varchar(10)
- PAYMETHOD — varchar(10)
- MID — varchar(100)
- TID — varchar(100)
- OID — varchar(30)
- RESULT_CD — varchar(10)
- RESULT_MSG — varchar(200)
- CARD_CD — varchar(10)
- BANK_CD — varchar(6)
- ACCOUNT_NO — varchar(50)
- ACCOUNT_HOLDER_NM — varchar(100)
- DEPOSITOR — varchar(100)
- DEPOSIT_DATE — varchar(20)
- PAY_DEVICE — varchar(10)
- IP — varchar(20)
- RDATETIME — datetime
- RUSERID — varchar(50)
- RUSERNM — varchar(50)
- RUSERTEL — varchar(20)
- USER_TYPE — varchar(1)
- SALE_CHANNEL_CD — varchar(10)
- API_RESULT — varchar(2000)
BR_TLS_POPUP
- POPUP_ID — int — NOT NULL
- TITLE — varchar(100)
- DISPLAY_GRADE_A_YN — char(1)
- DISPLAY_GRADE_B_YN — char(1)
- DISPLAY_GRADE_C_YN — char(1)
- DISPLAY_GRADE_D_YN — char(1)
- STORE_TYPE — char(6)
- POPUP_IMAGE — varchar(300)
- POPUP_WIDTH — int
- POPUP_HEIGHT — int
- DISPLAY_YN — char(1)
- DISPLAY_TYPE — char(1)
- START_DATE — datetime
- END_DATE — datetime
- POPUP_CONTENT — text
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- POPUP_X — varchar(20)
- POPUP_Y — varchar(20)
- URL — varchar(300)
BR_TLS_POST_MAPPING
- POST_MAPPING_CODE — int — Primary key — NOT NULL
- POST_CODE — varchar(4) — NOT NULL
- CITY — varchar(100) — NOT NULL
- REGION — varchar(100) — NOT NULL
- PART_CODE — int — NOT NULL
- PART_NM — varchar(50)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_PRODUCT_ICON_MNG
- ICON_CODE — varchar(6) — Primary key — NOT NULL
- COMPANY_CODE — int — NOT NULL
- ICON_NM — varchar(15) — NOT NULL
- COLOR — varchar(10) — NOT NULL
- SORT_SEQ — int — NOT NULL
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- USE_YN — varchar(1)
- BORDER — varchar(10)
- FONT_COLOR — varchar(10)
BR_TLS_PRODUCT_MULTI_CATEGORY
- CATEGORY_CONN_ID — int — Primary key — NOT NULL
- PRODUCT_CODE — int — Primary key — NOT NULL
- UPPER_CATEGORY_CODE — varchar(48)
- CATEGORY_NM — varchar(255)
- CATEGORY_CODE — varchar(48)
- CATEGORY_LEVEL — int
- CATEGORY_MULTI_ID — int
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_PROGRAM_LIST
- PROGRAM_FILE_NM — varchar(60) — Primary key — NOT NULL
- PROGRAM_STRE_PATH — varchar(100) — NOT NULL
- PROGRAM_KOREAN_NM — varchar(60)
- PROGRAM_DC — varchar(200)
- URL — varchar(100) — NOT NULL
- RUSERID — int
- RDATETIME — datetime
- UUSERID — int
- UDATETIME — datetime
BR_TLS_SCM_NOTICE
- NOTICE_CODE — int — Primary key — NOT NULL
- NOTICE_DAY — varchar(10)
- CUSTOMER_CODE — int — NOT NULL
- CUSTOMER_NM — varchar(50)
- USER_CODE — int — NOT NULL
- USER_NM — varchar(50)
- CATEGORY — char(6)
- TITLE — varchar(50)
- CONTENTS — text
- VIEW_CNT — int
- FILE1_PATH — varchar(100)
- FILE1_NAME — varchar(100)
- FILE2_PATH — varchar(100)
- FILE2_NAME — varchar(100)
- FILE3_PATH — varchar(100)
- FILE3_NAME — varchar(100)
- FILE4_PATH — varchar(100)
- FILE4_NAME — varchar(100)
- LINK_URL — varchar(255)
- USE_TYPE — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- FIXED — varchar(1)
BR_TLS_SCM_QNA
- QNA_CODE — int — Primary key — NOT NULL
- QNA_DAY — varchar(10)
- CUSTOMER_CODE — int — NOT NULL
- WRITER_CODE — int — NOT NULL
- WRITER_NM — varchar(50)
- CATEGORY — varchar(50)
- TITLE — varchar(30)
- CONTENT — varchar(4000)
- VIEW_CNT — int
- FILE1_PATH — varchar(100)
- FILE1_NAME — varchar(100)
- FILE2_PATH — varchar(100)
- FILE2_NAME — varchar(100)
- USER_TYPE — char(1)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
BR_TLS_SITE
- SITE_CODE — int — Primary key — NOT NULL
- SITE_DOMAIN — varchar(100) — NOT NULL
- SITE_NM — varchar(50) — NOT NULL
- SITE_ENG_NM — varchar(50)
- SITE_TITLE — varchar(200)
- SITE_FAVICON — varchar(100)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- JOIN_TERMS1 — varchar(MAX)
- JOIN_TERMS2 — varchar(MAX)
- JOIN_TERMS3 — varchar(MAX)
BR_TLS_SMS_AUTO_MANAGE
- CHANNEL_CD — varchar(10) — Primary key — NOT NULL
- SMS_GB_CD — int — Primary key — NOT NULL
- SMS_TYPE_CODE — int — Primary key — NOT NULL
- SMS_TYPE_NM — varchar(50)
- AUTO_SEND_YN — varchar(1)
- CALLBACK — varchar(100)
- SMS_TITLE — varchar(30)
- SMS_CONTENT — varchar(300)
- RDATETIME — datetime
- RUSERID — varchar(20)
- UDATETIME — datetime
- UUSERID — varchar(20)
TLS_BUY
- COMPANY_CODE — int — Primary key — NOT NULL
- BUY_CODE — int — Primary key — NOT NULL
- BUY_SLIPNO — varchar(20)
- CUSTOMER_CODE — int
- BUY_DAY — varchar(10)
- GT_BUYTYPE — char(6)
- GT_BUYKIND — char(6)
- USER_CODE — int
- GT_RECEIPT — char(6)
- NOTE — varchar(1000)
- STOCK_CHECK — nchar(10)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- DELETE_YN — char(1)
- CHECK_USER — int
- CHECK_DATE — datetime
- SALE_CHANNEL_CD — varchar(10)
TLS_BUY_ASK
- COMPANY_CODE — int — Primary key — NOT NULL
- BUY_ASK_CODE — int — Primary key — NOT NULL
- ASK_DAY — varchar(10)
- CUSTOMER_CODE — int
- COMSULT — varchar(500)
- DELIVERY — varchar(500)
- TERMS — varchar(500)
- SPOT — varchar(500)
- PAYMENT — varchar(500)
- NOTE — varchar(500)
- CUSTOMER_SUJU — varchar(50)
- ASK_CANCEL — char(1)
- DELIVERY_MEMO — varchar(500)
- ASK_STATE — nchar(6)
- ASK_STATE_USER — int
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- TEMP_MAKE_CODE — varchar(50)
- SUJU_CODE — int
- MEMO — varchar(500)
- PRINT_YN — nchar(1)
- ZIKSONG — nchar(10)
- USER_TYPE — nchar(1)
- ziksong_flag — char(6)
- SALE_CHANNEL_CD — varchar(10)
- CONTACT_01 — varchar(24)
- CONTACT_02 — varchar(24)
TLS_BUY_MONEY
- COMPANY_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int — Primary key — NOT NULL
- GIVE_CODE — int — Primary key — NOT NULL
- GIVE_DAY — varchar(10)
- GIVE_MONEY — money
- CASH_MONEY — money — NOT NULL
- CARD_MONEY — money
- BILL_MONEY — money
- BANK_MONEY — money
- DC_MONEY — money
- CARRY_MONEY — money
- NOTE — varchar(4000)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- TempMakeCode — varchar(50)
TLS_COMPANY
- COMPANY_CODE — int — Primary key — NOT NULL
- COMPANY_NM — varchar(50)
- COMPANY_USE_NM — varchar(50)
- COMPANY_PRINT_NM — varchar(50)
- BUSINESS_NUM — varchar(20)
- REGIST_NUM — varchar(20)
- COMPANY_POST — varchar(7)
- COMPANY_ADDR1 — varchar(100)
- COMPANY_ADDR2 — varchar(100)
- COMPANY_TEL — varchar(15)
- COMPANY_FAX — varchar(15)
- COMPANY_STATUS — varchar(200)
- COMPANY_TYPE — varchar(200)
- COMPANY_BOSS — varchar(10)
- COMPANY_BOSS_PHONE — varchar(15)
- COMPANY_EMAIL — varchar(50)
- COMPANY_ELECTRON_EMAIL — varchar(50)
- COMPANY_SECTOR — char(1)
- DIRECT_SALES_RATE — decimal(7,4)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- TEMP1 — varchar(20)
- PROMOTION_CONTENTS — varchar(1000)
- SHIPPING_POST — varchar(10)
- SHIPPING_ADDR1 — varchar(100)
- SHIPPING_ADDR2 — varchar(50)
- RETURN_POST — varchar(10)
- RETURN_ADDR1 — varchar(100)
- RETURN_ADDR2 — varchar(50)
- SALES_REGIST_NUM — varchar(50)
- PRIVACY_MNG — varchar(50)
TLS_CUSTOMER
- COMPANY_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int — Primary key — NOT NULL
- CUST_ID — varchar(10)
- CUST_PW — varchar(100)
- PRE_CUSTOMER_CODE — varchar(50)
- PRE_DE — char(1)
- PRE_JU — char(2)
- GT_CUSTOMER_TYPE — char(6)
- PROGRAM_AUTH — varchar(6)
- CUSTOMER_NM — varchar(50)
- CUSTOMER_TEL — varchar(15)
- CUSTOMER_FAX — varchar(15)
- GT_AREA — char(6)
- CUSTOMER_POST — varchar(7)
- CUSTOMER_ADDR1 — varchar(100)
- CUSTOMER_ADDR2 — varchar(100)
- CUSTOMER_EMAIL — varchar(70)
- GT_CUSTOMER_LEVEL — char(6)
- PART_CODE — int
- COURSE_CODE — int
- REGIST_NUM — varchar(20)
- PRINT_NM — varchar(50)
- PRINT_BOSS — varchar(20)
- PRINT_POST — varchar(7)
- PRINT_ADDR1 — varchar(100)
- PRINT_ADDR2 — varchar(100)
- PRINT_STATUS — varchar(50)
- PRINT_TYPE — varchar(100)
- CUSTOMER_PAY_DAY — varchar(10)
- CUSTOMER_CREDIT_MONTH — money
- CUSTOMER_CREDIT_DAY — money
- CUSTOMER_CREDIT_PRE — money
- USER_CODE — int
- USE_YN — char(1)
- CHARGE_NM — varchar(20)
- CHARGE_TEL — varchar(15)
- SMS_YN — char(1)
- MEMO — varchar(1000)
- NOTE — varchar(1000)
- CUSTOMER_CARGO — varchar(100)
- CALL_MONEY_DAY — nchar(2)
- SHIP_NOTE — varchar(1000)
- SHIP_SORT — int
- GT_ADD_SALE_RATE — char(6)
- BOJOONG_DAY — varchar(10)
- GT_GIVE_TYPE — char(6)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- BUSINESS_PLACE_TYPE_CD — varchar(6)
- BIZ_TYPE_CD — varchar(6)
- EMAIL_YN — varchar(1)
- HP_TEL — varchar(50)
- CONFIRM_YN — char(1)
- CEO_POST — varchar(7)
- CEO_ADDR1 — varchar(100)
- CEO_ADDR2 — varchar(100)
- CEO_ADDR3 — varchar(100)
- TAXBILL_EMAIL — varchar(100)
- … +27
TLS_CUST_START_AMOUNT
- COMPANY_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int — Primary key — NOT NULL
- GT_AMOUNT — char(6) — Primary key — NOT NULL
- AMOUNT_DAY — varchar(10) — Primary key — NOT NULL
- AMOUNT — money
TLS_GROUP
- COMPANY_CODE — int — Primary key — NOT NULL
- GROUP_CODE — char(3) — Primary key — NOT NULL
- GROUP_NM — varchar(100)
- GROUP_ITEM1 — varchar(20)
- GROUP_ITEM2 — varchar(20)
- GROUP_ITEM3 — varchar(20)
- SORT_SEQ — int
- SYSTEM_YN — char(1)
- USE_YN — char(1)
- NOTE — varchar(1000)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
TLS_ORDER_MONEY
- COMPANY_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int — Primary key — NOT NULL
- COLL_CODE — int — Primary key — NOT NULL
- COLL_DAY — varchar(10)
- COLL_MONEY — money
- CASH_MONEY — money
- CARD_MONEY — money
- BILL_MONEY — money
- BANK_MONEY — money
- DC_MONEY — money
- CARRY_MONEY — money
- NOTE — varchar(4000)
- ORDER_SLIPNO — varchar(20)
- GT_GIVE_YN — char(6)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- TempMakeCode — varchar(50)
- IF_COLL_CODE — int
- INTERFACE_NO — int
- ORD_NO — numeric(16,0)
- PAYMENT_WAY_CD — char(2)
- PAYMENT_AMT — numeric(20,2)
- FEE_YN — char(1)
- REFUND_YN — char(1)
- ISVM_ORDER_CODE — int
- SALE_CHANNEL_CD — varchar(10)
TLS_ORDER_MONEY_IF
- COMPANY_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int — Primary key — NOT NULL
- COLL_CODE — int — Primary key — NOT NULL
- COLL_DAY — varchar(10)
- COLL_MONEY — money
- CASH_MONEY — money
- CARD_MONEY — money
- BILL_MONEY — money
- BANK_MONEY — money
- DC_MONEY — money
- CARRY_MONEY — money
- NOTE — varchar(4000)
- ORDER_SLIPNO — varchar(20)
- GT_GIVE_YN — char(6)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- TempMakeCode — varchar(50)
- INTERFACE_NO — int
- PAYMENT_WAY_CD — char(2)
- PAYMENT_AMT — numeric(20,2)
- PAYMENT_YN — char(1)
- PG_FEE — float
- ORD_NO — numeric(16,0)
- DEL_YN — char(1)
- FEE_ACCOUNTING_YN — char(1)
- NO_TID — varchar(100)
- ID_MERCHANT — varchar(50)
- VIRTUAL_ACCOUNT — varchar(50)
- BANK_CD — char(6)
- MARKETING_YN — char(1)
- INPUT_DAY — varchar(10)
- ISVM_ORDER_CODE — int
- SALE_CHANNEL_CD — varchar(10)
TLS_SEQUENCE
- COMPANY_CODE — numeric(16,0) — Primary key — NOT NULL
- SELECT_TYPE — char(1) — Primary key — NOT NULL
- SELECT_DATE — char(8) — Primary key — NOT NULL
- SQ_START_NUMBER — int
- SQ_CURRENT_NUMBER — int
- SQ_LAST_FETCHED_DATE — datetime
TLS_TAX
- COMPANY_CODE — int — Primary key — NOT NULL
- TAX_CODE — int — Primary key — NOT NULL
- CUSTOMER_CODE — int
- ITEMKEY — varchar(50)
- TAXTYPE — varchar(50)
- WRITEDATE — varchar(50)
- REGDT — varchar(50)
- INVOICERCORPNAME — varchar(50)
- INVOICERCORPNUM — varchar(50)
- INVOICERMGTKEY — varchar(50)
- INVOICEECORPNAME — varchar(50)
- INVOICEECORPNUM — varchar(50)
- INVOICEEMGTKEY — varchar(50)
- TRUSTEECORPNAME — varchar(50)
- TRUSTEECORPNUM — varchar(50)
- TRUSTEEMGTKEY — varchar(50)
- SUPPLYCOSTTOTAL — varchar(50)
- TAXTOTAL — varchar(50)
- PURPOSETYPE — varchar(50)
- MODIFYCODE — varchar(50)
- ISSUETYPE — varchar(50)
- ISSUEDT — varchar(50)
- PREISSUEDT — varchar(50)
- STATECODE — varchar(50)
- STATEDT — varchar(50)
- OPENYN — varchar(50)
- OPENDT — varchar(50)
- NTSRESULT — varchar(50)
- NTSCONFIRMNUM — varchar(50)
- NTSSENDDT — varchar(50)
- NTSRESULTDT — varchar(50)
- NTSSENDERRCODE — varchar(50)
- STATEMEMO — varchar(50)
- RDATETIME — datetime
- RUSERID — int
- UDATETIME — datetime
- UUSERID — int
- CHARGEDIRECTION — varchar(50)
- RESULT_CODE — varchar(50)
- RESULT_MESSAGE — varchar(50)