no_rawat varchar(17)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
Mostrar los valores foráneos id_tb_03 varchar(30)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
id_periode_laporan enum --
1=Januari - Maret
2=April - Juni
3=Juli - September
4=Oktober - Desember
tanggal_buat_laporan datetime
CURRENT_DATE
CURRENT_TIME
DATE
FROM_DAYS
FROM_UNIXTIME
LAST_DAY
NOW
SEC_TO_TIME
SYSDATE
TIME
TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
YEAR
--------
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_USER
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
TAN
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
tahun_buat_laporan year(4)
CURRENT_DATE
CURRENT_TIME
DATE
FROM_DAYS
FROM_UNIXTIME
LAST_DAY
NOW
SEC_TO_TIME
SYSDATE
TIME
TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
YEAR
--------
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_USER
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
TAN
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
kd_wasor int(11)
ABS
ACOS
ASCII
ASIN
ATAN
BIT_LENGTH
BIT_COUNT
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
HOUR
INET6_ATON
INET_ATON
LENGTH
LN
LOG
LOG2
LOG10
MICROSECOND
MINUTE
MONTH
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SIGN
SIN
SQRT
TAN
TO_DAYS
TO_SECONDS
TIME_TO_SEC
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
--------
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
FROM_DAYS
FROM_UNIXTIME
HEX
INET6_NTOA
INET_NTOA
LAST_DAY
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
NOW
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SEC_TO_TIME
SHA1
SOUNDEX
SPACE
SYSDATE
TIME
TIMESTAMP
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
VERSION
YEAR
noregkab int(11)
ABS
ACOS
ASCII
ASIN
ATAN
BIT_LENGTH
BIT_COUNT
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
HOUR
INET6_ATON
INET_ATON
LENGTH
LN
LOG
LOG2
LOG10
MICROSECOND
MINUTE
MONTH
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SIGN
SIN
SQRT
TAN
TO_DAYS
TO_SECONDS
TIME_TO_SEC
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
--------
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
FROM_DAYS
FROM_UNIXTIME
HEX
INET6_NTOA
INET_NTOA
LAST_DAY
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
NOW
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SEC_TO_TIME
SHA1
SOUNDEX
SPACE
SYSDATE
TIME
TIMESTAMP
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
VERSION
YEAR
id_propinsi varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
kd_kabupaten varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
id_kecamatan varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
id_kelurahan varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
nama_rujukan enum --
Inisiatif pasien/Keluarga
Anggota Masyarakat/Kader
Faskes
Dokter Praktek Mandiri
Poli lain
Lain-lain
sebutkan1 varchar(100)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
tipe_diagnosis enum --
Terkonfirmasi bakteriologis
Terdiagnosis klinis
klasifikasi_lokasi_anatomi enum --
Paru
Ekstraparu
klasifikasi_riwayat_pengobatan enum --
Baru
Kambuh
Diobati setelah gagal
Diobati Setelah Putus Berobat
Lain-lain
Riwayat Pengobatan Sebelumnya Tidak Diketahui
Pindahan
klasifikasi_status_hiv enum --
Positif
Negatif
Tidak diketahui
total_skoring_anak enum --
1
2
3
4
5
6
7
8
9
10
11
12
13
Tidak dilakukan
konfirmasiSkoring5 enum --
Uji Tuberkulin Positif
Ada Kontak TB Paru
Uji Tuberkulin Negatif
Tidak Ada Kontak TB Paru
konfirmasiSkoring6 enum --
Ada Kontak TB Paru
Tidak Ada
Tidak Jelas Kontak TB Paru
tanggal_mulai_pengobatan date
CURRENT_DATE
CURRENT_TIME
DATE
FROM_DAYS
FROM_UNIXTIME
LAST_DAY
NOW
SEC_TO_TIME
SYSDATE
TIME
TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
YEAR
--------
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_USER
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
TAN
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
paduan_oat varchar(500)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
sumber_obat enum --
Program TB
Bayar Sendiri
Asuransi
Lain-lain
sebutkan varchar(500)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
sebelum_pengobatan_hasil_mikroskopis enum --
Negatif
1-19
1+
2+
3+
Tidak dilakukan
sebelum_pengobatan_hasil_tes_cepat enum --
Rif sensitif
Rif resisten
Negatif
Rif Indeterminated
Invalid
Error
No Result
Tidak dilakukan
sebelum_pengobatan_hasil_biakan enum --
Negatif
1-19 BTA
1+
2+
3+
4+
NTM
Kontaminasi
Tidak dilakukan
noreglab_bulan_2 varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
hasil_mikroskopis_bulan_2 enum --
Negatif
1-19
1+
2+
3+
Tidak dilakukan
noreglab_bulan_3 varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
hasil_mikroskopis_bulan_3 enum --
Negatif
1-19
1+
2+
3+
Tidak dilakukan
noreglab_bulan_5 varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
hasil_mikroskopis_bulan_5 enum --
Negatif
1-19
1+
2+
3+
Tidak dilakukan
akhir_pengobatan_noreglab varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
akhir_pengobatan_hasil_mikroskopis enum --
Negatif
1-19
1+
2+
3+
Tidak dilakukan
tanggal_hasil_akhir_pengobatan date
CURRENT_DATE
CURRENT_TIME
DATE
FROM_DAYS
FROM_UNIXTIME
LAST_DAY
NOW
SEC_TO_TIME
SYSDATE
TIME
TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
YEAR
--------
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_USER
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
TAN
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
hasil_akhir_pengobatan enum --
Belum
Sembuh
Pengobatan Lengkap
Lost To Follow Up
Meninggal
Gagal
Pindah
tanggal_dianjurkan_tes date
CURRENT_DATE
CURRENT_TIME
DATE
FROM_DAYS
FROM_UNIXTIME
LAST_DAY
NOW
SEC_TO_TIME
SYSDATE
TIME
TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
YEAR
--------
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_USER
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
TAN
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
tanggal_tes_hiv date
CURRENT_DATE
CURRENT_TIME
DATE
FROM_DAYS
FROM_UNIXTIME
LAST_DAY
NOW
SEC_TO_TIME
SYSDATE
TIME
TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
YEAR
--------
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_USER
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
TAN
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
hasil_tes_hiv enum --
Reaktif
Non Reaktif
Indeterminated
ppk enum --
Ya
Tidak
art enum --
Ya
Tidak
tb_dm enum --
Ya
Tidak
terapi_dm enum --
OHO
Inj. Insulin
pindah_ro enum --
Ya
Tidak
status_pengobatan enum --
Sesuai Standar
Tidak Sesuai Standar
foto_toraks enum --
Positif
Negatif
Tidak Dilakukan
toraks_tdk_dilakukan enum --
Tidak dilakukan
Setelah terapi antibioka non OAT: tidak ada perbaikan Klinis, ada faktor resiko TB, dan atas pertimbangan dokter
Setelah terapi antibioka non OAT: ada Perbaikan Klinis
keterangan varchar(100)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
kode_icd_x varchar(15)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
Mostrar los valores foráneos