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)