Talk:Fgdb tables

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,