알고케어백엔드
테이블 (78)
AlgocareUser
- id — PK — 기본 키 — NOT NULL
- 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)