Photo Organizer

support_type

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)
);

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

• support(type) references identifier

• support_type_id_sequence

• support_type_manufacturer_idx

• number_of_manufacturer_ref

• view_support_type
• view_support

Version 2.5

Still in use

= 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)
);