Health_Routine

Tables (4)

comments

  • comment_id — BIGINT
  • routine_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

likes

  • like_id — BIGINT
  • routine_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

routines

  • routine_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • routine_date — DATE — NOT NULL
  • sleep_hours — DECIMAL(3,1)
  • exercise_type — VARCHAR(30)
  • exercise_minutes — INT
  • meals — VARCHAR(1000)
  • water_ml — INT
  • note — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50)
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL