Keys

hardware_id

  Table                Alias, if any

  hardware
  hardware_instance
    

id

  Table                Alias, if any

  ltx_files
  test_instance_status
    

pkg_id

  Table                Alias, if any

  package
    

requirement_id

  Table                Alias, if any

  requirement_instance
  requirements
    

software_id

  Table                Alias, if any

  software
  software_instance
    

system_id

  Table                Alias, if any

  system
    

system_instance_id

  Table                Alias, if any

  hardware_instance
  requirement_instance
  software_instance
  system_instance
    

test_id

  Table                Alias, if any

  test
    

test_instance_id

  Table                Alias, if any

  test_instance
    

Tables

analysis_codes

  Field                Type            Null   Key   Default   Extra

  analysis_id          int(11)         -      PRI   0         -
  analysis             varchar(50)     YES    -     -         -
    

current_version

  Field                Type            Null   Key   Default   Extra

  test_name            varchar(20)     -      -     -         -
  pkg_version          varchar(20)     YES    -     -         -
  comment              varchar(200)    YES    -     -         -
    

hardware

  Field                Type            Null   Key   Default   Extra

  hardware_id          int(11)         -      PRI   -         auto_increment
  device_id            varchar(50)     -      -     -         -
  chip                 varchar(50)     YES    -     -         -
  descr                text            YES    -     -         -
  vendor_id            varchar(50)     YES    -     -         -
  vendor_name          text            YES    -     -         -
    

hardware_instance

  Field                Type            Null   Key   Default   Extra

  system_instance_id   int(11)         -      PRI   0         -
  hardware_id          int(11)         -      PRI   0         -
    

ltx_files

  Field                Type            Null   Key   Default   Extra

  id                   bigint(20) unsigned -      PRI   -         auto_increment
  test_instance_id     int(11)         -      -     0         -
  test_id              int(11)         -      -     0         -
  ltx_file_name        varchar(30)     YES    -     -         -
  ltx_file_path        varchar(100)    YES    -     -         -
    

package

  Field                Type            Null   Key   Default   Extra

  pkg_id               varchar(50)     -      PRI   -         -
  project              varchar(50)     YES    -     -         -
    

requirement_instance

  Field                Type            Null   Key   Default   Extra

  system_instance_id   int(11)         -      PRI   0         -
  requirement_id       int(11)         -      PRI   0         -
    

requirements

  Field                Type            Null   Key   Default   Extra

  requirement_id       int(11)         -      PRI   -         auto_increment
  requirement          varchar(50)     -      -     -         -
    

software

  Field                Type            Null   Key   Default   Extra

  software_id          int(11)         -      PRI   -         auto_increment
  pkg_id               varchar(50)     -      -     -         -
  con_id               varchar(50)     -      -     -         -
  version              varchar(50)     -      -     -         -
  target               varchar(50)     -      -     -         -
  built_by             varchar(50)     -      -     -         -
  built_at             varchar(50)     -      -     -         -
  built_on             datetime        YES    -     -         -
    

software_instance

  Field                Type            Null   Key   Default   Extra

  system_instance_id   int(11)         -      PRI   0         -
  software_id          int(11)         -      PRI   0         -
    

status_codes

  Field                Type            Null   Key   Default   Extra

  status_id            int(11)         -      PRI   0         -
  status               varchar(50)     YES    -     -         -
    

system

  Field                Type            Null   Key   Default   Extra

  system_id            int(11)         -      PRI   -         auto_increment
  system_type          varchar(50)     YES    -     -         -
  tag                  varchar(50)     YES    -     -         -
  ip                   varchar(50)     YES    -     -         -
    

system_instance

  Field                Type            Null   Key   Default   Extra

  system_instance_id   int(11)         -      PRI   -         auto_increment
  system_id            int(11)         -      MUL   0         -
  system_number        int(11)         -      -     0         -
  test_instance_id     int(11)         -      MUL   0         -
    

test

  Field                Type            Null   Key   Default   Extra

  test_id              int(11)         -      PRI   -         auto_increment
  test_name            varchar(50)     -      -     -         -
  test_level           varchar(50)     YES    -     -         -
  author               varchar(50)     YES    MUL   -         -
  test_package         varchar(50)     YES    MUL   -         -
  test_version         varchar(50)     -      -     -         -
    

test_case

  Field                Type            Null   Key   Default   Extra

  test_name            varchar(20)     -      -     -         -
  pkg_version          varchar(20)     YES    -     -         -
  build_version        varchar(20)     YES    -     -         -
  ltx_file_path        varchar(100)    YES    -     -         -
  type                 varchar(10)     YES    -     -         -
  status               varchar(10)     YES    -     -         -
  comment              varchar(200)    YES    -     -         -
    

test_instance

  Field                Type            Null   Key   Default   Extra

  test_instance_id     int(11)         -      PRI   -         auto_increment
  test_id              int(11)         -      MUL   0         -
  datetime             datetime        YES    -     -         -
  duration             time            YES    -     -         -
  engineer             varchar(50)     YES    MUL   -         -
  site                 varchar(50)     YES    -     -         -
  ltx_version          varchar(50)     YES    -     -         -
  dtd                  varchar(50)     YES    -     -         -
  activity             varchar(50)     YES    -     -         -
  release              varchar(50)     YES    -     -         -
  status               int(11)         YES    MUL   -         -
  analysis             int(11)         YES    MUL   -         -
  volume               varchar(50)     YES    MUL   -         -
  savedate             timestamp       YES    -     CURRENT_TIMESTAMP -
  savedir              varchar(50)     YES    -     -         -
    

test_instance_status

  Field                Type            Null   Key   Default   Extra

  id                   bigint(20) unsigned -      PRI   -         auto_increment
  test_instance_id     int(11)         -      -     0         -
  test_id              int(11)         -      -     0         -
  status               varchar(20)     -      -     -         -
  pkg_version          varchar(20)     YES    -     -         -
  comment              varchar(200)    YES    -     -         -
    

user

  Field                Type            Null   Key   Default   Extra

  user_id              varchar(50)     -      PRI   -         -
  name                 varchar(50)     YES    -     -         -
  email                varchar(50)     YES    -     -         -
  type                 varchar(50)     YES    -     -         -
    

volume

  Field                Type            Null   Key   Default   Extra

  vol_id               varchar(50)     -      PRI   -         -
  location             varchar(50)     YES    -     -         -