skin

Tables (14)

Untitled

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

boards

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100)

calendar_tasks

  • cal_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • task_date — DATE
  • title — VARCHAR(255)
  • description — VARCHAR(500)
  • is_completed — BOOLEAN

chat_messages

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • sender — VARCHAR(50)
  • message — TEXT
  • created_at — DATETIME

comments

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → posts.id
  • user_id — INT — Foreign key
  • content — TEXT
  • created_at — DATETIME

diagnosis_metrics

  • id — INT — Primary key — NOT NULL
  • diagnosis_record_id — INT — Foreign key → diagnosis_records.id
  • label — VARCHAR(100)
  • value — INT

diagnosis_recommendations

  • diagnosis_record_id — INT — Foreign key → diagnosis_records.id — NOT NULL
  • product_id — INT — Foreign key → products.id — NOT NULL

diagnosis_records

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • diagnosis_type_id — INT — Foreign key → diagnosis_types.id
  • image_url — VARCHAR(500)
  • score — INT
  • grade — VARCHAR(50)
  • created_at — DATETIME

diagnosis_types

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • description — VARCHAR(500)
  • icon — VARCHAR(500)

post_likes

  • user_id — INT — Foreign key — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL

posts

  • id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → boards.id
  • user_id — INT — Foreign key
  • title — VARCHAR(255)
  • content — TEXT
  • view_count — INT
  • like_count — INT
  • created_at — DATETIME

products

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • image_url — VARCHAR(500)
  • category — VARCHAR(100)

skin_score_logs

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • log_date — DATE
  • score — INT

users