The DENTAL_TOOTH table contains tooth information. Since one transaction may be associated with multiple teeth, each row in this table represents one tooth code and is identified by the transaction ID (TX_ID) and tooth line number (TOOTH_NUMBER).
Primary Key
Column Name
Ordinal Position
TX_ID
1
TOOTH_LINE
2
Column Information
Name
Type
Discontinued?
1
TX_ID
NUMERIC
No
The unique identifier for the transaction record.
2
TOOTH_LINE
INTEGER
No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.