WACS: Database Schemas

Database Schemas: Contents

Sets Table
Models Table
Idmap Table
Assoc Table
Download Table
Photographer Table
Tag Table
- Table Definition
- Defined Values
Vendor Table
Conn (Connections) Table
Keyword Table

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
	V	Viewed, Temporary
	P	Permanent
	A	Archived
tflag	M	Model-based tag entry
tflag	S	Set-based tag entry

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