Difference between revisions of "FGdb Tables"
Jump to navigation
Jump to search
(Update to more recent schema) |
|||
| Line 15: | Line 15: | ||
]; | ]; | ||
| − | " | + | "community_service_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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD | ||
| + | align="left" > hours_multiplier </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > lock_ | ||
| + | version </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" > updated_at </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" > created_at </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>> ]; | ||
| − | " | + | "contact_method_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" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></T | ||
| + | D><TD align="left" > description </TD><TD align="left" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD al | ||
| + | ign="left" > parent_id </TD><TD align="left" > integer </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" > lock_versi | ||
| + | on </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" > updated_at </TD><TD align="left" | ||
| + | > timestamp with 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" > created_at </TD><TD align="left" > time | ||
| + | stamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "contact_methods" [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" > serial </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" > contact_method_type_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="le | ||
| + | ft" > description </TD><TD align="left" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > ok | ||
| + | </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" > contact_id </TD><TD align="left" > | ||
| + | integer </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" > lock_version </TD><TD align="left" > integer </TD><TD al | ||
| + | ign="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </TD><TD align="le | ||
| + | ft" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > | ||
| + | </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "contact_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> <T |
| + | R><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD a | ||
| + | lign="left" > description </TD><TD align="left" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="le | ||
| + | ft" > for_who </TD><TD align="left" > character varying(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > lock_ver | ||
| + | sion </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" > updated_at </TD><TD align="lef | ||
| + | t" > timestamp with 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" > created_at </TD><TD align="left" > ti | ||
| + | mestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "contact_types_contacts" [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" > contact_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltc | ||
| + | ol2" ></TD><TD align="left" > contact_type_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "contacts" [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" > serial </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" > is_organization </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > sort_name | ||
| + | </TD><TD align="left" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > first_name </TD><TD a | ||
| + | lign="left" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > middle_name </TD><TD align="lef | ||
| + | t" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > surname </TD><TD align="left" > characte | ||
| + | r varying(50) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > organization </TD><TD align="left" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > extra_address </TD><TD align="left" > character varying(52) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > address </TD><TD align="left" > character varying(52) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > city </TD><TD align="left" > character varying(30) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > state_or_province </TD><TD align="left" > character varying(15) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > postal_code </TD><TD align="left" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > country </TD><TD align="left" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > user_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > created_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > updated_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "defaults" [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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > value </TD><TD align="left" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > lock_version </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" > updated_at </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" > created_at </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>> ]; |
| − | " | + | "disbursement_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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp without time zone </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_at </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>> ]; |
| − | " | + | "disbursements" [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" > serial </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" > comments </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" > contact_id </TD><TD align="left" > integer </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" > disbursement_type_id </TD><TD align="left" > integer </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > updated_at </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" > created_at </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > disbursed_at </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; |
| − | " | + | "discount_schedules" [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" > serial </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" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </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_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
| − | " | + | "discount_schedules_gizmo_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" > serial </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" > gizmo_type_id </TD><TD align="left" > integer </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" > discount_schedule_id </TD><TD align="left" > integer </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" > multiplier </TD><TD align="left" > numeric(10,3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ]; |
| + | |||
| + | "donations" [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" > serial </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" > contact_id </TD><TD align="left" > integer </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" > postal_code </TD><TD align="left" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > txn_complete </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" > txn_completed_at </TD><TD align="left" > timestamp with 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" > comments </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with time zone </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_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > updated_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > reported_required_fee_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > reported_suggested_fee_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ]; | ||
"engine_schema_info" [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" > engine_name </TD><TD align="left" > character varying(255) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; | "engine_schema_info" [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" > engine_name </TD><TD align="left" > character varying(255) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; | ||
| − | "gizmo_attrs" [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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > datatype </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > lock_version </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" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT=" | + | "gizmo_attrs" [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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > datatype </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > lock_version </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" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ]; |
| + | |||
| + | "gizmo_contexts" [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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </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_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "gizmo_contexts_gizmo_typeattrs" [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" > gizmo_context_id </TD><TD align="left" > integer </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" > gizmo_typeattr_id </TD><TD align="left" > integer </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </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_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
| − | " | + | "gizmo_contexts_gizmo_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" > gizmo_context_id </TD><TD align="left" > integer </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" > gizmo_type_id </TD><TD align="left" > integer </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </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_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
| − | " | + | "gizmo_events" [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" > serial </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" > donation_id </TD><TD align="left" > integer </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" > sale_id </TD><TD align="left" > integer </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" > disbursement_id </TD><TD align="left" > integer </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" > recycling_id </TD><TD align="left" > integer </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" > gizmo_type_id </TD><TD align="left" > integer </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" > gizmo_context_id </TD><TD align="left" > integer </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" > gizmo_count </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </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_at </TD><TD align="left" > timestamp with 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" > occurred_at </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > adjusted_fee_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ]; |
| − | " | + | "gizmo_events_gizmo_typeattrs" [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" > serial </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" > gizmo_event_id </TD><TD align="left" > integer </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" > gizmo_typeattr_id </TD><TD align="left" > integer </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" > attr_val_text </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" > attr_val_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" > attr_val_integer </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > attr_val_monetary_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> </TABLE>> ]; |
| − | " | + | "gizmo_typeattrs" [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" > serial </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" > gizmo_type_id </TD><TD align="left" > integer </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" > gizmo_attr_id </TD><TD align="left" > integer </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" > is_required </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" > validation_callback </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; |
| − | " | + | "gizmo_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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parent_id </TD><TD align="left" > integer </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" > lock_version </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" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with 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" > required_fee_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > suggested_fee_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; |
| − | " | + | "payment_methods" [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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </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_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ]; |
| − | " | + | "payments" [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" > serial </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" > donation_id </TD><TD align="left" > integer </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" > sale_id </TD><TD align="left" > integer </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" > payment_method_id </TD><TD align="left" > integer </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > amount_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; |
| − | " | + | "recyclings" [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" > serial </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" > comments </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp without time zone </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_at </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" > recycled_at </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>> ]; |
| − | " | + | "revision_records" [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" > serial </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" > revisionable_type </TD><TD align="left" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > revisionable_id </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" > revision </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" > data </TD><TD align="left" > bytea </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_at </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>> ]; |
"rfs_high_sales" [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" > contact_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > reported_discount_amount </TD><TD align="left" > numeric(10,2) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > open_window </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > close_window </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > first_name </TD><TD align="left" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > surname </TD><TD align="left" > character varying(50) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > hours_worked </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > discount_taken </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; | "rfs_high_sales" [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" > contact_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > reported_discount_amount </TD><TD align="left" > numeric(10,2) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > open_window </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > close_window </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > first_name </TD><TD align="left" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > surname </TD><TD align="left" > character varying(50) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > hours_worked </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > discount_taken </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; | ||
| Line 73: | Line 111: | ||
"rfs_volunteer_hours_worked" [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" > contact_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > hours_worked </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; | "rfs_volunteer_hours_worked" [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" > contact_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > hours_worked </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "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" > serial </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" > character varying(40) </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_at </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" > updated_at </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>> ]; |
| + | |||
| + | "roles_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" > user_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > role_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; | ||
| + | |||
| + | "sales" [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" > serial </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" > contact_id </TD><TD align="left" > integer </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" > postal_code </TD><TD align="left" > character varying(25) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > txn_complete </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" > txn_completed_at </TD><TD align="left" > timestamp with 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" > discount_schedule_id </TD><TD align="left" > integer </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" > comments </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" > bulk </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </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_at </TD><TD align="left" > timestamp with 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" > created_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > updated_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > reported_discount_amount_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > reported_amount_due_cents </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> </TABLE>> ]; | ||
"schema_info" [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" > version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> </TABLE>> ]; | "schema_info" [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" > version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> </TABLE>> ]; | ||
| − | " | + | "trash_records" [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" > serial </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" > trashable_type </TD><TD align="left" > character varying(255) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > trashable_id </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" > data </TD><TD align="left" > bytea </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_at </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>> ]; |
| − | " | + | "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" > serial </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" > login </TD><TD align="left" > character varying(255) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > email </TD><TD align="left" > character varying(255) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > crypted_password </TD><TD align="left" > character varying(40) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > salt </TD><TD align="left" > character varying(40) </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_at </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" > updated_at </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > remember_token </TD><TD align="left" > character varying(255) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > remember_token_expires_at </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > contact_id </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > created_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > updated_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> </TABLE>> ]; |
| − | " | + | "volunteer_hours_worked" [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" > contact_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > hours_worked </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ]; |
| − | |||
| − | |||
| + | "volunteer_task_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" > serial </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" > character varying(100) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parent_id </TD><TD align="left" > integer </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" > hours_multiplier </TD><TD align="left" > numeric(10,3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > instantiable </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" > lock_version </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > updated_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > created_at </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ]; | ||
| + | "volunteer_tasks" [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" > serial </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" > contact_id </TD><TD align="left" > integer </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" > duration </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > lock_version </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" > updated_at </TD><TD align="left" > timestamp with 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" > created_at </TD><TD align="left" > timestamp with 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" > community_service_type_id </TD><TD align="left" > integer </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" > volunteer_task_type_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > date_performed </TD><TD align="left" > date </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_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > updated_by </TD><TD align="left" > bigint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> </TABLE>> ]; | ||
| − | "contact_methods":rtcol2 -> "contact_method_types":ltcol1 [label=" | + | "contact_method_types":rtcol3 -> "contact_method_types":ltcol1 [label="contact_method_types_parent_id_fk"]; |
| − | "contact_methods":rtcol5 -> "contacts":ltcol1 [label=" | + | "contact_methods":rtcol2 -> "contact_method_types":ltcol1 [label="contact_methods_contact_method_type_fk"]; |
| − | "disbursements":rtcol3 -> "contacts":ltcol1 [label=" | + | "contact_methods":rtcol5 -> "contacts":ltcol1 [label="contact_methods_contact_id_fk"]; |
| − | "disbursements":rtcol4 -> "disbursement_types":ltcol1 [label=" | + | "contact_types_contacts":rtcol1 -> "contacts":ltcol1 [label="contact_types_contacts_contacts_fk"]; |
| + | "contact_types_contacts":rtcol2 -> "contact_types":ltcol1 [label="contact_types_contacts_contact_types_contacts_fk"]; | ||
| + | "contacts":rtcol18 -> "users":ltcol1 [label="contacts_users_fk"]; | ||
| + | "disbursements":rtcol3 -> "contacts":ltcol1 [label="disbursements_contact_id_fkey"]; | ||
| + | "disbursements":rtcol3 -> "contacts":ltcol1 [label="disbursements_contacts_fk"]; | ||
| + | "disbursements":rtcol4 -> "disbursement_types":ltcol1 [label="disbursements_disbursement_type_id_fkey"]; | ||
| + | "disbursements":rtcol4 -> "disbursement_types":ltcol1 [label="disbursements_disbursements_type_id_fk"]; | ||
| + | "discount_schedules_gizmo_types":rtcol2 -> "gizmo_types":ltcol1 [label="discount_schedules_gizmo_types_gizmo_types_fk"]; | ||
| + | "discount_schedules_gizmo_types":rtcol3 -> "discount_schedules":ltcol1 [label="discount_schedules_gizmo_types_discount_schedules_fk"]; | ||
| + | "donations":rtcol2 -> "contacts":ltcol1 [label="donations_contacts_fk"]; | ||
| + | "gizmo_contexts_gizmo_typeattrs":rtcol1 -> "gizmo_contexts":ltcol1 [label="gizmo_contexts_gizmo_typeattrs_gizmo_contexts_fk"]; | ||
| + | "gizmo_contexts_gizmo_typeattrs":rtcol2 -> "gizmo_typeattrs":ltcol1 [label="gizmo_contexts_gizmo_typeattrs_gizmo_typeattrs_fk"]; | ||
| + | "gizmo_contexts_gizmo_types":rtcol1 -> "gizmo_contexts":ltcol1 [label="gizmo_contexts_gizmo_types_gizmo_contexts_fk"]; | ||
| + | "gizmo_contexts_gizmo_types":rtcol2 -> "gizmo_types":ltcol1 [label="gizmo_contexts_gizmo_types_gizmo_types_fk"]; | ||
| + | "gizmo_events":rtcol2 -> "donations":ltcol1 [label="gizmo_events_donations_fk"]; | ||
| + | "gizmo_events":rtcol3 -> "sales":ltcol1 [label="gizmo_events_sales_fk"]; | ||
| + | "gizmo_events":rtcol4 -> "disbursements":ltcol1 [label="gizmo_events_disbursements_fk"]; | ||
| + | "gizmo_events":rtcol5 -> "recyclings":ltcol1 [label="gizmo_events_recyclings_fk"]; | ||
| + | "gizmo_events":rtcol6 -> "gizmo_types":ltcol1 [label="gizmo_events_gizmo_types_fk"]; | ||
| + | "gizmo_events":rtcol7 -> "gizmo_contexts":ltcol1 [label="gizmo_events_gizmo_contexts_fk"]; | ||
| + | "gizmo_events_gizmo_typeattrs":rtcol2 -> "gizmo_events":ltcol1 [label="gizmo_events_gizmo_typeattrs_gizmo_events_fk"]; | ||
| + | "gizmo_events_gizmo_typeattrs":rtcol3 -> "gizmo_typeattrs":ltcol1 [label="gizmo_events_gizmo_typeattrs_gizmo_typeattrs_fk"]; | ||
| + | "gizmo_typeattrs":rtcol2 -> "gizmo_types":ltcol1 [label="gizmo_typeattrs_gizmo_types_fk"]; | ||
| + | "gizmo_typeattrs":rtcol3 -> "gizmo_attrs":ltcol1 [label="gizmo_typeattrs_gizmo_attrs_fk"]; | ||
| + | "gizmo_types":rtcol3 -> "gizmo_types":ltcol1 [label="gizmo_types_parent_fk"]; | ||
| + | "payments":rtcol2 -> "donations":ltcol1 [label="payments_donation_id_fk"]; | ||
"payments":rtcol2 -> "donations":ltcol1 [label="payments_donation_id_fkey"]; | "payments":rtcol2 -> "donations":ltcol1 [label="payments_donation_id_fkey"]; | ||
| + | "payments":rtcol3 -> "sales":ltcol1 [label="payments_sale_id_fk"]; | ||
"payments":rtcol3 -> "sales":ltcol1 [label="payments_sale_txn_id_fkey"]; | "payments":rtcol3 -> "sales":ltcol1 [label="payments_sale_txn_id_fkey"]; | ||
| + | "payments":rtcol4 -> "payment_methods":ltcol1 [label="payments_payment_methods_fk"]; | ||
| + | "roles_users":rtcol1 -> "users":ltcol1 [label="roles_users_user_id_fkey"]; | ||
| + | "roles_users":rtcol2 -> "roles":ltcol1 [label="roles_users_role_id_fkey"]; | ||
| + | "sales":rtcol2 -> "contacts":ltcol1 [label="sales_contacts_fk"]; | ||
| + | "sales":rtcol6 -> "discount_schedules":ltcol1 [label="sales_discount_schedules_fk"]; | ||
| + | "users":rtcol10 -> "contacts":ltcol1 [label="users_contacts_fk"]; | ||
| + | "volunteer_task_types":rtcol3 -> "volunteer_task_types":ltcol1 [label="volunteer_task_types_parent_fk"]; | ||
| + | "volunteer_tasks":rtcol2 -> "contacts":ltcol1 [label="volunteer_tasks_contacts_fk"]; | ||
| + | "volunteer_tasks":rtcol7 -> "community_service_types":ltcol1 [label="volunteer_tasks_community_service_type_id_fkey"]; | ||
| + | "volunteer_tasks":rtcol8 -> "volunteer_task_types":ltcol1 [label="volunteer_tasks_volunteer_task_type_id_fk"]; | ||
} | } | ||
</graphviz> | </graphviz> | ||
[[Category: Coders]] | [[Category: Coders]] | ||
Revision as of 22:55, 21 April 2008
This chart was auto-generated using the postgresql-autodoc package and then wrapped in the wiki graphviz tags.
