Table ptms..MiscellaneousCodes

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

Fieldname varchar 10 Yes

Code varchar 10 Yes

Description varchar 25 Yes

Timestamp datetime Yes

Indexes on this table

Index Name Index Description Index Keys

PK_MiscellaneousCodes clustered, unique, primary key located on PRIMARY ID

	Column Name	Type	Length	Nullable	Description	Relationships
Identity	ID	int identity		No
	Fieldname	varchar	10	Yes
	Code	varchar	10	Yes
	Description	varchar	25	Yes
	Timestamp	datetime		Yes

Index Name	Index Description	Index Keys
PK_MiscellaneousCodes	clustered, unique, primary key located on PRIMARY	ID