Revision 1021
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1024 | 1024 |
latitude double precision, |
| 1025 | 1025 |
longitude double precision, |
| 1026 | 1026 |
coordsaccuracy double precision, |
| 1027 |
footprintgeometry_dwc text |
|
| 1027 |
footprintgeometry_dwc text, |
|
| 1028 |
isoriginal int(1) DEFAULT false NOT NULL, |
|
| 1029 |
iscurrent int(1) DEFAULT false NOT NULL, |
|
| 1030 |
determinationdate timestamp NULL |
|
| 1028 | 1031 |
); |
| 1029 | 1032 |
|
| 1030 | 1033 |
|
| 1031 | 1034 |
-- |
| 1035 |
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: - |
|
| 1036 |
-- |
|
| 1037 |
|
|
| 1038 |
|
|
| 1039 |
|
|
| 1040 |
|
|
| 1041 |
-- |
|
| 1032 | 1042 |
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - |
| 1033 | 1043 |
-- |
| 1034 | 1044 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1193 | 1193 |
latitude double precision, |
| 1194 | 1194 |
longitude double precision, |
| 1195 | 1195 |
coordsaccuracy double precision, |
| 1196 |
footprintgeometry_dwc text |
|
| 1196 |
footprintgeometry_dwc text, |
|
| 1197 |
isoriginal boolean DEFAULT false NOT NULL, |
|
| 1198 |
iscurrent boolean DEFAULT false NOT NULL, |
|
| 1199 |
determinationdate timestamp with time zone |
|
| 1197 | 1200 |
); |
| 1198 | 1201 |
|
| 1199 | 1202 |
|
| 1200 | 1203 |
-- |
| 1204 |
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: - |
|
| 1205 |
-- |
|
| 1206 |
|
|
| 1207 |
COMMENT ON TABLE locationdetermination IS 'VegBank''s place table.'; |
|
| 1208 |
|
|
| 1209 |
|
|
| 1210 |
-- |
|
| 1201 | 1211 |
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - |
| 1202 | 1212 |
-- |
| 1203 | 1213 |
|
Also available in: Unified diff
vegbien.sql: locationdetermination: Added determination status columns from taxondetermination