kai_project_erd

Tables (12)

Group (kai_project_sap_group)

  • groupId — text — Primary key — NOT NULL

User (kai_project_sap_user)

  • userId — text — Primary key — NOT NULL
  • name — text — NOT NULL
  • group_id — text — Foreign key → Group.groupId

install_device (kai_project_install_device)

  • idx — integer — Primary key — NOT NULL
  • install_pos — character — NOT NULL
  • install_desc — character — NOT NULL

kiosk_job_list (kai_project_kiosk_job_list)

  • idx — integer — Primary key — NOT NULL
  • offer_status — character — NOT NULL
  • priority — integer — NOT NULL
  • group_id — text — Foreign key → Group.groupId
  • order_number — character — NOT NULL
  • gop_number — character — NOT NULL
  • workings — character — NOT NULL
  • part_number — character — NOT NULL
  • proc_start — timestamp — NOT NULL
  • proc_end — timestamp — NOT NULL
  • target_result — double — NOT NULL
  • real_result — double — NOT NULL
  • worker — character — NOT NULL
  • task_center — character — NOT NULL

kiosk_setting_info (kai_project_kiosk_setting_info)

  • idx — integer — Primary key — NOT NULL
  • created — timestamp — NOT NULL
  • updated — timestamp — NOT NULL
  • serial_num — character — NOT NULL
  • ip_address — character — NOT NULL
  • install_pos — character — NOT NULL

log_type_def (kai_project_log_type_def)

  • idx — integer — Primary key — NOT NULL
  • log_type — integer — NOT NULL
  • log_desc — character — NOT NULL

scan_log (kai_project_scan_log)

  • idx — integer — Primary key — NOT NULL
  • created — timestamp — NOT NULL
  • tag_id — character — NOT NULL
  • tag_text — character — NOT NULL
  • ip_address — character — NOT NULL
  • serial_num — character — NOT NULL

scan_log_barcode (kai_project_scan_log_barcode)

  • idx — integer — Primary key — NOT NULL
  • created — timestamp — NOT NULL
  • tag_id — character — NOT NULL
  • tag_text — character — NOT NULL
  • ip_address — character — NOT NULL
  • serial_num — character — NOT NULL

scan_log_barcode_orders (kai_project_scan_log_barcode_orders)

  • id — bigint — Primary key — NOT NULL
  • scan_log_barcode_id — integer — Foreign key → scan_log_barcode.idx — NOT NULL
  • kiosk_job_list_id — integer — Foreign key → kiosk_job_list.idx — NOT NULL

scan_log_nfc (kai_project_scan_log_nfc)

  • idx — integer — Primary key — NOT NULL
  • created — timestamp — NOT NULL
  • tag_id — character — NOT NULL
  • tag_text — character — NOT NULL
  • ip_address — character — NOT NULL
  • serial_num — character — NOT NULL
  • user_id — text — Foreign key → User.userId

scan_log_orders (kai_project_scan_log_orders)

  • id — bigint — Primary key — NOT NULL
  • scan_log_id — integer — Foreign key → scan_log.idx — NOT NULL
  • kiosk_job_list_id — integer — Foreign key → kiosk_job_list.idx — NOT NULL

system_log (kai_project_system_log)

  • idx — integer — Primary key — NOT NULL
  • created — timestamp — NOT NULL
  • log_memo — text — NOT NULL
  • ip_address — character — NOT NULL
  • log_type_id — integer — Foreign key → log_type_def.idx