ERD » History » Version 1
bford -, 01/01/2006 12:16 AM
1 | 1 | bford - | |
---|---|---|---|
2 | {{{ |
||
3 | !graphviz |
||
4 | digraph g { |
||
5 | graph [ |
||
6 | rankdir = "LR", |
||
7 | concentrate = true, |
||
8 | ratio = auto |
||
9 | ]; |
||
10 | node [ |
||
11 | fontsize = "10", |
||
12 | shape = record |
||
13 | ]; |
||
14 | edge [ |
||
15 | ]; |
||
16 | |||
17 | "aggregate_types" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > sql_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
18 | |||
19 | "available_format_checks" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > example </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
20 | |||
21 | "available_transformations" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
22 | |||
23 | "column_format_checks" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > available_format_checks_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; |
||
24 | |||
25 | "column_transformations" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > available_transformations_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; |
||
26 | |||
27 | "columns" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > relations_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > order_ranking </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > sql_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > title </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > fk </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > pk </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > use_in_title </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > refers_to_namespace </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > refers_to_relation </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > refers_to_column </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > resolve_to_column </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > resolve_to_sql_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > select_column </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > form_element_types_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > sql_transforms_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > width </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > height </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > maxlength </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > ro </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > plain_text </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > hidden </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > allow_empty </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > alignment </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > use_implicit_joins </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> <TR><TD PORT="ltcol28" ></TD><TD align="left" > aggregate_types_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol28"> </TD></TR> <TR><TD PORT="ltcol29" ></TD><TD align="left" > search_sql_operators_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol29"> </TD></TR> <TR><TD PORT="ltcol30" ></TD><TD align="left" > insert_variables_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol30"> </TD></TR> <TR><TD PORT="ltcol31" ></TD><TD align="left" > update_variables_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol31"> </TD></TR> <TR><TD PORT="ltcol32" ></TD><TD align="left" > form_column </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol32"> </TD></TR> <TR><TD PORT="ltcol33" ></TD><TD align="left" > allow_searching </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol33"> </TD></TR> <TR><TD PORT="ltcol34" ></TD><TD align="left" > link_to_query_views_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol34"> </TD></TR> <TR><TD PORT="ltcol35" ></TD><TD align="left" > include_large_objects </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol35"> </TD></TR> <TR><TD PORT="ltcol36" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol36"> </TD></TR> <TR><TD PORT="ltcol37" ></TD><TD align="left" > default_value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol37"> </TD></TR> </TABLE>> ]; |
||
28 | |||
29 | "connections" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > host </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > dbname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > password </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > username </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > port </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > active </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> </TABLE>> ]; |
||
30 | |||
31 | "content_types" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; |
||
32 | |||
33 | "demo_fk_table" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; |
||
34 | |||
35 | "demo_table" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > field_integer </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > field_boolean </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > demo_fk_table_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; |
||
36 | |||
37 | "form_element_types" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > can_validate </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
||
38 | |||
39 | "join_types" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > sql_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > is_default </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
40 | |||
41 | "joins" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > queries_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > join_types_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > relations_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; |
||
42 | |||
43 | "joins_clauses" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > joins_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > first_columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > second_columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sql_operators_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > logic_operators_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ]; |
||
44 | |||
45 | "large_objects" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > filename </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > size </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > content_types_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > lo_oid </TD><TD align="left" > oid </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; |
||
46 | |||
47 | "layouts" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > class_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
||
48 | |||
49 | "layouts_properties" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > layouts_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > type </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > default_value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; |
||
50 | |||
51 | "link_properties" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > query_views_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > link_types_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > open_mode </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > menu_bar </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > status_bar </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > scroll_bars </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > tool_bar </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > resizable </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > width </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > height </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> </TABLE>> ]; |
||
52 | |||
53 | "link_types" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
54 | |||
55 | "links" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > label </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > show_submenu </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > destination_query_views_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > source_query_views_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
||
56 | |||
57 | "links_clauses" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > links_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > first_columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > second_columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sql_operators_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > logic_operators_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ]; |
||
58 | |||
59 | "lo_relations" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > nspname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > relname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
60 | |||
61 | "logic_operators" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > sql_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
62 | |||
63 | "menus" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
64 | |||
65 | "pages" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > page </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > script </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > label </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > active </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
||
66 | |||
67 | "permissions" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > active </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
68 | |||
69 | "php_sessions" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > session_id </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > session_data </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
70 | |||
71 | "queries" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > connections_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > custom_where_sql </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > primary_relations_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > render_all_column_forms </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; |
||
72 | |||
73 | "query_views" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > queries_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > layouts_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > menus_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > page_size </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > menu_item_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > vertical_submenu </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > show_sub_and_main </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > custom_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> </TABLE>> ]; |
||
74 | |||
75 | "query_views_layouts_properties" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > query_views_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > layouts_properties_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
76 | |||
77 | "query_views_roles" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > query_views_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > roles_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
78 | |||
79 | "record_large_objects" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > lo_relations_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > large_objects_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > record_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ]; |
||
80 | |||
81 | "relations" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > queries_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > namespace </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > insert_order </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; |
||
82 | |||
83 | "roles" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > ro </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > active </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
||
84 | |||
85 | "roles_permissions" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > roles_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > permissions_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; |
||
86 | |||
87 | "sessions" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > users_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > fingerprint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
88 | |||
89 | "sort_order" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > ascending </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
90 | |||
91 | "sql_operators" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > sql_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > is_default </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > is_default_search </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; |
||
92 | |||
93 | "sql_transforms" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > sql_text </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ]; |
||
94 | |||
95 | "users" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > first_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > last_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > home_phone </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > work_phone </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > cell_phone </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > fax_number </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > email </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > passwd </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > active </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > username </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > is_admin </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > prefix </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> </TABLE>> ]; |
||
96 | |||
97 | "users_roles" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > users_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > roles_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; |
||
98 | |||
99 | "validation_rules" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> </TABLE>> ]; |
||
100 | |||
101 | "variables" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > code </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ]; |
||
102 | |||
103 | "where_clauses" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > queries_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > first_columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > second_columns_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sql_operators_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > logic_operators_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > ordering </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > created </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ]; |
||
104 | |||
105 | |||
106 | |||
107 | "column_format_checks":rtcol1 -> "columns":ltcol1 [label=""]; |
||
108 | "column_format_checks":rtcol2 -> "available_format_checks":ltcol1 [label=""]; |
||
109 | "column_transformations":rtcol1 -> "columns":ltcol1 [label=""]; |
||
110 | "column_transformations":rtcol2 -> "available_transformations":ltcol1 [label=""]; |
||
111 | "columns":rtcol2 -> "relations":ltcol1 [label="relations_id_exists"]; |
||
112 | "columns":rtcol16 -> "form_element_types":ltcol1 [label="form_element_types_id_exists"]; |
||
113 | "columns":rtcol17 -> "sql_transforms":ltcol1 [label="sql_transforms_id_exists"]; |
||
114 | "columns":rtcol28 -> "aggregate_types":ltcol1 [label="aggregate_types_id_exists"]; |
||
115 | "columns":rtcol29 -> "sql_operators":ltcol1 [label="search_sql_operators_id_exists"]; |
||
116 | "columns":rtcol30 -> "variables":ltcol1 [label="insert_variables_id_exists"]; |
||
117 | "columns":rtcol31 -> "variables":ltcol1 [label="update_variables_id_exists"]; |
||
118 | "columns":rtcol34 -> "query_views":ltcol1 [label="link_to_query_views_id_exists"]; |
||
119 | "demo_table":rtcol6 -> "demo_fk_table":ltcol1 [label="demo_fk_table_id_exists"]; |
||
120 | "joins":rtcol2 -> "queries":ltcol1 [label="queries_id_exists"]; |
||
121 | "joins":rtcol3 -> "join_types":ltcol1 [label="join_types_id_exists"]; |
||
122 | "joins":rtcol4 -> "relations":ltcol1 [label="relations_id_exists"]; |
||
123 | "joins_clauses":rtcol2 -> "joins":ltcol1 [label="joins_id_exists"]; |
||
124 | "joins_clauses":rtcol3 -> "columns":ltcol1 [label="first_columns_id_exists"]; |
||
125 | "joins_clauses":rtcol4 -> "columns":ltcol1 [label="second_columns_id_exists"]; |
||
126 | "joins_clauses":rtcol6 -> "sql_operators":ltcol1 [label="sql_operators_id_exists"]; |
||
127 | "joins_clauses":rtcol7 -> "logic_operators":ltcol1 [label="logic_operators_id_exists"]; |
||
128 | "large_objects":rtcol4 -> "content_types":ltcol1 [label="content_types_id_exists"]; |
||
129 | "layouts_properties":rtcol2 -> "layouts":ltcol1 [label="layouts_id_exists"]; |
||
130 | "link_properties":rtcol2 -> "query_views":ltcol1 [label="query_views_id_exists"]; |
||
131 | "link_properties":rtcol3 -> "link_types":ltcol1 [label="link_types_id_exists"]; |
||
132 | "links":rtcol4 -> "query_views":ltcol1 [label="destination_query_views_id_exists"]; |
||
133 | "links":rtcol5 -> "query_views":ltcol1 [label="source_query_views_id_exists"]; |
||
134 | "links_clauses":rtcol2 -> "links":ltcol1 [label="links_id_exists"]; |
||
135 | "links_clauses":rtcol3 -> "columns":ltcol1 [label="first_columns_id_exists"]; |
||
136 | "links_clauses":rtcol4 -> "columns":ltcol1 [label="second_columns_id_exists"]; |
||
137 | "links_clauses":rtcol6 -> "sql_operators":ltcol1 [label="sql_operators_id_exists"]; |
||
138 | "links_clauses":rtcol7 -> "logic_operators":ltcol1 [label="logic_operators_id_exists"]; |
||
139 | "queries":rtcol4 -> "connections":ltcol1 [label="connections_id_exists"]; |
||
140 | "queries":rtcol7 -> "relations":ltcol1 [label="primary_relations_id_exists"]; |
||
141 | "query_views":rtcol4 -> "queries":ltcol1 [label="queries_id_exists"]; |
||
142 | "query_views":rtcol5 -> "layouts":ltcol1 [label="layouts_id_exists"]; |
||
143 | "query_views":rtcol6 -> "menus":ltcol1 [label="menus_id_exists"]; |
||
144 | "query_views_layouts_properties":rtcol2 -> "query_views":ltcol1 [label="query_views_id_exists"]; |
||
145 | "query_views_layouts_properties":rtcol3 -> "layouts_properties":ltcol1 [label="layouts_properties_id_exists"]; |
||
146 | "query_views_roles":rtcol1 -> "query_views":ltcol1 [label="query_views_id_exists"]; |
||
147 | "query_views_roles":rtcol2 -> "roles":ltcol1 [label="roles_id_exists"]; |
||
148 | "record_large_objects":rtcol3 -> "lo_relations":ltcol1 [label="lo_relations_id_exists"]; |
||
149 | "record_large_objects":rtcol4 -> "large_objects":ltcol1 [label="large_objects_id_exists"]; |
||
150 | "relations":rtcol2 -> "queries":ltcol1 [label="queries_id_exists"]; |
||
151 | "roles_permissions":rtcol1 -> "roles":ltcol1 [label="roles_id_exists"]; |
||
152 | "roles_permissions":rtcol2 -> "permissions":ltcol1 [label="permissions_id_exists"]; |
||
153 | "sessions":rtcol2 -> "users":ltcol1 [label="users_id_exists"]; |
||
154 | "sort_order":rtcol2 -> "columns":ltcol1 [label=""]; |
||
155 | "users_roles":rtcol1 -> "users":ltcol1 [label="users_id_exists"]; |
||
156 | "users_roles":rtcol2 -> "roles":ltcol1 [label="roles_id_exists"]; |
||
157 | "where_clauses":rtcol2 -> "queries":ltcol1 [label="queries_id_exists"]; |
||
158 | "where_clauses":rtcol3 -> "columns":ltcol1 [label="first_columns_id_exists"]; |
||
159 | "where_clauses":rtcol4 -> "columns":ltcol1 [label="second_columns_id_exists"]; |
||
160 | "where_clauses":rtcol6 -> "sql_operators":ltcol1 [label="sql_operators_id_exists"]; |
||
161 | "where_clauses":rtcol7 -> "logic_operators":ltcol1 [label="logic_operators_id_exists"]; |
||
162 | } |
||
163 | |||
164 | }}} |