record_metadata

15,268,363 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE [record_metadata] (
   [record_id] INTEGER PRIMARY KEY,
   [record_num] INTEGER,
   [record_type_code] TEXT,
   [creation_julianday] INTEGER,
   [record_last_updated_julianday] INTEGER,
   [deletion_julianday] INTEGER
);
CREATE INDEX [idx_record_metadata_record_id]
    ON [record_metadata] ([record_id]);
CREATE INDEX [idx_record_metadata_record_num]
    ON [record_metadata] ([record_num], [record_type_code]);
CREATE INDEX [idx_record_metadata_creation_julianday]
    ON [record_metadata] ([creation_julianday]);
CREATE INDEX [idx_record_metadata_record_last_updated_julianday]
    ON [record_metadata] ([record_last_updated_julianday]);
CREATE INDEX [idx_record_metadata_deletion_julianday]
    ON [record_metadata] ([deletion_julianday]);