HealthCare

테이블 (4)

사용자 (user)

  • Key (USER_ID) — VARCHAR(255) — 기본 키 — NOT NULL
  • Field (PASSWORD) — VARCHAR(255)
  • Field (EMAIL) — VARCHAR(255)
  • Field (NAME) — VARCHAR(255)
  • Field (PHONE_NUM) — VARCHAR(255)
  • Field (AGE) — NUMBER(20)
  • Field (ADDR) — VARCHAR(255)

운동 (EXERCISE)

  • Key (E_NO) — NUMBER(20) — 기본 키 — NOT NULL
  • Key (USER_ID2) — VARCHAR(255) — 외래 키 → 사용자.Key — NOT NULL
  • Field (TYPE) — VARCHAR(255)
  • Field (CNT) — NUMBER(20)
  • Field (END_TIME) — TIMESTAMP DEFAULT CURRENT_TIMESTAMP

월별 랭킹 VIEW (EX_MONTH_BEST_CNT)

  • Key (E_NO) — NUMBER(20) — 외래 키 → 운동.Key — NOT NULL
  • Field (USER_ID) — VARCHAR(255)
  • Field (TYPE) — VARCHAR(255)
  • Field (CNT) — NUMBER(20)
  • Field (END_TIME) — TIMESTAMP DEFAULT CURRENT_TIMESTAMP

지병 (DISEASE)

  • Field (TYPE) — VARCHAR(255)