yaksokERD

Tables (13)

disease

  • id — BIGINT
  • sick_name — VARCHAR(255)

ingredient

  • id — BIGINT
  • ingredient_name — VARCHAR(255)
  • min_intake_value — DECIMAL
  • max_intake_value — DECIMAL
  • display_unit — VARCHAR(255)

intake_record

  • id — BIGINT
  • user_product_id — BIGINT — Foreign key → user_product.id — NOT NULL
  • taken — BOOLEAN — NOT NULL
  • intake_date — DATE — NOT NULL
  • created_at — DATETIME

notification

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • user_product_id — BIGINT — Foreign key → user_product.id — NOT NULL
  • intake_time — TIME
  • enabled — BOOLEAN
  • isTaken — BOOLEAN
  • category — VARCHAR(255)
  • created_at — DATETIME

notification_log

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • user_product_id — BIGINT — Foreign key → user_product.id
  • notification_type — VARCHAR(255)
  • sent_at — DATETIME

notification_setting

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • quiet_start — DATETIME — NOT NULL
  • quiet_end — DATETIME — NOT NULL
  • enabled — BOOLEAN

product

  • id — BIGINT
  • PRDLST_NM — VARCHAR(255)
  • PRIMARY_FNCLTY — TEXT
  • NTK_MTHD — TEXT
  • IFTKN_ATNT_MATR_CN — TEXT

product_ingredient

  • id — BIGINT
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.id — NOT NULL
  • ingredient_amount — DECIMAL
  • amount_unit — VARCHAR(255)

shedlock

  • name — VARCHAR(64) — Primary key — NOT NULL
  • lock_until — TIMESTAMP(3) — NOT NULL
  • locked_at — TIMESTAMP(3) — NOT NULL
  • locked_by — VARCHAR(255) — NOT NULL

user

  • id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • role — VARCHAR(255)
  • oauth_provider — VARCHAR(255)
  • oauth_id — VARCHAR(255)
  • status — VARCHAR(255)
  • last_login_at — DATETIME
  • age_group — VARCHAR(255)
  • gender — VARCHAR(255)
  • created_at — DATETIME

user_disease

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • disease_id — BIGINT — Foreign key → disease.id — NOT NULL

user_fcm_token

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • platform — VARCHAR(50)
  • active — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

user_product

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • product_id — BIGINT — Foreign key → product.id
  • nickname — VARCHAR(255)
  • daily_dose — INT
  • dose_amount — DECIMAL
  • dose_unit — VARCHAR(255)
  • active — BOOLEAN
  • created_at — DATETIME