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 — 신규상품여부