GOMETRIC-ERP

Tables (73)

admin_board

  • post_id — BIGINT(20) — Primary key — NOT NULL
  • board_id — BIGINT(20) — NOT NULL
  • ref_post_id — BIGINT(20)
  • rep_post_id — BIGINT(20)
  • depth — INT(11)
  • title — VARCHAR(1000)
  • contents — TEXT
  • read_count — BIGINT(20)
  • notify_flag — TINYINT(4)
  • category — VARCHAR(32)
  • regist_id — VARCHAR(32)
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

admin_board_files

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • post_id — BIGINT(20) — Foreign key → admin_board.post_id — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL

advance_payment

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Primary key — NOT NULL
  • contract_id — VARCHAR(20) — Primary key — NOT NULL
  • payment_type — VARCHAR(32) — NOT NULL
  • payment — BIGINT(20) — NOT NULL
  • balance — BIGINT(20) — NOT NULL
  • change_balance — BIGINT(20) — NOT NULL
  • signed_date — DATE — NOT NULL
  • expiration_date — DATE — NOT NULL
  • etc — TEXT
  • file_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

advance_payment_contract

  • idx — BIGINT(20) — Primary key — NOT NULL
  • ref_idx — BIGINT(20)
  • action_type — CHAR(1) — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • company_id — BIGINT(20) — NOT NULL
  • contract_id — VARCHAR(20) — NOT NULL
  • payment_type — VARCHAR(32) — NOT NULL
  • payment — BIGINT(20) — NOT NULL
  • balance — BIGINT(20) — NOT NULL
  • signed_date — DATE — NOT NULL
  • expiration_date — DATE — NOT NULL
  • etc — TEXT
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • delete_flag — BIT(1) — NOT NULL

advance_payment_contract_files

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • idx — BIGINT(20) — Foreign key → advance_payment_contract.idx — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL

advance_payment_history

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Primary key — NOT NULL
  • contract_id — VARCHAR(20) — Primary key — NOT NULL
  • weighing_id — VARCHAR(32) — Primary key — NOT NULL
  • balance — INT(11) — NOT NULL
  • change_balance — INT(11) — NOT NULL
  • advance_price — INT(11) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

approval

  • menu_id — VARCHAR(32) — Foreign key → menu.menu_id — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenants.tenant_id — NOT NULL
  • user_id — VARCHAR(32) — Foreign key → users.user_id — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

board_config

  • board_id — BIGINT(20) — Primary key — NOT NULL
  • board_name — VARCHAR(50)
  • use_flag — BIT(1)
  • notify_flag — BIT(1)
  • reply_flag — BIT(1)
  • category_flag — BIT(1)
  • category_group — VARCHAR(32)
  • base_file_dir — VARCHAR(1000)
  • max_file_count — INT(11)
  • max_file_size — BIGINT(20)
  • extensions — VARCHAR(1000)
  • regist_id — VARCHAR(32)
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME

calculate_purchase

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • calculate_id — VARCHAR(32) — Primary key — NOT NULL
  • calculate_date — DATE — NOT NULL
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • company_id — BIGINT(20) — NOT NULL
  • decision_price — BIGINT(20) — NOT NULL
  • vat — BIGINT(20) — NOT NULL
  • total_price — BIGINT(20) — NOT NULL
  • sup_amt_eq_flag — BIT(1) — NOT NULL
  • system_flag — BIT(1) — NOT NULL
  • nts_approval_flag — BIT(1) — NOT NULL
  • approval_no — VARCHAR(50)
  • approval_date — DATETIME
  • status — VARCHAR(32) — NOT NULL
  • item_name — VARCHAR(32)
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • map_calculate_id — VARCHAR(32)
  • conversation_id — VARCHAR(50)
  • write_date — DATE
  • issue_date — DATETIME
  • transfer_date — DATETIME
  • etc_memo — TEXT
  • supply_email — VARCHAR(256)
  • receive_email1 — VARCHAR(256)
  • receive_email2 — VARCHAR(256)
  • calculate_auto_flag — BIT(1) — NOT NULL
  • account_idx — BIGINT(20) — NOT NULL
  • pay_status — VARCHAR(32) — NOT NULL
  • pay_date — DATETIME
  • advance_payment_flag — BIT(1) — NOT NULL

calculate_sale

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • calculate_id — VARCHAR(32) — Primary key — NOT NULL
  • calculate_date — DATE — NOT NULL
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • company_id — BIGINT(20) — NOT NULL
  • decision_price — BIGINT(20) — NOT NULL
  • vat — BIGINT(20) — NOT NULL
  • total_price — BIGINT(20) — NOT NULL
  • sup_amt_eq_flag — BIT(1) — NOT NULL
  • system_flag — BIT(1) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • item_name — VARCHAR(32)
  • incentive_flag — BIT(1) — NOT NULL
  • incentive_price — BIGINT(20) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • conversation_id — VARCHAR(50)
  • approval_no — VARCHAR(50)
  • approval_date — DATETIME
  • nts_approval_flag — BIT(1) — NOT NULL
  • write_date — DATE
  • issue_date — DATETIME
  • transfer_date — DATETIME
  • etc_memo — TEXT
  • supply_email — VARCHAR(256)
  • receive_email1 — VARCHAR(256)
  • receive_email2 — VARCHAR(256)
  • calculate_auto_flag — BIT(1) — NOT NULL
  • account_idx — BIGINT(20) — NOT NULL
  • pay_status — VARCHAR(32) — NOT NULL
  • pay_date — DATETIME

calculate_transit

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • calculate_id — VARCHAR(32) — Primary key — NOT NULL
  • calculate_date — DATE — NOT NULL
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • company_id — BIGINT(20) — NOT NULL
  • decision_price — BIGINT(20) — NOT NULL
  • vat — BIGINT(20) — NOT NULL
  • total_price — BIGINT(20) — NOT NULL
  • sup_amt_eq_flag — BIT(1) — NOT NULL
  • system_flag — BIT(1) — NOT NULL
  • nts_approval_flag — BIT(1) — NOT NULL
  • approval_no — VARCHAR(50)
  • approval_date — DATETIME
  • status — VARCHAR(32) — NOT NULL
  • item_name — VARCHAR(32)
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • write_date — DATE
  • issue_date — DATETIME
  • transfer_date — DATETIME
  • etc_memo — TEXT
  • supply_email — VARCHAR(256)
  • receive_email1 — VARCHAR(256)
  • receive_email2 — VARCHAR(256)
  • calculate_auto_flag — BIT(1) — NOT NULL
  • account_idx — BIGINT(20) — NOT NULL
  • pay_status — VARCHAR(32) — NOT NULL
  • pay_date — DATETIME

calculate_transit_history

  • idx — INT(11) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • weighing_id — VARCHAR(32) — NOT NULL
  • transportation_type — VARCHAR(32)
  • transportation_price — INT(11) — NOT NULL
  • edit_reason — MEDIUMTEXT

calculate_waste

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • calculate_id — VARCHAR(32) — Primary key — NOT NULL
  • calculate_date — DATE — NOT NULL
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • company_id — BIGINT(20) — NOT NULL
  • decision_price — BIGINT(20) — NOT NULL
  • vat — BIGINT(20) — NOT NULL
  • total_price — BIGINT(20) — NOT NULL
  • sup_amt_eq_flag — BIT(1) — NOT NULL
  • system_flag — BIT(1) — NOT NULL
  • nts_approval_flag — BIT(1) — NOT NULL
  • approval_no — VARCHAR(50)
  • approval_date — DATETIME
  • status — VARCHAR(32) — NOT NULL
  • item_name — VARCHAR(32)
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • write_date — DATE
  • issue_date — DATETIME
  • transfer_date — DATETIME
  • etc_memo — TEXT
  • supply_email — VARCHAR(256)
  • receive_email1 — VARCHAR(256)
  • receive_email2 — VARCHAR(256)
  • calculate_auto_flag — BIT(1) — NOT NULL
  • account_idx — BIGINT(20) — NOT NULL
  • pay_status — VARCHAR(32) — NOT NULL
  • pay_date — DATETIME

code_group

  • group_code — VARCHAR(32) — Primary key — NOT NULL
  • group_code_name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • sort — INT(11) — NOT NULL
  • use_flag — BIT(1) — NOT NULL
  • system_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

codes

  • code — VARCHAR(32) — Primary key — NOT NULL
  • group_code — VARCHAR(32) — Foreign key → code_group.group_code — NOT NULL
  • code_name — VARCHAR(50) — NOT NULL
  • up_code — VARCHAR(32)
  • code_path — VARCHAR(1000)
  • description — TEXT
  • use_flag — BIT(1) — NOT NULL
  • sort — INT(11) — NOT NULL
  • ref_type_1 — VARCHAR(32)
  • ref_type_2 — VARCHAR(32)
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

column_visible

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • user_id — VARCHAR(32) — Primary key — NOT NULL
  • menu_id — VARCHAR(32) — Primary key — NOT NULL
  • column_1_flag — BIT(1) — NOT NULL
  • column_2_flag — BIT(1) — NOT NULL
  • column_3_flag — BIT(1) — NOT NULL
  • column_4_flag — BIT(1) — NOT NULL
  • column_5_flag — BIT(1) — NOT NULL
  • column_6_flag — BIT(1) — NOT NULL
  • column_7_flag — BIT(1) — NOT NULL
  • column_8_flag — BIT(1) — NOT NULL
  • column_9_flag — BIT(1) — NOT NULL
  • column_10_flag — BIT(1) — NOT NULL
  • column_11_flag — BIT(1) — NOT NULL
  • column_12_flag — BIT(1) — NOT NULL
  • column_13_flag — BIT(1) — NOT NULL
  • column_14_flag — BIT(1) — NOT NULL
  • column_15_flag — BIT(1) — NOT NULL
  • column_16_flag — BIT(1) — NOT NULL
  • column_17_flag — BIT(1) — NOT NULL
  • column_18_flag — BIT(1) — NOT NULL
  • column_19_flag — BIT(1) — NOT NULL
  • column_20_flag — BIT(1) — NOT NULL
  • column_21_flag — BIT(1) — NOT NULL
  • column_22_flag — BIT(1) — NOT NULL
  • column_23_flag — BIT(1) — NOT NULL
  • column_24_flag — BIT(1) — NOT NULL
  • column_25_flag — BIT(1) — NOT NULL
  • column_26_flag — BIT(1) — NOT NULL
  • column_27_flag — BIT(1) — NOT NULL
  • column_28_flag — BIT(1) — NOT NULL
  • column_29_flag — BIT(1) — NOT NULL
  • column_30_flag — BIT(1) — NOT NULL
  • edit_date — DATETIME — NOT NULL

companies

  • company_id — BIGINT(20) — Primary key — NOT NULL
  • tax_registration_number — VARCHAR(256) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • ceo_name — VARCHAR(50) — NOT NULL
  • business_condition — VARCHAR(1000)
  • business_kind — VARCHAR(1000)
  • business_type — VARCHAR(32) — NOT NULL
  • company_type — VARCHAR(32)
  • transaction_type — VARCHAR(32) — NOT NULL
  • company_phone — VARCHAR(32)
  • company_fax — VARCHAR(32)
  • workplace_id — INT(11) — NOT NULL
  • scrap_account_idx — BIGINT(20) — NOT NULL
  • memo — TEXT
  • manager_name — VARCHAR(256)
  • manager_phone — VARCHAR(256)
  • manager_email — VARCHAR(256)
  • close_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

company_bank

  • account_idx — BIGINT(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Foreign key → companies.company_id — NOT NULL
  • account_no — VARCHAR(256) — NOT NULL
  • bank_code — VARCHAR(32) — NOT NULL
  • account_holder — VARCHAR(256) — NOT NULL
  • bankbook_status — VARCHAR(32)
  • bankbook_userid — VARCHAR(32)
  • bankbook_date — DATETIME
  • bankbook_error_message — VARCHAR(1000)
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • delete_flag — BIT(1) — NOT NULL

company_bank_transaction

  • idx — BIGINT(20) — Primary key — NOT NULL
  • account_idx — BIGINT(20) — NOT NULL
  • tran_date — DATE — NOT NULL
  • tran_time — TIME — NOT NULL
  • in_amount — BIGINT(20) — NOT NULL
  • out_amount — BIGINT(20) — NOT NULL
  • bigo — VARCHAR(256)
  • ref_name1 — VARCHAR(256)
  • ref_name2 — VARCHAR(256)
  • ref_name3 — VARCHAR(256)
  • ref_name4 — VARCHAR(256)
  • calculate_id — VARCHAR(32)

company_files

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Foreign key → companies.company_id — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL
  • file_type — VARCHAR(32) — NOT NULL

company_truck

  • truck_number — VARCHAR(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Foreign key → companies.company_id — NOT NULL
  • driver_name — VARCHAR(50)
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

company_workplace

  • workplace_id — INT(11) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Foreign key → companies.company_id — NOT NULL
  • workplace_name — VARCHAR(50) — NOT NULL
  • postal_code — VARCHAR(10) — NOT NULL
  • address — VARCHAR(300) — NOT NULL
  • address_etc — VARCHAR(100)
  • use_flag — BIT(1) — NOT NULL
  • is_main_workplace — BIT(1)
  • latitude — FLOAT
  • longitude — FLOAT
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

distribution

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • weighing_id — VARCHAR(32) — Primary key — NOT NULL
  • deal_date — DATE — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • truck_number — VARCHAR(20) — NOT NULL
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • up_item_code — VARCHAR(32)
  • item_code — VARCHAR(32)
  • item_change_flag — BIT(1) — NOT NULL
  • origin_up_item_code — VARCHAR(32)
  • origin_item_code — VARCHAR(32)
  • departure — VARCHAR(32)
  • departure_postal_code — VARCHAR(10)
  • departure_address — VARCHAR(500)
  • departure_address_etc — VARCHAR(100)
  • transportation_type — VARCHAR(32)
  • transportation_price — INT(11) — NOT NULL
  • full_weight_date — DATETIME
  • full_weight — INT(11) — NOT NULL
  • empty_weight_date — DATETIME
  • empty_weight — INT(11) — NOT NULL
  • real_weight — INT(11) — NOT NULL
  • loss_weight — INT(11) — NOT NULL
  • loss_rate — FLOAT — NOT NULL
  • total_weight — INT(11) — NOT NULL
  • purchase_company_id — BIGINT(20)
  • purchase_company_name — VARCHAR(50)
  • purchase_upload_name — VARCHAR(50)
  • purchase_transport_name — VARCHAR(50)
  • purchase_unit_price — INT(11) — NOT NULL
  • purchase_price — INT(11) — NOT NULL
  • purchase_transportation_price — INT(11) — NOT NULL
  • purchase_advance_price — INT(11) — NOT NULL
  • purchase_decision_price — INT(11) — NOT NULL
  • purchase_calculate_flag — BIT(1) — NOT NULL
  • purchase_calculate_id — VARCHAR(50)
  • sale_company_id — BIGINT(20)
  • sale_company_name — VARCHAR(50)
  • sale_weighing_id — VARCHAR(32)
  • sale_item_name — VARCHAR(50)
  • sale_memo — TEXT
  • sale_unit_price — INT(11) — NOT NULL
  • sale_price — INT(11) — NOT NULL
  • sale_transportation_price — INT(11) — NOT NULL
  • sale_advance_price — INT(11) — NOT NULL
  • sale_decision_price — INT(11) — NOT NULL
  • sale_calculate_flag — BIT(1) — NOT NULL
  • sale_calculate_id — VARCHAR(50)
  • margin_unit_price — INT(11) — NOT NULL
  • margin_price — INT(11) — NOT NULL
  • margin_rate — FLOAT — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • transit_calculate_flag — BIT(1) — NOT NULL
  • transit_calculate_id — VARCHAR(50)
  • … +7

email_config

  • email_type — VARCHAR(32) — Primary key — NOT NULL
  • email_type_name — VARCHAR(50) — NOT NULL
  • use_flag — BIT(1) — NOT NULL
  • gmail_flag — BIT(1) — NOT NULL
  • smtp_address — VARCHAR(256) — NOT NULL
  • smtp_port — INT(11) — NOT NULL
  • smtp_username — VARCHAR(256) — NOT NULL
  • smtp_password — VARCHAR(256) — NOT NULL
  • from_email — VARCHAR(256) — NOT NULL
  • from_display — VARCHAR(50)
  • subject — VARCHAR(100)
  • body — MEDIUMTEXT
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

email_send_history

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • email_type — VARCHAR(32) — Foreign key → email_config.email_type — NOT NULL
  • send_date — DATETIME — NOT NULL
  • from_email — VARCHAR(256) — NOT NULL
  • to_email — TEXT — NOT NULL
  • cc — TEXT
  • bcc — TEXT
  • subject — VARCHAR(100) — NOT NULL
  • body — MEDIUMTEXT — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

instruction_perform

  • instruction_id — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • workplace_id — BIGINT(20) — NOT NULL
  • instructions — TEXT — NOT NULL
  • urgent_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • status — VARCHAR(32) — NOT NULL
  • perform_start_date — DATETIME
  • perform_end_date — DATETIME
  • performer_id — VARCHAR(32)
  • performer_name — VARCHAR(50)
  • perform_memo — TEXT
  • confirm_flag — BIT(1) — NOT NULL
  • confirm_id — VARCHAR(32)
  • confirm_name — VARCHAR(50)
  • confirm_date — DATETIME

instruction_perform_files

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • instruction_id — BIGINT(20) — Foreign key → instruction_perform.instruction_id — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL

inventory_base

  • tenant_id — BIGINT(20) — Foreign key → items.tenant_id — NOT NULL
  • item_code — VARCHAR(32) — Foreign key → items.item_code — NOT NULL
  • quantity — BIGINT(20) — NOT NULL
  • unit_price — BIGINT(20) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

inventory_base_history

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • workplace_id — INT(11) — NOT NULL
  • item_code — VARCHAR(32) — NOT NULL
  • quantity — BIGINT(20) — NOT NULL
  • unit_price — BIGINT(20) — NOT NULL
  • reason — MEDIUMTEXT
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

inventory_base_workplace

  • workplace_id — INT(11) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → items.tenant_id — NOT NULL
  • item_code — VARCHAR(32) — Foreign key → items.item_code — NOT NULL
  • quantity — BIGINT(20) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

inventory_change

  • change_id — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • workplace_id — INT(11) — NOT NULL
  • change_date — DATE — NOT NULL
  • current_weight — BIGINT(20)
  • estimated_weight — BIGINT(20)
  • waste_weight — BIGINT(20)
  • waste_rate — FLOAT
  • etc_weight — BIGINT(20)
  • etc_rate — FLOAT
  • total_weight — BIGINT(20)
  • total_rate — FLOAT
  • after_weight — BIGINT(20)
  • delete_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

inventory_change_item

  • change_id — BIGINT(20) — Primary key — NOT NULL
  • up_item_code — VARCHAR(32) — Primary key — NOT NULL
  • current_weight — BIGINT(20)
  • waste_weight — BIGINT(20)
  • waste_rate — FLOAT
  • etc_weight — BIGINT(20)
  • etc_rate — FLOAT
  • total_weight — BIGINT(20)
  • total_rate — FLOAT
  • after_weight — BIGINT(20)

item_map

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • item_sale_large_code — VARCHAR(32) — Primary key — NOT NULL
  • item_sale_small_code — VARCHAR(32) — Primary key — NOT NULL
  • item_purchase_large_code — VARCHAR(32) — Primary key — NOT NULL
  • item_purchase_small_code — VARCHAR(32) — Primary key — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

item_purchase

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • item_large_code — VARCHAR(32) — Primary key — NOT NULL
  • item_small_code — VARCHAR(32) — Primary key — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

item_purchase_price

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • item_purchase_large_code — VARCHAR(32) — Primary key — NOT NULL
  • item_purchase_small_code — VARCHAR(32) — Primary key — NOT NULL
  • yard_price — INT(11)
  • distribution_price — INT(11)
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

item_purchase_price_history

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → item_purchase_price.tenant_id — NOT NULL
  • item_purchase_large_code — VARCHAR(32) — Foreign key → item_purchase_price.item_purchase_large_code — NOT NULL
  • item_purchase_small_code — VARCHAR(32) — Foreign key → item_purchase_price.item_purchase_small_code — NOT NULL
  • yard_price — INT(11) — NOT NULL
  • distribution_price — INT(11) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

item_sale

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • item_large_code — VARCHAR(32) — Primary key — NOT NULL
  • item_small_code — VARCHAR(32) — Primary key — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

items

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • item_code — VARCHAR(32) — Primary key — NOT NULL
  • item_name — VARCHAR(50) — NOT NULL
  • item_level — INT(11) — NOT NULL
  • up_item_code — VARCHAR(32)
  • use_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

menu

  • menu_id — VARCHAR(32) — Primary key — NOT NULL
  • menu_name — VARCHAR(50)
  • menu_level — INT(11)
  • up_menu_id — VARCHAR(32)
  • controller — VARCHAR(32)
  • view_path — VARCHAR(100)
  • category — VARCHAR(32)
  • icon — VARCHAR(32)
  • use_flag — BIT(1)
  • sort — INT(11)
  • approval_flag — BIT(1) — NOT NULL
  • dashboard_flag — BIT(1) — NOT NULL

menu_authority_map

  • auth_id — BIGINT(20) — Foreign key → tenant_authority.auth_id — NOT NULL
  • menu_id — VARCHAR(32) — Foreign key → menu.menu_id — NOT NULL
  • role_code — VARCHAR(32)
  • regist_id — VARCHAR(32)
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME

statistics_dashboard

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • purchase_weight — BIGINT(20) — NOT NULL
  • purchase_price — BIGINT(20) — NOT NULL
  • sale_weight — BIGINT(20) — NOT NULL
  • sale_price — BIGINT(20) — NOT NULL
  • inventory_weight — BIGINT(20) — NOT NULL
  • inventory_price — BIGINT(20) — NOT NULL
  • regist_date — DATETIME — NOT NULL

steel_company_map

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Primary key — NOT NULL
  • purchase_company_name — VARCHAR(50) — Primary key — NOT NULL
  • purchase_company_id — BIGINT(20) — NOT NULL
  • regist_id — VARCHAR(50) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

steel_item_map

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Primary key — NOT NULL
  • item_name — VARCHAR(50) — Primary key — NOT NULL
  • up_item_code — VARCHAR(50) — NOT NULL
  • item_code — VARCHAR(50) — NOT NULL
  • regist_id — VARCHAR(50) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

steel_upload_data

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • weighing_id — VARCHAR(50) — Primary key — NOT NULL

steel_upload_files

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL
  • regist_id — VARCHAR(50) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

steel_workplace_map

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Primary key — NOT NULL
  • workplace_name — VARCHAR(50) — Primary key — NOT NULL
  • workplace_id — BIGINT(20) — NOT NULL
  • regist_id — VARCHAR(50) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

tax_invoice_nts

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • issue_id — VARCHAR(32) — Primary key — NOT NULL
  • supbuy_type — VARCHAR(32) — NOT NULL
  • dti_wdate — DATE — NOT NULL
  • dti_idate — DATE — NOT NULL
  • dti_sdate — DATE — NOT NULL
  • type_code — VARCHAR(32) — NOT NULL
  • dit_type — VARCHAR(32) — NOT NULL
  • tax_demand — VARCHAR(32) — NOT NULL
  • seq_id — VARCHAR(32)
  • sup_com_regno — VARCHAR(32)
  • sup_rep_name — VARCHAR(32)
  • sup_com_name — VARCHAR(32)
  • sup_email — VARCHAR(100)
  • byr_com_regno — VARCHAR(100)
  • byr_rep_name — VARCHAR(100)
  • byr_com_name — VARCHAR(100)
  • byr_email — VARCHAR(100)
  • sup_amount — BIGINT(20) — NOT NULL
  • tax_amount — BIGINT(20) — NOT NULL
  • total_amount — BIGINT(20) — NOT NULL
  • item_date — VARCHAR(32)
  • item_name — VARCHAR(50)
  • item_size — VARCHAR(50)
  • item_qty — INT(11) — NOT NULL
  • item_unit_price — BIGINT(20) — NOT NULL
  • item_sup_amount — BIGINT(20) — NOT NULL
  • item_tax_amount — BIGINT(20) — NOT NULL
  • item_remark — VARCHAR(1000)
  • regist_date — DATETIME — NOT NULL
  • calculate_id — VARCHAR(32)

tax_invoice_request

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • message_id — VARCHAR(100) — NOT NULL
  • request_signal — VARCHAR(50) — NOT NULL
  • request_time — VARCHAR(50) — NOT NULL
  • conversation_id — TEXT

tax_invoice_response

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • message_id — VARCHAR(100) — NOT NULL
  • response_signal — VARCHAR(50) — NOT NULL
  • conversation_id — TEXT
  • response_time — VARCHAR(50) — NOT NULL
  • result_code — VARCHAR(50) — NOT NULL
  • result_message — MEDIUMTEXT
  • result_data_set — MEDIUMTEXT
  • regist_date — DATETIME — NOT NULL

tenant_authority

  • auth_id — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenants.tenant_id — NOT NULL
  • auth_code — VARCHAR(32) — NOT NULL
  • auth_name — VARCHAR(50) — NOT NULL
  • memo — TEXT
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

tenant_board

  • post_id — BIGINT(20) — Primary key — NOT NULL
  • board_id — BIGINT(20) — Foreign key → board_config.board_id — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenants.tenant_id — NOT NULL
  • ref_post_id — BIGINT(20)
  • rep_post_id — BIGINT(20)
  • post_no — BIGINT(20) — NOT NULL
  • depth — INT(11)
  • title — VARCHAR(1000)
  • contents — TEXT
  • read_count — BIGINT(20)
  • notify_flag — BIT(1)
  • category — VARCHAR(32)
  • regist_id — VARCHAR(32)
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

tenant_board_files

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • post_id — BIGINT(20) — Foreign key → tenant_board.post_id — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL

tenant_codes

  • code — VARCHAR(32) — Primary key — NOT NULL
  • group_code — VARCHAR(32) — Foreign key → code_group.group_code — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenants.tenant_id — NOT NULL
  • code_name — VARCHAR(50) — NOT NULL
  • up_code — VARCHAR(32)
  • code_path — VARCHAR(1000)
  • description — TEXT
  • use_flag — BIT(1) — NOT NULL
  • sort — INT(11) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

tenant_company_bank

  • account_idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenant_company_map.tenant_id — NOT NULL
  • company_id — BIGINT(20) — Foreign key → tenant_company_map.company_id — NOT NULL
  • account_no — VARCHAR(256) — NOT NULL
  • bank_code — VARCHAR(32) — NOT NULL
  • account_holder — VARCHAR(256) — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • delete_flag — BIT(1) — NOT NULL

tenant_company_files

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenant_company_map.tenant_id — NOT NULL
  • company_id — BIGINT(20) — Foreign key → tenant_company_map.company_id — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL
  • file_type — VARCHAR(32) — NOT NULL

tenant_company_map

  • company_id — BIGINT(20) — Foreign key → companies.company_id — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenants.tenant_id — NOT NULL
  • tax_registration_number — VARCHAR(256) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • ceo_name — VARCHAR(50) — NOT NULL
  • business_condition — VARCHAR(1000)
  • business_kind — VARCHAR(1000)
  • business_type — VARCHAR(32) — NOT NULL
  • company_type — VARCHAR(32)
  • transaction_type — VARCHAR(32) — NOT NULL
  • company_phone — VARCHAR(32)
  • company_fax — VARCHAR(32)
  • workplace_id — INT(11) — NOT NULL
  • scrap_account_idx — BIGINT(20) — NOT NULL
  • memo — TEXT
  • manager_name — VARCHAR(256)
  • manager_phone — VARCHAR(256)
  • manager_email — VARCHAR(256)
  • close_flag — BIT(1) — NOT NULL
  • delete_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

tenant_company_truck

  • truck_number — VARCHAR(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenant_company_map.tenant_id — NOT NULL
  • company_id — BIGINT(20) — Foreign key → tenant_company_map.company_id — NOT NULL
  • driver_name — VARCHAR(50)
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

tenant_company_workplace

  • workplace_id — INT(11) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenant_company_map.tenant_id — NOT NULL
  • company_id — BIGINT(20) — Foreign key → tenant_company_map.company_id — NOT NULL
  • workplace_name — VARCHAR(50) — NOT NULL
  • postal_code — VARCHAR(10) — NOT NULL
  • address — VARCHAR(300) — NOT NULL
  • address_etc — VARCHAR(100)
  • use_flag — BIT(1) — NOT NULL
  • is_main_workplace — BIT(1) — NOT NULL
  • latitude — FLOAT
  • longitude — FLOAT
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

tenant_inbound

  • ip_address — VARCHAR(50) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — Foreign key → tenants.tenant_id — NOT NULL
  • request_id — VARCHAR(32)
  • request_name — VARCHAR(50)
  • request_date — DATETIME
  • request_count — INT(11) — NOT NULL
  • use_flag — BIT(1) — NOT NULL
  • process_id — VARCHAR(32)
  • process_name — VARCHAR(50)
  • process_date — DATETIME

tenant_license

  • tenant_id — BIGINT(20) — Foreign key → tenants.tenant_id — NOT NULL
  • license_no — VARCHAR(256) — NOT NULL
  • subscription_date — DATE — NOT NULL
  • expiration_date — DATE — NOT NULL
  • user_count — INT(11) — NOT NULL
  • delete_flag — BIT(1) — NOT NULL
  • edit_id — VARCHAR(32) — NOT NULL
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

tenants

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • company_id — BIGINT(20) — Foreign key → companies.company_id — NOT NULL
  • join_date — DATE — NOT NULL
  • rep_user_id — VARCHAR(32) — NOT NULL
  • ip_use_flag — BIT(1) — NOT NULL
  • memo — TEXT
  • admin_flag — BIT(1) — NOT NULL
  • delete_flag — BIT(1) — NOT NULL
  • sb_use_flag — BIT(1) — NOT NULL
  • sb_status — CHAR(1) — NOT NULL
  • sb_id — VARCHAR(32)
  • sb_company_code — VARCHAR(32)
  • sb_auth_code — VARCHAR(1000)
  • sb_token — VARCHAR(1000)
  • sb_cert_regist_flag — BIT(1) — NOT NULL
  • sb_cert_expire_date — DATE
  • sb_password — VARCHAR(1000)
  • sb_dept_user_flag — BIT(1) — NOT NULL
  • sb_dept_user_id — VARCHAR(32)
  • sb_dept_password — VARCHAR(256)
  • sb_log_flag — BIT(1) — NOT NULL
  • sb_regist_id — VARCHAR(32)
  • sb_regist_date — DATETIME
  • bank_regist_count — INT(11) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50) — NOT NULL
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

upload_files

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL
  • file_type — VARCHAR(32) — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • regist_id — VARCHAR(50) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

upload_print

  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • regist_id — VARCHAR(50) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

user_password_history

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • user_id — VARCHAR(32) — NOT NULL
  • password — VARCHAR(512)
  • change_date — DATETIME
  • regist_type — VARCHAR(32)
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

users

  • user_id — VARCHAR(32) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • password — VARCHAR(512) — NOT NULL
  • auth_code — VARCHAR(32) — NOT NULL
  • use_flag — BIT(1) — NOT NULL
  • dept_code — VARCHAR(32)
  • workplace_id — INT(11)
  • title_code — VARCHAR(32)
  • phone — VARCHAR(256)
  • email — VARCHAR(256)
  • login_flag — BIT(1) — NOT NULL
  • login_ip — VARCHAR(50)
  • login_date — DATETIME
  • login_fail_count — INT(11) — NOT NULL
  • login_fail_date — DATETIME
  • change_password_date — DATETIME — NOT NULL
  • token — TEXT
  • work_flag — BIT(1) — NOT NULL
  • admin_flag — BIT(1) — NOT NULL
  • delete_flag — BIT(1) — NOT NULL
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50) — NOT NULL
  • regist_date — DATETIME — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME

weighing_files

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • weighing_id — VARCHAR(32) — Primary key — NOT NULL
  • file_id — VARCHAR(256) — Primary key — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_extension — VARCHAR(200) — NOT NULL
  • file_type — VARCHAR(32) — NOT NULL

weighing_process_history

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • weighing_id — VARCHAR(32) — NOT NULL
  • process_type — VARCHAR(32) — NOT NULL
  • process_memo — TEXT
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL

yard_delete

  • Idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • weighing_id — VARCHAR(32) — NOT NULL
  • up_weighing_id — VARCHAR(32)
  • deal_date — DATE
  • deal_type — VARCHAR(32)
  • truck_number — VARCHAR(20)
  • company_id — BIGINT(20)
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • up_item_code — VARCHAR(32)
  • item_code — VARCHAR(32)
  • item_change_flag — BIT(1) — NOT NULL
  • origin_up_item_code — VARCHAR(32)
  • origin_item_code — VARCHAR(32)
  • transportation_type — VARCHAR(32)
  • status — VARCHAR(32)
  • prev_status — VARCHAR(32)
  • full_weight — INT(11) — NOT NULL
  • full_weight_date — DATETIME
  • full_weight_user_id — VARCHAR(32)
  • empty_weight — INT(11) — NOT NULL
  • empty_weight_date — DATETIME
  • empty_weight_user_id — VARCHAR(32)
  • weight_memo — TEXT
  • inspection_flag — BIT(1) — NOT NULL
  • loss_weight — INT(11) — NOT NULL
  • loss_rate — FLOAT — NOT NULL
  • loss_reason — MEDIUMTEXT
  • inspector_id — VARCHAR(32)
  • inspector_name — VARCHAR(50)
  • inspector_date — DATETIME
  • round_flag — BIT(1) — NOT NULL
  • round_count — INT(11) — NOT NULL
  • real_weight — INT(11) — NOT NULL
  • total_weight — INT(11) — NOT NULL
  • workplace_id — INT(11) — NOT NULL
  • process_id — VARCHAR(32)
  • process_name — VARCHAR(50)
  • process_date — DATETIME
  • process_flag — BIT(1) — NOT NULL
  • regist_date — DATETIME — NOT NULL
  • print_count — INT(11) — NOT NULL
  • edit_loss_weight — INT(11) — NOT NULL
  • final_loss_weight — INT(11) — NOT NULL
  • final_loss_rate — FLOAT — NOT NULL
  • final_total_weight — INT(11) — NOT NULL
  • edit_unit_price — INT(11) — NOT NULL
  • standard_unit_price — INT(11) — NOT NULL
  • final_unit_price — INT(11) — NOT NULL
  • estimated_price — INT(11) — NOT NULL
  • final_total_price — INT(11) — NOT NULL
  • total_edit_price — INT(11) — NOT NULL
  • total_edit_loss_price — INT(11) — NOT NULL
  • total_edit_unit_price — INT(11) — NOT NULL
  • transportation_price — INT(11) — NOT NULL
  • advance_price — INT(11) — NOT NULL
  • decision_price — INT(11) — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • … +51

yard_map

  • sale_tenant_id — BIGINT(20)
  • sale_weighing_id — VARCHAR(32)
  • sale_regist_date — DATE
  • purchase_tenant_id — BIGINT(20)
  • purchase_weighing_id — VARCHAR(32)
  • purchase_regist_date — DATE

yard_purchase

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • weighing_id — VARCHAR(32) — Primary key — NOT NULL
  • up_weighing_id — VARCHAR(32)
  • deal_date — DATE
  • deal_type — VARCHAR(32) — NOT NULL
  • truck_number — VARCHAR(20) — NOT NULL
  • company_id — BIGINT(20)
  • system_flag — BIT(1) — NOT NULL
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • up_item_code — VARCHAR(32)
  • item_code — VARCHAR(32)
  • item_change_flag — BIT(1) — NOT NULL
  • origin_up_item_code — VARCHAR(32)
  • origin_item_code — VARCHAR(32)
  • transportation_type — VARCHAR(32)
  • status — VARCHAR(32) — NOT NULL
  • prev_status — VARCHAR(32)
  • full_weight — INT(11) — NOT NULL
  • full_weight_date — DATETIME
  • full_weight_user_id — VARCHAR(32)
  • empty_weight — INT(11) — NOT NULL
  • empty_weight_date — DATETIME
  • empty_weight_user_id — VARCHAR(32)
  • weight_memo — TEXT
  • inspection_flag — BIT(1) — NOT NULL
  • loss_weight — INT(11) — NOT NULL
  • loss_rate — FLOAT — NOT NULL
  • loss_reason — TEXT
  • inspector_id — VARCHAR(32)
  • inspector_name — VARCHAR(50)
  • inspector_date — DATETIME
  • round_flag — BIT(1) — NOT NULL
  • round_count — INT(11) — NOT NULL
  • weight_value_type — INT(11) — NOT NULL
  • weight_value — FLOAT — NOT NULL
  • real_weight — INT(11) — NOT NULL
  • total_weight — INT(11) — NOT NULL
  • workplace_id — INT(11) — NOT NULL
  • process_id — VARCHAR(32)
  • process_name — VARCHAR(50)
  • process_date — DATETIME
  • process_flag — BIT(1) — NOT NULL
  • regist_date — DATETIME — NOT NULL
  • print_count — INT(11) — NOT NULL
  • edit_loss_weight — INT(11) — NOT NULL
  • final_loss_weight — INT(11) — NOT NULL
  • final_loss_rate — FLOAT — NOT NULL
  • final_total_weight — INT(11) — NOT NULL
  • edit_unit_price — INT(11) — NOT NULL
  • standard_unit_price — INT(11) — NOT NULL
  • final_unit_price — INT(11) — NOT NULL
  • estimated_price — INT(11) — NOT NULL
  • final_total_price — INT(11) — NOT NULL
  • total_edit_price — INT(11) — NOT NULL
  • total_edit_loss_price — INT(11) — NOT NULL
  • total_edit_unit_price — INT(11) — NOT NULL
  • transportation_price — INT(11) — NOT NULL
  • advance_price — INT(11) — NOT NULL
  • decision_price — INT(11) — NOT NULL
  • … +18

yard_sale

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • weighing_id — VARCHAR(32) — Primary key — NOT NULL
  • deal_date — DATE
  • deal_type — VARCHAR(32) — NOT NULL
  • truck_number — VARCHAR(20) — NOT NULL
  • company_id — BIGINT(20)
  • system_flag — BIT(1) — NOT NULL
  • purchase_flag — BIT(1) — NOT NULL
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • up_item_code — VARCHAR(32)
  • item_code — VARCHAR(32)
  • item_change_flag — BIT(1) — NOT NULL
  • origin_up_item_code — VARCHAR(32)
  • origin_item_code — VARCHAR(32)
  • transportation_type — VARCHAR(32)
  • transportation_price — INT(11) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • empty_weight — INT(11) — NOT NULL
  • empty_weight_date — DATETIME
  • empty_weight_user_id — VARCHAR(32)
  • full_weight — INT(11) — NOT NULL
  • full_weight_date — DATETIME
  • full_weight_user_id — VARCHAR(32)
  • weight_memo — TEXT
  • upload_flag — BIT(1) — NOT NULL
  • upload_id — VARCHAR(32)
  • upload_name — VARCHAR(50)
  • upload_date — DATETIME
  • upload_memo — TEXT
  • real_weight — INT(11) — NOT NULL
  • total_weight — INT(11) — NOT NULL
  • workplace_id — INT(11) — NOT NULL
  • process_id — VARCHAR(32)
  • process_name — VARCHAR(50)
  • process_date — DATETIME
  • process_flag — BIT(1) — NOT NULL
  • regist_date — DATETIME — NOT NULL
  • print_count — INT(11) — NOT NULL
  • image_upload_flag — BIT(1) — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • edit_reason — TEXT
  • handwriting_flag — BIT(1) — NOT NULL
  • unit_price — INT(11) — NOT NULL
  • advance_price — INT(11) — NOT NULL
  • buyer_decision_flag — BIT(1) — NOT NULL
  • buyer_full_weight_date — DATETIME
  • buyer_full_weight — INT(11) — NOT NULL
  • buyer_empty_weight_date — DATETIME
  • buyer_empty_weight — INT(11) — NOT NULL
  • buyer_real_weight — INT(11) — NOT NULL
  • buyer_loss_weight — INT(11) — NOT NULL
  • buyer_loss_rate — FLOAT — NOT NULL
  • buyer_total_weight — INT(11) — NOT NULL
  • buyer_unit_price — INT(11) — NOT NULL
  • buyer_weighing_id — VARCHAR(32)
  • buyer_item_name — VARCHAR(100)
  • buyer_memo — TEXT
  • … +17

yard_waste

  • tenant_id — BIGINT(20) — Primary key — NOT NULL
  • weighing_id — VARCHAR(32) — Primary key — NOT NULL
  • deal_date — DATE
  • deal_type — VARCHAR(32) — NOT NULL
  • truck_number — VARCHAR(20) — NOT NULL
  • company_id — BIGINT(20)
  • manager_id — VARCHAR(32)
  • manager_name — VARCHAR(50)
  • up_item_code — VARCHAR(32)
  • item_code — VARCHAR(32)
  • item_change_flag — BIT(1) — NOT NULL
  • origin_up_item_code — VARCHAR(32)
  • origin_item_code — VARCHAR(32)
  • transportation_type — VARCHAR(32)
  • waste_tran_type — VARCHAR(32)
  • status — VARCHAR(32) — NOT NULL
  • empty_weight — INT(11) — NOT NULL
  • empty_weight_date — DATETIME
  • empty_weight_user_id — VARCHAR(32)
  • full_weight — INT(11) — NOT NULL
  • full_weight_date — DATETIME
  • full_weight_user_id — VARCHAR(32)
  • weight_memo — TEXT
  • upload_flag — BIT(1) — NOT NULL
  • upload_id — VARCHAR(32)
  • upload_name — VARCHAR(50)
  • upload_date — DATETIME
  • upload_memo — TEXT
  • real_weight — INT(11) — NOT NULL
  • total_weight — INT(11) — NOT NULL
  • weight_price — INT(11) — NOT NULL
  • truck_price — INT(11) — NOT NULL
  • workplace_id — INT(11) — NOT NULL
  • process_id — VARCHAR(32)
  • process_name — VARCHAR(50)
  • process_date — DATETIME
  • process_flag — BIT(1) — NOT NULL
  • regist_date — DATETIME — NOT NULL
  • print_count — INT(11) — NOT NULL
  • image_upload_flag — BIT(1) — NOT NULL
  • edit_id — VARCHAR(32)
  • edit_name — VARCHAR(50)
  • edit_date — DATETIME
  • edit_reason — MEDIUMTEXT
  • handwriting_flag — BIT(1) — NOT NULL
  • transportation_price — INT(11) — NOT NULL
  • advance_price — INT(11) — NOT NULL
  • decision_price — INT(11) — NOT NULL
  • approval_status — VARCHAR(32)
  • approver_id — VARCHAR(32)
  • approver_name — VARCHAR(50)
  • approver_date — DATETIME
  • calculate_id — VARCHAR(32)
  • calculate_flag — BIT(1) — NOT NULL

yard_waste_history

  • idx — BIGINT(20) — Primary key — NOT NULL
  • tenant_id — BIGINT(20) — NOT NULL
  • weighing_id — VARCHAR(32) — NOT NULL
  • total_weight — INT(11) — NOT NULL
  • weight_price — INT(11) — NOT NULL
  • truck_price — INT(11) — NOT NULL
  • memo — TEXT
  • regist_id — VARCHAR(32) — NOT NULL
  • regist_name — VARCHAR(50)
  • regist_date — DATETIME — NOT NULL