Difference between revisions of "Talk:Fgdb tables"

Revision as of 17:03, 23 June 2007

Wondering about this one:

CREATE TABLE relationships (
   source_id integer,
   sink_id integer,
   relationship_type_id integer,

@@ Line 1: / Line 1: @@
-CREATE TABLE contact_method_types (
+Wondering about this one:
-    parent_id integer,
-CREATE TABLE contact_methods (
+ CREATE TABLE relationships (
-    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,

Difference between revisions of "Talk:Fgdb tables"

Revision as of 17:03, 23 June 2007

Navigation menu

Search