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