TEST
Tables (50)
INPUT_DATA_CNC_FANUC
- seq — int — Primary key — NOT NULL
- id — nvarchar(50)
- input_date — datetime
- positionx — nvarchar(100)
- positiony — nvarchar(100)
- positionz — nvarchar(100)
- feedrate — nvarchar(100)
- spindlespeed — nvarchar(100)
- spindleload — nvarchar(100)
- ps100alarm — nvarchar(100)
- ps000alarm — nvarchar(100)
- ps101alarm — nvarchar(100)
- psalarm — nvarchar(100)
- otalarm — nvarchar(100)
- ohalarm — nvarchar(100)
- servoalarm — nvarchar(100)
- systemalarm — nvarchar(100)
- apcalarm — nvarchar(100)
- spindlealarm — nvarchar(100)
- psalarm5000 — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
INPUT_DATA_CNC_MITSUBISHI
- seq — int — Primary key — NOT NULL
- id — nvarchar(50)
- input_date — datetime
- positionx — nvarchar(50)
- positiony — nvarchar(50)
- posotionz — nvarchar(50)
- status — nvarchar(50)
- lengthoffset — nvarchar(50)
- radiusoffset — nvarchar(50)
- servo — nvarchar(50)
- spindelspeed — nvarchar(50)
- spindleload — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
LEAK_TESTER_INPUT_DATA
- seq — int — Primary key — NOT NULL
- equip_id — nvarchar(50)
- input_date — datetime
- pass — nvarchar(1)
- val1 — numeric(18, 3)
- val2 — numeric(18, 3)
- val3 — numeric(18, 3)
- val4 — numeric(18, 3)
- val5 — numeric(18, 3)
- val6 — numeric(18, 3)
- val7 — numeric(18, 3)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
LOT_COUNTER_INPUT_DATA
- seq — int — Primary key — NOT NULL
- id — nvarchar(50)
- input_date — datetime
- work_day — nvarchar(50)
- work_time — nvarchar(50)
- work_lot_count — int
- mem_id — nvarchar(20)
- cmpnt_cd — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
LOT_TRACE
- lot_title — nvarchar(50)
- lot_date — datetime
- lot_pro_cd — nvarchar(50)
- lot_pro_nm — nvarchar(50)
- lot_cd — nvarchar(50)
- lot_qty — int
- barcode — nvarchar(50)
- remark — nvarchar(50)
TC_CODE
- group_code — varchar(200) — Primary key — NOT NULL
- value — varchar(200) — Primary key — NOT NULL
- group_name — varchar(200) — NOT NULL
- name1 — nvarchar(100) — NOT NULL
- name2 — nvarchar(100)
- name3 — nvarchar(100)
- name4 — nvarchar(100)
- name5 — nvarchar(100)
- data1 — nvarchar(100)
- data2 — nvarchar(100)
- data3 — nvarchar(100)
- order_num — int
- description — nvarchar(100)
- is_use — varchar(1) — NOT NULL
- is_system — varchar(1) — NOT NULL
- if_system_nm — varchar(10)
- created_id — nvarchar(100) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — nvarchar(100)
- updated_date — datetime
- work_division — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_CODE_QUERY
- id — varchar(50) — Primary key — NOT NULL
- name — nvarchar(50) — NOT NULL
- query_string — nvarchar(max) — NOT NULL
- description — nvarchar(200)
- is_use — varchar(1) — NOT NULL
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_DEPARTMENT
- bsns_cd — char(5) — Primary key — NOT NULL
- id — varchar(50) — Primary key — NOT NULL
- name — nvarchar(50) — NOT NULL
- parent_id — varchar(50)
- closed_date — datetime
- order_num — int
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_FILE
- link_id — varchar(50) — Primary key — NOT NULL
- from_type — varchar(50) — NOT NULL
- page — varchar(50) — NOT NULL
- name — nvarchar(100) — NOT NULL
- ext — varchar(10) — NOT NULL
- size — bigint — NOT NULL
- path — varchar(1000) — NOT NULL
- saved_name — nvarchar(100) — NOT NULL
- security_level — int — NOT NULL
- meta_info — nvarchar(1000)
- content_type — varchar(200)
- description — nvarchar(2000)
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- deleted_id — varchar(50)
- deleted_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_FILE_OPERATION_HISTORY
- id — bigint — Primary key — NOT NULL
- type — varchar(50) — NOT NULL
- link_id — varchar(50) — NOT NULL
- from_type — varchar(50) — NOT NULL
- page — varchar(50) — NOT NULL
- name — nvarchar(100) — NOT NULL
- saved_name — nvarchar(100) — NOT NULL
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_LANGUAGE
- module_code — varchar(50) — Primary key — NOT NULL
- code — varchar(50) — Primary key — NOT NULL
- type — int — NOT NULL
- name1 — nvarchar(250) — NOT NULL
- name2 — nvarchar(250)
- name3 — nvarchar(250)
- name4 — nvarchar(250)
- name5 — nvarchar(250)
- description — nvarchar(200)
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_MENU
- id — varchar(50) — Primary key — NOT NULL
- parent_id — varchar(50)
- type — int — NOT NULL
- name1 — nvarchar(50) — NOT NULL
- name2 — nvarchar(50)
- name3 — nvarchar(50)
- name4 — nvarchar(50)
- name5 — nvarchar(50)
- program_id — int
- program_param — nvarchar(200)
- description — nvarchar(200)
- is_use — varchar(1) — NOT NULL
- is_fixed — varchar(1)
- order_num — int
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_PROGRAM
- id — int — Primary key — NOT NULL
- name — nvarchar(50) — NOT NULL
- path — varchar(500)
- controller_name — varchar(500)
- description — nvarchar(200)
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_ROLE
- id — varchar(50) — Primary key — NOT NULL
- concurrency_stamp — nvarchar(256)
- name — nvarchar(256)
- normalized_name — nvarchar(256)
- created_id — varchar(50)
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_ROLECLAIM
- id — int — Primary key — NOT NULL
- claim_type — nvarchar(256)
- claim_value — nvarchar(256)
- role_id — varchar(50) — NOT NULL
- created_id — varchar(50)
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_ROLE_AUTHOR
- role_id — varchar(50) — Primary key — NOT NULL
- menu_id — varchar(50) — Primary key — NOT NULL
- auth_view — varchar(1) — NOT NULL
- auth_insert — varchar(1) — NOT NULL
- auth_select — varchar(1) — NOT NULL
- auth_update — varchar(1) — NOT NULL
- auth_delete — varchar(1) — NOT NULL
- auth_save — varchar(1) — NOT NULL
- auth_admin — varchar(1) — NOT NULL
- auth_download — varchar(1) — NOT NULL
- auth_reserve1 — varchar(1) — NOT NULL
- auth_reserve2 — varchar(1) — NOT NULL
- auth_reserve3 — varchar(1) — NOT NULL
- auth_reserve4 — varchar(1) — NOT NULL
- auth_reserve5 — varchar(1) — NOT NULL
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USER
- id — varchar(50) — Primary key — NOT NULL
- bsns_cd — char(5) — NOT NULL
- name — nvarchar(50) — NOT NULL
- sur_name — nvarchar(10) — NOT NULL
- given_name — nvarchar(40) — NOT NULL
- display_name — nvarchar(50) — NOT NULL
- security_level — int — NOT NULL
- access_failed_count — int — NOT NULL
- concurrency_stamp — nvarchar(256)
- email — varchar(50)
- email_confirmed — bit — NOT NULL
- lockout_enabled — bit — NOT NULL
- lockout_end — datetimeoffset(7)
- normalized_email — nvarchar(256)
- normalized_user_name — nvarchar(256)
- password_hash — nvarchar(256)
- phone_number — nvarchar(256)
- phone_number_confirmed — bit — NOT NULL
- security_stamp — nvarchar(256)
- two_factor_enabled — bit — NOT NULL
- user_name — nvarchar(256)
- allow_ip_range — varchar(256)
- deny_ip_range — varchar(256)
- timestamp — timestamp — NOT NULL
- discriminator — nvarchar(50)
- language — varchar(10) — NOT NULL
- is_use — varchar(1) — NOT NULL
- created_id — varchar(50)
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- deleted_date — datetime
- dept_id — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USERCLAIM
- id — int — Primary key — NOT NULL
- claim_type — nvarchar(256)
- claim_value — nvarchar(256)
- user_id — varchar(50) — NOT NULL
- created_id — varchar(50)
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USERTOKEN
- user_id — varchar(50) — Primary key — NOT NULL
- login_provider — varchar(50) — Primary key — NOT NULL
- name — varchar(50) — Primary key — NOT NULL
- id — int — NOT NULL
- value — nvarchar(max)
- created_id — varchar(50)
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USER_AUTHOR
- user_id — varchar(50) — Primary key — NOT NULL
- menu_id — varchar(50) — Primary key — NOT NULL
- auth_view — varchar(1) — NOT NULL
- auth_insert — varchar(1) — NOT NULL
- auth_select — varchar(1) — NOT NULL
- auth_update — varchar(1) — NOT NULL
- auth_delete — varchar(1) — NOT NULL
- auth_save — varchar(1) — NOT NULL
- auth_admin — varchar(1) — NOT NULL
- auth_download — varchar(1) — NOT NULL
- auth_reserve1 — varchar(1) — NOT NULL
- auth_reserve2 — varchar(1) — NOT NULL
- auth_reserve3 — varchar(1) — NOT NULL
- auth_reserve4 — varchar(1) — NOT NULL
- auth_reserve5 — varchar(1) — NOT NULL
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USER_EXTENSION
- user_id — varchar(50) — Primary key — NOT NULL
- mobile_phone — varchar(50)
- position_code — varchar(50)
- rank_code — varchar(50)
- join_date — varchar(10)
- retire_date — varchar(10)
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- cust_cd — varchar(30)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USER_LOGIN
- login_provider — varchar(50) — Primary key — NOT NULL
- provider_key — varchar(50) — Primary key — NOT NULL
- id — int — NOT NULL
- provider_display_name — nvarchar(max)
- user_id — varchar(50) — NOT NULL
- created_id — varchar(50)
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USER_MENU
- user_id — varchar(50) — Primary key — NOT NULL
- menu_id — varchar(50) — Primary key — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TC_USER_ROLE
- user_id — varchar(50) — Primary key — NOT NULL
- role_id — varchar(50) — Primary key — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TEMP_CONNECT
- pro_cd — nvarchar(50)
- pro_nm — nvarchar(50)
- vhcty_cd — nvarchar(50)
- max_qty — int
- box_qty — int
- in_out — nvarchar(5)
TI_CODE_STEP
- cate_key — varchar(30) — NOT NULL
- cate_cd — varchar(30) — NOT NULL
- cate_nm — nvarchar(40) — NOT NULL
- cate_val — varchar(30) — NOT NULL
- parent_cd — varchar(30)
- lvl — int
- job_se — nvarchar(50)
- cate_dc — varchar(max)
- sys_yn — char(1)
- ref1 — varchar(50)
- ref2 — varchar(50)
- ref3 — varchar(50)
- ref4 — varchar(50)
- ref5 — varchar(50)
- ref6 — varchar(50)
- ref7 — varchar(50)
- ref8 — varchar(50)
- ref9 — varchar(50)
- extn_link_yn — char(1)
- use_yn — char(1) — NOT NULL
- ord_no — int
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
TI_CON_BANK
- bank_cd — char(3) — Primary key — NOT NULL
- bank_nm — nvarchar(40) — NOT NULL
- bank_dc — nvarchar(2000)
- use_yn — char(1) — NOT NULL
- ord_no — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TI_CON_CALENDAR
- std_yy — int — Primary key — NOT NULL
- std_dt — varchar(10) — Primary key — NOT NULL
- std_mm — int — NOT NULL
- std_dd — int — NOT NULL
- week_of_yy — int — NOT NULL
- week_of_mm — int — NOT NULL
- day_of_week — nvarchar(10) — NOT NULL
- quarter_of_yy — int
- half_of_yy — nvarchar(10)
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TI_CON_COMP_BSNS
- bsns_cd — char(5) — Primary key — NOT NULL
- corp_cd — varchar(30)
- bsns_nm — nvarchar(40)
- bsns_snm — nvarchar(40)
- bsns_se — varchar(30)
- own_nm — nvarchar(40) — NOT NULL
- ssr_no — varchar(14)
- bsns_no — varchar(12) — NOT NULL
- corp_no — varchar(14)
- bizstart_dt — varchar(10)
- opbiz_dt — varchar(10)
- clsbiz_dt — varchar(10)
- bizcnd — nvarchar(50)
- bizitem — nvarchar(50)
- zip_no — varchar(7)
- addr — nvarchar(100)
- addr_dtl — nvarchar(150)
- email — varchar(100)
- bsns_tel — varchar(20)
- bsns_fax — varchar(20)
- bsns_url — varchar(200)
- national_se — varchar(30)
- bsns_dc — nvarchar(2000)
- head_bsns_yn — char(1)
- use_yn — char(1) — NOT NULL
- ord_no — int
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TI_CON_COMP_CORP
- corp_cd — varchar(30) — Primary key — NOT NULL
- corp_nm — nvarchar(40) — NOT NULL
- corp_snm — nvarchar(40)
- corp_se — varchar(30)
- own_nm — nvarchar(40) — NOT NULL
- ssr_no — varchar(14)
- bsns_no — varchar(12)
- corp_no — varchar(30)
- corp_est_dt — varchar(10)
- corp_opbiz_dt — varchar(10)
- corp_clsbiz_dt — varchar(10)
- comp_se — varchar(30)
- stacnt_mm — char(2)
- currency_se — varchar(30)
- corp_dc — nvarchar(2000)
- acc_accnt_cd — varchar(30)
- aprov_no — varchar(30)
- trade_no — varchar(30)
- capital_amt — decimal(38, 0)
- use_yn — char(1) — NOT NULL
- ord_no — int
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TI_CON_COMP_PLANT
- plant_cd — varchar(30) — Primary key — NOT NULL
- plant_nm — nvarchar(40) — NOT NULL
- corp_cd — varchar(30)
- bsns_cd — varchar(30)
- manage_plant — varchar(30)
- cost_plant — varchar(30)
- po_mng_plant — varchar(30)
- mm_mng_dept — varchar(50)
- pp_mng_dept — varchar(50)
- fm_dept — varchar(50)
- use_yn — char(1) — NOT NULL
- ord_no — int
- created_id — varchar(50) — NOT NULL
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TI_CON_CUST
- bsns_cd — char(5) — NOT NULL
- cust_cd — varchar(100) — NOT NULL
- cust_nm — varchar(500)
- ord_no — varchar(10)
- incharge_id — varchar(500)
- incharge_nm — varchar(500)
- incharge_dc — varchar(1000)
- cust_tp — varchar(30) — NOT NULL
- cust_se — varchar(30) — NOT NULL
- mker_yn — char(1)
- tax_se — varchar(30) — NOT NULL
- bsns_se — varchar(30)
- own_nm — varchar(500)
- cust_incharge_dc — varchar(500)
- ssr_no — varchar(14)
- bsns_no — varchar(50)
- corp_no — varchar(14)
- bank_cd — char(3)
- acnut_no — varchar(100)
- dpstr — nvarchar(40)
- bizcnd — nvarchar(500)
- bizitem — nvarchar(500)
- zip_no — varchar(10)
- addr — varchar(1000)
- addr_dtl — varchar(500)
- email — varchar(1000)
- bsns_tel — varchar(100)
- bsns_fax — varchar(100)
- bsns_cell — varchar(100)
- bsns_url — varchar(500)
- adjust_cd — varchar(30)
- cust_dc — text
- wh_cd — nvarchar(5)
- customer_yn — char(1)
- partner_yn — char(1)
- scm_yn — char(1)
- use_yn — char(1) — NOT NULL
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
TI_CON_HOLYDAY
- std_yy — int — Primary key — NOT NULL
- holy_dt — varchar(10) — Primary key — NOT NULL
- holy_nm — nvarchar(40) — NOT NULL
- holy_tp — varchar(30) — NOT NULL
- solar_yn — char(1)
- holy_dc — nvarchar(2000)
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TI_CON_PRINTFORM
- print_form_key — nvarchar(300) — NOT NULL
- cust_cd — varchar(100)
- cust_nm — varchar(500)
- cmpnt_cd — nvarchar(50)
- cmpnt_nm — nvarchar(500)
- rev_no — int
- print_form — text
- use_yn — char(1) — NOT NULL
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
- print_title — nvarchar(500)
TI_CON_REQUEST
- rqst_no — bigint — NOT NULL
- aprov_rqst_yn — char(1)
- rqst_subj — nvarchar(200)
- rqst_conts — nvarchar(max)
- limit_dt — varchar(10)
- imptance_yn — char(1)
- end_yn — char(1)
- stts — varchar(30)
- trget_path — varchar(50)
- trget_key1 — varchar(20)
- trget_val1 — varchar(50)
- trget_key2 — nvarchar(200)
- trget_val2 — varchar(50)
- link_url — varchar(max)
- rejt_conts — nvarchar(max)
- created_id — varchar(50)
- created_date — datetime — NOT NULL
- updated_id — varchar(50)
- updated_date — datetime
- all_yn — char(1)
TI_CON_REQUEST_TARGET
- rqst_no — bigint — NOT NULL
- trget_tp — varchar(30) — NOT NULL
- trget_id — varchar(50) — NOT NULL
- stts — varchar(30)
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
- comment — nvarchar(500) — varchar(500) NUL
- req_order — nvarchar(50)
- req_yn — nvarchar(50)
TI_CON_TEAM_LEADER
- mem_nm — nvarchar(20) — NOT NULL
- team_leader — nvarchar(20)
- tl_email — nvarchar(100)
TN_ERRLOG_DB
- err_code — varchar(11) — NOT NULL
- err_time — datetime — NOT NULL
- sys_nm — nvarchar(200) — NOT NULL
- proc_nm — nvarchar(128)
- custom_msg — nvarchar(4000)
- detail_msg — nvarchar(4000)
TN_IF_SCHE_T
- order_id — int — Primary key — NOT NULL
- order_no — nvarchar(16)
- t_date — nvarchar(10)
- t_time — nvarchar(8)
- order_status — numeric(10, 0)
- program_cnt — numeric(10, 0)
- unload — numeric(10, 0)
- t_set — numeric(10, 0)
- program_siq1 — nvarchar(64)
- laser1 — nvarchar(1)
- material1 — nvarchar(64)
- thickness1 — numeric(7, 2)
- sheet_x1 — numeric(10, 0)
- sheet_y1 — numeric(10, 0)
- ji_code1 — numeric(5, 0)
- qty1 — numeric(5, 0)
- fin_qty1 — numeric(5, 0)
- cycle1 — numeric(5, 0)
- kend_set1 — numeric(5, 0)
- kend_qty1 — numeric(5, 0)
- unload1 — numeric(5, 0)
- sort_set1 — numeric(5, 0)
- add_order_no1 — nvarchar(16)
- program_siq2 — nvarchar(64)
- laser2 — nvarchar(1)
- material2 — nvarchar(64)
- thickness2 — numeric(7, 2)
- sheet_x2 — numeric(10, 0)
- sheet_y2 — numeric(10, 0)
- ji_code2 — numeric(5, 0)
- qty2 — numeric(5, 0)
- fin_qty2 — numeric(5, 0)
- cycle2 — numeric(5, 0)
- kend_set2 — numeric(5, 0)
- kend_qty2 — numeric(5, 0)
- unload2 — numeric(5, 0)
- sort_set2 — numeric(5, 0)
- add_order_no2 — nvarchar(16)
- program_siq3 — nvarchar(64)
- laser3 — nvarchar(1)
- material3 — nvarchar(64)
- thickness3 — numeric(7, 2)
- sheet_x3 — numeric(10, 0)
- sheet_y3 — numeric(10, 0)
- ji_code3 — numeric(5, 0)
- qty3 — numeric(5, 0)
- fin_qty3 — numeric(5, 0)
- cycle3 — numeric(5, 0)
- kend_set3 — numeric(5, 0)
- kend_qty3 — numeric(5, 0)
- unload3 — numeric(5, 0)
- sort_set3 — numeric(5, 0)
- add_order_no3 — nvarchar(16)
- program_siq4 — nvarchar(64)
- laser4 — nvarchar(1)
- material4 — nvarchar(64)
- thickness4 — numeric(7, 2)
- sheet_x4 — numeric(10, 0)
- sheet_y4 — numeric(10, 0)
- ji_code4 — numeric(5, 0)
- … +336
TN_IF_TPUR_ORDER_DETAIL
- order_no — nvarchar(20) — NOT NULL
- order_seq — int
- ins_cd — nvarchar(20)
- part_code — nvarchar(50)
- unit_cost — decimal(19, 2)
- order_qty — decimal(9, 2)
- order_amt — decimal(19, 2)
- order_state — nvarchar(2)
- cancel_reason — nvarchar(300)
- insert_userid — nvarchar(10)
- insert_time — datetime
- update_userid — nvarchar(10)
- update_time — datetime
- full_receive — nvarchar(10)
TN_IF_TPUR_ORDER_MASTER
- order_no — nvarchar(20) — NOT NULL
- ven_code — nvarchar(10)
- order_date — nvarchar(8)
- due_date — nvarchar(8)
- order_state — nvarchar(2)
- confirm_date — nvarchar(8)
- confirm_emp_code — nvarchar(10)
- memo — nvarchar(300)
- insert_userid — nvarchar(10)
- insert_time — datetime
- update_userid — nvarchar(10)
- update_time — datetime
TN_MAIL_SET
- doc_no — nvarchar(20) — Primary key — NOT NULL
- menu_name — nvarchar(500)
- explain — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TN_MAIL_SET_DTL
- seq_no — int — Primary key — NOT NULL
- parent_cd — nvarchar(500)
- user_id — varchar(50)
- user_name — nvarchar(50)
- email — varchar(50)
- created_id — varchar(20)
- created_date — datetime
- use_yn — char(1) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TN_MES_ACINS_REG
- don_no — nvarchar(20) — Primary key — NOT NULL
- pro_cd — nvarchar(20) — NOT NULL
- com_qy — numeric(22, 0) — NOT NULL
- real_qy — numeric(22, 0) — NOT NULL
- diff_qy — numeric(22, 0) — NOT NULL
- barcode — nvarchar(20)
- acins_dt — datetime — NOT NULL
- application_yn — char(1) — NOT NULL
- check_yn — char(1) — NOT NULL
- use_yn — char(1)
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
- wh_cd — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TN_MES_ACINS_SCAN
- scan_no — nvarchar(20) — NOT NULL
- barcode — nvarchar(20) — NOT NULL
- scan_dt — datetime — NOT NULL
- pro_cd — nvarchar(20)
- pro_nm — nvarchar(500)
- prcd_qy — numeric(22, 0)
- wh_cd — nvarchar(20)
- barcode_used — char(1)
- comp_cd — nvarchar(20)
- bsns_cd — nvarchar(20)
- plant_cd — nvarchar(20)
- use_yn — char(1)
- created_id — varchar(50)
- created_date — datetime
- eq_cd — nvarchar(20)
- research_dt — nvarchar(20)
TN_MES_AUTOMATION_INSPECTION
- seq — nvarchar(20) — Primary key — NOT NULL
- serial_no — nvarchar(20)
- barcode — nvarchar(20)
- lot_cd — nvarchar(20)
- reg_date — datetime
- comp_cd — nvarchar(20)
- bsns_cd — nvarchar(20)
- plant_cd — nvarchar(20)
- use_yn — char(1)
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
- chk_val — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TN_MES_AUTOMATION_INSPECTION_BAD
- seq — int — Primary key — NOT NULL
- pro_cd — nvarchar(20) — NOT NULL
- line_cd — nvarchar(2) — NOT NULL
- bad_cd — nvarchar(10) — NOT NULL
- bad_nm — nvarchar(50)
- bad_qty — int
- remark — nvarchar(4000)
- reg_date — datetime
- created_id — varchar(50)
- created_date — datetime
- updated_id — varchar(50)
- updated_date — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
고객사
- 비고 — nvarchar(500)
- 거래처명 — nvarchar(500)
- 영문명 — nvarchar(500)
- 거래처담당자 — nvarchar(500)
- 담당자 — nvarchar(500)
- 사업자번호 — nvarchar(500)
- 일련번호 — nvarchar(500)
- 주민번호(외국인번호) — nvarchar(500)
- 대표자명 — nvarchar(500)
- 우편번호 — nvarchar(500)
- 주소 — nvarchar(500)
- 전화 — nvarchar(500)
- Fax번호 — nvarchar(500)
- E-Mail — nvarchar(500)
- 상호 — nvarchar(500)
- 종목 — nvarchar(500)
- 업태 — nvarchar(500)
- 유통구조 — nvarchar(500)
- CustormerNo — nvarchar(500)
- 은행계좌 — nvarchar(500)
- 비고1 — nvarchar(500)
- 담당자비고 — nvarchar(500)
- 사업장 — nvarchar(500)
- 거래처분류1 — nvarchar(500)
- 거래처분류2 — nvarchar(500)
- 거래처분류3 — nvarchar(500)
- 거래처분류4 — nvarchar(500)
- 집계거래처 — nvarchar(500)
- 거래처상태 — nvarchar(500)
- 거래개시일 — nvarchar(500)
- 영문약명 — nvarchar(500)
- sheet — 정보
- sheet — key
- Dummy — nvarchar(500)
- Dummy1 — nvarchar(500)
- JUMP — PGM_ID
- JUMP — PGM_ID
사원명부
- 부서 — varchar(255)
- 성명 — varchar(255)
- 사번 — varchar(255)
- 직위 — varchar(255)
- 직종 — varchar(255)
- 사원구분 — varchar(255)
- 입사일자 — varchar(255)
- 퇴사일자 — varchar(255)
- 재직여부 — varchar(255)
- 주민등록번호 — varchar(255)
- 직무내역 — varchar(255)
- 성별 — varchar(255)
- 나이 — varchar(255)
- 종교 — varchar(255)
- 최종학력 — varchar(255)
- 근무부서 — varchar(255)
원자재현황
- 자재명 — nvarchar(255)
- 자재번호 — nvarchar(255)
- 규격 — nvarchar(255)
- 재고단위 — nvarchar(255)
- 구매단위 — nvarchar(255)
- 조달기간 — nvarchar(255)
- 재고자산구분 — nvarchar(255)
- 안전재고수량 — float
- 적정발주수량 — float
- 투입구분 — nvarchar(255)
- 자재분류1 — nvarchar(255)
- 자재분류2 — nvarchar(255)
- 자재분류3 — nvarchar(255)
- 자재분류4 — nvarchar(255)
- 기본구매처 — nvarchar(255)
- Maker — nvarchar(255)
- 관리부서 — nvarchar(255)
- 관리창고 — nvarchar(255)
- 검사여부 — nvarchar(255)
- 등록일 — nvarchar(255)
- 등록자 — nvarchar(255)
- 수정일 — nvarchar(255)
- 내외자구분 — nvarchar(255)
- 중요도 — nvarchar(255)
- 상태 — nvarchar(255)
- 약명1 — nvarchar(255)
- 약명2 — nvarchar(255)
- 약명3 — nvarchar(255)