15.00 - Table Definition for Examples - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Table Definition for Examples

An Employee table is used for the examples described in this topic. The definition of the Employee table is given by the following table:

 

employee

employee_number

last_name

supervisor_employee_

number

PK, SA

 

FK

1

Smith

null

2

Brown

1

3

White

1

4

Gibson

2

5

Black

2

6

Jones

3

7

Mason

3

The following domain rule applies to the employee_number column: Its data type is INTEGER and any value inserted into the column must have a value greater than zero.