test

Tables (16)

DRAMinfo (DRAM)

  • ID (d_id) — Primary key — NOT NULL
  • DramTech (Tech) — char
  • Dram용량 (Density) — char
  • DramRev (d_rev) — char

DramWaferinfo

  • ID (dramwafer_id) — Primary key — NOT NULL
  • ID (t_r_s_id) — Foreign key → TestResults_sample.ID — NOT NULL
  • ID (r_d_id) — Foreign key → Recipe_Items_Info.ID — NOT NULL
  • cs (csvalue)
  • waferid
  • Lotno
  • x-axis
  • y-axis

Equipmentinfo (Equipment)

  • id (e_id) — Primary key — NOT NULL
  • 장비 No (e_no)
  • 장비Maker (e_maker) — char
  • 장비IP (IP) — char
  • 위치 (Location) — char
  • OS Verison (o_ver)

FAInfo

  • ID (fain_id) — Primary key — NOT NULL
  • ID (t_r_s_id2) — Foreign key → TestResults_sample.ID — NOT NULL
  • ID (r_d_id) — Foreign key → Recipe_Items_Info.ID — NOT NULL
  • failmode
  • failcategory (category)
  • jira (jira_no)
  • sfa (sfa_no)
  • status
  • summary

NANDWafer_Info (NANDWaferInfo)

  • ID (nandwafer_id) — Primary key — NOT NULL
  • ID (t_r_s_id) — Foreign key → TestResults_sample.ID — NOT NULL
  • ID (r_d_id) — Foreign key → Recipe_Items_Info.ID — NOT NULL
  • die (die_value)
  • waferid
  • Lotno
  • x-axis
  • y-axis

NANDinfo (NAND)

  • ID (n_id) — Primary key — NOT NULL
  • Type — char
  • NAND적층 (Tech) — char
  • NANDRev (n_rev) — char
  • NAND Density (Density) — char

PJTinfo (Project)

  • ID (p_id) — Primary key — NOT NULL
  • id (s_id) — Foreign key → SoCinfo.id — NOT NULL
  • ID (n_id) — Foreign key → NANDinfo.ID — NOT NULL
  • ID (d_id) — Foreign key → DRAMinfo.ID — NOT NULL
  • Name
  • Interface — char

PowerInfo (Powerinfo)

  • ID (Power_id) — Primary key — NOT NULL
  • ID (t_r_s_id) — Foreign key → TestResults_sample.ID — NOT NULL
  • ID (r_d_id) — Foreign key → Recipe_Items_Info.ID — NOT NULL
  • powermode (pm)
  • value

RecipeInfo

  • ID (recipe_id) — Primary key — NOT NULL
  • ID (p_id) — Foreign key → PJTinfo.ID — NOT NULL
  • TestType (Type)
  • recipename (r_name)
  • RecipeRev (Recipe_Rev)

Recipe_Items_Info (Recipe_Details)

  • ID (r_d_id) — Primary key — NOT NULL
  • ID (recipe_id) — Foreign key → RecipeInfo.ID — NOT NULL
  • testno (tno)
  • testname
  • Addressing (l_addr)
  • DataPattern (d_pattern)
  • loop
  • time (testtime)
  • 온도 (temp)
  • Field

SMARTInfo

  • ID (smart_id) — Primary key — NOT NULL
  • ID (t_r_s_id) — Foreign key → TestResults_sample.ID — NOT NULL
  • ID (r_d_id) — Foreign key → Recipe_Items_Info.ID — NOT NULL
  • Attribute (attribute)
  • value

SSDinfo (SSD)

  • ID (ssd_id) — Primary key — NOT NULL
  • ID (p_id) — Foreign key → PJTinfo.ID — NOT NULL
  • SSDLotno (s_lot_no) — char
  • SerialNo. (S_no) — int
  • 용량 (Capacity) — char
  • 폼팩터 (FormFactor) — char
  • NANDPKGStack (n_pkg_stk) — int
  • DramPKGStack (d_pkg_stck) — int
  • NandPkgCount (n_pkg_count) — int
  • location

SoCWaferinfo

  • ID (nandwafer_id) — Primary key — NOT NULL
  • ID (t_r_s_id) — Foreign key → TestResults_sample.ID — NOT NULL
  • ID (r_d_id) — Foreign key → Recipe_Items_Info.ID — NOT NULL
  • waferid
  • Lotno
  • x-axis
  • y-axis

SoCinfo (Controller)

  • id (s_id) — Primary key — NOT NULL
  • 이름 (name) — char
  • Rev (s_rev) — char

TestInfo

  • ID (t_id) — Primary key — NOT NULL
  • id (e_id) — Foreign key → Equipmentinfo.id — NOT NULL
  • ID (recipe_id) — Foreign key → RecipeInfo.ID — NOT NULL
  • 시작날짜 (s_date)
  • 종료날짜 (e_date)
  • Testin (Input) — int
  • Pass (p_count) — int
  • Fail (f_count) — int
  • Yield — float

TestResults_sample (TestResults_Sample)

  • ID (t_r_s_id) — Primary key — NOT NULL
  • ID (ssd_id) — Foreign key → SSDinfo.ID — NOT NULL
  • ID (t_id) — Foreign key → TestInfo.ID — NOT NULL
  • TB No. (tb_no)
  • Dut No. (dut_no)
  • Results (results)