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