This repository has been archived by the owner on Feb 1, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
matrixator.dbm
107 lines (97 loc) · 3.28 KB
/
matrixator.dbm
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
99
100
101
102
103
104
105
106
107
<?xml version="1.0" encoding="UTF-8"?>
<!--
CAUTION: Do not modify this file unless you know what you are doing.
Unexpected results may occur if the code is changed deliberately.
-->
<dbmodel pgmodeler-ver="0.9.1" last-position="0,0" last-zoom="1"
default-schema="public" default-owner="postgres">
<role name="matrixator"
createdb="true"
encrypted="true"
password="abrakadabramatrix">
<appended-sql><![CDATA[GRANT all on taks to matrixator;
grant all on play to matrixator;
grant all on rel_task_play to matrixator;]]></appended-sql>
</role>
<database name="matrixator" is-template="false" allow-conns="true">
<role name="matrixator"/>
</database>
<schema name="public" fill-color="#e1e1e1" sql-disabled="true">
</schema>
<table name="play">
<schema name="public"/>
<role name="matrixator"/>
<position x="460" y="240"/>
<column name="id" not-null="true">
<type name="bigserial" length="0"/>
</column>
<column name="status" not-null="true">
<type name="character varying" length="0"/>
</column>
<column name="host" not-null="true">
<type name="character varying" length="0"/>
</column>
<column name="ts" not-null="true" default-value="now()">
<type name="timestamptz" length="0"/>
</column>
<column name="name" not-null="true">
<type name="character varying" length="0"/>
</column>
<constraint name="play_pk" type="pk-constr" table="public.play">
<columns names="id" ref-type="src-columns"/>
</constraint>
</table>
<index name="play_status_idx" table="public.play"
concurrent="false" unique="false" fast-update="false" buffering="false"
index-type="btree" factor="0">
<idxelement use-sorting="false">
<column name="status"/>
</idxelement>
</index>
<index name="play_ts_idx" table="public.play"
concurrent="false" unique="false" fast-update="false" buffering="false"
index-type="btree" factor="0">
<idxelement use-sorting="true" nulls-first="false" asc-order="true">
<column name="ts"/>
</idxelement>
</index>
<index name="play_host_idx" table="public.play"
concurrent="false" unique="false" fast-update="false" buffering="false"
index-type="btree" factor="0">
<idxelement use-sorting="false">
<column name="host"/>
</idxelement>
</index>
<table name="task">
<schema name="public"/>
<role name="matrixator"/>
<position x="1080" y="220"/>
<column name="id" not-null="true">
<type name="bigserial" length="0"/>
</column>
<column name="result" not-null="true">
<type name="jsonb" length="0"/>
</column>
<column name="duration" not-null="true">
<type name="tsrange" length="0"/>
</column>
<column name="status" not-null="true">
<type name="character varying" length="0"/>
</column>
<column name="id_play">
<type name="bigserial" length="0"/>
</column>
<constraint name="task_pk" type="pk-constr" table="public.task">
<columns names="id" ref-type="src-columns"/>
</constraint>
</table>
<constraint name="play_fk" type="fk-constr" comparison-type="MATCH FULL"
upd-action="CASCADE" del-action="CASCADE" ref-table="public.play" table="public.task">
<columns names="id_play" ref-type="src-columns"/>
<columns names="id" ref-type="dst-columns"/>
</constraint>
<relationship name="rel_task_play" type="relfk"
src-table="public.task"
dst-table="public.play" reference-fk="play_fk"
src-required="false" dst-required="false"/>
</dbmodel>