알고케어백엔드

테이블 (78)

AlgocareUser

  • id — PK — 기본 키 — NOT NULL
  • email
  • Field2 (secondary_email)
  • Field2 (name)
  • Field3 (phone)
  • Field4 (signup_date)
  • Field5 (is_admin)
  • Field6 (is_superuser)
  • Field (is_active)
  • Field2 (did_login)
  • Field3 (did_take_basic_ask)
  • Field4 (user_type)
  • Field5 (sex)
  • Field7 (birthday)
  • Field8 (signup_type)
  • Field (privacy_policy)
  • Field2 (terms_condition)
  • Field3 (push_notification)
  • Field4 (push_token)
  • Field5 (last_action_time)
  • Field (profile_img)
  • Field (is_sub_user)
  • Field (sub_user_code) — unique
  • Field (number_of_intake)
  • Field (basic_doses)
  • Field (card_infos)
  • Field (drugs)

Copy Of Copy Of Copy Of Untitled5 (DispensingDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (nutrient) — 외래 키 → Untitled.Key — NOT NULL
  • Field (dose)

Copy Of Copy Of Copy Of Untitled6 (DispensingHistory-DispensingDose)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (dispensing_dose) — PK — 외래 키 → Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL

Copy Of Copy Of Copy Of Untitled7 (DispensingCartridgeDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (cartridge) — 외래 키 → Untitled.Key — NOT NULL
  • Field (num_of_beads)

Copy Of Copy Of Copy Of Untitled8 (DispensingHistory-ChangeCartridgeDose)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (change_cartridge_dose) — PK — 외래 키 → Untitled.Key — NOT NULL

Copy Of Copy Of Untitled5 (SplitDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (nutrient) — 외래 키 → Untitled.Key — NOT NULL
  • Field (dose)

Copy Of Copy Of Untitled6 (DispensingHistory-SplitDose)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (split_dose) — PK — 외래 키 → Copy Of Copy Of Untitled5.Key — NOT NULL

Copy Of Copy Of Untitled7 (ChangeCartridgeDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (cartridge) — 외래 키 → Untitled.Key — NOT NULL
  • Field (num_of_beads)

Copy Of Copy Of Untitled8 (DispensingHistory-DispensingCartridgeDose)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (dispensing_cartridge_dose) — PK — 외래 키 → Untitled.Key — NOT NULL

Copy Of Untitled (Factory)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (address)

Copy Of Untitled2 (CartCartirdgeLineUp)

  • Key (cartridge_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (cart_item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity)

Copy Of Untitled3 (CartDeviceLineUp)

  • Key (device_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (cart_item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity)

Copy Of Untitled4 (LabelIngredient)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)

Copy Of Untitled5 (ChangeDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (nutrient) — 외래 키 → Untitled.Key — NOT NULL
  • Field (dose)

Copy Of Untitled6 (DispensingHistory-ChangeDose)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (change_dose) — PK — 외래 키 → Copy Of Untitled5.Key — NOT NULL

Copy Of Untitled7 (SplitCartridgeDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (cartridge) — 외래 키 → Untitled.Key — NOT NULL
  • Field (num_of_beads)

Copy Of Untitled8 (DispensingHistory-SplitCartridgeDose)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (split_cartridge_dose) — PK — 외래 키 → Copy Of Untitled7.Key — NOT NULL

Untitled (DeviceLog)

  • Key (device) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (id2) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (log_type)
  • Field (log)

Untitled (BasicReport)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (archived_time)
  • Field (json_file) — ?
  • Field (vs) — ?

Untitled (ScheduleJob)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (type)
  • Field (title)
  • Field (contents)
  • Field (next_path)
  • Field (reservation_time)

Untitled (MonthlyReport)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (year)
  • Field (month)
  • Field (json_file) — ?
  • Field (vs) — ?

Untitled (Notification)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (title)
  • Field (contents)
  • Field (next_path)
  • Field (created_time)
  • Field (is_read)

Untitled (Drug-Ingridient)

  • Key (drug) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (ingridient) — PK — 외래 키 → Untitled.Key — NOT NULL

Untitled (DNILabel)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)

Untitled (Ingridient)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)

Untitled (Drug)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)

Untitled (CartItem)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Key (item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (total_money)

Untitled (AS)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Key (device) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (id2) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (as_type)
  • Field (as_content)
  • Field (engineer) — PK
  • Field (status)
  • Field (created_time)
  • Field (completed_time)

Untitled (DispensingHistory-BasicCartridgeDose)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (basic_cartridge_dose) — PK — 외래 키 → Untitled.Key — NOT NULL

Untitled (OrderItem)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (order) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (total_money)

Untitled (OrderCartirdgeLineUp)

  • Key (order_item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (cartridge_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity)

Untitled (OrderDeviceLineUp)

  • Key (order_item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (device_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity)

Untitled (OrderPolicy)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (exchange_policy)
  • Field (refund_policy)
  • Field (delivery_policy)

Untitled (UserDrugInfo)

  • id (user) — 외래 키 → AlgocareUser.id — NOT NULL
  • Key (drug) — 외래 키 → Untitled.Key — NOT NULL
  • Field (period)

Untitled (Ingredient-LabelIngredient)

  • Key (ingredient) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (lable_ingredient) — PK — 외래 키 → Copy Of Untitled4.Key — NOT NULL

Untitled (LabelIngredient-DNILabel)

  • Key (label_ingredient) — PK — 외래 키 → Copy Of Untitled4.Key — NOT NULL
  • Key (dni_label) — PK — 외래 키 → Untitled.Key — NOT NULL

Untitled (DrugDetail)

  • Key — 기본 키 — NOT NULL
  • Field (drug_name)
  • Field (drug_id)
  • Field (ingredient_names)
  • Field (label_ingredient_names)
  • Field (label_names)

Untitled (BasicDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (nutrient) — 외래 키 → Untitled.Key — NOT NULL
  • Field (dose)

Untitled (DispensingHistory-BasicDose)

  • Key (baisc_dose) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL

Untitled (BasicCartridgeDose)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (cartridge) — 외래 키 → Untitled.Key — NOT NULL
  • Field (num_of_beads)

Untitled (NutrientRatioInfo)

  • Key (nutrient) — 외래 키 → Untitled.Key — NOT NULL
  • Key (nutrient_group) — 외래 키 → Untitled.Key — NOT NULL
  • Field (ratio)
  • Field2 (is_representative)

Untitled (DeviceLineUp-Warehouse)

  • Key (device_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (warehouse) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (stock)

Untitled (DeviceLineUp)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (title)
  • Field (warehouses)
  • Field (factories)
  • Field (color)
  • Field (model_id)

Untitled (CartridegeLineUp-Factory)

  • Key (cartridge_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (factory) — PK — 외래 키 → Copy Of Untitled.Key — NOT NULL

Untitled (CartridgeLineUp-Warehouse)

  • Key (cartridge_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (warehouse) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (stock)

Untitled (Warehouse)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (address)

Untitled (Cartridge)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (cartridge_line_up) — 외래 키 → Untitled.Key — NOT NULL
  • Field (amount_of_remainder)
  • Field (is_opened)
  • Field (serial_number)
  • Field (sku_number)
  • Field (expiration_date)
  • Field (mounting_date_time)

Untitled (CartridgeLineUp)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (nutrient_group) — 외래 키 → Untitled.Key — NOT NULL
  • Field (title)
  • Field (amount)
  • Field (warehouses)
  • Field (factories)

Untitled (Notice)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (title)
  • Field2 (content)
  • Field3 (order)
  • Field4 (is_used_app)
  • Field5 (is_used_shop)
  • Field6 (created_time)
  • Field7 (modified_time)
  • Field (hits)
  • Field (is_hidden)

Untitled (FAQ)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (title)
  • Field2 (content)
  • Field3 (order)
  • Field4 (is_used_app)
  • Field5 (is_used_shop)
  • Field (is_used_device)
  • Field6 (created_time)
  • Field7 (modified_time)
  • Field (is_hidden)

Untitled (DeviceLineUp-Factory)

  • Key (device_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (factory) — PK — 외래 키 → Copy Of Untitled.Key — NOT NULL

Untitled (NutrientGroup)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (nutrients)
  • Field (order)

Untitled (Nutrient)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (description)
  • Field3 (unit)
  • Field4 (minimum_dose)
  • Field5 (maximum_dose)
  • Field6 (amount_per_bead)
  • Field (icon)

Untitled (BodyCondition-BodyConditionGroup)

  • Key (body_copndition_group) — 외래 키 → Untitled.Key — NOT NULL
  • Key (body_condition) — 외래 키 → Untitled.Key — NOT NULL

Untitled (BodyConditionGroup)

  • Key (id) — 기본 키 — NOT NULL
  • Field (name)
  • Field (order)
  • Field (conditions)

Untitled (BodyCondition)

  • Key (id) — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (description)
  • Field3 (order)
  • Field4 (icon)

Untitled (BodyConditionOfUser)

  • Key (id) — 기본 키 — NOT NULL
  • id (user) — 외래 키 → AlgocareUser.id — NOT NULL
  • Key (body_condition) — 외래 키 → Untitled.Key — NOT NULL
  • Field (order)
  • Field2 (count)

Untitled (LoginHistory)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (host)
  • Field2 (agent)
  • Field3 (login_time)

Untitled (PhoneAuth)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (phone)
  • Field2 (verification_code)
  • Field3 (is_authenticated)
  • Field4 (authentication_time)
  • Field5 (expired_time)

Untitled (DeliveryDetail)

  • Key (order) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (recipient_name)
  • Field (postcode)
  • Field (address)
  • Field (phone)
  • Field (memo)
  • Field (company_anme)
  • Field (traking_number)

Untitled (PaymentSchedule)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Key (order) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (amount)
  • Field (total_times)
  • Field (remain_times)
  • Field (payment_day)

Untitled (CardInfo-Device)

  • Key (card_info) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (device) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (id2) — PK — 외래 키 → Untitled.Key — NOT NULL

Untitled (Device)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (device_line_up) — 외래 키 → Untitled.Key — NOT NULL
  • Key (firmware) — 외래 키 → Untitled.Key — NOT NULL
  • Field (users)
  • Field (cartideges)
  • Field (serial_number) — unique
  • Field (sku_number)

Untitled (CardInfo)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (devices)
  • Field (card_number)
  • Field (expire_date)
  • Field (billing_key)
  • Field (cvc)
  • Field (owner_name)

Untitled (IntakeInfo)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (nutrient_group) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (basic_dose)
  • Field (delta_dose)

Untitled (DispensingHistory-BodyCondition)

  • Key (dispensing_history) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (body_condition) — PK — 외래 키 → Untitled.Key — NOT NULL

Untitled (DispensingHistory)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — 외래 키 → AlgocareUser.id — NOT NULL
  • Key (device) — 외래 키 → Untitled.Key — NOT NULL
  • Field (dispensing_time)
  • Field (dispensing_date)
  • Field (split_dispensing_number)
  • Field (dispensing_number)
  • Field (selected_body_conditions)
  • Field (basic_dose_list)
  • Field (split_dose_list)
  • Field (change_dose_list)
  • Field (dispensing_dose_list)

Untitled (AlgocareInfo)

  • Key (id) — 기본 키 — NOT NULL
  • Field (representative)
  • Field (corp_registration_number)
  • Field (address)
  • Field (security_officer_name)
  • Field (tele_sales_number)

Untitled (PaymentInfo)

  • Key (order) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (type)
  • Field (account_number)
  • Field (bank_name)
  • Field (card_number)
  • Field (owner_name)
  • Field (expire_date)
  • Field (cvc)
  • Field (is_completed)

Untitled (CS)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (responder) — PK
  • Field2 (question)
  • Field (answer)
  • Field (created_time)

Untitled (Order)

  • Key (id) — PK — 기본 키 — NOT NULL
  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Field (total_money)
  • Field (order_date)
  • Field (status)
  • Field (items)

Untitled (Item-DeviceLineUp)

  • Key (item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (device_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (price)
  • Field (discount)
  • Field (sales)

Untitled (Item-CartridgeLineUp)

  • Key (item) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (cartridge_line_up) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (price)
  • Field (discount)
  • Field (sales)

Untitled (Item)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Field (name)
  • Field (goods_type)
  • Field (cartridge_line_ups)
  • Field (device_line_ups)
  • Field (contents)
  • Field (hits)
  • Field (thumbnail)

Untitled (Transportation)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (from) — 외래 키 → Copy Of Untitled.Key — NOT NULL
  • Key (to) — 외래 키 → Untitled.Key — NOT NULL
  • Key (device_line_up) — 외래 키 → Untitled.Key
  • Key (cartridge_line_up) — 외래 키 → Untitled.Key
  • Field (cargo_type)
  • Field (stock)
  • Field (departure_time)
  • Field (arrival_time)

Untitled (Firmware)

  • Key (id) — PK — 기본 키 — NOT NULL
  • Key (device_line_up) — 외래 키 → Untitled.Key — NOT NULL
  • Field (version)
  • Field (description)
  • Field (file)
  • Field (file_size)
  • Field (is_deployed)
  • Field (update_date)
  • Field (deploy_date)

Untitled (User-Device)

  • id (user) — PK — 외래 키 → AlgocareUser.id — NOT NULL
  • Key (device) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (id2) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (nickname)

Untitled (Device-Cartridge)

  • Key (device) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (cartridge) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (id2) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (slot_number)