간식

테이블 (4)

map_snack_item_additive

  • id — BIGINT — 기본 키 — NOT NULL
  • created_by — VARCHAR(255)
  • created_at — TIMESTAMP
  • modified_by — VARCHAR(255)
  • modified_at — TIMESTAMP
  • snack_item_id — BIGINT — NOT NULL
  • snack_additive_id — BIGINT — NOT NULL

snack

  • id — BIGINT — 기본 키 — NOT NULL
  • created_by — VARCHAR(255)
  • created_at — TIMESTAMP
  • modified_by — VARCHAR(255)
  • modified_at — TIMESTAMP
  • barcode — VARCHAR(255)
  • snack_type — VARCHAR(255)
  • name — VARCHAR(255)
  • company — VARCHAR(255)
  • total_serving_size — VARCHAR(255)
  • thumbnail_url — VARCHAR(255)
  • main_image_url — VARCHAR(255)
  • allergy_list — jsonb
  • safe_food_mark_list — jsonb

snack_additive

  • id — BIGINT — 기본 키 — NOT NULL
  • created_by — VARCHAR(255)
  • created_at — TIMESTAMP
  • modified_by — VARCHAR(255)
  • modified_at — TIMESTAMP
  • korean_name — VARCHAR(255)
  • english_name — VARCHAR(255)
  • main_use_list — jsonb
  • grade — VARCHAR(255)
  • description — VARCHAR(2048)
  • stability_message — VARCHAR(2048)

snack_item

  • id — BIGINT — 기본 키 — NOT NULL
  • created_by — VARCHAR(255)
  • created_at — TIMESTAMP
  • modified_by — VARCHAR(255)
  • modified_at — TIMESTAMP
  • snack_id — BIGINT — 외래 키 → snack.id
  • item_name — VARCHAR(255)
  • serving_size — VARCHAR(255)
  • service_unit — VARCHAR(255)
  • calorie — VARCHAR(255)
  • nutrient_list — jsonb