18 lines
520 B
SQL
18 lines
520 B
SQL
CREATE TABLE nshift_events (
|
|
id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
|
inserted TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
|
|
webhook TEXT,
|
|
order_number TEXT,
|
|
number TEXT,
|
|
package_number TEXT,
|
|
carrier_name TEXT,
|
|
product_name TEXT,
|
|
event_date TIMESTAMP WITH TIME ZONE,
|
|
event_status_text TEXT,
|
|
normalized_status_id TEXT,
|
|
submit_date TIMESTAMP WITH TIME ZONE,
|
|
lines_summed_weights TEXT,
|
|
volume_cm TEXT,
|
|
number_of_packages TEXT,
|
|
custom_field1 TEXT
|
|
); |