test

Tables (6)

ACTIVITY

  • activity_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • laundry — NUMBER(10)
  • dish — NUMBER(10)
  • vacuum — NUMBER(10)
  • sleep_num — NUMBER(10)
  • sleep_qual_awake — NUMBER(10)
  • sleep_qual_rem — NUMBER(10)
  • sleep_qual_core — NUMBER(10)
  • sleep_qual_deep — NUMBER(10)
  • steps — NUMBER(10)
  • created_at — DATE — NOT NULL

AFFORDABILITY

  • user_affordability_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • activity_id — NUMBER(10) — NOT NULL
  • user_affordability — NUMBER(10)
  • user_affordability_level — NUMBER(10)

DIARY

  • diary_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • diary_title — VARCHAR2(100) — NOT NULL
  • diary_context — VARCHAR2(500) — NOT NULL
  • created_at — DATE — NOT NULL

FILE

  • file_num — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • file_path — VARCHAR2(100) — NOT NULL
  • created_at — DATE — NOT NULL

SKIN

  • skin_id — NUMBER(10) — NOT NULL
  • file_num — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • skin_age — NUMBER(10) — NOT NULL
  • skin_type — NUMBER(10) — NOT NULL
  • skin_wrinkle — NUMBER(10) — NOT NULL
  • skin_pores — NUMBER(10) — NOT NULL
  • skin_blackhead — NUMBER(10) — NOT NULL
  • skin_acne — NUMBER(10) — NOT NULL
  • skin_sensitivity — NUMBER(10) — NOT NULL
  • skin_melanin — NUMBER(10) — NOT NULL
  • skin_water — NUMBER(10) — NOT NULL
  • skin_rough — NUMBER(10) — NOT NULL
  • skin_dark_circle — NUMBER(10) — NOT NULL
  • total_score — NUMBER(10) — NOT NULL

USER

  • user_id — NUMBER(10) — NOT NULL
  • user_pw — VARCHAR2(50) — NOT NULL
  • user_name — VARCHAR2(50) — NOT NULL
  • user_email — VARCHAR2(100) — NOT NULL
  • user_gender — VARCHAR2(1)