QiufengandClaude Opus 4.8
5e51dc3f56
恢复点(restore point)。别人改崩后可 git reset --hard 回到此提交。 == 此快照内容 == - 后端 oa-backend: 734 控制器 / 711 实体 (Spring Boot 3.2.5 + SQLite, 端口8091) - 前端 modern-ui/app: Vue3+Vite, 约700页 (构建产物已在 oa-backend/src/main/resources/static) - 数据库 oa-backend/data/oa.db: 含全部演示数据 (强制入库, 6.6MB) - 交接文档 go.md + go-code-reference/endpoints/entities/database.md - 多代理建设脚本 .claude/wf-*.js == 状态 == - 对 凯迪科技ERP_20260507.xlsx 合规 MET ~73.3% (PARTIAL 75: 34可建+6种子/bug+35外部硬天花板) - 安全: 5轮红队+5轮复检, default-deny分级鉴权, 连续零可利用 - W3~W7 累计补完436缺口; W8末轮(40缺口)为半成品(源码树可编译但未集成) - 运行: cd oa-backend; java -jar build/libs/oa-backend-0.1.0.jar --server.port=8091; admin/123456 == 排除(gitignore, 可再生) == node_modules / oa-backend/build / .jdks / *.log / Backup-ERP-* / 弃用的OFBiz核心(只保留modern-ui) 完整文件夹备份见同目录 Backup-ERP-20260615-191517/ (含上述全部, 仅缺 node_modules) 时间戳: 20260615-191517 Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
16 KiB
16 KiB
数据库表与行数目录（go-database.md）
来自
oa-backend/data/oa.db（SQLite）。共 702 张表，有数据 218、空表 484。 空表 = 该功能"代码在但无演示数据"，补 Seeder 即可让活体可演示（很多 PARTIAL 缺口就是这个）。
有数据的表（表名 行数），按行数降序
oa_message: 1711operation_audit_log: 1152flow_trace: 236fts_index: 175fts_index_content: 175fts_index_docsize: 175automation_log: 131collab_doc_update: 130flow_task: 126form_instance: 87payment: 85form_template: 66contract_change: 56project: 56sys_user: 56voucher: 52sys_dept: 47decl_evidence_item: 43budget: 34opportunity: 30contract_milestone: 28contract: 27blog: 26archive: 25seal_use: 25csl_timesheet: 22fts_index_data: 22it_inspection: 22crawl_job: 21oa_setting: 21fts_index_idx: 20declaration_step: 19intel: 19water_quality_record: 18bid: 17cost_center: 17price_item: 17invoice: 16favorite: 15feed: 15opportunity_followup: 15patent: 15account: 14bom_item: 14rd_expense: 14work_plan: 14crawl_source: 13archive_comment: 12it_asset: 12lab_test_task: 12market_campaign: 12personnel_cert: 12repayment_plan: 12supplier: 12health_record: 11inventory_item: 11it_sec_policy_config: 11lab_sample: 11safety_check: 11brand_event_material: 10declaration: 10supervision_log: 10work_order: 10audit_project: 9collab_doc: 9project_task: 9company_subject: 8content_task: 8csl_report_chapter: 8customer: 8decl_achievement: 8design_doc: 8expert: 8fin_rd_timesheet: 8it_network_device: 8lab_instrument: 8legal_compliance_alert_rule: 8ops_emergency_supply: 8pmt_bank_evaluation: 8qms_record: 8rd_project: 8standard_cost: 8wastewater_client: 8ww_msds_file: 8certification: 7crm_opp_stage_config: 7fin_voucher_template: 7handover: 7it_monitor_item: 7legal_regulation: 7biz_record: 6contract_template: 6cost_hr_dept_labor_rate: 6cost_purchase_order: 6declaration_template: 6delegation: 6design_change: 6discussion: 6doc_file: 6fin_account_aux: 6fin_budget_plan: 6fin_cost_calc: 6fin_elec_archive: 6fin_rd_personnel: 6legal_external_regulation: 6meeting_minute: 6policy: 6rd_dev_wbs_task: 6schedule_event: 6seal: 6sewage_cross_dept_linkage: 6sewage_report_template: 6sys_user_role: 6audit_fraud_invest_note: 5audit_fraud_report: 5bank_account: 5cost_adjust_log: 5cost_reduction_item: 5env_discharge_permit: 5fin_budget_execution: 5fin_emp_loan: 5financing_policy: 5leader_trip: 5legal_hr_non_compete: 5legal_litigation_case: 5sewage_ext_lab_commission: 5staff_dossier_item: 5ww_sampling_task: 5ar_ap_item: 4csl_project: 4culture_survey: 4doc_folder: 4fert_invoice_ledger: 4fert_pkg_material_ledger: 4hr_ai_doc_draft: 4hr_emp_satisfaction_survey: 4legal_credit_invest: 4org_branch: 4pmt_bank_relation: 4policy_application: 4qual_cert: 4rd_decl_plan: 4staff_credential: 4ww_exceed_event: 4announcement: 3culture_goal: 3fert_accounting_voucher: 3financing: 3it_asset_event: 3meeting: 3meeting_room: 3qual_decl_task: 3qual_risk_alert: 3staff_dossier: 3survey: 3sys_role: 3ww_discharge_bill: 3audit_archive: 2audit_finding: 2branch_asset: 2countersign_vote: 2csl_risk_log: 2expense_claim: 2feed_like: 2fin_account_standard: 2ip_asset: 2ip_asset_event: 2qual_declaration: 2qual_year_check: 2report_definition: 2rule_config: 2stored_file: 2wm_event: 2ww_service_report: 2archive_borrow: 1archive_category: 1archive_destruction: 1archive_reservation: 1archive_submission: 1archive_version: 1biz_plan: 1bom_signoff: 1brand_asset: 1brand_event: 1brand_honor: 1brand_plan: 1brand_project: 1completion_acceptance: 1content_piece: 1crisis_plan: 1csl_budget_line: 1csl_expert: 1csl_report: 1culture_scheme: 1data_sync_log: 1event_guest: 1ext_system_config: 1fixed_asset: 1fts_index_config: 1hr_event_archive_log: 1hr_recruit_job: 1lab_internal_audit: 1lab_test_report: 1measurement_payment: 1pmt_financing_contract: 1pmt_inbound_receipt: 1project_budget_line: 1rd_dev_project: 1rd_engineering_change: 1sentiment_record: 1sewage_gov_report: 1stl_bank_reconciliation: 1stl_settlement: 1supervision_project: 1tax_filing: 1wm_work_method: 1ww_alert_rule: 1ww_discharge_contract: 1
空表（行数=0，需补种子才能演示）
admin_access_recordadmin_ai_action_logadmin_cctv_deviceadmin_cleaning_scheduleadmin_cleaning_supplyadmin_cleaning_supply_moveadmin_conference_materialadmin_conference_staffadmin_doc_templateadmin_dorm_checkinadmin_dorm_inspectionadmin_dorm_repairadmin_dorm_roomadmin_dorm_utilityadmin_equip_setupadmin_expressadmin_footage_requestadmin_greeneryadmin_hygiene_inspectionadmin_official_doc_tpladmin_patrol_logadmin_patrol_pointadmin_procurement_requestadmin_quiz_questionadmin_quotaadmin_receptionadmin_recurring_bookingadmin_requisitionadmin_security_eventadmin_shuttle_busadmin_shuttle_passengeradmin_stock_moveadmin_supplyadmin_training_courseadmin_training_enrollmentadmin_vehicleadmin_vehicle_dispatchadmin_vehicle_violationadmin_visitorannual_reportarchive_access_logarchive_aclarchive_backup_logarchive_drill_recordarchive_hash_recordarchive_physical_itemarchive_repair_recordarchive_vaultaudit_annual_planaudit_auditor_profileaudit_continuous_logaudit_economic_responsibilityaudit_evidenceaudit_material_requestaudit_monitor_exceptionaudit_monitor_ruleaudit_noticeaudit_procedureaudit_quality_reviewaudit_rectificationaudit_reportaudit_risk_assessmentaudit_work_paperbid_bondbid_decisionbid_depositbid_knowledge_entrybid_loss_casebid_taskbiz_budgetbiz_plan_targetbom_change_historybom_variance_detailbranch_budget_linebranch_cost_entrybranch_licensebrand_collab_pushbrand_expensebrand_suppliercanteen_meal_costcanteen_menucanteen_sanitation_recordchannel_publish_historychronicle_eventcompetitor_ipcompliance_evaluationcontent_reviewcontract_budget_reviewcontract_esigncost_inv_project_linkcost_procurement_bidcpc_versioncrm_bid_quote_detailcrm_branch_leasecrm_branch_petitioncrm_competitorcrm_contract_approval_stepcrm_customer_contactcrm_daily_reportcrm_doc_receiptcrm_imprest_fundcrm_petty_cashcrm_satisfaction_surveycrm_talk_scriptcrm_wbs_taskcsl_archive_itemcsl_bid_linkcsl_chapter_commentcsl_contractcsl_customercsl_entity_historycsl_estimate_itemcsl_expert_scorecsl_integral_ledgercsl_operation_logcsl_project_costcsl_report_reviewcsl_review_assignmentcsl_taskcsl_team_scheduleculture_archiveculture_awardculture_award_reviewculture_caseculture_improveculture_materialculture_material_downloadculture_storyculture_survey_responsecustomer_complaintcustomer_creditcustomer_visitdecl_acceptancedecl_audit_reportdecl_failure_casedecl_material_linkdecl_policy_subscriptiondecl_project_assignmentdecl_push_devicedecl_submissiondesign_annotationdesign_audit_traildesign_change_orderdesign_clashdesign_distributiondesign_drawingdesign_drawing_versiondesign_external_accessdesign_external_portaldesign_handoffdesign_interfacedesign_knowledgedesign_metricdesign_output_sharedesign_projectdesign_reservationdesign_taskdesigner_capabilitydish_reviewehs_audit_prep_taskehs_capaehs_check_planehs_contractor_eduehs_env_tax_recordehs_hazardehs_incidentehs_objectiveehs_special_equipehs_supplyehs_work_permitemg_drillenv_compli_obligationenv_monitor_recordenv_risk_sourceenv_waste_recordevent_checkinevent_taskext_audit_planfert_agri_servicefert_batch_costfert_customer_profilefert_deliveryfert_energy_logfert_gas_emissionfert_mpsfert_occ_healthfert_pack_orderfert_process_qcfert_procure_planfert_product_qcfert_qc_standardfert_raw_material_catalogfert_raw_material_qcfert_safety_patrol_logfert_safety_patrol_planfert_sales_linefert_sales_orderfert_solid_wastefert_stock_lotfert_stock_movefert_supplier_profilefert_wastewaterfert_wip_stockfert_work_sub_orderfin_account_permfin_advancefin_asset_inventoryfin_asset_inventory_itemfin_bad_debtfin_budget_adjfin_cash_journalfin_cipfin_depreciation_allocfin_field_diff_logfin_impairment_testfin_lease_rightfin_payroll_entryfin_post_loan_checkfin_rd_expensefin_rev_recognitionfin_threeway_matchfood_batchfraud_alert_rulehr_appointment_orderhr_interview_questionhr_labor_contracthr_recruit_candidatehzs_hazard_sourceinternal_newsletterinventory_valuation_configip_budgetip_feeip_free_tagip_knowledgeip_license_transferip_regulationip_regulation_versionip_sci_cred_archiveit_account_audit_recordit_backup_recordit_budget_lineit_data_export_requestit_demand_requestit_disaster_drill_recordit_dlp_policyit_inspection_reportit_knowledge_articleit_procurement_orderit_remote_assist_sessionit_sec_eventit_sec_training_recordit_service_ticketit_software_licenseit_sys_logit_ticket_attachmentit_vuln_recordlab_budgetlab_cost_entrylab_deviationlab_elnlab_eln_versionlab_haz_requestlab_incidentlab_instrument_maintlab_reagentlab_report_archivelab_reservationlab_safety_checklab_sample_eventlab_stocktakelab_stocktake_linelab_test_methodlab_wastelegal_auth_limitlegal_compliance_certlegal_compliance_checklistlegal_compliance_obligationlegal_compliance_risk_reportlegal_compliance_self_check_tasklegal_compliance_violationlegal_entitylegal_financial_guaranteelegal_internal_control_matrixlegal_ip_infringement_caselegal_knowledgelegal_legal_consultlegal_litigation_documentlegal_litigation_expenselegal_litigation_firmlegal_opinion_letterlegal_regulatory_submissionlegal_risk_assess_tasklegal_risk_assessmentlegal_risk_eventlegal_risk_measurelegal_supplier_blacklistlegal_trade_secret_assetlegal_traininglocal_resourcelogistics_budgetlogistics_expenselogistics_supplierlogistics_supplier_contractlogistics_supplier_evallogistics_supplier_paymentlogistics_surveylogistics_survey_responselogistics_ticketmarket_budgetmarket_expensemarket_intelmarket_qualificationmeal_ordermedia_brief_reportmedia_contactmedia_recordmeeting_action_itemmfg_cost_entrymfg_deliverymfg_drawingmfg_eng_bommfg_eng_bom_itemmfg_env_contractmfg_env_supplier_profilemfg_equipmentmfg_feedstock_batchmfg_ferment_batchmfg_ferment_logmfg_fert_recipemfg_fqc_reportmfg_inventory_lotmfg_maint_ordermfg_material_issuemfg_mps_nodemfg_outsourcemfg_production_anomalymfg_production_reportmfg_purchase_ordermfg_qc_inspectionmfg_quotemfg_recipe_ingredientmfg_sales_ordermfg_service_ticketmfg_stocktakemfg_stocktake_linemfg_warranty_contractmfg_wip_positionmobile_checkinmulti_payment_batchmulti_payment_batch_itemnet_scan_lognet_scan_taskocc_hazard_factorocc_workplace_monitorops_haz_chem_requestops_xdept_pushpatent_disclosurepatent_feepatent_mid_filepmt_collection_logpmt_contract_attachmentpmt_contract_fee_itempmt_cost_alloc_rulepmt_internal_transpmt_loan_schemepmt_payee_blacklistppe_itempublicity_taskpublish_channelqms_auditqms_audit_findingqms_documentqms_management_reviewqsup_quality_lotqual_achievementqual_cert_changequal_decl_feequal_elec_licensequal_safety_accidentqual_usagerd_after_sales_feedbackrd_annual_budgetrd_design_reviewrd_dev_project_budgetrd_doc_signoffrd_doc_versionrd_ebomrd_grant_disbursementrd_innovation_pointrd_issuerd_knowledgerd_maintenance_taskrd_materialrd_mobile_photord_product_certrd_product_requirementrd_product_roadmaprd_prototype_loanrd_prototype_orderrd_prototype_stockrd_purchase_requestrd_reuse_modulerd_review_voterd_roadmap_itemrd_sci_tech_personnelrd_service_agencyrd_supplier_samplerd_test_planrd_timesheetrd_weekly_reportsecret_access_logsewage_cost_monthsewage_detection_reportsewage_emergency_plansewage_energy_logsewage_env_recordsewage_equipmentsewage_inflow_forecastsewage_mobile_queuesewage_occ_healthsewage_patrol_recordsewage_patrol_routesewage_power_section_logsewage_process_runsewage_process_schemesewage_reagent_stocksewage_sampling_plansewage_shift_handoversewage_sludge_recordsewage_spare_partsewage_work_ordersfac_facilitysfty_investmentsfty_responsibilitysfty_trainingsfty_training_enrollmentstaff_self_requeststd_applicationstl_forex_riskstl_fund_planstl_fund_plan_submissionstl_internal_settle_rulestl_payment_refundsupervision_inspectionsv_accidentsv_archive_transfersv_change_claimsv_drawing_issuesv_equipment_ledgersv_hidden_worksv_material_inspectsv_monthly_reportsv_noticesv_open_work_ordersv_patrol_checkpointsv_patrol_plansv_patrol_schemesv_personal_certsv_plansv_progress_plansv_progress_tasksv_qualificationsv_schemesv_sequence_inspectsv_survey_verifytech_achievementtech_contractwm_applicationwm_decl_planwm_decl_templatewm_doc_versionwm_feewm_gov_subsidywm_promotionwm_reviewwm_rewardwm_reward_configwm_usageww_anomaly_caseww_client_attachmentww_hazwaste_manifestww_maint_orderww_maint_planww_process_unit