User Tools

Site Tools


podoc:support_type_sql_table

Database Table Description of "support_type"

Name

support_type

Description

Purpose

Schema

create table support_type (
  identifier            integer not null primary key,
  manufacturer          integer not null references manufacturer(identifier),
  model                 varchar(100),
  variation             varchar(100),
  last_modified_date    timestamp,
  last_modifying_users  integer references users(identifier)
);

References tables

  • last_modifying_users references users(identifier)
  • manufacturer references manufacturer(identifier)

Is referenced by tables

  • support(type) references identifier

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

create table support_type (
  identifier            integer not null primary key,
  manufacturer          integer not null references manufacturer(identifier),
  model                 varchar(100),
  variation             varchar(100),
  last_modified_date    timestamp,
  last_modifying_users  integer references users(identifier)
);
podoc/support_type_sql_table.txt · Last modified: 2007/04/20 11:23 by Luud