xml version encoding utf-8 sql datatypes db postgresql group label Num

 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
<?xml version="1.0" encoding="utf-8" ?><sql><datatypes db="postgresql">
<group label="Numeric" color="rgb(238,238,170)">
<type label="Integer" length="0" sql="INTEGER" re="INT" quote=""/>
<type label="Small Integer" length="0" sql="SMALLINT" quote=""/>
<type label="Big Integer" length="0" sql="BIGINT" quote=""/>
<type label="Decimal" length="1" sql="DECIMAL" re="numeric" quote=""/>
<type label="Serial" length="0" sql="SERIAL" re="SERIAL4" quote=""/>
<type label="Big Serial" length="0" sql="BIGSERIAL" re="SERIAL8" quote=""/>
<type label="Real" length="0" sql="BIGINT" quote=""/>
<type label="Single precision" length="0" sql="FLOAT" quote=""/>
<type label="Double precision" length="0" sql="DOUBLE" re="DOUBLE" quote=""/>
</group>
<group label="Character" color="rgb(255,200,200)">
<type label="Char" length="1" sql="CHAR" quote="'"/>
<type label="Varchar" length="1" sql="VARCHAR" re="CHARACTER VARYING" quote="'"/>
<type label="Text" length="0" sql="TEXT" quote="'"/>
<type label="Binary" length="1" sql="BYTEA" quote="'"/>
<type label="Boolean" length="0" sql="BOOLEAN" quote="'"/>
</group>
<group label="Date &amp; Time" color="rgb(200,255,200)">
<type label="Date" length="0" sql="DATE" quote="'"/>
<type label="Time" length="1" sql="TIME" quote="'"/>
<type label="Time w/ TZ" length="0" sql="TIME WITH TIMEZONE" quote="'"/>
<type label="Interval" length="1" sql="INTERVAL" quote="'"/>
<type label="Timestamp" length="1" sql="TIMESTAMP" quote="'"/>
<type label="Timestamp w/ TZ" length="0" sql="TIMESTAMP WITH TIMEZONE" quote="'"/>
</group>
<group label="Miscellaneous" color="rgb(200,200,255)">
<type label="XML" length="1" sql="XML" quote="'"/>
<type label="Bit" length="1" sql="BIT" quote="'"/>
<type label="Bit Varying" length="1" sql="VARBIT" re="BIT VARYING" quote="'"/>
<type label="Inet Host Addr" length="0" sql="INET" quote="'"/>
<type label="Inet CIDR Addr" length="0" sql="CIDR" quote="'"/>
</group>
</datatypes><table x="681" y="21" name="ticket"><row name="id" null="0" autoincrement="1"><datatype>SERIAL</datatype></row><row name="customer_id" null="0" autoincrement="0"><datatype>SERIAL</datatype><relation table="customer" row="id" /></row><row name="site_id" null="0" autoincrement="0"><datatype>SERIAL</datatype><relation table="site" row="id" /></row><row name="code" null="0" autoincrement="0"><datatype>VARCHAR(128)</datatype></row><row name="staff_id" null="1" autoincrement="0"><datatype>INTEGER</datatype><relation table="staff" row="id" /></row><row name="created_at" null="1" autoincrement="0"><datatype>TIMESTAMP</datatype></row><row name="updated_at" null="1" autoincrement="0"><datatype>TIMESTAMP</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="841" y="201" name="site"><row name="id" null="0" autoincrement="1"><datatype>SERIAL</datatype></row><row name="title" null="0" autoincrement="0"><datatype>VARCHAR(128)</datatype></row><row name="url" null="0" autoincrement="0"><datatype>VARCHAR(128)</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="842" y="19" name="customer"><row name="id" null="0" autoincrement="1"><datatype>SERIAL</datatype></row><row name="fullname" null="1" autoincrement="0"><datatype>VARCHAR(128)</datatype></row><row name="email" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype></row><row name="password" null="0" autoincrement="0"><datatype>VARCHAR(128)</datatype></row><row name="token" null="0" autoincrement="0"><datatype>VARCHAR(128)</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="983" y="202" name="box"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="site_id" null="0" autoincrement="0"><datatype>SERIAL</datatype><relation table="site" row="id" /></row><row name="box_type" null="0" autoincrement="0"><datatype>VARCHAR(32)</datatype><comment>pop3/imap</comment></row><row name="host" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype></row><row name="port" null="0" autoincrement="0"><datatype>INTEGER</datatype></row><row name="login" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype></row><row name="password" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="495" y="21" name="ticket_flow"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="ticket_id" null="0" autoincrement="0"><datatype>SERIAL</datatype><relation table="ticket" row="id" /></row><row name="author_type" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype><comment>staff/customer</comment></row><row name="author_id" null="0" autoincrement="0"><datatype>INTEGER</datatype><comment>staff_id or customer_id, polimorthic relation</comment></row><row name="status_id" null="0" autoincrement="0"><datatype>INTEGER</datatype><relation table="status" row="id" /></row><row name="body" null="0" autoincrement="0"><datatype>TEXT</datatype></row><row name="created_at" null="1" autoincrement="0"><datatype>TIMESTAMP</datatype></row><row name="updated_at" null="1" autoincrement="0"><datatype>TIMESTAMP</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="536" y="292" name="staff"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="fullname" null="0" autoincrement="0"><datatype>VARCHAR(128)</datatype></row><row name="email" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype></row><row name="password" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="342" y="21" name="status"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="name" null="0" autoincrement="0"><datatype>VARCHAR(64)</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table></sql>