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