Talk:Fgdb tables
Jump to navigation
Jump to search
Wondering about this:
CREATE TABLE relationship_types ( id serial NOT NULL, description character varying(100), direction_matters boolean, lock_version integer DEFAULT 0 NOT NULL, updated_at timestamp with time zone DEFAULT now(), created_at timestamp with time zone DEFAULT now(), created_by bigint DEFAULT 1 NOT NULL, updated_by bigint DEFAULT 1 NOT NULL ); COMMENT ON TABLE relationship_types IS 'abstract type of relationships that can exist between contacts, i.e. sibling, parent-child, spouse, employer-employee'; CREATE TABLE relationships ( id serial NOT NULL, source_id integer, sink_id integer, flow integer, relationship_type_id integer, lock_version integer DEFAULT 0 NOT NULL, updated_at timestamp with time zone DEFAULT now(), created_at timestamp with time zone DEFAULT now(), created_by bigint DEFAULT 1 NOT NULL, updated_by bigint DEFAULT 1 NOT NULL ); COMMENT ON TABLE relationships IS 'actual relationship between two contacts';
Probably should be dropped unless we intend to use them.
RfS 17:34, 23 June 2007 (PDT)