<?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="1.2.2" use-changelog="false" max-obj-count="13"
	 gen-disabled-objs-code="false" show-sys-schemas-rects="true"
	 last-position="279,-132" last-zoom="0.9" scene-rect="0,-147,1570.8,1223.8"
	 default-schema="public" default-owner="postgres"
	 layers="Default layer"
	 active-layers="0"
	 layer-name-colors="#000000"
	 layer-rect-colors="#b4b4b4"
	 show-layer-names="false" show-layer-rects="false">
<database name="new_database" is-template="false" allow-conns="true">
</database>

<schema name="public" layers="0" fill-color="#e1e1e1" name-color="#000000" sql-disabled="true">
</schema>

<table name="Korisnik" layers="0" collapse-mode="2" max-obj-count="4" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="300" y="120"/>
	<column name="SifK" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="Ime" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<column name="Prezime" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<column name="BrLK">
		<type name="varchar" length="7"/>
	</column>
	<constraint name="UQ_BrLK" type="pk-constr" table="public.&quot;Korisnik&quot;">
		<columns names="SifK" ref-type="src-columns"/>
	</constraint>
</table>

<table name="Sahista" layers="0" collapse-mode="2" max-obj-count="2" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="500" y="380"/>
</table>

<relationship name="Sahista_has_one_Korisnik" type="rel11" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#2c30a2"
	 src-table="public.&quot;Korisnik&quot;"
	 dst-table="public.&quot;Sahista&quot;"
	 src-required="true" dst-required="false"
	 identifier="true"
>
	<label ref-type="name-label">
		<position x="-102.037" y="-60.353"/>
	</label>
</relationship>

<table name="Komentator" layers="0" collapse-mode="2" max-obj-count="2" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="160" y="380"/>
</table>

<relationship name="Komentator_has_one_Korisnik" type="rel11" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#a8f34a"
	 src-table="public.&quot;Korisnik&quot;"
	 dst-table="public.&quot;Komentator&quot;"
	 src-required="true" dst-required="false"
	 identifier="true"
/>

<table name="Turnir" layers="0" collapse-mode="2" max-obj-count="4" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="1120" y="120"/>
	<column name="SifT" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="Naziv" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<column name="Datum" not-null="true">
		<type name="date" length="0"/>
	</column>
	<column name="Mesto" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<constraint name="Turnir_pk" type="pk-constr" table="public.&quot;Turnir&quot;">
		<columns names="SifT" ref-type="src-columns"/>
	</constraint>
</table>

<table name="Ucestvuje" layers="0" collapse-mode="2" max-obj-count="3" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="720" y="140"/>
</table>

<relationship name="Korisnik_has_many_Ucestvuje" type="rel1n" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#8db444"
	 src-table="public.&quot;Korisnik&quot;"
	 dst-table="public.&quot;Ucestvuje&quot;"
	 src-required="true" dst-required="false"
	 identifier="true"
/>

<relationship name="Turnir_has_many_Ucestvuje" type="rel1n" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#103dd7"
	 src-table="public.&quot;Turnir&quot;"
	 dst-table="public.&quot;Ucestvuje&quot;"
	 src-required="true" dst-required="false"
	 identifier="true"
/>

<table name="Partija" layers="0" collapse-mode="2" max-obj-count="6" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="1140" y="360"/>
	<column name="SifP" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="Ishod">
		<type name="char" length="1"/>
	</column>
	<constraint name="Partija_pk" type="pk-constr" table="public.&quot;Partija&quot;">
		<columns names="SifP" ref-type="src-columns"/>
	</constraint>

	<customidxs object-type="column">
		<object name="SifT_Turnir" index="1"/>
	</customidxs>
	<customidxs object-type="constraint">
		<object name="Turnir_fk" index="1"/>
	</customidxs></table>

<relationship name="Turnir_has_many_Partija" type="rel1n" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#43fe2e"
	 src-table="public.&quot;Turnir&quot;"
	 dst-table="public.&quot;Partija&quot;"
	 src-required="false" dst-required="false"/>

<relationship name="Sahista_has_many_Partija_Beli" type="rel1n" layers="0"
	 src-col-pattern="Beli"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#5f21f9"
	 src-table="public.&quot;Sahista&quot;"
	 dst-table="public.&quot;Partija&quot;"
	 src-required="true" dst-required="false"/>

<relationship name="Sahista_has_many_Partija_Crni" type="rel1n" layers="0"
	 src-col-pattern="Crni"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#c926db"
	 src-table="public.&quot;Sahista&quot;"
	 dst-table="public.&quot;Partija&quot;"
	 src-required="true" dst-required="false"/>

<table name="Analiza" layers="0" collapse-mode="2" max-obj-count="4" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="560" y="600"/>
	<column name="SifA" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="Lista" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<constraint name="Analiza_pk" type="pk-constr" table="public.&quot;Analiza&quot;">
		<columns names="SifA" ref-type="src-columns"/>
	</constraint>

	<customidxs object-type="column">
		<object name="SifPot_Potez" index="1"/>
	</customidxs>
	<customidxs object-type="constraint">
		<object name="Potez_fk" index="1"/>
	</customidxs></table>

<table name="Potez" layers="0" collapse-mode="2" max-obj-count="3" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="1120" y="640"/>
	<column name="SifPot" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="Opis" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<constraint name="Potez_pk" type="pk-constr" table="public.&quot;Potez&quot;">
		<columns names="SifPot" ref-type="src-columns"/>
	</constraint>
</table>

<relationship name="Partija_has_many_Potez" type="rel1n" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#f178e1"
	 src-table="public.&quot;Partija&quot;"
	 dst-table="public.&quot;Potez&quot;"
	 src-required="true" dst-required="false"/>

<relationship name="Potez_has_many_Analiza" type="rel1n" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#06e054"
	 src-table="public.&quot;Potez&quot;"
	 dst-table="public.&quot;Analiza&quot;"
	 src-required="true" dst-required="false"/>

<relationship name="Komentator_has_many_Analiza" type="rel1n" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#1808d5"
	 src-table="public.&quot;Komentator&quot;"
	 dst-table="public.&quot;Analiza&quot;"
	 src-required="true" dst-required="false"/>

<table name="Nagrada" layers="0" collapse-mode="2" max-obj-count="4" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="680" y="-80"/>
	<column name="SifN" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="Suma" not-null="true">
		<type name="decimal" length="10" precision="2"/>
	</column>
	<constraint name="Nagrada_pk" type="pk-constr" table="public.&quot;Nagrada&quot;">
		<columns names="SifN" ref-type="src-columns"/>
	</constraint>
</table>

<relationship name="Nagrada_has_one_Ucestvuje" type="rel11" layers="0"
	 src-col-pattern="{sc}_{st}"
	 pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
	 src-fk-pattern="{st}_fk"
	 fk-idx-pattern="{st}_idx"
	 custom-color="#1b2020"
	 src-table="public.&quot;Ucestvuje&quot;"
	 dst-table="public.&quot;Nagrada&quot;"
	 src-required="true" dst-required="false">
	<label ref-type="name-label">
		<position x="124.5" y="-34.553"/>
	</label>
</relationship>

</dbmodel>
