tsunami

log in
history

tsunami data structure: Item

Luke Breuer
2009-02-01 18:26 UTC

full table
create table Item (
    item_pk                 int               identity primary key,
    name                    nvarchar(100)     not null,
    description             nvarchar(200)         null,              -- unused
    summary                 nvarchar(2000)        null,              -- unused
    keywords                nvarchar(1000)        null,
    data                    ntext                 null,
    is_common_predicate     bit               not null default (0),  -- unused
    weight                  tinyint           not null default (0),  -- unused
    subject_item_fk         int               not null default (0),
    predicate_item_fk       int               not null default (0),
    object_item_fk          int               not null default (0),
    responsible_person_fk   int               not null default (0),  -- unused
    select_bitmap_0         int               not null default (0),  -- obsolete
    update_bitmap_0         int               not null default (0),  -- obsolete
    record_fk               int               not null default (0),  -- unused
    record_source_fk        int               not null default (0),  -- unused
    version                 timestamp         not null,              -- unused
    locked_by               nvarchar(50)          null,              -- unused
    input_person_fk         int               not null,
    input_date              smalldatetime     not null default getdate(),
    update_person_fk        int                   null,
    update_date             smalldatetime         null,
    update_count            int               not null default (0),
) 
columns in use
create table Item (
    item_pk                 int               identity primary key,
    name                    nvarchar(100)     not null,
    keywords                nvarchar(1000)        null,
    data                    ntext                 null,
    subject_item_fk         int               not null default (0),
    predicate_item_fk       int               not null default (0),
    object_item_fk          int               not null default (0),
    input_person_fk         int               not null,
    input_date              smalldatetime     not null default getdate(),
    update_person_fk        int                   null,
    update_date             smalldatetime         null,
    update_count            int               not null default (0),
)