yangwa
V2EX  ›  问与答

问一下各位大佬,问一下表结构设计,发票通过 ocr 识别后如何存储

  •  
  •   yangwa · Apr 8, 2022 · 2444 views
    This topic created in 1669 days ago, the information mentioned may be changed or developed.

    各种发票字段都不一样,像火车票字段和增值税发票相差很大,是每种发票都建一个表吗?

    3 replies  •  2022-04-08 17:51:27 +08:00
    herich
    herich
    Apr 8, 2022
    1
    存 json
    yangwa
    yangwa
    OP
    Apr 8, 2022
    2
    @herich 用的 oracle11g,好像没有 json 支持,需要查询怎么实现
    ldyisbest
    ldyisbest
    Apr 8, 2022
    3
    不需要查询发票里面的内容的话就搞一列,存 json 字符串
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   5069 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 59ms · UTC 01:33 · PVG 09:33 · LAX 17:33 · JFK 20:33
    ♥ Do have faith in what you're doing.