설문조사
테이블 (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)