mig-sql/init/010_gsheet_tracking.sql

   1 CREATE TABLE gsheet_tracked_table (
   2     id                          SERIAL PRIMARY KEY
   3     ,table_name                 TEXT NOT NULL
   4     ,tab_name                   TEXT
   5     ,created                    TIMESTAMP
   6     ,last_pulled                TIMESTAMP
   7     ,last_pushed                TIMESTAMP
   8 );
   9
  10 CREATE TABLE gsheet_tracked_column (
  11     id               SERIAL
  12     ,table_id        INTEGER REFERENCES gsheet_tracked_table (id)
  13     ,column_name     TEXT NOT NULL
  14 );