간식
테이블 (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