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