K1 ERD
Tables (38)
t_apply_delivery
- apply_delivery_idx — int(11) — Primary key — NOT NULL
- delivery_idx (delivery_idx2) — int(11) — Foreign key → t_delivery.delivery_idx — NOT NULL
- delivery_idx — int(11)
- lot_no — varchar(20)
- product_idx — int(11)
- warehouse_idx — int(11)
- pkg_amount — int(11)
- pkg_qty — int(11)
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- sobun_yn — char(1)
- sobun_qty — int(11)
- lot_fix — char(1)
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product.manu_brand_idx — NOT NULL
t_apply_wearing
- apply_wearing_idx — int(11) — Primary key — NOT NULL
- purchase_idx (purchase_idx2) — int(11) — Foreign key → t_purchase.purchase_idx — NOT NULL
- purchase_idx — int(11) — NOT NULL
- wearing_order — int(11)
- wearing_date — datetime
- income_num — varchar(20)
- lot_no — varchar(20)
- pkg_amount — int(11)
- pkg_qty — int(11)
- manu_date — datetime
- valid_date — datetime
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
t_business_log
- business_log_idx — int(11) — Primary key — NOT NULL
- company_idx — int(11)
- business_log_status — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- ses_reg_date — datetime
- company_address_idx — int(11)
- company_idx (company_idx2) — int(11) — Foreign key → t_company.company_idx — NOT NULL
t_business_log_content
- bsn_con_idx — int(11) — Primary key — NOT NULL
- business_log_product_idx (business_log_product_idx2) — int(11) — Foreign key → t_business_log_product.business_log_product_idx — NOT NULL
- business_log_idx (business_log_idx2) — int(11) — Foreign key → t_business_log_product.business_log_idx — NOT NULL
- business_log_product_idx — int(11)
- bsn_type — varchar(20)
- bsn_prg — int(11)
- bsn_con — varchar(8000)
- exp_order_date — varchar(10)
- exp_order_qty — int(11)
t_business_log_product
- business_log_product_idx — int(11) — Primary key — NOT NULL
- business_log_idx (business_log_idx2) — int(11) — Foreign key → t_business_log.business_log_idx — NOT NULL
- business_log_idx — int(11)
- product_idx — int(11)
- bra_nm — varchar(100)
- reg_id — varchar(20)
- reg_date — datetime
- product_nm — varchar(50)
- bra_idx — int(11)
t_business_log_psn
- business_log_psn_idx — int(11) — Primary key — NOT NULL
- business_log_idx (business_log_idx2) — int(11) — Foreign key → t_business_log.business_log_idx — NOT NULL
- business_log_idx — int(11)
- psn_id — varchar(20)
- psn_nm — varchar(50)
- psn_posi — varchar(20)
- reg_id — varchar(20)
- reg_date — datetime
t_code
- code — varchar(20) — Primary key — NOT NULL
- code_type — char(4)
- code_nm — varchar(20)
- code_order — int(11)
- reg_date — datetime
- reg_id — varchar(20)
- del_yn — char(1)
t_company
- company_idx — int(11) — Primary key — NOT NULL
- company_nm — varchar(100)
- buy_yn — char(1)
- sell_yn — char(1)
- company_phone — varchar(50)
- company_fax — varchar(20)
- company_num — varchar(50)
- company_nation — varchar(20)
- available_yn — char(1)
- company_bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- ses_reg_id — varchar(20)
- ses_udt_id — varchar(20)
- company_region — varchar(20)
- company_gubun — varchar(20)
- company_business — varchar(100)
t_company_address
- company_address_idx — int(11) — Primary key — NOT NULL
- company_idx — int(11) — Primary key — NOT NULL
- company_idx (company_idx2) — int(11) — Foreign key → t_company.company_idx — NOT NULL
- address_nm — varchar(100)
- address — varchar(200)
- represent — char(1)
- reg_id — varchar(20)
- reg_date — datetime
- del_yn — char(1)
- business_log_idx — int(11) — Foreign key → t_business_log.business_log_idx — NOT NULL
t_company_psn
- company_psn_idx — int(11) — Primary key — NOT NULL
- company_idx (company_idx2) — int(11) — Foreign key → t_company.company_idx — NOT NULL
- company_idx — int(11)
- company_psn_nm — varchar(50)
- company_psn_dept — varchar(50)
- company_psn_rank — varchar(50)
- company_psn_phone — varchar(50)
- company_psn_email — varchar(100)
- reg_id — varchar(20)
- reg_date — datetime
- del_yn — char(1)
- psn_represent — char(1)
t_delivery
- delivery_idx — int(11) — Primary key — NOT NULL
- company_from_idx — int(11)
- company_to_idx — int(11)
- delivery_contact — varchar(100)
- company_psn_idx — int(11)
- company_address_idx — int(11)
- due_date — datetime
- reg_date — datetime
- reg_id — varchar(20)
- delivery_status — int(11)
- delivery_bigo — varchar(1000)
- udt_date — datetime
- udt_id — varchar(20)
- del_yn — char(1)
- dvr_no — varchar(20)
- pre_pay — char(1) — NOT NULL
- order_date — datetime
- order_method — varchar(20)
- company_idx — int(11) — Foreign key → t_company.company_idx — NOT NULL
t_expect_delivery
- expect_delivery_idx — int(11) — Primary key — NOT NULL
- delivery_idx (delivery_idx2) — int(11) — Foreign key → t_delivery.delivery_idx — NOT NULL
- delivery_idx — int(11)
- product_idx — int(11)
- warehouse_idx — int(11)
- lot_no — varchar(20)
- pkg_amount — int(11)
- pkg_qty — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- sobun_yn — char(1)
- sobun_qty — int(11)
- expect_status — int(11)
- lot_fix — char(1)
- row_order — int(11)
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product.manu_brand_idx — NOT NULL
t_expect_wearing
- expect_wearing_idx — int(11) — Primary key — NOT NULL
- purchase_idx (purchase_idx2) — int(11) — Foreign key → t_purchase.purchase_idx — NOT NULL
- purchase_idx — int(11)
- expect_wearing_order — int(11)
- expect_wearing_date — datetime
- income_num — varchar(20)
- lot_no — varchar(20)
- expect_pkg_amount — int(11)
- expect_pkg_qty — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- wearing_status — int(11)
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- expect_status — int(11)
- manu_date — datetime
- valid_date — datetime
t_partner
- user_id — varchar(20) — Primary key — NOT NULL
- manu_brand_idx — int(11) — Primary key — NOT NULL
- user_id (user_id2) — varchar(20) — Foreign key → t_user.user_id — NOT NULL
- product_file_idx — int(11) — Foreign key → t_product_file.product_file_idx — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_product_file.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product_file.manu_brand_idx — NOT NULL
t_partner_company
- partner_company_idx — int(11) — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → t_partner.user_id — NOT NULL
- manu_brand_idx — int(11) — Foreign key → t_partner.manu_brand_idx — NOT NULL
- user_id (user_id2) — varchar(20) — Foreign key → t_partner.user_id — NOT NULL
- product_file_idx — int(11) — Foreign key → t_partner.product_file_idx — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_partner.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_partner.manu_brand_idx — NOT NULL
- partner_company_nm — varchar(100)
- partner_company_phone — varchar(50)
- partner_company_fax — varchar(20)
- partner_company_num — varchar(50)
- partner_company_nation — varchar(20)
- available_yn — char(1)
- partner_company_bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- ses_reg_id — varchar(20)
- ses_udt_id — varchar(20)
- partner_company_region — varchar(20)
- partner_company_gubun — varchar(20)
- partner_company_business — varchar(100)
t_partner_company_address
- partner_company_address_idx — int(11) — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → t_partner.user_id — NOT NULL
- manu_brand_idx — int(11) — Foreign key → t_partner.manu_brand_idx — NOT NULL
- user_id (user_id2) — varchar(20) — Foreign key → t_partner.user_id — NOT NULL
- product_file_idx — int(11) — Foreign key → t_partner.product_file_idx — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_partner.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_partner.manu_brand_idx — NOT NULL
- partner_company_idx — int(11) — NOT NULL
- partner_address_nm — varchar(100)
- partner_address — varchar(200)
- represent — char(1)
- del_yn — char(1)
t_partner_company_psn
- partner_company_psn_idx — int(11) — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → t_partner.user_id — NOT NULL
- manu_brand_idx — int(11) — Foreign key → t_partner.manu_brand_idx — NOT NULL
- user_id (user_id2) — varchar(20) — Foreign key → t_partner.user_id — NOT NULL
- product_file_idx — int(11) — Foreign key → t_partner.product_file_idx — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_partner.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_partner.manu_brand_idx — NOT NULL
- partner_company_idx — int(11)
- partner_company_psn_nm — varchar(50)
- partner_company_psn_dept — varchar(50)
- partner_company_psn_rank — varchar(50)
- partner_company_psn_phone — varchar(50)
- partner_company_psn_email — varchar(100)
- psn_represent — char(1)
- del_yn — char(1)
t_product
- product_idx — int(11) — Primary key — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product_manu_brand.manu_brand_idx — NOT NULL
- product_nm — varchar(100)
- hs_code — varchar(50)
- inci — varchar(200)
- pkg_unit — varchar(20)
- product_bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- manu_brand_idx — int(11)
t_product_file
- product_file_idx — int(11) — Primary key — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product.manu_brand_idx — NOT NULL
- product_idx — int(11)
- reg_date — datetime
- manu_brand_idx — int(11)
- material_gubun — varchar(200)
- material_name — varchar(200)
- rev — int(11)
- bigo — varchar(1000)
- reg_id — varchar(20)
- ses_reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- available — char(1)
t_product_manu_brand
- manu_brand_idx — int(11) — Primary key — NOT NULL
- bra_nm — varchar(100)
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(45)
- udt_date — varchar(45)
- del_yn — char(1)
t_purchase
- purchase_idx — int(11) — Primary key — NOT NULL
- product_idx — int(11)
- company_idx — int(11)
- purchase_date — datetime
- warehouse_idx — int(11)
- cost — bigint(20)
- income_cost — decimal(10,2)
- income_cost_unit — varchar(20)
- total_purchase_qty — bigint(19)
- purchase_bigo — varchar(1000)
- company_psn_idx — int(11)
- brand_idx — int(11)
- reg_date — datetime
- reg_id — varchar(20)
- udt_id — varchar(20)
- udt_date — datetime
- purchase_status — int(11)
- udt_purchase_date — datetime
- udt_total_purchase_qty — bigint(30)
- udt_purchase_bigo — varchar(1000)
- del_yn — char(1)
- prch_no — varchar(20)
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product.manu_brand_idx — NOT NULL
t_real_delivery
- real_delivery_idx — int(11) — Primary key — NOT NULL
- delivery_idx (delivery_idx2) — int(11) — Foreign key → t_delivery.delivery_idx — NOT NULL
- delivery_idx — int(11)
- lot_no — varchar(20)
- product_idx — int(11)
- warehouse_idx — int(11)
- pkg_amount — int(11)
- pkg_qty — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- sobun_yn — char(1)
- sobun_qty — int(11)
- comment — varchar(1000)
- real_status — int(11)
- lot_fix — char(1)
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product.manu_brand_idx — NOT NULL
t_rental
- rental_idx — int(11) — Primary key — NOT NULL
- company_idx — int(11)
- company_address_idx — int(11)
- company_psn_idx — int(11)
- rental_contact — varchar(100)
- rental_date — datetime
- rental_bigo — varchar(1000)
- del_yn — char(1)
- rental_no — varchar(20)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
t_rental_product
- rental_product_idx — int(11) — Primary key — NOT NULL
- rental_idx (rental_idx2) — int(11) — Foreign key → t_rental.rental_idx — NOT NULL
- rental_idx — int(11)
- rental_type — int(11)
- product_idx — int(11)
- warehouse_idx — int(11)
- lot_no — varchar(50)
- pkg_amount — int(11)
- pkg_qty — int(11)
- sobun_yn — char(1)
- sobun_qty — int(11)
t_return
- return_idx — int(11) — Primary key — NOT NULL
- return_no — varchar(20)
- return_status — int(11)
- company_from_idx — int(11)
- company_to_idx — int(11)
- return_contact — varchar(100)
- company_psn_idx — int(11)
- company_address_idx — int(11)
- return_date — varchar(10)
- return_bigo — varchar(2000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- warehouse_idx — int(11)
t_send
- send_idx — int(11) — Primary key — NOT NULL
- send_type — char(4)
- send_content — varchar(1000)
- sales_psnid — varchar(20)
- req_date — datetime
- company_idx — int(11)
- company_psn_idx — int(11)
- company_psn_text — varchar(100)
- proc_id — varchar(20)
- proc_date — datetime
- send_bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- mail_yn — char(1)
- del_yn — char(1)
- bra_idx — int(11)
t_send_etc
- send_etc_idx — int(11) — Primary key — NOT NULL
- support_content — varchar(200)
- sales_psn_nm — varchar(50)
- company_nm — varchar(100)
- company_psn_nm — varchar(50)
- req_date — datetime
- due_date — datetime
- proc_nm — varchar(50)
- proc_date — datetime
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- bra_idx — int(11)
t_send_mail
- send_mail_idx — int(11) — Primary key — NOT NULL
- send_idx (send_idx2) — int(11) — Foreign key → t_send.send_idx — NOT NULL
- send_idx — int(11)
- mail_title — varchar(200)
- mail_content — varchar(1000)
- mail_ref — varchar(100)
- send_mail_status — int(11)
- send_id — varchar(20)
- send_date — datetime
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- receiver_email — varchar(100)
- receiver_nm — varchar(50)
- cc_email — varchar(300)
- bcc_email — varchar(300)
t_send_mail_file_history
- send_mail_idx — int(11) — Primary key — NOT NULL
- file_idx — int(11) — Primary key — NOT NULL
- lot_no — varchar(50) — Primary key — NOT NULL
- send_mail_idx (send_mail_idx2) — int(11) — Foreign key → t_send_mail.send_mail_idx — NOT NULL
- send_idx (send_idx2) — int(11) — Foreign key → t_send_mail.send_idx — NOT NULL
t_send_pdf
- send_idx — int(11) — Primary key — NOT NULL
- pdf_type — int(11)
- send_date — datetime
- receiver_company_nm — varchar(200)
- reference_nm — varchar(50)
- reference_email — varchar(100)
- bigo — varchar(2000)
- order_date — datetime
- release_date — datetime
- tel — varchar(100)
- fax — varchar(100)
- warehouse_idx — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- estm_cond — varchar(2000)
- pdf_no — varchar(100)
t_send_pdf_product
- send_pdf_product_idx — int(11) — Primary key — NOT NULL
- send_idx — int(11)
- product_nm — varchar(100)
- standard — varchar(100)
- price — int(20)
- price2 — int(11)
- maker — varchar(100)
- product_bigo — varchar(500)
- reg_id — varchar(20)
- reg_date — datetime
- pack_spc — int(20)
- supply_price — int(20)
- tax_amount — int(20)
t_send_sample
- send_sample_idx — int(11) — Primary key — NOT NULL
- proc_date — datetime
- company_idx — int(11)
- company_psn_idx — int(11)
- company_psn_text — varchar(100)
- send_sample_bigo — varchar(1000)
- company_address_idx — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- proc_id — varchar(20)
- req_id — varchar(20)
- del_yn — char(1)
- bra_idx — int(11)
- sample_contact — varchar(50)
- dvr_num — varchar(20)
t_send_sample_product
- send_sample_product_idx — int(11) — Primary key — NOT NULL
- send_sample_idx (send_sample_idx2) — int(11) — Foreign key → t_send_sample.send_sample_idx — NOT NULL
- send_sample_idx — int(11)
- product_idx — int(11)
- product_qty — int(11)
t_stock
- product_idx — int(11) — Primary key — NOT NULL
- warehouse_idx — int(11) — Primary key — NOT NULL
- pkg_amount — int(11) — Primary key — NOT NULL
- lot_no — varchar(20) — Primary key — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product.manu_brand_idx — NOT NULL
- warehouse_idx (warehouse_idx2) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
- pkg_qty — int(11)
- manu_date — datetime
- valid_date — datetime
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- income_num — varchar(20)
t_stock_process_history
- stock_process_history — int(11) — Primary key — NOT NULL
- type — varchar(10)
- product_idx — int(11)
- warehouse_idx — int(11)
- lot_no — varchar(20)
- pkg_amount — int(11)
- pkg_qty — int(11)
- reason — varchar(300)
- reg_id — varchar(20)
- reg_date — datetime
t_user
- user_id — varchar(20) — Primary key — NOT NULL
- user_password — varchar(200)
- user_nm — varchar(50)
- user_phone — varchar(20)
- user_email — varchar(100)
- user_auth — varchar(20)
- warehouse_idx — int(11)
- user_status — int(11)
- user_mailsign — varchar(1000)
- user_posi — varchar(20)
- user_rank — varchar(20)
- user_dept — varchar(20)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- main_apply — int(11)
- main_house — int(11)
- main_valid — int(11)
- main_support — int(11)
- main_support_detail — int(11)
- manu_brand_idx — int(11)
- del_yn — char(1)
- notice_idx — int(11)
- bs_log1 — int(11)
- bs_log2 — int(11)
- main_return_wait — int(11)
- main_return_fin — int(11)
- search_yn — char(1) — NOT NULL
- code — varchar(20) — Foreign key → t_code.code — NOT NULL
t_warehouse
- warehouse_idx — int(11) — Primary key — NOT NULL
- warehouse_nm — varchar(20)
- color — varchar(50)
- warehouse_status — char(1)
- warehouse_bigo — varchar(1000)
- address — varchar(200)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- tell — varchar(20)
t_warehouse_auth
- warehouse_idx — int(11) — Primary key — NOT NULL
- auth_idx — int(11) — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → t_user.user_id — NOT NULL
- warehouse_idx (warehouse_idx2) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL