Archibus Schema Related to Work Orders
Work Orders
|
Table Name |
Title |
Description |
|
activity_log |
Action Items |
Table of activity & action items |
|
probtype |
Problem Type |
Problem Type |
|
wo |
Work Orders |
Work Orders |
|
wr |
Work Requests |
Work Requests |
|
hwr |
Historical Work Requests |
Historical Work Requests |
|
cf |
Craftspersons |
Craftsperson |
|
wrcf |
Work Request Labor Assignments |
Work requested by Labor Assignments |
Equipment
|
Table Name |
Title |
Description |
|
eq |
Equipment |
Equipment |
|
eqstd |
Equipment Standard |
Equipment Standard |
Preventive Maintenance
|
Table Name |
Title |
Description |
|
pmp |
PM Procedures |
PM Procedures |
|
pmps |
PM Procedures Steps |
PM Procedures Steps |
|
pmpspt |
PM Procedures Steps Parts |
PM Procedures Steps Parts |
|
pmpstr |
PM Procedures Steps Trades |
PM Procedures Steps Trades |
|
pmpstl |
PM Procedures Steps Tool Types |
PM Procedures Steps Tool Types |
|
pms |
PM Schedules |
PM Schedules |
In the diagram below, the blocks show the table and the fields that relate to each other. The field names highlighted in green are the fields that relate to another table.
pms
pms_id (pk1)
pmp_id
eq_id
pmp
pmp_id (pk1)
cost_cat
wr
wr_id (pk1)
wo_id
tr_id
pmp_id
pms_id
prob_type
eq_id
activity_log_id
wo
wo_id (pk1)
tr_id
pmps
pmps_id (pk2)
pmp_id (pk1)
pmpspt
part_id (pk3)
pmps_id (pk2)
pmp_id (pk1)
pmpstr
tr_id (pk3)
pmps_id (pk2)
pmp_id (pk1)
pmpstt
tool_type (pk3)
pmps_id (pk2)
pmp_id (pk1)
activity_log
activity_log_id (pk1)
cf_id
pmp_id
prob_type
tr_id
wo_id
eq_id
probtype
prob_type (pk1)
cost_cat
wrcf
wr_id (pk1)
cf_id (pk2)
date_assigned (pk3)
time_assigned (pk4)
tr_id
cf
cf_id (pk1)
tr_id
hwr
wr_id (pk1)
eqstd
eq_std (pk1)
eq
eq_id (pk1)
eq_std
Was this helpful?
1 / 0