질병예측

테이블 (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)