<?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="12"
	 gen-disabled-objs-code="false" show-sys-schemas-rects="true"
	 last-position="190,483" last-zoom="1" scene-rect="0,0,1628.18,1076.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="Film" layers="0" collapse-mode="1" max-obj-count="7" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="100" y="340"/>
	<column name="IdF" 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="Trajanje" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<constraint name="Film_pk" type="pk-constr" table="public.&quot;Film&quot;">
		<columns names="IdF" ref-type="src-columns"/>
	</constraint>
</table>

<table name="Clan" layers="0" collapse-mode="1" max-obj-count="3" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="860" y="260"/>
	<column name="IdC" 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>
	<constraint name="Clan_pk" type="pk-constr" table="public.&quot;Clan&quot;">
		<columns names="IdC" ref-type="src-columns"/>
	</constraint>
</table>

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

<table name="Reziser" layers="0" collapse-mode="1" max-obj-count="2" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="520" y="400"/>
</table>

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

<relationship name="Glumac_has_one_Clan" 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="#69d7e4"
	 src-table="public.&quot;Clan&quot;"
	 dst-table="public.&quot;Glumac&quot;"
	 src-required="true" dst-required="false"
	 identifier="true"
/>

<relationship name="Reziser_has_one_Clan" 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="#e3a287"
	 src-table="public.&quot;Clan&quot;"
	 dst-table="public.&quot;Reziser&quot;"
	 src-required="true" dst-required="false"
	 identifier="true"
/>

<relationship name="Scenarista_has_one_Clan" 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="#94523b"
	 src-table="public.&quot;Clan&quot;"
	 dst-table="public.&quot;Scenarista&quot;"
	 src-required="true" dst-required="false"
	 identifier="true"
/>

<relationship name="Reziser_has_many_Film" 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="#4ad32a"
	 src-table="public.&quot;Reziser&quot;"
	 dst-table="public.&quot;Film&quot;"
	 src-required="true" dst-required="false"/>

<relationship name="Scenarista_has_many_Film" 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="#15ba43"
	 src-table="public.&quot;Scenarista&quot;"
	 dst-table="public.&quot;Film&quot;"
	 src-required="true" dst-required="false"/>

<relationship name="many_Film_has_many_Glumac" type="relnn" layers="0"
	 src-col-pattern="{sc}_{st}" dst-col-pattern="{sc}_{dt}"
	 pk-pattern="{gt}_pk" uq-pattern="{gt}_uq"
	 src-fk-pattern="{st}_fk" dst-fk-pattern="{dt}_fk"
	 pk-col-pattern="id"
	 fk-idx-pattern="{gt}_idx"
	 custom-color="#9c3d14"
	 src-table="public.&quot;Film&quot;"
	 dst-table="public.&quot;Glumac&quot;"
	 src-required="false" dst-required="false"
	 table-name="Ucestvuje"/>

<table name="Sala" layers="0" collapse-mode="2" max-obj-count="3" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="920" y="560"/>
	<column name="IdS" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="BrRedova" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="BrSedista" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<constraint name="Sala_pk" type="pk-constr" table="public.&quot;Sala&quot;">
		<columns names="IdS" ref-type="src-columns"/>
	</constraint>
</table>

<table name="Korisnik" layers="0" collapse-mode="2" max-obj-count="7" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="1100" y="800"/>
	<column name="IdK" 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="Email" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<column name="Lozinka" not-null="true">
		<type name="varchar" length="200"/>
	</column>
	<column name="BrRezervacija" not-null="true" default-value="0">
		<type name="integer" length="0"/>
	</column>
	<constraint name="Korisnik_pk" type="pk-constr" table="public.&quot;Korisnik&quot;">
		<columns names="IdK" ref-type="src-columns"/>
	</constraint>
</table>

<table name="Termin" layers="0" collapse-mode="2" max-obj-count="6" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="180" y="700"/>
	<column name="IdT" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="Datum" not-null="true">
		<type name="date" length="0"/>
	</column>
	<column name="Vreme" not-null="true">
		<type name="time" length="0"/>
	</column>
	<constraint name="Termin_pk" type="pk-constr" table="public.&quot;Termin&quot;">
		<columns names="IdT" ref-type="src-columns"/>
	</constraint>
</table>

<relationship name="Film_has_many_Termin" 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="#0d8705"
	 src-table="public.&quot;Film&quot;"
	 dst-table="public.&quot;Termin&quot;"
	 src-required="true" dst-required="false"/>

<relationship name="Sala_has_many_Termin" 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="#b9148f"
	 src-table="public.&quot;Sala&quot;"
	 dst-table="public.&quot;Termin&quot;"
	 src-required="true" dst-required="false"/>

<table name="Rezervacija" layers="0" collapse-mode="1" max-obj-count="6" z-value="0">
	<schema name="public"/>
	<role name="postgres"/>
	<position x="660" y="860"/>
	<column name="IdR" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="BrReda" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<column name="BrSedista" not-null="true">
		<type name="integer" length="0"/>
	</column>
	<constraint name="Rezervacija_pk" type="pk-constr" table="public.&quot;Rezervacija&quot;">
		<columns names="IdR" ref-type="src-columns"/>
	</constraint>

	<customidxs object-type="column">
		<object name="IdK_Korisnik" index="1"/>
		<object name="IdT_Termin" index="2"/>
	</customidxs>
	<customidxs object-type="constraint">
		<object name="Korisnik_fk" index="0"/>
		<object name="Termin_fk" index="1"/>
	</customidxs></table>

<relationship name="Korisnik_has_many_Rezervacija" 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="#03ce26"
	 src-table="public.&quot;Korisnik&quot;"
	 dst-table="public.&quot;Rezervacija&quot;"
	 src-required="true" dst-required="false"/>

<relationship name="Termin_has_many_Rezervacija" 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="#4b45d4"
	 src-table="public.&quot;Termin&quot;"
	 dst-table="public.&quot;Rezervacija&quot;"
	 src-required="true" dst-required="false"/>

</dbmodel>
