lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README | LICENSE

0003_gcs_location.up.sql (744B)

      1 CREATE TABLE IF NOT EXISTS gcs_location (
      2     id CHAR(36) PRIMARY KEY NOT NULL UNIQUE CHECK(length(id) = 36),
      3     created_at DATETIME NOT NULL CHECK(length(created_at) = 24),
      4     updated_at DATETIME NOT NULL CHECK(length(updated_at) = 24),
      5     d_tag TEXT NOT NULL,
      6     lat REAL NOT NULL,
      7     lng REAL NOT NULL,
      8     geohash TEXT NOT NULL,
      9     point TEXT NOT NULL,
     10     polygon TEXT NOT NULL,
     11     accuracy REAL,
     12     altitude REAL,
     13     tag_0 TEXT,
     14     label TEXT,
     15     area REAL,
     16     elevation INTEGER,
     17     soil TEXT,
     18     climate TEXT,
     19     gc_id TEXT,
     20     gc_name TEXT,
     21     gc_admin1_id TEXT,
     22     gc_admin1_name TEXT,
     23     gc_country_id TEXT,
     24     gc_country_name TEXT
     25 );
     26 
     27 CREATE INDEX IF NOT EXISTS gcs_location_geohash_idx ON gcs_location(geohash);