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)