data

Tables (5)

Ingredient_master (Untitled)

  • id (Key) — Primary key — NOT NULL
  • kr_name (Field) — string
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

ingredient_history (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • ingredient_master_id (Key2) — Foreign key → Ingredient_master.id — NOT NULL
  • name (Field) — string
  • platform (Field4) — enum
  • language (Field5) — string
  • platform_ingredient_code (Field2) — string
  • is_active (Field7) — boolean
  • created_at (Field3) — datetime
  • updated_at (Field6) — datetime

ingredient_variants (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • ingredient_history_id (Key22) — Foreign key → ingredient_history.ingredient_master_id — NOT NULL
  • name (Field) — string
  • is_active (Field4) — boolean
  • platform (Field5) — string
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

t_kcia_ingt_list (Untitled4)

  • kcia_rawcno (Field) — bigint
  • kcia_rawcdk (Field2) — string
  • kcia_rawcde (Field3) — string
  • kcia_ingt_list (Field4) — stirng
  • kcia_rawcdk_old (Field5) — string
  • kcia_rawcde_old (Field6) — string
  • kcia_inci_changed_date (Field7) — timestamp

t_vh_raw_element_master (Untitled5)

  • compid (Field) — string
  • version (Field2) — smallint
  • rawcno (Field3) — decimal
  • rawcdk (Field4) — string
  • rawcde (Field5) — string
  • logtim (Field6) — timestamp
  • rawcdk_old (Field7) — string
  • rawcde_old (Field8) — string
  • addtim (Field9) — timestamp