HillTJ
To train a dog, first know more than the dog..
- Local time
- Yesterday, 21:43
- Joined
- Apr 1, 2019
- Messages
- 731
Hi,
I'm developing an equipment calibration database. I am playing with the following structure;
TBL_Site
LocationID-PK
Location _Name
Etc...
TBL_Equipment
EquipmentID-PK
Equipment_Desc
Serial_Id
Etc...
TBL_Site_Equipment (The link in Many:Many)
Link_LocationID-PK?
link_EquipmentID-PK?
TBL_Inspect_Record
InspectID-PK
LocationID-Composite Key
EquipmentID-Composite Key
Condition
Inspect_Date
Etc...
TBL_Measurement
MeasurementID-PK
Inspect_ID-FK
Actual_Measurement
Etc....
Is this sensible? Appreciate any feedback before I go off the rails by too much.
I'm developing an equipment calibration database. I am playing with the following structure;
TBL_Site
LocationID-PK
Location _Name
Etc...
TBL_Equipment
EquipmentID-PK
Equipment_Desc
Serial_Id
Etc...
TBL_Site_Equipment (The link in Many:Many)
Link_LocationID-PK?
link_EquipmentID-PK?
TBL_Inspect_Record
InspectID-PK
LocationID-Composite Key
EquipmentID-Composite Key
Condition
Inspect_Date
Etc...
TBL_Measurement
MeasurementID-PK
Inspect_ID-FK
Actual_Measurement
Etc....
Is this sensible? Appreciate any feedback before I go off the rails by too much.