Skip to content

Instantly share code, notes, and snippets.

@slawo-ch

slawo-ch/create_table_still.sql

Created November 2, 2019 21:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save slawo-ch/a000ff7b4e3c83decf3066bf045c2281 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save slawo-ch/a000ff7b4e3c83decf3066bf045c2281 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_table_still.sql
CREATE TABLE still (
still_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
sample_index BIGINT,
orientation varchar(20),
model varchar(200),
device varchar(200),
arrival_time NUMERIC(32,12),
sensor_time NUMERIC(32,12),
creation_time NUMERIC(32,12),
x NUMERIC(32,20),
y NUMERIC(32,20),
z NUMERIC(32,20)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment