Member

Attribute member_id sex age password name
Type Long String int String String
Example 123456 “M”, “F” 28 hash value 김동일

Ramen

Attribute ramen_id sample_id name english_name brand survey_year noodle code
Type Long String String String String int String String
Example 123456 P072751-ZZ-AVG 김치왕뚜껑 Kimchi Wang Tukong 팔도 2021 유탕면 P035524

Composition

Attribute composition_id ramen_id raw boiled fried non_fried liquid powder
Type Long Long TINYINT TINYINT TINYINT TINYINT TINYINT TINYINT
Example 123456 123456 0 or 1 0 or 1 0 or 1 0 or 1 0 or 1 0 or 1
Attribute seasoning soup cup cold jjajang
Type TINYINT TINYINT TINYINT TINYINT TINYINT
Example 0 or 1 0 or 1 0 or 1 0 or 1 0 or 1

Nutrient

Attribute nutrient_id ramen_id volume kcal lipid(지질, g) carbo(탄수화물, g)
Type Long Long Double Double Double Double
Example 123456 123456 130 6.82 18.75 68.16
sugar(총당류, mg) sodium(나트륨, mg) cholesterol(mg) saturated_fat(포화 지방, g) trans_fat(트랜스 지방, g)
Double Double Double Double Double
7.2 962.84 0 9.37 0

Fond

Attribute fond_id member_id noodle_length noodle_texture ingredient_none ingredient_galic ingredient_pepper ingredient_green_onion egg topping_none topping_cheese topping_tteok topping_dumpling spicy
Type Long Long String String Boolean Boolean Boolean Boolean String Boolean int
Example 123456 123456 “그냥”, “2개로 분리” “쫄깃하게”, “부드럽게” “안 넣음”, “완숙”, “반숙”, “풀어서” 0 ~ 5

Like

Attribute like_id member_id ramen_id
Type Long Long Long
Example 123456 123456 123456