object ApiDatabase: TApiDatabase
  OnCreate = DataModuleCreate
  Height = 358
  Width = 519
  object ucKG: TUniConnection
    ProviderName = 'MySQL'
    Database = 'kg_order_entry'
    Username = 'root'
    LoginPrompt = False
    Left = 75
    Top = 65
    EncryptedPassword = '9AFF92FF8CFF86FF8CFFCFFFCEFF'
  end
  object UniQuery1: TUniQuery
    Connection = ucKG
    SQL.Strings = (
      '')
    Left = 73
    Top = 148
  end
  object MySQLUniProvider1: TMySQLUniProvider
    Left = 162
    Top = 66
  end
  object UniQuery2: TUniQuery
    Connection = ucKG
    SQL.Strings = (
      '')
    Left = 179
    Top = 148
  end
  object uqOrders: TUniQuery
    Connection = ucKG
    SQL.Strings = (
      'select * from corrugated_plate_orders')
    Left = 257
    Top = 148
    object uqOrdersORDER_ID: TIntegerField
      FieldName = 'ORDER_ID'
    end
    object uqOrdersCOMPANY_ID: TIntegerField
      FieldName = 'COMPANY_ID'
      Required = True
    end
    object uqOrdersUSER_ID: TIntegerField
      FieldName = 'USER_ID'
      Required = True
    end
    object uqOrdersORDER_DATE: TDateTimeField
      FieldName = 'ORDER_DATE'
    end
    object uqOrdersSTART_DATE: TDateField
      FieldName = 'START_DATE'
    end
    object uqOrdersEND_DATE: TDateField
      FieldName = 'END_DATE'
    end
    object uqOrdersORDER_STATUS: TStringField
      FieldName = 'ORDER_STATUS'
      Size = 10
    end
    object uqOrdersSCHED_JSON: TStringField
      FieldName = 'SCHED_JSON'
      Size = 4096
    end
    object uqOrdersstaff_fields_order_date: TDateField
      FieldName = 'staff_fields_order_date'
    end
    object uqOrdersstaff_fields_proof_date: TDateField
      FieldName = 'staff_fields_proof_date'
    end
    object uqOrdersstaff_fields_ship_date: TDateField
      FieldName = 'staff_fields_ship_date'
    end
    object uqOrdersstaff_fields_ship_via: TStringField
      FieldName = 'staff_fields_ship_via'
      Size = 45
    end
    object uqOrdersstaff_fields_price: TStringField
      FieldName = 'staff_fields_price'
      Size = 10
    end
    object uqOrdersstaff_fields_invoice_to: TStringField
      FieldName = 'staff_fields_invoice_to'
      Size = 128
    end
    object uqOrdersstaff_fields_invoice_attention: TStringField
      FieldName = 'staff_fields_invoice_attention'
      Size = 256
    end
    object uqOrdersstaff_fields_ship_to: TStringField
      FieldName = 'staff_fields_ship_to'
      Size = 128
    end
    object uqOrdersstaff_fields_ship_attention: TStringField
      FieldName = 'staff_fields_ship_attention'
      Size = 256
    end
    object uqOrdersstaff_fields_po_number: TStringField
      FieldName = 'staff_fields_po_number'
      Size = 16
    end
    object uqOrdersstaff_fields_job_name: TStringField
      FieldName = 'staff_fields_job_name'
      Size = 45
    end
    object uqOrdersstaff_fields_art_due: TDateField
      FieldName = 'staff_fields_art_due'
    end
    object uqOrdersstaff_fields_plate_due: TDateField
      FieldName = 'staff_fields_plate_due'
    end
    object uqOrdersstaff_fields_mount_due: TDateField
      FieldName = 'staff_fields_mount_due'
    end
    object uqOrdersplates_job_number: TStringField
      FieldName = 'plates_job_number'
      Size = 16
    end
    object uqOrderssupplied_by_customer_b_w_copy: TStringField
      FieldName = 'supplied_by_customer_b_w_copy'
      Size = 1
    end
    object uqOrderssupplied_by_customer_color_copy: TStringField
      FieldName = 'supplied_by_customer_color_copy'
      Size = 1
    end
    object uqOrderssupplied_by_customer_plates: TStringField
      FieldName = 'supplied_by_customer_plates'
      Size = 1
    end
    object uqOrderssupplied_by_customer_sample_ca: TStringField
      FieldName = 'supplied_by_customer_sample_ca'
      Size = 1
    end
    object uqOrderssupplied_by_customer_dimension: TStringField
      FieldName = 'supplied_by_customer_dimension'
      Size = 64
    end
    object uqOrderssupplied_by_customer_disk_or_cd: TStringField
      FieldName = 'supplied_by_customer_disk_or_cd'
      Size = 1
    end
    object uqOrderssupplied_by_customer_e_mail: TStringField
      FieldName = 'supplied_by_customer_e_mail'
      Size = 256
    end
    object uqOrderssupplied_by_customer_ftp: TStringField
      FieldName = 'supplied_by_customer_ftp'
      Size = 256
    end
    object uqOrderssupplied_by_customer_other: TStringField
      FieldName = 'supplied_by_customer_other'
      Size = 96
    end
    object uqOrderssupplied_by_customer_existing_: TStringField
      FieldName = 'supplied_by_customer_existing_'
      Size = 16
    end
    object uqOrderssupplied_by_customer_ref_art_p: TStringField
      FieldName = 'supplied_by_customer_ref_art_p'
      Size = 256
    end
    object uqOrderssupplied_by_customer_ref_art_a: TStringField
      FieldName = 'supplied_by_customer_ref_art_a'
      Size = 256
    end
    object uqOrderscut_die_cutdier: TStringField
      FieldName = 'cut_die_cutdier'
      Size = 10
    end
    object uqOrderscut_die_cutdieb: TStringField
      FieldName = 'cut_die_cutdieb'
      Size = 10
    end
    object uqOrderscut_die_cutdief: TStringField
      FieldName = 'cut_die_cutdief'
      Size = 10
    end
    object uqOrderscut_die_cutdierkr: TStringField
      FieldName = 'cut_die_cutdierkr'
      Size = 10
    end
    object uqOrderscut_die_cutdiefkr: TStringField
      FieldName = 'cut_die_cutdiefkr'
      Size = 10
    end
    object uqOrderscut_die_cad_file: TStringField
      FieldName = 'cut_die_cad_file'
      Size = 128
    end
    object uqOrderscut_die_attached: TStringField
      FieldName = 'cut_die_attached'
      Size = 1
    end
    object uqOrderscut_die_boxpol250: TStringField
      FieldName = 'cut_die_boxpol250'
      Size = 10
    end
    object uqOrderscut_die_boxpol155: TStringField
      FieldName = 'cut_die_boxpol155'
      Size = 10
    end
    object uqOrderscut_die_boxpol125: TStringField
      FieldName = 'cut_die_boxpol125'
      Size = 10
    end
    object uqOrderscut_die_brub: TStringField
      FieldName = 'cut_die_brub'
      Size = 10
    end
    object uqOrdersproofing_fax: TStringField
      FieldName = 'proofing_fax'
      Size = 16
    end
    object uqOrdersproofing_fax_attn: TStringField
      FieldName = 'proofing_fax_attn'
      Size = 256
    end
    object uqOrdersproofing_e_mail: TStringField
      FieldName = 'proofing_e_mail'
      Size = 256
    end
    object uqOrdersproofing_e_mail_attn: TStringField
      FieldName = 'proofing_e_mail_attn'
      Size = 256
    end
    object uqOrdersproofing_ship_to: TStringField
      FieldName = 'proofing_ship_to'
      Size = 1024
    end
    object uqOrdersproofing_full_size_panel: TStringField
      FieldName = 'proofing_full_size_panel'
      Size = 1
    end
    object uqOrdersproofing_print_card: TStringField
      FieldName = 'proofing_print_card'
      Size = 1
    end
    object uqOrdersproofing_wide_format: TStringField
      FieldName = 'proofing_wide_format'
      Size = 1
    end
    object uqOrdersproofing_pdf_file: TStringField
      FieldName = 'proofing_pdf_file'
      Size = 1
    end
    object uqOrdersproofing_other: TStringField
      FieldName = 'proofing_other'
      Size = 64
    end
    object uqOrdersproofing_art_approved_as_is: TStringField
      FieldName = 'proofing_art_approved_as_is'
      Size = 1
    end
    object uqOrdersproofing_approved_date: TDateField
      FieldName = 'proofing_approved_date'
    end
    object uqOrdersproofing_changes_required: TStringField
      FieldName = 'proofing_changes_required'
      Size = 1
    end
    object uqOrdersproofing_changes_date: TDateField
      FieldName = 'proofing_changes_date'
    end
    object uqOrderslayout_rsc_l: TStringField
      FieldName = 'layout_rsc_l'
      Size = 10
    end
    object uqOrderslayout_rcs_w: TStringField
      FieldName = 'layout_rcs_w'
      Size = 10
    end
    object uqOrderslayout_rcs_d: TStringField
      FieldName = 'layout_rcs_d'
      Size = 10
    end
    object uqOrderslayout_die_cut_no: TStringField
      FieldName = 'layout_die_cut_no'
      Size = 45
    end
    object uqOrderslayout_accross_no: TStringField
      FieldName = 'layout_accross_no'
      Size = 10
    end
    object uqOrderslayout_around_no: TStringField
      FieldName = 'layout_around_no'
      Size = 10
    end
    object uqOrderslayout_cad_file: TStringField
      FieldName = 'layout_cad_file'
      Size = 45
    end
    object uqOrderslayout_excalibur_die: TStringField
      FieldName = 'layout_excalibur_die'
      Size = 1
    end
    object uqOrdersmounting_loose: TStringField
      FieldName = 'mounting_loose'
      Size = 10
    end
    object uqOrdersmounting_sticky_bak: TStringField
      FieldName = 'mounting_sticky_bak'
      Size = 1
    end
    object uqOrdersmounting_full_mount: TStringField
      FieldName = 'mounting_full_mount'
      Size = 1
    end
    object uqOrdersmounting_strip_mount: TStringField
      FieldName = 'mounting_strip_mount'
      Size = 10
    end
    object uqOrderscolors_cylinder_size: TStringField
      FieldName = 'colors_cylinder_size'
      Size = 45
    end
    object uqOrderscolors_machine_ident: TStringField
      FieldName = 'colors_machine_ident'
      Size = 45
    end
    object uqOrdersmounting_standard_setup: TStringField
      FieldName = 'mounting_standard_setup'
      Size = 45
    end
    object uqOrdersmounting_custom_backing: TStringField
      FieldName = 'mounting_custom_backing'
      Size = 96
    end
    object uqOrdersmounting_custom_adhesive: TStringField
      FieldName = 'mounting_custom_adhesive'
      Size = 45
    end
    object uqOrderscolors_cross_hairs: TStringField
      FieldName = 'colors_cross_hairs'
      Size = 10
    end
    object uqOrderscolors_clemson: TStringField
      FieldName = 'colors_clemson'
      Size = 10
    end
    object uqOrdersplates_thickness: TStringField
      FieldName = 'plates_thickness'
      Size = 5
    end
    object uqOrdersplates_plate_material: TStringField
      FieldName = 'plates_plate_material'
      Size = 16
    end
    object uqOrdersgeneral_special_instructions: TStringField
      FieldName = 'general_special_instructions'
      Size = 2048
    end
    object uqOrderscolors_colors: TStringField
      FieldName = 'colors_colors'
      Size = 4096
    end
    object uqOrdersstaff_fields_quickbooks_item: TStringField
      FieldName = 'staff_fields_quickbooks_item'
      Size = 45
    end
    object uqOrdersstaff_fields_quantity: TStringField
      FieldName = 'staff_fields_quantity'
      Size = 10
    end
    object uqOrderslayout_rsc_style: TStringField
      FieldName = 'layout_rsc_style'
      Size = 32
    end
    object uqOrdersstaff_fields_art_location: TStringField
      FieldName = 'staff_fields_art_location'
      Size = 16
    end
  end
  object uqOrdersStatusSchedule: TUniQuery
    Connection = ucKG
    SQL.Strings = (
      'select * from ORDERS_STATUS_SCHEDULE')
    Left = 365
    Top = 146
    object uqOrdersStatusScheduleORDERS_STATUS_SCHEDULE_ID: TLongWordField
      FieldName = 'ORDERS_STATUS_SCHEDULE_ID'
    end
    object uqOrdersStatusScheduleORDER_ID: TLongWordField
      FieldName = 'ORDER_ID'
      Required = True
    end
    object uqOrdersStatusScheduleORDER_STATUS: TStringField
      FieldName = 'ORDER_STATUS'
      Required = True
      Size = 45
    end
    object uqOrdersStatusScheduleSTATUS_DATE: TDateField
      FieldName = 'STATUS_DATE'
      Required = True
    end
    object uqOrdersStatusScheduleORIGINAL_STATUS_DATE: TDateField
      FieldName = 'ORIGINAL_STATUS_DATE'
      Required = True
    end
    object uqOrdersStatusScheduleUSER_ID: TLongWordField
      FieldName = 'USER_ID'
      Required = True
    end
    object uqOrdersStatusScheduleORDER_REVISION: TLongWordField
      FieldName = 'ORDER_REVISION'
      Required = True
    end
  end
  object uqUsers: TUniQuery
    Connection = ucKG
    SQL.Strings = (
      'SELECT USER_ID, NAME, STATUS from users ORDER BY NAME')
    OnCalcFields = uqUsersCalcFields
    Left = 318
    Top = 252
    object uqUsersUSER_ID: TIntegerField
      FieldName = 'USER_ID'
      Required = True
    end
    object uqUsersNAME: TStringField
      FieldName = 'NAME'
      Size = 40
    end
    object uqUsersSTATUS: TStringField
      FieldName = 'STATUS'
      Size = 7
    end
    object uqUsersREPRESENTATIVE: TStringField
      FieldKind = fkCalculated
      FieldName = 'REPRESENTATIVE'
      Calculated = True
    end
  end
end
