Talk:Fgdb tables - Revision history

Rfs: /* Useful SQL snippets */

2007-06-27T16:58:53Z

Useful SQL snippets

Rfs: /* Amount of volunteer hours worked over time */

2007-06-27T16:55:58Z

Amount of volunteer hours worked over time

Rfs: /* Useful SQL snippets */

2007-06-27T16:53:29Z

Useful SQL snippets

Rfs: /* Useful SQL snippets */

2007-06-27T16:30:39Z

Useful SQL snippets

Rfs: /* Useful SQL snippets */

2007-06-27T00:46:14Z

Useful SQL snippets

Rfs at 00:37, 24 June 2007

2007-06-24T00:37:56Z

Show changes

Rfs at 00:34, 24 June 2007

2007-06-24T00:34:32Z

Rfs at 00:03, 24 June 2007

2007-06-24T00:03:08Z

Rfs at 23:41, 23 June 2007

2007-06-23T23:41:59Z

New page

CREATE TABLE contact_method_types (
parent_id integer,
CREATE TABLE contact_methods (
contact_method_type_id integer,
contact_id integer,
CREATE TABLE contact_types (
CREATE TABLE contact_types_contacts (
contact_id integer DEFAULT 0 NOT NULL,
contact_type_id integer DEFAULT 0 NOT NULL
CREATE TABLE contacts (
CREATE TABLE "defaults" (
CREATE TABLE discount_schedules (
CREATE TABLE discount_schedules_gizmo_types (
gizmo_type_id integer NOT NULL,
discount_schedule_id integer NOT NULL,
CREATE TABLE dispersement_types (
CREATE TABLE dispersements (
contact_id integer NOT NULL,
dispersement_type_id integer NOT NULL,
CREATE TABLE donations (
contact_id integer,
CREATE TABLE engine_schema_info (
CREATE TABLE gizmo_attrs (
CREATE TABLE gizmo_contexts (
CREATE TABLE gizmo_contexts_gizmo_typeattrs (
gizmo_context_id integer NOT NULL,
gizmo_typeattr_id integer NOT NULL,
CREATE TABLE gizmo_contexts_gizmo_types (
gizmo_context_id integer NOT NULL,
gizmo_type_id integer NOT NULL,
CREATE TABLE gizmo_events (
donation_id integer,
sale_id integer,
dispersement_id integer,
recycling_id integer,
gizmo_type_id integer NOT NULL,
gizmo_context_id integer NOT NULL,
CREATE TABLE gizmo_events_gizmo_typeattrs (
gizmo_event_id integer NOT NULL,
gizmo_typeattr_id integer NOT NULL,
CREATE TABLE gizmo_typeattrs (
gizmo_type_id integer NOT NULL,
gizmo_attr_id integer NOT NULL,
CREATE TABLE gizmo_types (
parent_id integer,
CREATE TABLE payment_methods (
CREATE TABLE payments (
donation_id integer,
sale_id integer,
payment_method_id integer NOT NULL,
CREATE TABLE recyclings (
CREATE TABLE relationship_types (
CREATE TABLE relationships (
source_id integer,
sink_id integer,
relationship_type_id integer,
CREATE TABLE rfs_high_sales (
contact_id integer,
CREATE TABLE rfs_high_sales_summary (
contact_id integer,
CREATE TABLE rfs_sales_violations (
contact_id integer,
CREATE TABLE rfs_sales_violations_summary (
contact_id integer,
CREATE TABLE rfs_total_discount_taken (
contact_id integer,
CREATE TABLE rfs_volunteer_hours_worked (
contact_id integer,
CREATE TABLE sales (
contact_id integer,
discount_schedule_id integer,
CREATE TABLE schema_info (
CREATE TABLE volunteer_hours_worked (
contact_id integer,
CREATE TABLE volunteer_task_types (
parent_id integer,
CREATE TABLE volunteer_task_types_volunteer_tasks (
volunteer_task_id integer NOT NULL,
volunteer_task_type_id integer NOT NULL
CREATE TABLE volunteer_tasks (
contact_id integer,

@@ Line 1: / Line 1: @@
 == Useful SQL snippets ==
 Here is where to put things that might be useful to cut and paste into scripts that could be modified as needed for ad hoc reporting.
 === Count of volunteers worked over time ===
@@ Line 20: / Line 12: @@
    GROUP BY 1, 2
    ORDER BY 1, 2 ;
 === Amount of volunteer hours worked over time ===
@@ Line 50: / Line 51: @@
    HAVING SUM(volunteer_tasks.duration) > 1000
    ORDER BY 4 DESC ;
 == Basic SQL for table creation ==

@@ Line 9: / Line 9: @@
 * Amount of volunteer hours worked by job in a given month (or another specific time period)
 ** same but over time, each month or each year
 === Amount of volunteer hours worked over time ===

@@ Line 4: / Line 4: @@
 Needed:
 * Number of volunteers logging in a given month (or another specific time period)
 ** same but over time, each month or each year
 * Amount of volunteer hours worked by job in a given month (or another specific time period)
 ** same but over time, each month or each year
 === All volunteers that have accumulated more than X hours ===

@@ Line 3: / Line 3: @@
 Needed:
 * Number of volunteers logging in a given month (or another specific time period)
 ** same but over time, each month or each year
@@ Line 10: / Line 9: @@
 * Number of computer received in a given month (or another specific time period)
 ** same but over time, each month or each year
 == Basic SQL for table creation ==

@@ Line 4: / Line 4: @@
 Needed:
 * All volunteers that have accumulated more than X hours
 == Basic SQL for table creation ==

@@ Line 1: / Line 1: @@
-Wondering about this one:
+Wondering about this:
   CREATE TABLE relationships (
-    source_id integer,
+     id serial NOT NULL,
-    sink_id integer,
+     source_id integer,
-    relationship_type_id integer,
+     sink_id integer,