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