Difference between revisions of "Talk:Fgdb tables"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | Wondering about this | + | 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 ( | 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. | ||
+ | |||
+ | [[User:Rfs|RfS]] 17:34, 23 June 2007 (PDT) |
Revision as of 17:34, 23 June 2007
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)