tanghulu ice cream
Tables (6)
tb_ice_cream_bowl
- id — int — Primary key — NOT NULL
- levelId — int — Foreign key → tb_ice_cream_level.id — NOT NULL
- name — varchar(255)
- type — int — 0 = inedible 1 = edible default = 0
- width — int
- height — int
- size — int
- imagePath — varchar(255)
- orderIndex — int
- status — int
- eatingWidth — int
- eatingHeight — int
- eatingSize — int
- eatingImagePath — mediumText — NOT NULL — nullable if bowl type = 1 use this coulmn
- eatingSound — varchar(255) — nullable if type === 1 use this coulmn
tb_ice_cream_container
- id — int — Primary key — NOT NULL
- foodId — int — Foreign key → tb_ice_cream_food.id — NOT NULL
- containerImage — varchar(255)
- lockedContainerImage — varchar(255)
- containerLeft — int
- containerBottom — nt
- containerWidth
- containerHeight
- containerSize — int
tb_ice_cream_food
- id — int — Primary key — NOT NULL
- levelId — int — Foreign key → tb_ice_cream_level.id — NOT NULL
- name — varchar(255)
- status — int
- rewardAmount — int
- gaugeAmount (gauageAmount) — int — reward amount of gauge when eat ice cream
- scoopingSound — varchar(255)
- iceCreamImage — mediumText — when user complete the scoop total 5 image in a column
- iceCreamWidth — varchar(255)
- iceCreamHeight — varchar(255)
- iceCreamSize — varchar(255)
- eatingSound — varchar(255)
- toppingImage — varchar(255)
- toppingLocation — mediumText — location of topping like [{id:1, x: 100, y:100}, id:2, x: 120, y:140},...]
- emoji — varchar(255)
- chewingImage — varchar(255)
- chewingSound — varchar(255)
- chewingDuration — int
- startedAt — Date
tb_ice_cream_food_translation
- id — Primary key — NOT NULL
- iceCreamId — int — Foreign key → tb_ice_cream_food.id — NOT NULL
- languageCode — varchar(255)
- name — varchar(255)
tb_ice_cream_level
- id — int — Primary key — NOT NULL
- name — varchar(255) — for manage
- itemType — enum — 0 = bowl 1 = ice cream deafult = 0
- orderIndex — int
- status — int — 0 = off 1 = on
- targetGauge — int
- iconImage — varchar(255)
tb_user_ice_cream_level
- id — int — Primary key — NOT NULL
- levelId — int — Foreign key → tb_ice_cream_level.id — NOT NULL
- uid — int
- currentGauge — int — when current gauge reach or over targetGauge, change isUnlocked = true
- isUnlocked — boolean