Project

General

Profile

« Previous | Next » 

Revision 591

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Made taxondetermination.determinationdate optional because some determinations might not have a date

View differences:

schemas/vegbien.for_ERD.my.sql
318 318 
  notespublic int(1),
319 319 
  notesmgt int(1),
320 320 
  revisions int(1),
321 
  determinationdate timestamp NOT NULL,
321 
  determinationdate timestamp NULL,
322 322 
  emb_taxondetermination int(11),
323 323 
  accessioncode character varying(255),
324 324 
  CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id ),
schemas/vegbien.for_wiki.sql
133 133 
  notespublic boolean,
134 134 
  notesmgt boolean,
135 135 
  revisions boolean,
136 
  determinationdate timestamp with time zone NOT NULL,
136 
  determinationdate timestamp with time zone,
137 137 
  emb_taxondetermination integer,
138 138 
  accessioncode character varying(255),
139 139 
);
schemas/vegbien.for_ERD.sql
318 318 
  notespublic boolean,
319 319 
  notesmgt boolean,
320 320 
  revisions boolean,
321 
  determinationdate timestamp with time zone NOT NULL,
321 
  determinationdate timestamp with time zone,
322 322 
  emb_taxondetermination integer,
323 323 
  accessioncode character varying(255),
324 324 
  CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id ),
schemas/vegbien.sql
2532 2532 
    notespublic boolean,
2533 2533 
    notesmgt boolean,
2534 2534 
    revisions boolean,
2535 
    determinationdate timestamp with time zone NOT NULL,
2535 
    determinationdate timestamp with time zone,
2536 2536 
    emb_taxondetermination integer,
2537 2537 
    accessioncode character varying(255)
2538 2538 
);

Also available in: Unified diff