WACS: Database Schemas

Database Schemas: Contents

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

Assoc Table

This is the assoc 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 assoc 
( assocno			number(9) primary key,
  amodelno			number(6) references models,
  asetno			number(9) references sets,
  astatus			char(1),
  aadded                        date,
  aamended                      date
);

Defined Values For The Assoc Table

Values For Short Fields In Assoc Table
astatus	M	Manually Added
	G	Generated Automatically
	R	Relationship entry - not the primary model for this set.

Previous Schema: IDmap Next Schema: Download
Back to Schema Overview Next Section: Futures
Back to WACS Documentation Index