설문조사

테이블 (3)

DISEASE (Untitled2)

  • DISEASE_NAME — varchar2(30) — 기본 키 — NOT NULL
  • TYPE — varchar2(10)
  • COUNT — number

MEMBER (Untitled)

  • ID — varhcar2(30) — 기본 키 — NOT NULL
  • PW — varchar2(20)
  • NAME — varchar2(20)
  • AGE — number
  • PHONE — varchar2(30)
  • TYPE — varchar2(10)
  • DISEASE_NAME — varchar2(30)

SURVEY_RESULT (Untitled3)

  • NUM — number — 기본 키 — NOT NULL
  • ID — varhcar2(30) — 외래 키 → MEMBER.ID — NOT NULL
  • DISEASE_NAME — varchar2(30) — 외래 키 → DISEASE.DISEASE_NAME — NOT NULL
  • TYPE — varchar2(10)