PersonalSpringProjec
Tables (3)
Health (health)
- 넘버링 (no) — number(7,0) — Primary key — NOT NULL
- 아이디 (id) — varchar2(20) — Foreign key → Members.아이디 — NOT NULL
- 운동이름 (pname) — varchar2(10)
- 무게 (weight) — number(3,0)
- 개수 (count) — number(3,0)
- 날짜 (createdate) — date
Members (members)
- 아이디 (id) — varchar2(20) — Primary key — NOT NULL
- 비밀번호 (pswd) — varchar2(10)
- 성명 (name) — varchar2(10)
- 이메일 (email) — varchar2(50)
- 가입일 (joindate) — date
- 최근로그인 (logindate) — date
- 구분 (type) — char(1)
Weather (weather)
- Key — Primary key — NOT NULL