home / civic

Menu
  • Log in

law_finance_tag

Data license: 비공개

0 rows where article_id = 113

✎ View and edit SQL

This data as json

0 records

CREATE TABLE law_finance_tag (
    id               INTEGER PRIMARY KEY AUTOINCREMENT,
    law_master_id    INTEGER NOT NULL REFERENCES law_master(id) ON DELETE CASCADE,
    article_id       INTEGER REFERENCES law_article(id) ON DELETE CASCADE,
    finance_tag      TEXT NOT NULL,
    keyword          TEXT,
    evidence_text    TEXT,
    confidence       REAL,
    collected_at     TEXT NOT NULL
);
CREATE INDEX idx_law_finance_tag_master
    ON law_finance_tag(law_master_id, finance_tag);
Powered by Datasette · Queries took 61.066ms · Data license: 비공개