java.lang.Object
- nzilbb.labbcat.server.db.SqlConstants

```
public class SqlConstants
extends Object
```
Constants relating to SQL annotation stores.

Author:

Robert Fromont robert@fromont.net.nz

Field Summary

Fields
Modifier and Type	Field	Description
`static int`	`LAYER_CORPUS`	Database Layer ID for corpora
`static int`	`LAYER_GRAPH`	Database Layer ID for graphs/transcripts
`static int`	`LAYER_MAIN_PARTICIPANT`	Database Layer ID for marking main participants in a transcript
`static int`	`LAYER_ORTHOGRAPHY`	Database Layer ID for orthography layer - i.e.
`static int`	`LAYER_PARTICIPANT`	Database Layer ID for participants
`static int`	`LAYER_SEGMENT`	Database Layer ID for segment layer - i.e.
`static int`	`LAYER_SERIES`	Database Layer ID for series
`static int`	`LAYER_TRANSCRIPTION`	Database Layer ID for raw transcription layer - i.e.
`static int`	`LAYER_TURN`	Database Layer ID for turn layer - i.e.
`static int`	`LAYER_UTTERANCE`	Database Layer ID for utterance layer - i.e.
`static String`	`SCOPE_EPISODE`	Scope for Episode layer - value is "e"
`static String`	`SCOPE_FREEFORM`	Scope for Freeform layers - value is "f"
`static String`	`SCOPE_META`	Scope for Meta layers - value is "m"
`static String`	`SCOPE_PARTICIPANT`	Scope for Participant layer - value is "p"
`static String`	`SCOPE_SEGMENT`	Scope for Segment layers - value is "s"
`static String`	`SCOPE_WORD`	Scope for Word layers - value is "w"

Constructor Summary

Constructors
Constructor Description

SqlConstants()

Method Summary
- Methods inherited from class java.lang.Object
  equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - LAYER_TRANSCRIPTION
```
public static final int LAYER_TRANSCRIPTION
```
    Database Layer ID for raw transcription layer - i.e. how the transcript was typed in Transcriber
    
    See Also:
    
    Constant Field Values
  - LAYER_SEGMENT
```
public static final int LAYER_SEGMENT
```
    Database Layer ID for segment layer - i.e. the components of each word (most likely phonemes)
    
    See Also:
    
    Constant Field Values
  - LAYER_ORTHOGRAPHY
```
public static final int LAYER_ORTHOGRAPHY
```
    Database Layer ID for orthography layer - i.e. the original text cleaned up to make standard spellings (if possible)
    
    See Also:
    
    Constant Field Values
  - LAYER_TURN
```
public static final int LAYER_TURN
```
    Database Layer ID for turn layer - i.e. the speaker turns originally marked in the transcript
    
    See Also:
    
    Constant Field Values
  - LAYER_UTTERANCE
```
public static final int LAYER_UTTERANCE
```
    Database Layer ID for utterance layer - i.e. the lines/chunks of the transcript as originally time aligned before upload (in Transcriber, the words between Sync points)
    
    See Also:
    
    Constant Field Values
  - LAYER_GRAPH
```
public static final int LAYER_GRAPH
```
    Database Layer ID for graphs/transcripts
    
    See Also:
    
    Constant Field Values
  - LAYER_PARTICIPANT
```
public static final int LAYER_PARTICIPANT
```
    Database Layer ID for participants
    
    See Also:
    
    Constant Field Values
  - LAYER_MAIN_PARTICIPANT
```
public static final int LAYER_MAIN_PARTICIPANT
```
    Database Layer ID for marking main participants in a transcript
    
    See Also:
    
    Constant Field Values
  - LAYER_SERIES
```
public static final int LAYER_SERIES
```
    Database Layer ID for series
    
    See Also:
    
    Constant Field Values
  - LAYER_CORPUS
```
public static final int LAYER_CORPUS
```
    Database Layer ID for corpora
    
    See Also:
    
    Constant Field Values
  - SCOPE_EPISODE
```
public static final String SCOPE_EPISODE
```
    Scope for Episode layer - value is "e"
    
    See Also:
    
    Constant Field Values
  - SCOPE_PARTICIPANT
```
public static final String SCOPE_PARTICIPANT
```
    Scope for Participant layer - value is "p"
    
    See Also:
    
    Constant Field Values
  - SCOPE_FREEFORM
```
public static final String SCOPE_FREEFORM
```
    Scope for Freeform layers - value is "f"
    
    See Also:
    
    Constant Field Values
  - SCOPE_META
```
public static final String SCOPE_META
```
    Scope for Meta layers - value is "m"
    
    See Also:
    
    Constant Field Values
  - SCOPE_WORD
```
public static final String SCOPE_WORD
```
    Scope for Word layers - value is "w"
    
    See Also:
    
    Constant Field Values
  - SCOPE_SEGMENT
```
public static final String SCOPE_SEGMENT
```
    Scope for Segment layers - value is "s"
    
    See Also:
    
    Constant Field Values
- Constructor Detail
  - SqlConstants
```
public SqlConstants()
```

Class SqlConstants

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

LAYER_TRANSCRIPTION

LAYER_SEGMENT

LAYER_ORTHOGRAPHY

LAYER_TURN

LAYER_UTTERANCE

LAYER_GRAPH

LAYER_PARTICIPANT

LAYER_MAIN_PARTICIPANT

LAYER_SERIES

LAYER_CORPUS

SCOPE_EPISODE

SCOPE_PARTICIPANT

SCOPE_FREEFORM

SCOPE_META

SCOPE_WORD

SCOPE_SEGMENT

Constructor Detail

SqlConstants