Member

Attribute member_id sex age password name
Type Long int int String String
Example 123456 M = 1 F = 0 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 egg topping spicy
Type Long Long String String String String String int
Example 123456 123456 “그냥”, “2개로 분리” “쫄깃하게”, “부드럽게” “안 넣음”, “마늘”, “고추”, “파” “안 넣음”, “완숙”, “반숙”, “풀어서” “안 넣음”, “치즈”, “떡”, “만두”, “닭가슴살”, “김치” 0 ~ 5

Like

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