ClaimMiner/deploy/base.sql at main · conversence/ClaimMiner · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
-- Deploy base
-- requires: admin_base
-- Copyright Society Library and Conversence 2022-2024

BEGIN;

CREATE SEQUENCE IF NOT EXISTS public.topic_id_seq
    AS bigint
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

CREATE TYPE public.topic_type AS ENUM (
    'fragment',
    'standalone',
    'link',
    'hyperedge',
    'document',
    'analyzer',
    'analysis',
    'collection',
    'agent',
    'cluster'
);


CREATE TYPE public.permission AS ENUM (
    'admin',
    'access',
    'add_document',
    'add_claim',
    'claim_score_query',
    'bigdata_query',
    'openai_query',
    'confirm_claim',
    'edit_prompts'
);

CREATE TYPE public.link_type AS ENUM (
    'freeform',
    'key_point',
    'supported_by',
    'opposed_by',
    'implied',
    'implicit',
    'derived',
    'has_premise',
    'answers_question',
    'irrelevant',
    'relevant',
    'subcategory',
    'subclaim',
    'subquestion',
    'quote'
);

CREATE TYPE public.process_status AS ENUM (
    'inapplicable',
    'not_ready',
    'not_requested',
    'pending',
    'ongoing',
    'complete',
    'error'
);


CREATE TYPE public.fragment_type AS ENUM (
  'document',
  'paragraph',
  'sentence',
  'phrase',
  'quote',
  'summary',
  'reified_arg_link',
  'standalone',
  'generated',
  'standalone_root',
  'standalone_category',
  'standalone_question',
  'standalone_claim',
  'standalone_argument'
);

CREATE TYPE public.relevance AS ENUM (
    'irrelevant',
    'unknown',
    'relevant'
);


CREATE TYPE public.id_score_type AS (
    id bigint, score float
);

COMMIT;