madalicious
Tables (6)
Copy Of Untitled2 (ma_cluster_info)
- Key (clusterid) — varchar — Primary key — NOT NULL — 클러스터인덱스
- Key (learnid) — varchar — Foreign key → Untitled.Key — NOT NULL — 모델학습로그 인덱스
- Field (clusterNum) — int — 클러스터번호
- Field (usersCount) — int — 학습구매자수
- Field2 (gender) — int — 성별
- Field3 (birthplace) — int — 출생지
- Field4 (birthyear) — int — 생년
- Field5 (active) — int — 운동량
- Field (alcohol) — int — 음주량
- Field2 (eatLate) — int — 야식량
- Field3 (forever_1) — int — 영원음식1
- Field4 (forever_2) — int — 영원음식2
- Field5 (friendRec) — int — 친구추천
- Field7 (tasteHouse) — int — 맛집헌팅
- Field6 (quanOrQual) — int — 양또는질
- Field (delicious) — int — NOT NULL — 맛있는
- Field (sweet) — int — NOT NULL — 달달한
- Field (spicy) — int — NOT NULL — 매콤한
- Field (salty) — int — NOT NULL — 짭잘한
- Field (healthy) — int — NOT NULL — 건강한
- Field (sweetnsalty) — int — NOT NULL — 단짠단짠
- Field (sweetnsour) — int — NOT NULL — 새콤달콤
- Field (salivate) — int — NOT NULL — 입맛돋구는
- Field (umami) — int — NOT NULL — 감칠맛
- Field (foreign) — int — NOT NULL — 이국적인
- Field (korean) — int — NOT NULL — 한국적인
- Field (exotic) — int — NOT NULL — 이색적인
- Field (creative) — int — NOT NULL — 창의적인
- Field (trendy) — int — NOT NULL — 트렌디
- Field (refreshing) — int — NOT NULL — 신선한
- Field (seasonal) — int — NOT NULL — 제철음식
- Field (cool) — int — NOT NULL — 시원한
- Field (spicy2) — int — NOT NULL — 얼큰한
- Field (fire) — int — NOT NULL — 불맛
- Field (plentiful) — int — NOT NULL — 푸짐한
- Field (korean2) — int — NOT NULL — 한식
- Field (chinese) — int — NOT NULL — 중식
- Field (japanese) — int — NOT NULL — 일식
- Field2 (european) — int — 양식
- Field3 (vietnamese) — int — 베트남
- Field4 (siamese) — int — 타이
- Field5 (southeast) — int — 동남아
- Field6 (italian) — int — 이탈리아
- Field7 (spainish) — int — 스페인
- Field (barfood) — int — 안주
- Field (vegetarian) — int — 채식
- Field (salad) — int — 샐러드
- Field (vegan) — int — 비건
- Field (diet) — int — 다이어트
- Field (wellbing) — int — 웰빙
- Field (meathead) — int — 육식
- Field (heavy) — int — 헤비
- Field (light) — int — 가벼운
- Field (withwine) — int — 와인페어링
- Field (hmr) — int — HMR
- Field (fingerfood) — int — 핑거푸드
- Field (homemade) — int — 직접조리
- Field (eatrightaway) — int — 바로섭취
- Field (simplecooking) — int — 간편조리
- Field (ricecake) — int — 떡류
- … +32
Untitled (ma_user_data)
- Key (uid) — varchar — Primary key — NOT NULL — 유저id
- Field (gender) — int — NOT NULL — 성별, 0~1
- Field (birthplace) — int — NOT NULL — 출생지, 0~9
- Field (birthyear) — int — NOT NULL — 생년월일, YYYY
- Field (active) — int — NOT NULL — 운동량, 0~2
- Field (alcohol) — int — NOT NULL — 음주량, 0~2
- Field (eatLate) — int — NOT NULL — 야식량, 0~2
- Field (forever_1) — int — NOT NULL — 영원음식1, 0~4
- Field (forever_2) — int — NOT NULL — 영원음식2, 0~4
- Field (friendRec) — int — NOT NULL — 친구추천, 0~1
- Field (tasteHouse) — int — NOT NULL — 맛집헌팅, 0~2
- Field (quanOrQual) — int — NOT NULL — 양또는질, 0~1
- Field (registerDt) — varchar — 데이터등록일자
Untitled (ma_order_data)
- Key (index) — varchar — Primary key — NOT NULL — 주문인덱스
- Key (uid) — varchar — Foreign key → Untitled.Key — NOT NULL — 유저id
- Key (pid) — varchar — Foreign key → Untitled.Key — NOT NULL — 메뉴id
- Field (oid) — varchar — NOT NULL — 주문식별자
- Field (serveDate) — varchar — NOT NULL — 구매확정일자
Untitled (ma_item_data)
- Key (pid) — varchar — Primary key — NOT NULL — 메뉴id
- Field (registerDt) — varchar — 데이터등록일자
- Field (delicious) — int — NOT NULL — 맛있는
- Field (sweet) — int — NOT NULL — 달달한
- Field (spicy) — int — NOT NULL — 매콤한
- Field (salty) — int — NOT NULL — 짭잘한
- Field (healthy) — int — NOT NULL — 건강한
- Field (sweetnsalty) — int — NOT NULL — 단짠단짠
- Field (sweetnsour) — int — NOT NULL — 새콤달콤
- Field (salivate) — int — NOT NULL — 입맛돋구는
- Field (umami) — int — NOT NULL — 감칠맛
- Field (foreign) — int — NOT NULL — 이국적인
- Field (korean) — int — NOT NULL — 한국적인
- Field (exotic) — int — NOT NULL — 이색적인
- Field (creative) — int — NOT NULL — 창의적인
- Field (trendy) — int — NOT NULL — 트렌디
- Field (refreshing) — int — NOT NULL — 신선한
- Field (seasonal) — int — NOT NULL — 제철음식
- Field (cool) — int — NOT NULL — 시원한
- Field (spicy2) — int — NOT NULL — 얼큰한
- Field (fire) — int — NOT NULL — 불맛
- Field (plentiful) — int — NOT NULL — 푸짐한
- Field (korean2) — int — NOT NULL — 한식
- Field (chinese) — int — NOT NULL — 중식
- Field (japanese) — int — NOT NULL — 일식
- Field2 (european) — int — 양식
- Field3 (vietnamese) — int — 베트남
- Field4 (siamese) — int — 타이
- Field5 (southeast) — int — 동남아
- Field6 (italian) — int — 이탈리아
- Field7 (spainish) — int — 스페인
- Field (barfood) — int — 안주
- Field (vegetarian) — int — 채식
- Field (salad) — int — 샐러드
- Field (vegan) — int — 비건
- Field (diet) — int — 다이어트
- Field (wellbing) — int — 웰빙
- Field (meathead) — int — 육식
- Field (heavy) — int — 헤비
- Field (light) — int — 가벼운
- Field (withwine) — int — 와인페어링
- Field (hmr) — int — HMR
- Field (fingerfood) — int — 핑거푸드
- Field (homemade) — int — 직접조리
- Field (eatrightaway) — int — 바로섭취
- Field (simplecooking) — int — 간편조리
- Field (ricecake) — int — 떡류
- Field (rice) — int — 밥류
- Field (flour) — int — 면/만두류
- Field (porridge) — int — 죽류
- Field (guktang) — int — 국/탕류
- Field (jjigae) — int — 찌개류
- Field (steamed) — int — 찜류
- Field (grilled) — int — 구이류
- Field (stirfried) — int — 볶음류
- Field (deepfried) — int — 튀김류
- Field (herbs) — int — 나물/무침류
- Field (kimchi) — int — 김치류
- Field (sashimi) — int — 회류
- Field (saucy) — int — 양념류
- … +19
Untitled (ma_learning_log)
- Key (learnid) — varchar — Primary key — NOT NULL — 모델학습로그 인덱스
- Field (learnDt) — varcahr — 학습일자
- Field2 (clusterCount) — int — 클러스터개수
- Field3 (serveDateMin) — varchar — 학습데이터 구매확정일자 최소값
- Field (serveDateMax) — varchar — 학습데이터 구매확정일자 최대값
Untitled (ma_curation_log)
- Key (curationid) — varchar — Primary key — NOT NULL — 상품추천로그 인덱스
- Key (pid) — varchar — Foreign key → Untitled.Key — NOT NULL — 메뉴id
- Key (uid) — varchar — Foreign key → Untitled.Key — NOT NULL — 유저id
- Key (clusterid) — varchar — Foreign key → Copy Of Untitled2.Key — NOT NULL — 클러스터인덱스
- Key (learnid) — varchar — Foreign key → Copy Of Untitled2.Key — NOT NULL — 모델학습로그 인덱스
- Field (recommended) — varchar — 추천여부
- Field (recDt) — varchar — 추천일자
- Field (userNew) — varcahr — 신규고객여부
- Field (itemNew) — varcahr — 신규상품여부