질병예측
테이블 (13)
community (Untitled8)
- community ID (community_id) — int — 기본 키 — NOT NULL
- community Name (name) — varchar(50)
community participant (Untitled10)
- commuity id (community_id) — int — 기본 키 — NOT NULL
- user_id — varchar(30) — 기본 키 — NOT NULL
community post (Untitled7)
- post_id — int — 기본 키 — NOT NULL
- community ID (community_id) — int — 기본 키 — NOT NULL
- title — varchar(100)
- content — text
- upload date (date) — Date
- Field
community post comments (Untitled9)
- commnet ID (comment_id) — int — 기본 키 — NOT NULL
- post_id — int — 기본 키 — NOT NULL
- community_id — int — 기본 키 — NOT NULL
- comment — text
- comment date (date) — date
- user ID (user_id) — varchar(30)
disease (Untitled)
- oid — int — 기본 키 — NOT NULL
- disease name (name) — varchar(50)
- category — varchar(50)
- Symptom (symptom) — text
- complications — text
- department — varchar(30)
disease statistics (Untitled3)
- oid — int — 기본 키 — NOT NULL
- disease name (name) — varchar(50)
- age — int
- month — varchar(10)
- gender — varchat(10)
- number of patient (patient_number) — int
family (Untitled11)
- user_id — varchar(30) — 기본 키 — NOT NULL
- family_name — varchar(30) — 기본 키 — NOT NULL
- nick name (nick__name) — varchar(50)
- approval — boolean
news (Untitled4)
- oid — int — 기본 키 — NOT NULL
- title — varchar(100)
- date — Date
- content — text
- keyword — text
- link — varchar(100)
population (Untitled5)
- code — int — 기본 키 — NOT NULL
- administrative division (name) — varchar(50)
- population — int
possibility of outbreak (Untitled6)
- oid — int — 기본 키 — NOT NULL
- diseasename (disease_name) — varchar(50)
- gender — varchat(10)
- age — int
- month — varchar(10)
- residence — varchar(30)
- percentage — float
- Field
statistics per residence (Untitled2)
- oid — int — 기본 키 — NOT NULL
- disease name (name) — varchar(50)
- residence — varchar(30)
- number of patients (patient_number) — int
underlying disease
- oid — int — 기본 키 — NOT NULL
- underlying disease (underlying_disease) — varchar(50) — 기본 키 — NOT NULL
user (User)
- 아이디 (user_id) — varchar(30) — 기본 키 — NOT NULL — 아이디
- 비밀번호 (password) — varchar(50)
- 이름 (user_name) — varchar(30)
- 생년월일 (birthday) — Date
- 성별 (gender) — varchat(10)
- 거주지 (residence)