Debian Codegraph @

lib/UR/DataSource/Meta.sqlite3-schema

raw
1 CREATE TABLE IF NOT EXISTS dd_bitmap_index (
2 data_source varchar NOT NULL,
3 owner varchar,
4 table_name varchar NOT NULL,
5 bitmap_index_name varchar NOT NULL,
6 PRIMARY KEY (data_source, owner, table_name, bitmap_index_name)
7 );
8 CREATE TABLE IF NOT EXISTS dd_fk_constraint (
9 data_source varchar NOT NULL,
10 owner varchar,
11 r_owner varchar,
12 table_name varchar NOT NULL,
13 r_table_name varchar NOT NULL,
14 fk_constraint_name varchar NOT NULL,
15 last_object_revision timestamp NOT NULL,
16 PRIMARY KEY(data_source, owner, r_owner, table_name, r_table_name, fk_constraint_name)
17 );
18 CREATE TABLE IF NOT EXISTS dd_fk_constraint_column (
19 fk_constraint_name varchar NOT NULL,
20 data_source varchar NOT NULL,
21 owner varchar,
22 table_name varchar NOT NULL,
23 r_table_name varchar NOT NULL,
24 column_name varchar NOT NULL,
25 r_column_name varchar NOT NULL,
26
27 PRIMARY KEY(data_source, owner, table_name, fk_constraint_name, column_name)
28 );
29 CREATE TABLE IF NOT EXISTS dd_pk_constraint_column (
30 data_source varchar NOT NULL,
31 owner varchar,
32 table_name varchar NOT NULL,
33 column_name varchar NOT NULL,
34 rank integer NOT NULL,
35 PRIMARY KEY (data_source,owner,table_name,column_name,rank)
36 );
37 CREATE TABLE IF NOT EXISTS dd_table (
38 data_source varchar NOT NULL,
39 owner varchar,
40 table_name varchar NOT NULL,
41 table_type varchar NOT NULL,
42 er_type varchar NOT NULL,
43 last_ddl_time timestamp,
44 last_object_revision timestamp NOT NULL,
45 remarks varchar,
46 PRIMARY KEY(data_source, owner, table_name)
47 );
48 CREATE TABLE IF NOT EXISTS dd_table_column (
49 data_source varchar NOT NULL,
50 owner varchar,
51 table_name varchar NOT NULL,
52 column_name varchar NOT NULL,
53 data_type varchar NOT NULL,
54 data_length varchar,
55 nullable varchar NOT NULL,
56 last_object_revision timestamp NOT NULL,
57 remarks varchar,
58 PRIMARY KEY(data_source, owner, table_name, column_name)
59 );
60 CREATE TABLE IF NOT EXISTS dd_unique_constraint_column (
61 data_source varchar NOT NULL,
62 owner varchar,
63 table_name varchar NOT NULL,
64 constraint_name varchar NOT NULL,
65 column_name varchar NOT NULL,
66 PRIMARY KEY (data_source,owner,table_name,constraint_name,column_name)
67 );
68