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 — =