WACS: Database Schemas

Database Schemas: Contents

Tag Table

This is the tag table - directly below is the sample SQL command to create it and below that details of the fixed values for each of the short fields.
create table tag
( tagno				number(9) primary key,
  tmodelno                      number(6) references models,
  tsetno                        number(9) references sets,
  tstatus			char(1),
  tflag				char(1),
  tgroup			number(6),
  tdesc				varchar2(40),
  towner			varchar2(20),
  texpiry			date,
  tadded			date,
  tamended			date 
);
 

Defined Values For The Tag Table

Values For Short Fields In Tag Table
tstatus T Temporary
PPermanent
tflag M Model-based tag entry
SSet-based tag entry

Previous Schema: Photographer  Next Schema: Vendor
Back to Schema Overview  Next Section: Futures
Back to WACS Documentation Index