DUUUUIT

Tables (20)

app_body_shapes

  • id — TinyInt( 0 ) — Primary key — NOT NULL — ID as same No.
  • petType — Enum( 'DOG', 'CAT' ) — NOT NULL
  • bcsThinImg — BigInt( 0 ) — Thin: 야윈 상태 (File id)
  • bcsUnderweightImg — BigInt( 0 ) — Underweight: 저체중 (File id)
  • bcsProperWeightImg — BigInt( 0 ) — Proper weight: 적정체중 (File id)
  • bcsOverweightImg — BigInt( 0 ) — overweight: 과체중 (File id)
  • bcsObesityImg — BigInt( 0 ) — obesity: 비만 (File id)
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL

app_images

  • id — TinyInt( 0 ) — Primary key — NOT NULL — ID as same No.
  • processMakingPreparationImg — BigInt( 0 ) — making preparation: img file uploaded at here is showed on app page 5-1 (File id)
  • processMachineSettingImg — BigInt( 0 ) — machine setting: img file uploaded at here is showed on app page 5-2 (File id)
  • processSmartPhoneImg — BigInt( 0 ) — smart phone: img file uploaded at here is showed on app page 5-3 (File id)
  • processMachineConnectingImg — BigInt( 0 ) — machine connecting step: img file uploaded at here is showed on app page 5-4 (File id)
  • processMachineConnectedImg — BigInt( 0 ) — machine connecting complete: img file uploaded at here is showed on app page 5-5 (File id)
  • sensorSeperateFeedBowlImg — BigInt( 0 ) — seperate the feed bowl: 사료그릇 분리 related on App SB 8-3-1 page (File id)
  • sensorBowlOutBackImg — BigInt( 0 ) — bowlput the bowl back: 그릇 재장착 related on App SB 8-3-2 page (File id)
  • sensorFillingFeedImg — BigInt( 0 ) — filling the feed: 사료 담기 related on App SB 8-4-1 page (File id)
  • sensorFeedDischargeCalculateImg — BigInt( 0 ) — feed discharging amount calculation: 사료 토출량 계산 related on App SB 8-4-2 page (File id)
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL

app_informations

  • id — TinyInt( 0 ) — Primary key — NOT NULL — ID as same No.
  • urlTermsServiceEn — VarChar( 255 ) — Url about terms of use for language English
  • urlTermsServiceKr — VarChar( 255 ) — Url about terms of use for language Korea
  • urlPrivacyPolicyEn — VarChar( 255 ) — Url about privacy policy for language English
  • urlPrivacyPolicyKr — VarChar( 255 ) — Url about privacy policy for language Korea
  • urlReceptionAgreementEn — VarChar( 255 ) — Url about promotion reception agreement for language English
  • urlReceptionAgreementKr — VarChar( 255 ) — Url about promotion reception agreement for language Korea
  • urlDuitGuideEn — VarChar( 255 ) — Url Duit Guide Settings agreement for language English
  • urlDuitGuideKr — VarChar( 255 ) — Url Duit Guide Settings agreement for language Korea
  • urlDuitErrorGuideEn — VarChar( 255 ) — Url Duit Error Guide Settings agreement for language English
  • urlDuitErrorGuideKr — VarChar( 255 ) — Url Duit Error Guide Settings agreement for language Korea
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL

birthday_coupons

  • id — TinyInt( 0 ) — Primary key — NOT NULL — ID as same No.
  • dailyTime — Time — NOT NULL — daily sending time: input (hour & minute)
  • beforeBDay — TinyInt( 0 ) — input (default: 14days) (max 2 number each input field) => beforeBDay How many days ago before the birthday should I se…
  • couponCode — VarChar( 255 ) — coupon code input(birthday coupon Input)
  • titleKr — VarChar( 255 ) — birthday celebration title input(Korean) : this data will show on app page 4-5
  • titleEn — VarChar( 255 ) — birthday celebration title input(English) : this data will show on app page 4-5
  • descriptionKr — MediumText — birthday celebration message input(Korean): this data will show on app page 4-5
  • descriptionEn — MediumText — birthday celebration message input(Korean): this data will show on app page 4-5
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL

contents

  • id — Int( 0 ) — Primary key — NOT NULL — ID as same No., auto increment, not null
  • titleEn — VarChar( 255 ) — NOT NULL — Title content for language English
  • titleKr — VarChar( 255 ) — NOT NULL — Title content for language Korea
  • urlWebView — MediumText — NOT NULL — Url webview
  • imageThumbnail — BigInt( 0 ) — NOT NULL — Image thumbnail content
  • isShow — TinyInt( 1 ) — Display or hidden on app , if 0 (false) is hidden, if 1(true) is display
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

devices

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID of device, auto increment, not null
  • name — VarChar( 255 ) — NOT NULL — Name of device, input to user
  • version — VarChar( 50 ) — Version firmware of device
  • serialNumber — VarChar( 255 ) — NOT NULL — Serial number of device
  • ledLight — TinyInt( 0 ) — LED light on device
  • powerStatus — TinyInt( 1 ) — Power status of device, default off (off = false(0), on = true(1))
  • almMelodyFeedingTime — TinyInt( 1 ) — Device alarm: (melody ON/OFF) - (melody OFF: ‘melody on feeding time is turned off ), default off (off = false(0), on =…
  • almFeedingFail — TinyInt( 1 ) — Device alarm: (feeding fail ON/OFF) - (feeding fail Alarm OFF: ‘feeding fail alarm is turned off’), default off (off =…
  • almFeedShortage — TinyInt( 1 ) — Device alarm: (feed shortage alarm ON/OFF) - (feed shortage Alarm OFF: ‘ feed shortage alarm is turned off’), default o…
  • almNotEating — TinyInt( 1 ) — Device alarm: (not eating Alarm off: ON/OFF) - (not eating Alarm off: “{petName} not eating alarm is turned off”), defa…
  • almDischargeComplete — TinyInt( 1 ) — Device alarm: (discharge complete alarm ON/OFF) - (discharge complete alarm OFF: the discharge complete alarm is turned…
  • almEatingComplete — TinyInt( 1 ) — Device alarm: (eating complete ON/OFF) - (eating complete alarm OFF: “the alarm ‘the dog ate feed all’ is turned off”),…
  • almBowlWashing — TinyInt( 1 ) — Device alarm: (bowl washing alarm ON/OFF) - (bowl washing alarm OFF: “bowl washing alarm is turned off” ), default off…
  • petId — BigInt( 0 ) — Which pet? It is pet ID
  • ownerId — BigInt( 0 ) — NOT NULL — Owner device
  • status — Enum( 'STEP1', 'STEP2', 'STEP3', 'STEP4' ) — Status of device (STEP1, STEP2, STEP3, STEP4)
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

diseases

  • id — Int( 0 ) — Primary key — NOT NULL — ID of disease, auto increment, not null
  • parentId — Int( 0 ) — Category parent, 0 is the large category, non-zero is the small category
  • nameEn — VarChar( 255 ) — NOT NULL — Name for language English
  • nameKr — VarChar( 255 ) — NOT NULL — Name for language Korea
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

files

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID of file, auto increment, not null
  • userId — BigInt( 0 ) — NOT NULL — Created by?, user id
  • type — VarChar( 255 ) — NOT NULL — File type (jpg, jpeg, png, gif, ...)
  • bucket — VarChar( 255 ) — NOT NULL — Bucket on AWS S3
  • url — VarChar( 255 ) — NOT NULL — URL file from AWS S3
  • key — VarChar( 255 ) — NOT NULL — Key save on AWS S3
  • filename — VarChar( 255 ) — NOT NULL — Name of file
  • size — Int( 0 ) — NOT NULL — Name of file
  • status — Enum( 'PENDING', 'USED' ) — NOT NULL — Status of file (PENDING, USED)
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

food_allergies

  • parentId — Int( 0 ) — Primary key — NOT NULL — ID of allergy, auto increment, not null
  • nameEn — VarChar( 255 ) — NOT NULL — Name for language English
  • nameKr — VarChar( 255 ) — NOT NULL — Name for language Korea
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

notices

  • id — Int( 0 ) — Primary key — NOT NULL — ID as same No., auto increment, not null
  • title — VarChar( 255 ) — NOT NULL — Title notice
  • description — MediumText — NOT NULL — Description notice
  • isShow — TinyInt( 1 ) — Display or hidden on app, if 0 (false) is hidden, if 1(true) is display
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

notifications

  • id — NOT — Primary key — NOT NULL
  • type — NOT — NOT NULL
  • ownerId — NOT — NOT NULL
  • data — NOT — NOT NULL
  • status — NOT — NOT NULL
  • createdAt — NOT — NOT NULL
  • updatedAt — NOT — NOT NULL
  • deletedAt — NOT — NOT NULL

pet_diseases

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID as same No., auto increment, not null
  • petId — BigInt( 0 ) — NOT NULL — Which pet?, pet id
  • userId — BigInt( 0 ) — NOT NULL — Owner pet, user id
  • diseaseId — Int( 0 ) — NOT NULL — Which disease?, Disease id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL

pet_food_allergies

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID as same No., auto increment, not null
  • petId — BigInt( 0 ) — NOT NULL — Which pet?, pet id
  • userId — BigInt( 0 ) — NOT NULL — Owner pet, user id
  • foodAllergyId — Int( 0 ) — NOT NULL — Which food allergy?, Food allergy id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL

pet_foods

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID as same No., auto increment, not null
  • feedName — VarChar( 255 ) — NOT NULL — Food name (feed name)
  • crudeProteinPercent — float — Percent crude protein
  • crudeFatPercent — float — Percent crude fat
  • crudeFiberPercent — float — Percent crude fiber
  • crudeContentPercent — float — Percent crude content
  • moisturePercent — float — Percent moisture
  • etcPercent1 — float — Percent etc1
  • etcPercent2 — float — Percent etc2
  • etcPercent3 — float — Percent etc3
  • etcPercent4 — float — Percent etc4
  • createdBy — BigInt( 0 ) — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

pet_timers

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID as same No., auto increment, not null
  • petId — BigInt( 0 ) — NOT NULL — Which pet?, pet id
  • userId — BigInt( 0 ) — NOT NULL — Owner pet and device, user id
  • deviceId — BigInt( 0 ) — NOT NULL — Which device?, Device id
  • timer — Time — NOT NULL — Feeding timer
  • daySession — Enum( 'MORNING', 'AFTERNOON', 'EVENING', 'NIGHT' ) — NOT NULL — Session(MORNING, AFTERNOON, EVENING, NIGHT) of the day
  • amountBeforeEat — Int( 0 ) — Amount before pet eat
  • amountAfterEat — Int( 0 ) — Amount after pet eat
  • isEat — TinyInt( 1 ) — Is pet eat?, if 0(false) pet is eat, 1(true) is pet not eat
  • createdHow — Enum( 'AUTO', 'CUSTOM' ) — Feeding timer create by auto or custom by user (AUTO, CUSTOM)
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL

pets

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID of pet, auto increment, not null
  • avatar — BigInt( 0 ) — Avatar of pet
  • petType — Enum( 'DOG', 'CAT' ) — NOT NULL — What is the type of pet?
  • name — VarChar( 255 ) — NOT NULL — Name of device, input to user
  • varietyId — Int( 0 ) — what variety?, ID table variety
  • foodId — BigInt( 0 ) — what food?, ID table food
  • caloriesDaily — float — calories daily for pet
  • birthday — DateTime — birthday for pet
  • gender — Enum( 'MALE', 'FEMALE' ) — Gender of pet
  • isNeuter — TinyInt( 1 ) — Castrated or not castrated, if 0 is not yet, 1 is castrated
  • weight — float — Weight for pet
  • amountDischargeAVG — float — Amount discharge AVG for pet
  • deviceId — BigInt( 0 ) — Which device? It is device ID
  • ownerId — BigInt( 0 ) — NOT NULL — Owner pet
  • status — Enum( 'STEP1', 'STEP2', 'STEP3', 'STEP4', 'STEP5' ) — Status of pet (STEP1, STEP2, STEP3, STEP4, STEP5)
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime
  • petId — BigInt( 0 )

sessions

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID of session, auto increment, not null
  • userId — BigInt( 0 ) — NOT NULL — ID of user, not null
  • deviceToken — MediumText — NOT NULL — Token Device get from firebase, not null
  • deviceType — Enum( 'ANDROID', 'IOS', 'MAC', 'LINUX', 'WINDOWS', 'UNKNOWN' ) — NOT NULL — Device type when login by on app of which device(ANDROID, IOS, MAC, LINUX, WINDOWS, UNKNOWN), not null
  • ipAddress — VarChar( 255 ) — Address at login
  • location — VarChar( 255 ) — Location at login
  • language — Enum( 'EN', 'KR' ) — NOT NULL — Language setting on app
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

shops

  • id — Int( 0 ) — Primary key — NOT NULL — ID as same No., auto increment, not null
  • titleEn — VarChar( 255 ) — NOT NULL — Title shop for language English
  • titleKr — VarChar( 255 ) — NOT NULL — Title shop for language Korea
  • urlWebView — MediumText — NOT NULL — Url webview
  • imageThumbnail — BigInt( 0 ) — NOT NULL — Image thumbnail shop
  • isShow — TinyInt( 1 ) — Display or hidden on app , if 0 (false) is hidden, if 1(true) is display
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

users

  • id — BigInt( 0 ) — Primary key — NOT NULL — ID of user, not null
  • clientId — VarChar( 255 ) — Is the user ID returned when logging in with a social account(GOOGLE | KAKAOTALK | NAVER | APPLE), can null
  • accountType — Enum( 'DUIT', 'KAKAOTALK', 'NAVER', 'GOOGLE', 'APPLE' ) — NOT NULL — Is an account type, it is scraped out when registering a Duit account(DUIT) or logging into a social account(GOOGLE, KA…
  • memberCode — VarChar( 255 ) — User code: When make user pk, use random numbers and English characters. Example: AS456
  • fullname — VarChar( 255 ) — Full name of user, can null
  • email — VarChar( 255 ) — NOT NULL — Email of user, not null
  • password — VarChar( 255 ) — Password of user, can null
  • gender — Enum( 'MALE', 'FEMALE', 'ETC' ) — Gender of user (MALE. FEMALE, ETC), can null
  • age — TinyInt( 0 ) — Age of user, can null
  • birthday — DateTime — Birthday of user, can null
  • phone — VarChar( 50 ) — Contact of user, can null
  • role — Enum( 'ADMIN', 'MANAGER', 'USER' ) — NOT NULL — Role of user (ADMIN, MANAGER, USER)
  • totalDevices — Int( 0 ) — Total device of user
  • isUseMarketCondition — TinyInt( 1 ) — Marketing Usage Agreement Terms and Conditions, default off (off = false(0), on = true(1))
  • lastDateAccessApp — DateTime — Last time to access application
  • notiMarketing — TinyInt( 1 ) — Marketing alarm agreement: push noti or no - default off (off = false(0), on = true(1))
  • notiBirthdayCoupon — TinyInt( 1 ) — Birthday coupon alarm agreement: push noti or no - default off (off = false(0), on = true(1)
  • notiNotice — TinyInt( 1 ) — Notice system alarm agreement: push noti or no - default off (off = false(0), on = true(1)
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

varieties

  • id — Int( 0 ) — Primary key — NOT NULL — ID of varieties, auto increment, not null
  • nameEn — VarChar( 255 ) — NOT NULL — Name for language English
  • nameKr — VarChar( 255 ) — NOT NULL — Name for language Korea
  • petType — Enum( 'DOG', 'CAT' ) — NOT NULL — Type pet (dog or cat)
  • createdBy — BigInt( 0 ) — NOT NULL — Created by who, it is user id
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime