likelion3
Tables (9)
activity_records
- activity_record_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- routine_item_id — BIGINT — Foreign key → routine_items.routine_item_id — NOT NULL
- content — TEXT
- actual_value — DECIMAL(10, 2)
- image_url — VARCHAR(1000)
- status — VARCHAR(30) — NOT NULL
- ai_feedback — TEXT
- performed_at — DATETIME — NOT NULL
analyses
- analysis_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- analysis_type — VARCHAR(50) — NOT NULL
- summary — TEXT
- details — JSON
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
curricula
- market_item_id — BIGINT — Foreign key → market_items.market_item_id — NOT NULL
- expert_id — BIGINT — Foreign key → experts.user_id — NOT NULL
- category — VARCHAR(100) — NOT NULL
- difficulty — VARCHAR(30)
- duration_days — INT
- description — TEXT
- content_url — VARCHAR(1000)
experts
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- specialty — VARCHAR(100) — NOT NULL
- qualification_info — TEXT — NOT NULL
- evidence_url — VARCHAR(1000)
- introduction — TEXT
- verification_status — VARCHAR(30) — NOT NULL
- applied_at — DATETIME — NOT NULL
health_records
- health_record_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- metric_type — VARCHAR(50) — NOT NULL
- metric_value — DECIMAL(10, 2) — NOT NULL
- unit — VARCHAR(30) — NOT NULL
- input_source — VARCHAR(50) — NOT NULL
- measured_at — DATETIME — NOT NULL
market_items
- market_item_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- item_type — VARCHAR(50) — NOT NULL
- price — DECIMAL(12, 2) — NOT NULL
- provider_name — VARCHAR(200)
- image_url — VARCHAR(1000)
- purchase_url — VARCHAR(1000)
- status — VARCHAR(30) — NOT NULL
personalized_routines
- personalized_routine_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- source_curriculum_id — BIGINT — Foreign key → curricula.market_item_id
- title — VARCHAR(200) — NOT NULL
- goal — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
routine_items
- routine_item_id — BIGINT — Primary key — NOT NULL
- personalized_routine_id — BIGINT — Foreign key → personalized_routines.personalized_routine_id — NOT NULL
- item_type — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- scheduled_at — DATETIME
- target_value — DECIMAL(10, 2)
- target_unit — VARCHAR(30)
- sequence — INT — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- health_goal — TEXT
- created_at — DATETIME — NOT NULL