aa

Tables (29)

active_alarm

  • clear_time — character
  • code — integer — NOT NULL
  • location — character
  • related_command_id — character
  • type — character
  • seq — number — NOT NULL
  • set_time — character — NOT NULL
  • sub_code — integer
  • location_type — character

carrier

  • seq — number — NOT NULL
  • block_reason — character
  • column_no — integer
  • id — character — NOT NULL
  • is_block — boolean
  • is_clean — boolean
  • is_load — boolean
  • is_read_ok — boolean
  • location — character — NOT NULL
  • location_type — character — NOT NULL
  • lot_id — character
  • previous_location — character
  • row_no — integer
  • side_no — integer
  • size — character
  • status — character — NOT NULL
  • sub_location — character
  • time_destination_port_loaded — character
  • time_installed — character
  • time_stored — character
  • type — character

def_alarm_detail

  • code — integer — NOT NULL
  • level — integer
  • class_code — integer
  • classification — integer
  • detail — character
  • is_host_report — boolean
  • recovery_way — character
  • seq — number — NOT NULL
  • sub_code — integer
  • type — character
  • location_type — character

def_alternate_destination

  • alternate_destination — character — NOT NULL
  • original_destination — character — NOT NULL
  • priority — integer
  • seq — number — NOT NULL
  • transfer_priority — integer

def_carrier_size

  • description — character
  • seq — number — NOT NULL
  • size — character — NOT NULL

def_carrier_type

  • description — character
  • seq — number — NOT NULL
  • type — character — NOT NULL
  • id_length — numeric(2,0) — NOT NULL

def_default_destination

  • source — character — NOT NULL
  • destination — character — NOT NULL
  • destination_type — character — NOT NULL
  • priority — integer
  • seq — number — NOT NULL
  • transfer_priority — integer

def_parameter

  • detail — character
  • id — character — NOT NULL
  • max — integer
  • min — integer
  • type — character
  • value — character
  • seq — number — NOT NULL
  • process — character

def_port_type

  • description — character
  • seq — number — NOT NULL
  • type — character — NOT NULL

def_unit

  • description — character
  • id — integer — NOT NULL
  • name — character — NOT NULL
  • seq — number — NOT NULL
  • type — character — NOT NULL

def_unit_cmd

  • device_type — character — NOT NULL
  • device_id — character — NOT NULL
  • unit_type — character — NOT NULL
  • unit_id — character — NOT NULL
  • unit_value — character — NOT NULL
  • cmd_type — smallint — NOT NULL

def_user_account

  • seq — number — NOT NULL
  • auto_alert_close — boolean
  • auto_logout_time — integer
  • phone — character
  • default_language — character
  • department — character
  • email — character
  • id — character — NOT NULL
  • insert_time — timestamp(6)
  • last_login_time — timestamp(6)
  • last_logout_time — timestamp(6)
  • name — character
  • password — character — NOT NULL
  • position — character
  • update_time — timestamp(6)
  • user_group — character

def_user_group

  • seq — number — NOT NULL
  • id — character — NOT NULL
  • feature — character — NOT NULL
  • navigation — character — NOT NULL
  • tab — character — NOT NULL

def_zone

  • detail — character
  • id — character — NOT NULL
  • seq — number — NOT NULL
  • total_shelves — integer
  • type — character — NOT NULL

history_alarm

  • clear_time — character — NOT NULL
  • code — integer — NOT NULL
  • location — character
  • related_command_id — character
  • type — character
  • seq — number — NOT NULL
  • set_time — character — NOT NULL
  • sub_code — integer
  • location_type — character

history_operation

  • id — number — NOT NULL
  • user_id — character — NOT NULL
  • client — character — NOT NULL
  • menu — character — NOT NULL
  • crud — character — NOT NULL
  • create_date — timestamp

history_transfer

  • abort_reason — character
  • carrier_id — character — NOT NULL
  • cmd_seq — character
  • command_by — character
  • current_column_no — integer
  • current_loc — character
  • current_row_no — integer
  • current_side_no — integer
  • current_sub_location — character
  • deleted_by — character
  • destination — character — NOT NULL
  • destination_column_no — integer
  • destination_row_no — integer
  • destination_side_no — integer
  • id — character — NOT NULL
  • previous_sub_status — character
  • priority — integer — NOT NULL
  • result — character
  • seq — number — NOT NULL
  • source — character
  • source_column_no — integer
  • source_row_no — integer
  • source_side_no — integer
  • status — character
  • sub_status — character
  • time — character
  • time_acquire_cmp — character
  • time_acquire_cmd_ans — character
  • time_acquire_cmd_req — character
  • time_complete — character
  • time_deposit_cmd_ans — character
  • time_deposit_cmd_req — character
  • time_deposit_cmp — character
  • time_installed — character
  • time_move_cmd_ans — character
  • time_move_cmd_req — character
  • time_move_cmp — character
  • time_priority_auto_increament — character
  • waiting_code — character
  • waiting_location — character
  • waiting_reason — character

init_setting

  • side_no — integer — NOT NULL
  • row_no — integer — NOT NULL
  • column_no — integer — NOT NULL
  • type — character — NOT NULL
  • priority — integer — NOT NULL
  • status — character — NOT NULL
  • result — character
  • zone_id — character
  • reason — character

inventory

  • side_no — integer — NOT NULL
  • row_no — integer — NOT NULL
  • column_no — integer — NOT NULL
  • carrier_id — character
  • status — character — NOT NULL
  • result — character
  • zone_id — character
  • reason — character

port

  • buffer_size — integer
  • column_no — integer
  • device_type — character
  • direction — character — NOT NULL
  • floor — character
  • id — character — NOT NULL
  • is_bp_load — boolean
  • is_lp_load — boolean
  • is_op_load — boolean
  • mode — character — NOT NULL
  • mode_local — character
  • mode_set_user — character
  • relative_ts — character
  • row_no — integer
  • seq — number — NOT NULL
  • side_no — integer
  • status — character
  • status_local — character
  • status_id_reader — character
  • time_mode_set — character
  • type — character — NOT NULL
  • vendor_id — character — NOT NULL
  • is_mt_load — boolean
  • mt_position — character
  • mt_lift — character

s1f3_ses

  • select_1 — character — NOT NULL
  • select_2 — character
  • select_3 — character
  • select_4 — character
  • select_5 — character
  • seq — number — NOT NULL
  • svid — integer — NOT NULL
  • svid_name — character — NOT NULL
  • table_name — character

s6f11_event

  • ceid — integer — NOT NULL
  • event — character — NOT NULL
  • mode — character
  • report_id — integer — NOT NULL
  • seq — number — NOT NULL

s6f11_report_id

  • id — integer — NOT NULL
  • seq — number — NOT NULL
  • vid_1 — character — NOT NULL
  • vid_2 — character
  • vid_3 — character
  • vid_4 — character
  • vid_5 — character
  • vid_6 — character
  • vid_7 — character
  • vid_cnt — integer

sc

  • id — character — NOT NULL
  • mode_cmd_ready — character
  • mode_mplc — character
  • mode_set_user — character
  • seq — number — NOT NULL
  • status — character
  • status_alarm — character
  • status_control_on_offline — character
  • status_control_local_remote — character
  • status_host_comm — character
  • status_hsms — character
  • status_mplc — character
  • status_plc_comm — character
  • status_prev_control — character
  • status_system — character
  • time_mode_set — character
  • type — character
  • mode_stkc_cmd_ready — character

storage

  • block_reason — character
  • block_by — character
  • carrier_id — character
  • column_no — integer — NOT NULL
  • is_block — boolean
  • row_no — integer — NOT NULL
  • seq — number — NOT NULL
  • side_no — integer — NOT NULL
  • status — character — NOT NULL
  • time_stored — character
  • zone_id — character

transfer

  • abort_reason — character
  • alaternate_column_no — integer
  • alaternate_destination — character
  • alaternate_row_no — integer
  • alaternate_side_no — integer
  • carrier_id — character — NOT NULL
  • cmd_seq — character
  • command_by — character
  • current_column_no — integer
  • current_loc — character
  • current_row_no — integer
  • current_side_no — integer
  • current_sub_location — character
  • deleted_by — character
  • destination — character — NOT NULL
  • destination_column_no — integer
  • destination_row_no — integer
  • destination_side_no — integer
  • id — character — NOT NULL
  • original_column_no — integer
  • original_destination — character
  • original_row_no — integer
  • original_side_no — integer
  • previous_sub_status — character
  • priority — integer — NOT NULL
  • result — character
  • seq — number — NOT NULL
  • source — character
  • source_column_no — integer
  • source_row_no — integer
  • source_side_no — integer
  • status — character
  • sub_status — character
  • time — character
  • time_acquire_cmd_ans — character
  • time_acquire_cmd_req — character
  • time_acquire_cmp — character
  • time_alternate_changed — character
  • time_complete — character
  • time_deposit_cmd_ans — character
  • time_deposit_cmd_req — character
  • time_deposit_cmp — character
  • time_input_ans — character
  • time_input_cmp — character
  • time_input_req — character
  • time_installed — character
  • time_move_cmd_ans — character
  • time_move_cmd_req — character
  • time_move_cmp — character
  • time_output_ans — character
  • time_output_cmp — character
  • time_output_req — character
  • time_priority_auto_increament — character
  • waiting_code — character
  • waiting_location — character
  • waiting_reason — character
  • priority_increase_time — character

ts

  • column_no — integer
  • device_type — character
  • id — character — NOT NULL
  • is_load — boolean
  • mode — character
  • mode_local — character
  • mode_set_user — character
  • row_no — integer
  • status — character
  • status_active — character
  • status_local — character
  • status_cmd — integer
  • status_id_reader — character
  • seq — number — NOT NULL
  • side_no — integer
  • time_mode_set — character
  • transfer_cmd_seq — integer
  • transfer_id — character
  • vendor_id — character — NOT NULL

units

  • device_type — character — NOT NULL
  • device_id — character — NOT NULL
  • unit_type — character — NOT NULL
  • unit_id — character — NOT NULL
  • unit_value — character — NOT NULL
  • cmd_type — smallint — NOT NULL
  • remark — character
  • utility — boolean
  • show_utility_mode — boolean
  • relative_ts — character
  • relative_sub_loc — character
  • req_cmd_type — smallint

vid_info

  • parsing — character
  • seq — number — NOT NULL
  • type — character — NOT NULL
  • vid — character — NOT NULL
  • vid_cnt — integer — NOT NULL
  • vid1 — character
  • vid2 — character
  • vid3 — character
  • vid4 — character