-
Notifications
You must be signed in to change notification settings - Fork 0
/
news.ids
73 lines (73 loc) · 6.26 KB
/
news.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
<?xml version="1.0" encoding="UTF-8"?><component name="dataSourceStorage">
<data-source source="LOCAL" name="Data Source" product="Oracle" version="Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production" jdbc-version="11.2" driver-name="Oracle JDBC driver" driver-version="11.2.0.3.0" uuid="d7502511-5687-485c-8c33-a0312fd182ed">
<extra-name-characters>$#</extra-name-characters>
<identifier-quote-string>"</identifier-quote-string>
<jdbc-driver>oracle.jdbc.OracleDriver</jdbc-driver>
<jdbc-url>jdbc:oracle:thin:@//localhost:1521/xe</jdbc-url>
<user-name>Saj</user-name>
<user-password>dfcbdfcedfc7dfc3dfc4</user-password>
<schema-pattern>*.SAJ</schema-pattern>
<default-schemas>*.SAJ</default-schemas>
<default-dialect>Oracle</default-dialect>
<libraries>
<library>
<url>jar://$MAVEN_REPOSITORY$/com/oracle/ojdbc6/11.2.0.3/ojdbc6-11.2.0.3.jar!/</url>
</library>
</libraries>
<schema name="SAJ" catalog="" />
<table name="T_CATEGORIES" schema="SAJ" catalog="" type="TABLE">
<column name="F_CATEGORY_ID" sqlType="NUMBER" length="10" precision="0" nullable="false" jdbcType="3" version="true" />
<column name="F_CATEGORY" sqlType="VARCHAR2" length="40" precision="0" nullable="true" jdbcType="12" version="true" />
<primary-key name="PRIMARY" columns="F_CATEGORY_ID" />
<exported-key name="SYS_C008018" table="T_NEWS" schema="SAJ" catalog="" columns="F_CATEGORY_ID" />
</table>
<table name="T_CATEGORIES_SEQ" schema="SAJ" catalog="" type="SEQUENCE" />
<table name="T_COMMENTS" schema="SAJ" catalog="" type="TABLE">
<column name="F_ID" sqlType="NUMBER" length="0" precision="-127" nullable="false" jdbcType="3" version="true" />
<column name="F_NEWS_ID" sqlType="NUMBER" length="0" precision="-127" nullable="false" jdbcType="3" version="true" />
<column name="F_USER_ID" sqlType="VARCHAR2" length="40" precision="0" nullable="false" jdbcType="12" version="true" />
<column name="F_DATE" sqlType="VARCHAR2" length="40" precision="0" nullable="false" jdbcType="12" version="true" />
<column name="F_NUMBER" sqlType="NUMBER" length="0" precision="-127" nullable="false" jdbcType="3" version="true" />
<column name="F_COMMENT" sqlType="VARCHAR2" length="3000" precision="0" nullable="false" jdbcType="12" version="true" />
<primary-key name="SYS_C008233" columns="F_ID" />
<foreign-key name="SYS_C008240" columns="F_NEWS_ID" ref-table="T_NEWS" ref-schema="SAJ" ref-catalog="" ref-columns="F_NEWS_ID" update-rule="0" delete-rule="1" deferrability="2" />
<foreign-key name="SYS_C008241" columns="F_USER_ID" ref-table="T_USERS" ref-schema="SAJ" ref-catalog="" ref-columns="F_USER_ID" update-rule="0" delete-rule="1" deferrability="2" />
</table>
<table name="T_NEWS" schema="SAJ" catalog="" type="TABLE">
<column name="F_TITLE" sqlType="VARCHAR2" length="150" precision="0" nullable="true" jdbcType="12" version="true" />
<column name="F_AUTHOR" sqlType="VARCHAR2" length="30" precision="0" nullable="false" jdbcType="12" version="true" />
<column name="F_CREATIONDATE" sqlType="VARCHAR2" length="15" precision="0" nullable="true" jdbcType="12" version="true" />
<column name="F_ANNOTATION" sqlType="VARCHAR2" length="1500" precision="0" nullable="true" jdbcType="12" version="true" />
<column name="F_CATEGORY_ID" sqlType="NUMBER" length="10" precision="0" nullable="false" jdbcType="3" version="true" />
<column name="F_CONTENT" sqlType="VARCHAR2" length="3000" precision="0" nullable="true" jdbcType="12" version="true" />
<column name="F_NEWS_ID" sqlType="NUMBER" length="0" precision="-127" nullable="false" jdbcType="3" version="true" />
<primary-key name="SYS_C008031" columns="F_NEWS_ID" />
<foreign-key name="SYS_C008018" columns="F_CATEGORY_ID" ref-table="T_CATEGORIES" ref-schema="SAJ" ref-catalog="" ref-columns="F_CATEGORY_ID" update-rule="0" delete-rule="1" deferrability="2" />
<exported-key name="SYS_C008240" table="T_COMMENTS" schema="SAJ" catalog="" columns="F_NEWS_ID" />
</table>
<table name="T_NEWS_SEQ" schema="SAJ" catalog="" type="SEQUENCE" />
<table name="T_ROLES" schema="SAJ" catalog="" type="TABLE">
<column name="F_ROLE_ID" sqlType="NUMBER" length="0" precision="-127" nullable="false" jdbcType="3" version="true" />
<column name="F_ROLE_NAME" sqlType="VARCHAR2" length="50" precision="0" nullable="false" jdbcType="12" version="true" />
<primary-key name="SYS_C008172" columns="F_ROLE_ID" />
<exported-key name="SYS_C008184" table="T_ROLES_USERS" schema="SAJ" catalog="" columns="F_ROLE_ID" />
</table>
<table name="T_ROLES_SEQ" schema="SAJ" catalog="" type="SEQUENCE" />
<table name="T_ROLES_USERS" schema="SAJ" catalog="" type="TABLE">
<column name="F_USER_ID" sqlType="VARCHAR2" length="40" precision="0" nullable="false" jdbcType="12" />
<column name="F_ROLE_ID" sqlType="NUMBER" length="0" precision="-127" nullable="false" jdbcType="3" />
<foreign-key name="SYS_C008184" columns="F_ROLE_ID" ref-table="T_ROLES" ref-schema="SAJ" ref-catalog="" ref-columns="F_ROLE_ID" update-rule="0" delete-rule="1" deferrability="2" />
<foreign-key name="SYS_C008185" columns="F_USER_ID" ref-table="T_USERS" ref-schema="SAJ" ref-catalog="" ref-columns="F_USER_ID" update-rule="0" delete-rule="1" deferrability="2" />
</table>
<table name="T_USERS" schema="SAJ" catalog="" type="TABLE">
<column name="F_USER_ID" sqlType="VARCHAR2" length="40" precision="0" nullable="false" jdbcType="12" version="true" />
<column name="F_PASSWORD" sqlType="VARCHAR2" length="10" precision="0" nullable="false" jdbcType="12" version="true" />
<column name="F_NAME" sqlType="VARCHAR2" length="50" precision="0" nullable="false" jdbcType="12" version="true" />
<column name="F_SECONDNAME" sqlType="VARCHAR2" length="50" precision="0" nullable="false" jdbcType="12" version="true" />
<primary-key name="PRIMARY_2" columns="F_USER_ID" />
<exported-key name="SYS_C008241" table="T_COMMENTS" schema="SAJ" catalog="" columns="F_USER_ID" />
<exported-key name="SYS_C008185" table="T_ROLES_USERS" schema="SAJ" catalog="" columns="F_USER_ID" />
</table>
<table name="T_USERS_SEQ" schema="SAJ" catalog="" type="SEQUENCE" />
</data-source>
</component>