podoc:scanner_type_sql_table
Database Table Description of "scanner_type"
Name
scanner_type
Description
Purpose
Schema
CREATE TABLE scanner_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
- scanner(type) references identifier
Related sequences
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
CREATE TABLE scanner_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/scanner_type_sql_table.txt · Last modified: 2007/04/20 15:01 by Luud