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