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