Project

General

Profile

« Previous | Next » 

Revision 642

vegbien.sql: Added comments to specimen.collectioncode_dwc and collectionnumber to differentiate them

View differences:

schemas/vegbien.for_ERD.my.sql
282 282
(
283 283
  specimen_id int(11) NOT NULL AUTO_INCREMENT,
284 284
  reference_id int(11) NOT NULL,
285
  collectioncode_dwc character varying(255),
285
  collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
286 286
  catalognumber_dwc character varying(255),
287 287
  collectiondate timestamp NULL,
288 288
  museum_id int(11),
......
290 290
  accessioncode character varying(255),
291 291
  taxonoccurrence_id int(11) NOT NULL,
292 292
  verbatimcollectorname character varying(255),
293
  collectionnumber character varying(255),
293
  collectionnumber character varying(255), -- The number of the specimen within the collection.
294 294
  CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
295 295
  CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
296 296
      REFERENCES party (party_id) MATCH SIMPLE
schemas/vegbien.for_wiki.sql
95 95
(
96 96
  specimen_id serial NOT NULL,
97 97
  reference_id integer NOT NULL,
98
  collectioncode_dwc character varying(255),
98
  collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
99 99
  catalognumber_dwc character varying(255),
100 100
  collectiondate timestamp with time zone,
101 101
  museum_id integer,
......
103 103
  accessioncode character varying(255),
104 104
  taxonoccurrence_id integer NOT NULL,
105 105
  verbatimcollectorname character varying(255),
106
  collectionnumber character varying(255),
106
  collectionnumber character varying(255), -- The number of the specimen within the collection.
107 107
);
108 108

  
109 109
CREATE TABLE voucher
schemas/vegbien.for_ERD.sql
282 282
(
283 283
  specimen_id serial NOT NULL,
284 284
  reference_id integer NOT NULL,
285
  collectioncode_dwc character varying(255),
285
  collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
286 286
  catalognumber_dwc character varying(255),
287 287
  collectiondate timestamp with time zone,
288 288
  museum_id integer,
......
290 290
  accessioncode character varying(255),
291 291
  taxonoccurrence_id integer NOT NULL,
292 292
  verbatimcollectorname character varying(255),
293
  collectionnumber character varying(255),
293
  collectionnumber character varying(255), -- The number of the specimen within the collection.
294 294
  CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
295 295
  CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
296 296
      REFERENCES party (party_id) MATCH SIMPLE
schemas/vegbien.sql
2285 2285

  
2286 2286

  
2287 2287
--
2288
-- Name: COLUMN specimen.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2289
--
2290

  
2291
COMMENT ON COLUMN specimen.collectioncode_dwc IS 'The code for the collection that the specimen is from.';
2292

  
2293

  
2294
--
2295
-- Name: COLUMN specimen.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2296
--
2297

  
2298
COMMENT ON COLUMN specimen.collectionnumber IS 'The number of the specimen within the collection.';
2299

  
2300

  
2301
--
2288 2302
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2289 2303
--
2290 2304

  

Also available in: Unified diff