-
Notifications
You must be signed in to change notification settings - Fork 0
/
pet hospital.ids
75 lines (75 loc) · 6.28 KB
/
pet hospital.ids
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
<?xml version="1.0" encoding="UTF-8"?>
<component name="dataSourceStorage">
<data-source name="MySQL - @localhost" uuid="ec6a0031-ffd1-45ac-b162-02c3a17f1de9">
<database-info product="MySQL" version="5.6.22" jdbc-version="4.0" driver-name="MySQL Connector Java" driver-version="mysql-connector-java-5.1.34 ( Revision: jess.balint@oracle.com-20141014163213-wqbwpf1ok2kvo1om )">
<extra-name-characters>#@</extra-name-characters>
<identifier-quote-string>`</identifier-quote-string>
</database-info>
<case-sensitivity plain-identifiers="mixed" quoted-identifiers="upper"/>
<schema name="" catalog="test"/>
<table name="Admin" schema="" catalog="test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="email" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="password" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<primary-key name="PRIMARY" columns="id"/>
</table>
<table name="Appointment" schema="" catalog="test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="comments" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="date" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/>
<column name="duration" sqlType="TIME" precision="8" scale="0" nullable="true" jdbcType="92"/>
<column name="treatment" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="pet_id" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/>
<column name="vet_id" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/>
<primary-key name="PRIMARY" columns="id"/>
<foreign-key name="FKB7F037F43567FB6" columns="pet_id" ref-table="Pet" ref-schema="" ref-catalog="test" ref-columns="id" update-rule="3" delete-rule="3" deferrability="2"/>
<foreign-key name="FKB7F037F4D93A9F6" columns="vet_id" ref-table="Vet" ref-schema="" ref-catalog="test" ref-columns="id" update-rule="3" delete-rule="3" deferrability="2"/>
<index name="FKB7F037F43567FB6" unique="false" columns="pet_id"/>
<index name="FKB7F037F4D93A9F6" unique="false" columns="vet_id"/>
</table>
<table name="Pet" schema="" catalog="test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="name" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="type" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/>
<column name="birthDate" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/>
<column name="breed" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="certificateInfo" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="diseases" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="gender" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/>
<column name="isPrivate" sqlType="BIT" precision="1" scale="0" nullable="false" jdbcType="-7"/>
<column name="vaccinations" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="owner_id" sqlType="BIGINT" precision="19" scale="0" nullable="true" jdbcType="-5"/>
<primary-key name="PRIMARY" columns="id"/>
<foreign-key name="FK138FF1A78CE1F" columns="owner_id" ref-table="PetOwner" ref-schema="" ref-catalog="test" ref-columns="id" update-rule="3" delete-rule="3" deferrability="2"/>
<exported-key name="FKB7F037F43567FB6" table="Appointment" schema="" catalog="test" columns="pet_id"/>
<index name="FK138FF1A78CE1F" unique="false" columns="owner_id"/>
</table>
<table name="PetOwner" schema="" catalog="test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="address" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="birthDate" sqlType="DATETIME" precision="19" scale="0" nullable="true" jdbcType="93"/>
<column name="email" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="lastName" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="name" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="password" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="tcNo" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/>
<primary-key name="PRIMARY" columns="id"/>
<exported-key name="FK138FF1A78CE1F" table="Pet" schema="" catalog="test" columns="owner_id"/>
</table>
<table name="Statistics" schema="" catalog="test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="numOfPets" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/>
<column name="numOfUsers" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/>
<column name="vetBrowse" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/>
<column name="vetAppointments" sqlType="INT" precision="10" scale="0" nullable="true" jdbcType="4"/>
<primary-key name="PRIMARY" columns="id"/>
</table>
<table name="Vet" schema="" catalog="test" type="TABLE">
<column name="id" sqlType="BIGINT" precision="19" scale="0" nullable="false" jdbcType="-5" autoIncrement="true"/>
<column name="email" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<column name="password" sqlType="VARCHAR" precision="255" scale="0" nullable="true" jdbcType="12"/>
<primary-key name="PRIMARY" columns="id"/>
<exported-key name="FKB7F037F4D93A9F6" table="Appointment" schema="" catalog="test" columns="vet_id"/>
</table>
</data-source>
</component>