보건소 자율점검

테이블 (9)

selfcheck_answer (답지)

  • Field10
  • Field8 — int
  • Field9 — varchar2(50)
  • Field — int
  • (Field3) — char(1)
  • Field4
  • Field7

selfcheck_bifurcation (분기테이블)

  • bc_no (Key) — int — 기본 키 — NOT NULL
  • bc_title (Field) — varchar2(100)
  • bc_Sdate (Field2) — varchar2(50)
  • bc_Edate (Field3) — varchar2(50)
  • bc_date (Field4) — varchar2(50)

selfcheck_class (기관코드)

  • cl_no (Key) — int — 기본 키 — NOT NULL
  • cl_name (Field) — varchar2(50)

selfcheck_question (문항)

  • qs_num (Field2) — int — 기본 키
  • Key — 기본 키 — NOT NULL
  • qc_no (Field9) — int — 외래 키 → selfcheck_question_category.qc_no
  • qs_type (Field) — char(1)
  • qs_question (Field3) — varchar2(200)
  • Field5
  • Field4
  • Field6

selfcheck_question_category (설문지 카테고리)

  • qc_no (Field) — int — 기본 키
  • qg_no (Key) — int — 외래 키 → selfcheck_question_group.qg_no — NOT NULL
  • qc_name (Field2) — varchar2(50)

selfcheck_question_group (문항 그룹(설문지))

  • qg_no (Key) — int — 기본 키 — NOT NULL
  • bc_no (Field2) — int
  • cl_no (Field3) — int
  • qg_name (Field) — varchar2(50)

selfcheck_question_info (문항 정보)

  • Field2 — varchar2(500)
  • Field3 — varchar2(1000)
  • Field4 — varchar2(100)

selfcheck_user (설문기관)

  • Field7 — int
  • Field
  • Field2
  • Field3 — int
  • Field4
  • Field6

selfcheck_user_info (Untitled)

  • Field2
  • Field