WACS: Database Schemas

Database Schemas: Contents

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

  Keyword Table

  This is the keyword 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 keyword ( kentryno number(9) primary key, kflag char(1), kword varchar(30) not null, kexclusions varchar(120), kiloc varchar(20), kiscore number(1), kicat char(1), kicscore number(1), kidet varchar(40), kidscore number(1), kiattr varchar(30), kiascore number(1), kiother varchar(40), kioscore number(1), knotes varchar(80), kadded date, kamended date );

  
  

  Defined Values For The Keyword Table

  Values For Short Fields In Keyword Table
  kflag	A	Applies to All Added
  	N	Not Active (Ignore)

  ---

  Previous Schema: Conn  No further schemas (yet)
  Back to Schema Overview  Next Section: Futures
  Back to WACS Documentation Index