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