Database Structure

Database Structure - Board library

The board library fields

Materials table: MATERIALS

	Field name	Description
	MaterialsCode	unique code, text(50)
	MaterialsDescription	text(50)
	MaterialsThickness	number
	MaterialsGrain	number
	MaterialsBookHeight	number
	MaterialsParametersName	text(50)
	MaterialsPictureFileName	text(50)
	MaterialsType	number

Boards table: BOARDS

	Field name	Description
	BoardsCode	unique code, text(50)
	BoardsMaterialCode	text(50)
	BoardsLength	number
	BoardsWidth	number
	BoardsInformation	text(25)
	BoardsStockQuantity	number
	BoardsOrderQuantity	number
	BoardsAllocationQuantity	number
	BoardsCost	number
	BoardsLimit	number
	BoardsMinimumQuantity	number
	BoardBin	text(25)
	BoardsSupplier	text(25)
	BoardsCostMethod	number
	BoardsParametersName	text(50)
	BoardsReorderQuantity	text(20)
	BoardsType	number
	BoardsGrain	number

Stock transactions table: TRANSACTIONS

	Field name	Description
	TransactionsID	unique ID, number
	TransactionsDate	text(6) (ddmmyy)
	TransactionsType	number
	TransactionsReference	text(50)
	TransactionsBoardCode	text(25)
	TransactionsQuantity	number
	TransactionsBoardCost	number
	TransactionsUser	text(4)

Material type table: MATERIALTYPE

	Field name	Description
	MaterialTypeCode	number
	MaterialTypeDescription	text(40)