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