UtoNH_cwj

Tables (13)

TB_CARDIO7

  • CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • DT — datetime — NOT NULL
  • ECG_FILENAME — nvarchar(1000)
  • NURSE_NOTE — nvarchar(max)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_CHART

  • CH_CD — int — Primary key — NOT NULL
  • RS_CD — int — NOT NULL
  • CH_DT — datetime — NOT NULL
  • USER_CD — int — NOT NULL
  • OPINION — nvarchar(max)
  • VISIT_CD — smallint — NOT NULL
  • IMSI — bit
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_JAWON

  • CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • DT — datetime
  • NIBP_MAX — decimal(3, 0)
  • NIBP_MIN — decimal(3, 0)
  • PULSE — decimal(3, 0)
  • NURSE_NOTE — nvarchar(max)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • TEMP — decimal(4, 1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_MOARIN

  • CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • DT — datetime
  • PULSE — decimal(3, 0)
  • SpO2 — decimal(3, 0)
  • RESP — decimal(3, 0)
  • NIBP_MAX — decimal(3, 0)
  • NIBP_MIN — decimal(3, 0)
  • ECG_FILENAME — nvarchar(1000)
  • NURSE_NOTE — nvarchar(max)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • TEMP — decimal(4, 1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_NURSENOTE

  • CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • DT — datetime — NOT NULL
  • NURSE_NOTE — nvarchar(max) — NOT NULL
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_PATIENT

  • P_CD — int — Primary key — NOT NULL
  • P_NM — nvarchar(50) — NOT NULL
  • BIRTH_DT — datetime
  • HSPT_CD — smallint — NOT NULL
  • BLOOD — varchar(2)
  • RH — varchar(1)
  • SEX — varchar(1)
  • REMARK — nvarchar(1000)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • P_IBSO_GB — varchar(1)
  • P_SITE — nvarchar(30)
  • P_ROOM — nvarchar(30)
  • P_RELIGION_NM — nvarchar(50)
  • P_IPSO_DT — datetime
  • P_IPSO_TM — nvarchar(10)
  • P_GRADE — nvarchar(1)
  • P_YOYANG — nvarchar(30)
  • P_EXPIRE_ST — datetime
  • P_EXPIRE_ED — datetime
  • P_ADDRESS — nvarchar(100)
  • P_JUMIN — nvarchar(14)
  • MEDICINE — nvarchar(1000)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_PATIENT_FILE

  • CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • DT — datetime — NOT NULL
  • FILENAME — nvarchar(500) — NOT NULL
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • RS_CD — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_PATIENT_NOTE

  • P_NOTE_CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • USER_CD — int — NOT NULL
  • PATIENT_NOTE — nvarchar(max)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_RS_REJECT

  • RS_REJECT_CD — int — Primary key — NOT NULL
  • RS_CD — int
  • USER_CD — int — NOT NULL
  • REJECT_DT — datetime — NOT NULL
  • REJECT_SAYU — nvarchar(max)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_SOMETECH

  • CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • DT — datetime — NOT NULL
  • SOMETECH_FILENAME — nvarchar(1000)
  • NURSE_NOTE — nvarchar(max)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_SUGAR

  • CD — int — Primary key — NOT NULL
  • P_CD — int — NOT NULL
  • DT — datetime
  • BEFORE_SUGAR — smallint
  • AFTER_SUGAR — smallint
  • NURSE_NOTE — nvarchar(max)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_TDRUG

  • DRUG_CD — int — Primary key — NOT NULL
  • DRUG_NM — nvarchar(500) — NOT NULL
  • BOHUM_CD — varchar(20)
  • COMPANY — nvarchar(100)
  • PERMISSION_DT — varchar(10)
  • JUNMUN_CD — smallint
  • SUNGSANG — nvarchar(500)
  • STD_CD — nvarchar(50)
  • SUNGBUN — nvarchar(500)
  • DANWI — nvarchar(200)
  • SINGO — nvarchar(1)
  • COMPANY_NO — nvarchar(10)
  • STATUS_CD — smallint
  • CANCEL_DT — varchar(10)
  • CHANGE_DT — varchar(10)
  • CHONG — nvarchar(500)
  • DEL — bit
  • INPUT_USER_CD — int
  • INPUT_DT — datetime
  • UPDATE_USER_CD — int
  • UPDATE_DT — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_TDRUG_JUNMUN

  • JUNMUN_CD — smallint — Primary key — NOT NULL
  • JUNMUN_NM — nvarchar(50) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =