tube_type_info
|
type_info_id* (int not null)
|
tube_id (int not null - indicating 7835, 8613, ...)
|
serial_num (varchar(32) not null - from Serial No. column on given spreadsheet)
|
ion_pump (int null)
|
coast_guard_flag (int not null)
|
new4E27 (int not null)
|
tube_history
|
tube_history_id* (int not null)
|
type_info_id (int not null)
|
rebuild_num (int not null - zero for new)
|
parent_history_id (int null)
|
task_id_str (varchar(64) not null - may be more than one task_id)
|
cost (float null)
|
po (varchar(24) null)
|
supplier_id (int not null)
|
received_date (datetime null - some dates not included in original)
|
getterless (int null)
|
station_flag (int not null)
|
sps_id (int null)
|
sps (varchar(32) null)
|
status_id (int null)
|
borrowed (int not null)
|
uploaded_files (int not null)
|
fnal_id (varchar(16) not null) (person entering data)
|
update_date (datetime not null - entry update)
|
notes (varchar(256) null)
|
tube_station_history
(which tube was at what station for how long, when and why it failed)
|
station_history_id* (int not null)
|
station_id (int not null)
|
designator (varchar(64) null)
|
tube_history_id (int not null)
|
inservice_date (datetime not null)
|
outservice_date (datetime null)
|
meter_HV_IN (int null)
|
meter_PA_IN (int null)
|
meter_SW_IN (int null)
|
meter_HV_OUT (int null)
|
meter_PA_OUT (int null)
|
meter_SW_OUT (int null)
|
hours (int null)
|
date_recorded (datetime null)
|
failure_id (int null)
|
failure_comments (varchar(256)
null - used initially for those entries that don't comform to the
defined failure options and/or specify more than one failure mode)
|
uploaded_files (int not null)
|
fnal_id (varchar(16) not null) (person entering data)
|
update_date (datetime not null - date of entry update)
|
notes (varchar(256) null)
|
tube_monthly_report - not used
(not really sure what readings are taken each month)
|
station_id (int not null)
|
tube_history_id (int not null)
|
fnal_id (varchar(16) not null)
|
reading_date (datetime not null - report month)
|
meter_HV (int null)
|
meter_PA (int null)
|
meter_SW (int null)
|
hours (int not null)
|
update_date (datetime not null - date of entry)
|
notes (varchar(256) null)
|
tube_rebuild
|
rebuild_id* (int not null)
|
tube_history_id (int not null)
|
rebuild_status_id (int not null)
|
date_marked (datetime not null)
|
date_send_out (datetime null)
|
supplier_id (int null)
|
send_notes (varchar(256) null)
|
date_rebuild_report (datetime null)
|
task_id_str (varchar(64) null)
|
TCA (int not null)
|
TCA_PO (varchar(24) null)
|
TCA_PO_date (datetime null)
|
TCA_cost (float null)
|
PO (varchar(24) null)
|
cost (float null)
|
edd_days (int null)
|
rebuild_report_notes (varchar(256) null)
|
uploaded_files (int not null)
|
date_received (datetime null)
|
rebuild_num (int null)
|
new_type_info_id (int null)
|
fnal_id (varchar(16) null)
|
tube_cost_history
|
tube_id (int not null)
|
cost (float null)
|
rebuild_cost (float null)
|
rebuild_task_id (int null)
|
start_date (datetime not null)
|
expire_date (datetime null)
|
update_date (datetime not null)
|
tube_purchase_plan
|
tube_id (int not null)
|
fiscalyear (int not null)
|
rebuild_flag (int not null)
|
q1 (int null)
|
| q2 (int null) |
| q3 (int null) |
| q4 (int null) |
|
tube_list
(7835, 8613, ...)
|
tube_id* (int not null)
|
tube (varchar(24) not null)
|
tube_desc (varchar(256) null)
|
tube_type (varchar(24) not null)
|
supplier_id (int not null)
|
num_per_station (int not null)
|
usage (varchar(128) null)
|
order_val (int not null)
|
designator_options (varchar(256) null)
|
pulse_transformers_SN (varchar(256) null)
|
solenoid_SN (varchar(256) null)
|
tube_life (float not null)
|
low_spare_min (int not null)
|
uploaded_files (int not null)
|
deleted (int not null)
|
tube_station_list
|
station_id* (int not null)
|
station (varchar(32) not null)
|
notes (varchar(256) null)
|
deleted (int not null)
|
tube_station_map
|
tube_id (int not null)
|
station_id (int not null)
|
tube_failure_mode
(Low Emission, Gassy, ...)
|
failure_id* (int not null)
|
failure_short (varchar(16) null)
|
failure (varchar(64) not null)
|
failure_desc (varchar(256) null)
|
tube_rebuild_task
|
task_id* (int not null)
|
task_num (int not null)
|
task_sub (char(2) null)
|
task (varchar(64) null)
|
task_desc (varchar(256) null - might be a link to help)
|
deleted (int not null)
|
tube_rebuild_task_map
|
tube_id (int not null)
|
task_id (int not null)
|
tube_SPS
(special processed spares)
|
sps_id* (int not null)
|
sps_short (varchar(16) not null)
|
sps (varchar(64) not null)
|
tube_status
|
status_id* (int not null)
|
status (varchar(16) not null)
|
status_notes (varchar(256) null)
|
Values: Active, Spare, Failed, Being Rebuilt, On order, Archive, Stand by, Conditioning, Received
|
tube_rebuild_status
|
rebuild_status_id* (int not null)
|
sortorder (int not null)
|
rebuild_status (varchar(32) not null)
|
tube_supplier
|
supplier_id* (int not null)
|
supplier (varchar(32) not null)
|
deleted (int not null)
|
tube_notification
|
notification_id* (int not null)
|
notification (varchar(32) not null)
|
tube_notification_frequency
|
frequency_id* (int not null)
|
frequency (varchar(32) not null)
|
tube_subscription
|
fnal_id (varchar(16) not null)
|
notification_id (int not null)
|
tube_id_list (varchar(64) not null) ("all" or list of tube id's)
|
frequency_id (int not null)
|
tube_on_order
|
tube_id (int not null)
|
order_date (datetime not null)
|
number (int not null)
|
cost (float null)
|
edd_days (int null)
|
PO (varchar(24) null)
|
received_date (datetime null)
|
notes (varchar(256) null)
|
update_date (datetime not null)
|
fnal_id (varchar(16) not null)
|
on_order_id (numeric identity)
|
|