153 lines
4.8 KiB
XML
153 lines
4.8 KiB
XML
<?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.0-alpha1" use-changelog="false" max-obj-count="4"
|
|
last-position="0,29" last-zoom="1"
|
|
default-schema="public" default-owner="dev"
|
|
layers="Default layer"
|
|
active-layers="0"
|
|
layer-name-colors="#000000"
|
|
layer-rect-colors="#b4b4b4"
|
|
show-layer-names="false" show-layer-rects="false">
|
|
<role name="dev"
|
|
superuser="true"
|
|
createdb="true"
|
|
replication="true"
|
|
createrole="true"
|
|
inherit="true"
|
|
login="true"
|
|
bypassrls="true"
|
|
password="********"
|
|
sql-disabled="true">
|
|
</role>
|
|
|
|
<database name="dev1" encoding="UTF8" lc-collate="en_US.utf8" lc-ctype="en_US.utf8" is-template="false" allow-conns="true">
|
|
<role name="dev"/>
|
|
<tablespace name="pg_default"/>
|
|
</database>
|
|
|
|
<schema name="public" layers="0" rect-visible="true" fill-color="#e1e1e1" name-color="#000000" sql-disabled="true">
|
|
</schema>
|
|
|
|
<table name="goose_db_version" layers="0" collapse-mode="2" max-obj-count="4" z-value="0">
|
|
<schema name="public"/>
|
|
<role name="dev"/>
|
|
<position x="440" y="300"/>
|
|
<column name="id" not-null="true"
|
|
identity-type="BY DEFAULT" start="1" increment="1" min-value="1" max-value="2147483647" cache="1">
|
|
<type name="integer" length="0"/>
|
|
</column>
|
|
<column name="version_id" not-null="true">
|
|
<type name="bigint" length="0"/>
|
|
</column>
|
|
<column name="is_applied" not-null="true">
|
|
<type name="boolean" length="0"/>
|
|
</column>
|
|
<column name="tstamp" not-null="true" default-value="now()">
|
|
<type name="timestamp" length="0"/>
|
|
</column>
|
|
<constraint name="goose_db_version_pkey" type="pk-constr" table="public.goose_db_version">
|
|
<columns names="id" ref-type="src-columns"/>
|
|
</constraint>
|
|
</table>
|
|
|
|
<sequence name="goose_db_version_id_seq" cycle="false" start="1" increment="1" min-value="1" max-value="2147483647" cache="1" sql-disabled="true">
|
|
<schema name="public"/>
|
|
<role name="dev"/>
|
|
</sequence>
|
|
|
|
<sequence name="usuario_id_seq" cycle="false" start="1" increment="1" min-value="1" max-value="2147483647" cache="1" sql-disabled="true">
|
|
<schema name="public"/>
|
|
<role name="dev"/>
|
|
</sequence>
|
|
|
|
<table name="file" layers="0" collapse-mode="2" max-obj-count="12" z-value="0">
|
|
<schema name="public"/>
|
|
<role name="dev"/>
|
|
<position x="1160" y="520"/>
|
|
<column name="id" not-null="true">
|
|
<type name="uuid" length="0"/>
|
|
</column>
|
|
<column name="name" not-null="true">
|
|
<type name="varchar" length="256"/>
|
|
</column>
|
|
<column name="size" not-null="true">
|
|
<type name="integer" length="0"/>
|
|
</column>
|
|
<column name="created_at" not-null="true">
|
|
<type name="timestamp" length="0"/>
|
|
</column>
|
|
<column name="mime" not-null="true">
|
|
<type name="text" length="0"/>
|
|
</column>
|
|
<column name="message">
|
|
<type name="varchar" length="8192"/>
|
|
</column>
|
|
<column name="width">
|
|
<type name="smallint" length="0"/>
|
|
</column>
|
|
<column name="height">
|
|
<type name="smallint" length="0"/>
|
|
</column>
|
|
<column name="md5" not-null="true">
|
|
<type name="text" length="0"/>
|
|
</column>
|
|
<constraint name="file_pk" type="pk-constr" table="public.file">
|
|
<columns names="id" ref-type="src-columns"/>
|
|
</constraint>
|
|
|
|
<customidxs object-type="column">
|
|
<object name="id_box" index="8"/>
|
|
</customidxs>
|
|
<customidxs object-type="constraint">
|
|
<object name="box_fk" index="1"/>
|
|
</customidxs></table>
|
|
|
|
<table name="box" layers="0" collapse-mode="2" max-obj-count="9" z-value="0">
|
|
<schema name="public"/>
|
|
<role name="dev"/>
|
|
<position x="560" y="560"/>
|
|
<column name="id" not-null="true">
|
|
<type name="uuid" length="0"/>
|
|
</column>
|
|
<column name="url" not-null="true">
|
|
<type name="varchar" length="256"/>
|
|
</column>
|
|
<column name="edit_code" not-null="true">
|
|
<type name="varchar" length="64"/>
|
|
</column>
|
|
<column name="header">
|
|
<type name="text" length="16384"/>
|
|
</column>
|
|
<column name="private" not-null="true" default-value="false">
|
|
<type name="boolean" length="0"/>
|
|
</column>
|
|
<column name="moderation" not-null="true" default-value="false">
|
|
<type name="boolean" length="0"/>
|
|
</column>
|
|
<column name="created_at" not-null="true" default-value="current_timestamp">
|
|
<type name="timestamp" length="0"/>
|
|
</column>
|
|
<column name="last_updated_at" not-null="true" default-value="current_timestamp">
|
|
<type name="timestamp" length="0"/>
|
|
</column>
|
|
<constraint name="url_uq" type="uq-constr" table="public.box">
|
|
<columns names="url" ref-type="src-columns"/>
|
|
</constraint>
|
|
<constraint name="box_pk" type="pk-constr" table="public.box">
|
|
<columns names="id" ref-type="src-columns"/>
|
|
</constraint>
|
|
</table>
|
|
|
|
<relationship name="box_has_many_file" type="rel1n" layers="0"
|
|
src-col-pattern="{sc}_{st}"
|
|
pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
|
|
src-fk-pattern="{st}_fk"
|
|
custom-color="#ccd394"
|
|
src-table="public.box"
|
|
dst-table="public.file"
|
|
src-required="true" dst-required="false"/>
|
|
|
|
</dbmodel>
|