Database

SQL File

Lihat detail pada card Trello ini.

Cara Backup dan Restore

Backup

Untuk backup database production, sudah tersedia cron job yang berjalan otomatis setiap hari pada pukul 23.00 WIB. File backup akan tersimpan di folder: /home/{username}/klinikarsaya_backup_db/.

• Login ke cPanel > Advanced > Cron Jobs untuk melihat daftar cron yang berjalan.
• Login ke cPanel > File Manager > Home > klinikarsaya_backup_db untuk melihat daftar file backup.

Restore

Langkah-langkah restore database:

1. Drop semua tabel pada database yang akan direstore.
2. Import file SQL yang diinginkan melalui phpMyAdmin.

Visual Structure

Lihat struktur database secara visual melalui dbdiagram.io untuk detail skema.

Structures

Table antrian_asuransi

Kolom	Tipe Data	Atribut
antrian_asuransi_id	bigint(20)	NOT NULL, AUTO_INCREMENT
antrian_pasien_id	bigint(20)	NOT NULL
asuransi_id	bigint(20)	NOT NULL
asuransi_option	varchar(100)	NOT NULL
asuransi_owner_name	varchar(256)	NOT NULL
asuransi_id_number	varchar(256)	NOT NULL
asuransi_model_pembayaran	varchar(256)	NOT NULL
antrian_asuransi_created_at	datetime	NOT NULL
antrian_asuransi_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_antrian_asuransi	( antrian_asuransi_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_antrian_asuransi_asuransi	( asuransi_id ) ref asuransi (asuransi_id)
🔗	fk_antrian_asuransi_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table antrian_pasien

Kolom	Tipe Data	Atribut
antrian_pasien_id	bigint(20)	NOT NULL, AUTO_INCREMENT
parent_antrian_id	bigint(20)	DEFAULT NULL
connected_to_antrian_id	bigint(20)	DEFAULT NULL
pasien_id	bigint(20) unsigned	NOT NULL
doctor_id	bigint(20) unsigned	NOT NULL
receptionist_id	bigint(20) unsigned	NOT NULL
farmasi_id	bigint(20)	DEFAULT NULL
antrian_pasien_created_at	datetime	NOT NULL
antrian_pasien_updated_at	datetime	NOT NULL
status_antrian_pasien_id	int(11)	DEFAULT NULL
antrian_unique_code	varchar(60)	DEFAULT NULL
awal_keluhan_utama	varchar(200)	DEFAULT NULL
is_suspect	int(1)	DEFAULT 0
booking_at	date	DEFAULT NULL
confirmed_booking	int(1)	DEFAULT NULL
doctor_shift	text	DEFAULT NULL
tujuan_klinik	varchar(80)	DEFAULT NULL
timestamps	longtext	DEFAULT NULL, CHARACTER SET utf8mb4_bin
history_antrian	text	DEFAULT NULL
alasan_batal	varchar(255)	DEFAULT NULL
counter_wa_click	varchar(50)	NOT NULL DEFAULT ‘0’
survey	longtext	DEFAULT NULL, CHECK (json_valid(survey))
layanan_included	longtext	DEFAULT NULL, CHECK (json_valid(layanan_included))

Indexes

	Nama Index	Kolom
🔒	pk_antrian_pasien	( antrian_pasien_id )
🔍	unq_antrian_pasien_parent_antrian_id	( parent_antrian_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_antrian_pasien_pasien	( pasien_id ) ref pasien (pasien_id)
🔗	fk_antrian_pasien_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (parent_antrian_id)
🔗	fk_antrian_pasien_antrian_pasien_0	( connected_to_antrian_id ) ref antrian_pasien (parent_antrian_id)
🔗	fk_antrian_pasien_users	( receptionist_id ) ref users (user_id)
🔗	fk_antrian_pasien_users_0	( doctor_id ) ref users (user_id)
🔗	fk_antrian_pasien_users_1	( farmasi_id ) ref users (user_id)
🔗	fk_antrian_pasien_status_antrian_pasien	( status_antrian_pasien_id ) ref status_antrian_pasien (status_antrian_pasien_id)

Check Constraints

• survey → CHECK (json_valid(survey))
• layanan_included → CHECK (json_valid(layanan_included))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table antrian_tumbuh_kembang

Kolom	Tipe Data	Atribut
antrian_tk_id	bigint(20)	NOT NULL, AUTO_INCREMENT
tabungan_id	int(11)	NOT NULL
status	varchar(50)	NOT NULL
next_jadwal	datetime	DEFAULT NULL
data	longtext	DEFAULT NULL, CHECK (json_valid(data))
uraian_tumbang	text	DEFAULT NULL
history_antrian_tk	text	DEFAULT NULL
terapis_id	bigint(20)	DEFAULT NULL
pertemuan_ke	int(3)	DEFAULT NULL
antrian_tk_created_at	datetime	DEFAULT NULL
antrian_tk_updated_at	datetime	NOT NULL DEFAULT current_timestamp()
antrian_tk_completed_at	datetime	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_antrian_tumbuh_kembang	( antrian_tk_id )

Foreign Keys

🔗	fk_antrian_tumbuh_kembang_tabungan	( tabungan_id ) ref tabungan (tabungan_id)
🔗	fk_antrian_tumbuh_kembang_users	( terapis_id ) ref users (user_id)

Check Constraints

• data → CHECK (json_valid(data))

Options

ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

---

Table arsip_pemasukan

Kolom	Tipe Data	Atribut
arsip_pemasukan_id	int(11) unsigned	NOT NULL, AUTO_INCREMENT
date	date	NOT NULL
detail	longtext	NOT NULL, CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
created_at	timestamp	NOT NULL DEFAULT current_timestamp()
updated_at	timestamp	NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Indexes

	Nama Index	Kolom
🔒	pk_arsip_pemasukan	( arsip_pemasukan_id )
🔍	unq_arsip_pemasukan_date	( date )

Options

ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

---

Table arsip_transaksi

Kolom	Tipe Data	Atribut
arsip_transaksi_id	bigint(11) unsigned	NOT NULL, AUTO_INCREMENT
antrian_pasien_id	int(11)	NOT NULL
pembayaran_id	bigint(11)	NOT NULL
date	date	NOT NULL
detail	longtext	NOT NULL, CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
created_at	timestamp	NOT NULL DEFAULT current_timestamp()
updated_at	timestamp	NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Indexes

	Nama Index	Kolom
🔒	pk_arsip_transaksi	( arsip_transaksi_id )
🔍	unq_arsip_transaksi_antrian_pasien_id	( antrian_pasien_id )
🔍	idx_date_pembayaran_id	( date, pembayaran_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_arsip_transaksi_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_arsip_transaksi_pembayaran	( pembayaran_id ) ref pembayaran (pembayaran_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

---

Table asuransi

Kolom	Tipe Data	Atribut
asuransi_id	bigint(20)	NOT NULL, AUTO_INCREMENT
asuransi_name	varchar(100)	DEFAULT NULL
asuransi_legal_name	varchar(100)	DEFAULT NULL
asuransi_contact_name	varchar(100)	DEFAULT NULL
asuransi_contact	varchar(50)	DEFAULT NULL
asuransi_phone	varchar(50)	DEFAULT NULL
asuransi_address	text	DEFAULT NULL
asuransi_notes	text	DEFAULT NULL
asuransi_created_at	datetime	DEFAULT NULL
asuransi_updated_at	datetime	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_asuransi	( asuransi_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table bundle_obat

Kolom	Tipe Data	Atribut
bundle_id	bigint(20)	NOT NULL, AUTO_INCREMENT
nama_bundle	varchar(120)	NOT NULL
kode_bundle	varchar(40)	NOT NULL
deskripsi	varchar(255)	DEFAULT NULL
aktif	varchar(1)	NOT NULL DEFAULT ‘0’
created_at	timestamp	NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
updated_at	timestamp	NOT NULL DEFAULT ‘0000-00-00 00:00:00’

Indexes

	Nama Index	Kolom
🔒	pk_bundle_obat	( bundle_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table bundle_obat_detail

Kolom	Tipe Data	Atribut
bundle_detail_id	bigint(20)	NOT NULL, AUTO_INCREMENT
bundle_id	bigint(20)	NOT NULL
obat_id	bigint(20)	NOT NULL
jumlah	int(11)	NOT NULL DEFAULT 0
diskon	bigint(20)	NOT NULL DEFAULT 0
unit_satuan	varchar(50)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_bundle_obat_detail	( bundle_detail_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_bundle_obat_detail_bundle	( bundle_id ) ref bundle_obat (bundle_id)
🔗	fk_bundle_obat_detail_obat	( obat_id ) ref obat (obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table counter

Kolom	Tipe Data	Atribut
counter_id	bigint(20)	NOT NULL, AUTO_INCREMENT
counter_title	varchar(50)	NOT NULL
counter_desc	varchar(120)	DEFAULT NULL
counter_role	int(11)	NOT NULL
current_counter	int(10) unsigned	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_counter	( counter_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table cronjob

Kolom	Tipe Data	Atribut
id	int(11) unsigned	NOT NULL, AUTO_INCREMENT
name	varchar(50)	DEFAULT NULL
type	varchar(25)	NOT NULL
action	varchar(255)	NOT NULL
environment	varchar(100)	NOT NULL
output	varchar(255)	DEFAULT NULL
error	varchar(255)	DEFAULT NULL
start_at	datetime	NOT NULL
end_at	datetime	NOT NULL
duration	time	NOT NULL
test_time	datetime	DEFAULT NULL
created_at	datetime	NOT NULL DEFAULT current_timestamp()
updated_at	datetime	NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
deleted_at	datetime	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_cronjob	( cronjob_id )
🔍	idx_deleted_at	( deleted_at )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table customer_panel

Kolom	Tipe Data	Atribut
customer_panel_id	int(11)	NOT NULL, AUTO_INCREMENT
nama	varchar(255)	NOT NULL
no_hp	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_customer_panel	( customer_panel_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table diagnosis

Kolom	Tipe Data	Atribut
diagnosis_id	bigint(20)	NOT NULL, AUTO_INCREMENT
diagnosis_id_duplicate	int(11)	NOT NULL
chapter	smallint(5) unsigned	NOT NULL
section	varchar(100)	NOT NULL
descriptions	varchar(255)	NOT NULL
inggris	varchar(150)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_diagnosis	( diagnosis_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table diagnosis_ref

Kolom	Tipe Data	Atribut
diagnosis_ref_id	bigint(20)	NOT NULL, AUTO_INCREMENT
chapter	varchar(50)	NOT NULL
description_en	longtext	NOT NULL
description_ind	longtext	NOT NULL
information	longtext	DEFAULT NULL
category	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_diagnosis_ref	( diagnosis_ref_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table diskon_kasir

Kolom	Tipe Data	Atribut
diskon_kasir_id	bigint(20)	NOT NULL, AUTO_INCREMENT
dk_name	varchar(100)	NOT NULL COMMENT ‘nama diskon’
dk_desc	text	NOT NULL COMMENT ‘deskripsi diskon’
dk_is_active	int(1)	NOT NULL DEFAULT 0
all_tindakan	varchar(1)	NOT NULL DEFAULT ‘0’
all_obat	varchar(1)	NOT NULL DEFAULT ‘0’
all_lab	varchar(1)	NOT NULL DEFAULT ‘0’
all_tumbang	varchar(1)	NOT NULL DEFAULT ‘0’
all_perawat	varchar(1)	NOT NULL DEFAULT ‘0’

Indexes

	Nama Index	Kolom
🔒	pk_diskon_kasir	( diskon_kasir_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table diskon_lab

Kolom	Tipe Data	Atribut
diskon_lab_id	bigint(20)	NOT NULL, AUTO_INCREMENT
diskon_kasir_id	bigint(20)	NOT NULL
lab_id	bigint(20)	DEFAULT NULL
is_vendor	int(1)	NOT NULL DEFAULT 0
is_klinik	int(1)	NOT NULL DEFAULT 0
nilai_lab	varchar(100)	NOT NULL
tipe_nilai_lab	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_diskon_lab	( diskon_lab_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_diskon_lab_tarif_laboratorium	( lab_id ) ref tarif_laboratorium (tl_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table diskon_obat

Kolom	Tipe Data	Atribut
diskon_obat_id	bigint(20)	NOT NULL, AUTO_INCREMENT
diskon_kasir_id	bigint(20)	NOT NULL
obat_id	bigint(20)	DEFAULT NULL
nilai_obat	varchar(100)	NOT NULL
tipe_nilai_obat	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_diskon_obat	( diskon_obat_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_diskon_obat_obat	( obat_id ) ref obat (obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table diskon_perawat

Kolom	Tipe Data	Atribut
diskon_perawat_id	bigint(20)	NOT NULL, AUTO_INCREMENT
diskon_kasir_id	bigint(20)	NOT NULL
tt_id	bigint(20)	NOT NULL
is_klinik	int(1)	NOT NULL DEFAULT 0
is_perawat	int(1)	NOT NULL DEFAULT 0
nilai_perawat	varchar(100)	NOT NULL
tipe_nilai_perawat	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_diskon_perawat	( diskon_perawat_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_diskon_perawat_diskon_kasir	( diskon_kasir_id ) ref diskon_kasir (diskon_kasir_id)
🔗	fk_diskon_perawat_tarif_tindakan	( tt_id ) ref tarif_tindakan (tt_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table diskon_tindakan

Kolom	Tipe Data	Atribut
diskon_tindakan_id	bigint(20)	NOT NULL, AUTO_INCREMENT
diskon_kasir_id	bigint(20)	NOT NULL
tindakan_name	varchar(150)	DEFAULT NULL
is_admin	int(1)	DEFAULT 0
is_perawat	int(1)	NOT NULL DEFAULT 0
is_dokter	int(1)	NOT NULL DEFAULT 0
is_bhp	int(1)	NOT NULL DEFAULT 0
is_harga_jual	int(1)	NOT NULL
nilai_tindakan	varchar(100)	NOT NULL
tipe_nilai_tindakan	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_diskon_tindakan	( diskon_tindakan_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_diskon_tindakan_diskon_kasir	( diskon_kasir_id ) ref diskon_kasir (diskon_kasir_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table diskon_tumbang

Kolom	Tipe Data	Atribut
diskon_tumbang_id	bigint(20)	NOT NULL, AUTO_INCREMENT
diskon_kasir_id	bigint(20)	NOT NULL
tumbang_id	bigint(20)	DEFAULT NULL
nilai_tumbang	varchar(100)	NOT NULL
tipe_nilai_tumbang	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_diskon_tumbang	( diskon_tumbang_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_diskon_tumbang_tarif_tumbuh_kembang	( tumbang_id ) ref tarif_tumbuh_kembang (tk_id)
🔗	fk_diskon_tumbang_diskon_kasir	( diskon_kasir_id ) ref diskon_kasir (diskon_kasir_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table distributor

Kolom	Tipe Data	Atribut
distributor_id	int(11)	NOT NULL, AUTO_INCREMENT
nama_distributor	varchar(100)	NOT NULL
alamat_distributor	varchar(255)	DEFAULT NULL
email_distributor	varchar(255)	DEFAULT NULL
sales_rep	longtext	DEFAULT NULL
created_by	int(11)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_distributor	( distributor_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table feedback_pelayanan

Kolom	Tipe Data	Atribut
feedback_id	bigint(20)	NOT NULL, AUTO_INCREMENT
antrian_pasien_id	bigint(20)	NOT NULL
feedback	text	DEFAULT NULL
administrasi	int(1)	DEFAULT NULL
dokter	int(1)	DEFAULT NULL
perawat	int(1)	DEFAULT NULL
farmasi	int(1)	DEFAULT NULL
laboratorium	int(1)	DEFAULT NULL
psikolog	int(1)	DEFAULT NULL
tumbuh_kembang	int(1)	DEFAULT NULL
feedback_average	varchar(10)	DEFAULT NULL
feedback_token	varchar(256)	NOT NULL
feedback_created_at	datetime	NOT NULL
feedback_updated_at	datetime	NOT NULL
feedback_completed_at	datetime	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_feedback_pelayanan	( feedback_pelayanan_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_feedback_pelayanan_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table golongan_obat

Kolom	Tipe Data	Atribut
golongan_id	int(11)	NOT NULL, AUTO_INCREMENT
obat_group	varchar(60)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_golongan_obat	( golongan_obat_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

Table grup_jual_obat

Kolom	Tipe Data	Atribut
grup_jual_id	int(11)	NOT NULL, AUTO_INCREMENT
rentang_harga_beli	varchar(20)	DEFAULT NULL
operator_type	enum( <,>,- )	NOT NULL
rentang_harga_akhir	varchar(20)	NOT NULL
profit_jual	varchar(20)	NOT NULL
grup_created_at	datetime	DEFAULT NULL
grup_updated_at	datetime	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_grup_jual_obat	( grup_jual_obat_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table history_stok_obat

Kolom	Tipe Data	Atribut
history_stok_obat_id	bigint(20)	NOT NULL, AUTO_INCREMENT
history_created_by	int(5)	NOT NULL
no_po	varchar(100)	DEFAULT NULL
obat_id	bigint(20)	NOT NULL
obat_date_buy	datetime	NOT NULL
obat_date_expired	date	NOT NULL
obat_buy_price	int(11)	NOT NULL
diskon_beli	float	DEFAULT 0
obat_sell_price	int(11)	NOT NULL
obat_stock	float	DEFAULT NULL
biaya_tambahan	int(11)	NOT NULL DEFAULT 0
history_created_at	datetime	NOT NULL
batch_no	varchar(50)	DEFAULT NULL
history_updated_at	datetime	NOT NULL
first_stock	float	DEFAULT NULL
distributor	varchar(80)	DEFAULT NULL
history_catatan	text	DEFAULT NULL
faktur_distributor	text	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_history_stok_obat	( history_stok_obat_id )
🔍	idx_history_stok_obat_id	( obat_id )
🔍	idx_history_stok_obat_id_desc	( history_stok_obat_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_history_stok_obat_obat	( obat_id ) ref obat (obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table history_transfer_stok

Kolom	Tipe Data	Atribut
history_transfer_id	bigint(20)	NOT NULL, AUTO_INCREMENT
from_obat_id	bigint(20)	NOT NULL
to_obat_id	bigint(20)	NOT NULL
transferred_stock	varchar(5)	NOT NULL
notes	varchar(256)	NOT NULL
history_transfer_created_at	datetime	NOT NULL
history_transfer_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_history_transfer_stok	( history_transfer_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_history_transfer_stok_obat	( from_obat_id ) ref obat (obat_id)
🔗	fk_history_transfer_stok_obat_0	( to_obat_id ) ref obat (obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table jadwal_dokter

Kolom	Tipe Data	Atribut
jadwal_id	int(11)	NOT NULL, AUTO_INCREMENT
doctor_id	bigint(20)	NOT NULL
jadwal	longtext	NOT NULL CHECK (json_valid(jadwal))
new_jadwal	longtext	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_jadwal_dokter	( jadwal_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_jadwal_dokter_users	( doctor_id ) ref users (user_id)

Check Constraints

• CHECK (json_valid(jadwal))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table kategori_master_tarif

Kolom	Tipe Data	Atribut
kmt_id	int(11)	NOT NULL, AUTO_INCREMENT
kmt_name	varchar(100)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_kategori_master_tarif	( kmt_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table kategori_master_tarif_psikolog

Kolom	Tipe Data	Atribut
kmtp_id	int(11)	NOT NULL, AUTO_INCREMENT
kmtp_name	varchar(100)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_kategori_master_tarif_psikolog	( kmtp_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table kategori_tarif_laboratorium

Kolom	Tipe Data	Atribut
kategori_tl_id	int(11)	NOT NULL, AUTO_INCREMENT
kategori_tarif	varchar(60)	NOT NULL
kategori_deskripsi	text	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_kategori_tarif_laboratorium	( kategori_tl_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table logger_actions

Kolom	Tipe Data	Atribut
logger_id	bigint(20)	NOT NULL, AUTO_INCREMENT
logger_triggered_by	bigint(20)	NOT NULL
logger_user_type	varchar(60)	NOT NULL
logger_status	varchar(50)	NOT NULL
logger_desc	text	NOT NULL
logger_created_at	datetime	NOT NULL
logger_updated_at	datetime	NOT NULL
logger_action	varchar(50)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_logger_actions	( logger_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table master_tarif

Kolom	Tipe Data	Atribut
mt_id	int(11)	NOT NULL AUTO_INCREMENT
kmt_id	int(11)	DEFAULT NULL
mt_history_id	int(11)	NOT NULL
mt_name	varchar(70)	NOT NULL
mt_type	enum(‘default’,‘vaksin’)	NOT NULL DEFAULT ‘default’
mt_is_default	int(1)	NOT NULL DEFAULT 0
mt_desc	varchar(256)	NOT NULL
mt_price	varchar(15)	NOT NULL DEFAULT ‘0’
mt_admin	varchar(15)	NOT NULL DEFAULT ‘0’
mt_perawat	varchar(15)	NOT NULL DEFAULT ‘0’
mt_bhp	varchar(15)	NOT NULL DEFAULT ‘0’
mt_harga_jual	varchar(15)	NOT NULL DEFAULT ‘0’

Indexes

	Nama Index	Kolom
🔒	pk_master_tarif	( mt_id )
🔍	idx_kmt_id	( kmt_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_master_tarif_kategori_master_tarif	( kmt_id ) ref kategori_master_tarif (kmt_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table master_tarif_psikolog

Kolom	Tipe Data	Atribut
mtp_id	int(11)	NOT NULL AUTO_INCREMENT
kmtp_id	int(11)	DEFAULT NULL
mtp_name	varchar(70)	NOT NULL
mtp_tarif	varchar(15)	NOT NULL DEFAULT ‘0’
mtp_satuan	varchar(100)	NOT NULL
mtp_desc	varchar(256)	NOT NULL
mtp_is_default	int(1)	NOT NULL DEFAULT 0
mtp_included_once	varchar(1)	DEFAULT NULL
mtp_is_booking_dp	varchar(1)	DEFAULT NULL
mtp_ratio_klinik	int(3)	NOT NULL DEFAULT 15
mtp_ratio_psikolog	int(3)	NOT NULL DEFAULT 85
mtp_porsi_klinik	int(11)	NOT NULL DEFAULT 0
mtp_porsi_psikolog	int(11)	NOT NULL DEFAULT 0

Indexes

	Nama Index	Kolom
🔒	pk_master_tarif_psikolog	( mtp_id )
🔍	idx_kmtp_id	( kmtp_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_master_tarif_kategori_master_tarif_psikolog	( kmtp_id ) ref kategori_master_tarif_psikolog (kmtp_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

---

Table medical_records

Kolom	Tipe Data	Atribut
medrec_id	bigint(20)	NOT NULL AUTO_INCREMENT
pasien_id	bigint(20) unsigned	NOT NULL
doctor_id	bigint(20) unsigned	NOT NULL
antrian_id	bigint(20)	DEFAULT NULL
keluhan_utama	text	NOT NULL
anamnesis	text	NOT NULL
pemeriksaan_fisik	text	DEFAULT NULL
hasil_penunjang	text	DEFAULT NULL
catatan_diagnosis	text	DEFAULT NULL
catatan_prosedur_diagnosis	text	DEFAULT NULL
list_diagnosis	text	DEFAULT NULL
list_prosedur_diagnosis	text	DEFAULT NULL
kode_diagnosis	text	DEFAULT NULL
kode_prosedur_diagnosis	text	DEFAULT NULL
diagnosis_banding	varchar(256)	DEFAULT NULL
tarif_tindakan	varchar(100)	DEFAULT NULL
tumbuh_kembang_id	varchar(100)	DEFAULT NULL
tumbuh_kembang_dates	varchar(200)	DEFAULT NULL
uraian_tumbang	text	DEFAULT NULL
deskripsi_tindakan	text	DEFAULT NULL
saran_pemeriksaan	varchar(100)	DEFAULT NULL
list_obat	text	DEFAULT NULL
medrec_created_at	datetime	NOT NULL
medrec_updated_at	datetim	DEFAULT NULL
pasien	text	DEFAULT NULL
medrec_is_pending	enum(‘0’,‘1’)	DEFAULT ‘0’
resep_obat_luar	varchar(256)	DEFAULT NULL
perawat_id	bigint(20)	NOT NULL DEFAULT 0
last_modified_at	datetime	DEFAULT NULL
lampiran	text	DEFAULT NULL
rujukan_psikolog_id	bigint(20)	DEFAULT NULL
temp_data	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin CHECK (json_valid(temp_data))
rekomendasi_icd	longtext	DEFAULT NULL COMMENT ‘Kolom untuk menyimpan rekomendasi ICD-10 dan ICD-9 dalam format JSON’

Indexes

	Nama Index	Kolom
🔒	pk_medical_records	( medrec_id )
🔍	idx_doctor_id	( doctor_id )
🔍	idx_medrec_id	( medrec_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_medical_records_pasien	( pasien_id ) ref pasien (pasien_id)
🔗	fk_medical_records_users	( doctor_id ) ref users (user_id)
🔗	fk_medical_records_antrian_pasien	( antrian_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_medical_records_users_0	( perawat_id ) ref users (user_id)
🔗	fk_medical_records_users_1	( rujukan_psikolog_id ) ref users (user_id)

Check Constraints

• CHECK (json_valid(temp_data))

Table migrations

Kolom	Tipe Data	Atribut
id	bigint(20) unsigned	NOT NULL AUTO_INCREMENT
version	varchar(255)	NOT NULL
class	text	NOT NULL
group	varchar(255)	NOT NULL
namespace	varchar(255)	NOT NULL
time	int(11)	NOT NULL
batch	int(11) unsigned	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_migrations	( id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table next_visit

Kolom	Tipe Data	Atribut
next_visit_id	bigint(20)	NOT NULL AUTO_INCREMENT
antrian_pasien_id	bigint(20)	NOT NULL
pasien_id	bigint(20)	NOT NULL
notes	text	DEFAULT NULL
date_visit	date	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_next_visit	( next_visit_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_next_visit_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_next_visit_pasien	( pasien_id ) ref pasien (pasien_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table notifikasi

Kolom	Tipe Data	Atribut
notifikasi_id	int(11)	NOT NULL AUTO_INCREMENT
title	varchar(100)	NOT NULL
message	longtext	NOT NULL
detail	longtext	DEFAULT NULL
is_read	tinyint(1)	NOT NULL DEFAULT 0
source	int(11)	DEFAULT NULL
destination	longtext	DEFAULT NULL
created_at	datetime	NOT NULL
updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_notifikasi	( notifikasi_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_notifikasi_users	( source ) ref users (user_id)

Check Constraints

• CHECK (json_valid(destination))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table obat

Kolom	Tipe Data	Atribut
obat_id	bigint(20)	NOT NULL AUTO_INCREMENT
kode_unik	varchar(50)	DEFAULT NULL
pharmacy_id	bigint(20) unsigned	NOT NULL
obat_name	varchar(256)	NOT NULL
obat_generic_name	text	NOT NULL
golongan_id	int(11)	DEFAULT NULL
obat_created_at	datetime	NOT NULL
obat_updated_at	datetime	NOT NULL
obat_satuan	varchar(40)	DEFAULT NULL
obat_konversi_satuan	float	DEFAULT NULL
obat_composition	text	DEFAULT NULL
unit_id	int(11)	DEFAULT NULL
pabrikan	varchar(60)	DEFAULT NULL
stok_min_alert	varchar(10)	DEFAULT NULL
obat_net	float	DEFAULT NULL
obat_net_satuan	varchar(40)	DEFAULT NULL
obat_foto	varchar(255)	DEFAULT NULL
max_obat_sell_price	bigint(20)	NOT NULL DEFAULT 0
is_archive	int(1)	NOT NULL DEFAULT 0

Indexes

	Nama Index	Kolom
🔒	pk_obat	( obat_id )
🔍	idx_obat_name	( obat_name )
🔍	idx_kode_unik	( kode_unik )

Foreign Keys

	Nama FK	Detail
🔗	fk_obat_users	( pharmacy_id ) ref users (user_id)
🔗	fk_obat_golongan_obat	( golongan_id ) ref golongan_obat (golongan_id)
🔗	fk_obat_obat_satuan	( obat_satuan ) ref obat_satuan (satuan_id)
🔗	fk_obat_unit_obat	( unit_id ) ref unit_obat (unit_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table obat_satuan

Kolom	Tipe Data	Atribut
satuan_id	int(11)	NOT NULL AUTO_INCREMENT
obat_satuan	varchar(40)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_obat_satuan	( satuan_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table options

Kolom	Tipe Data	Atribut
option_id	int(11)	NOT NULL AUTO_INCREMENT
option_name	varchar(120)	NOT NULL
option_desc	varchar(150)	NOT NULL
role_id	int(11)	DEFAULT NULL
int_value	int(11)	DEFAULT NULL
text_value	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
float_value	float	DEFAULT NULL
option_created_at	datetime	DEFAULT current_timestamp()
option_updated_at	datetime	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_options	( option_id )

Check Constraints

• CHECK (json_valid(text_value))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table order_lab

Kolom	Tipe Data	Atribut
order_lab_id	bigint(20)	NOT NULL AUTO_INCREMENT
antrian_pasien_id	bigint(20)	NOT NULL
tl_id	varchar(50)	NOT NULL
order_lab_status	int(1)	NOT NULL DEFAULT 0
lampiran	varchar(256)	DEFAULT NULL
lampiran_base64	longtext	DEFAULT NULL
vendor_lab_name	varchar(256)	DEFAULT NULL
counter_download_rujukan	varchar(20)	NOT NULL DEFAULT ‘0’
order_lab_created_at	datetime	NOT NULL
order_lab_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_order_lab	( order_lab_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_order_lab_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_order_lab_tarif_laboratorium	( tl_id ) ref tarif_laboratorium (tl_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table order_obat

Kolom	Tipe Data	Atribut
order_obat_id	bigint(20)	NOT NULL AUTO_INCREMENT
pembayaran_id	bigint(20) unsigned	NOT NULL
taken_by	bigint(20) unsigned	NOT NULL
notes1	varchar(100)	NOT NULL
taken_at	datetime	NOT NULL
order_obat_updated_at	datetime	NOT NULL
medrec_id	bigint(20)	DEFAULT NULL
antrian_pasien_id	bigint(20)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_order_obat	( order_obat_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_order_obat_users	( taken_by ) ref users (user_id)
🔗	fk_order_obat_medical_records	( medrec_id ) ref medical_records (medrec_id)
🔗	fk_order_obat_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_order_obat_pembayaran	( pembayaran_id ) ref pembayaran (pembayaran_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table order_perawat

Kolom	Tipe Data	Atribut
order_perawat_id	bigint(20)	NOT NULL AUTO_INCREMENT
antrian_pasien_id	bigint(20)	NOT NULL
perawat_id	bigint(20)	DEFAULT NULL
status_id	int(1)	NOT NULL DEFAULT 0
layanan_id	bigint(20)	NOT NULL
ordered_at	datetime	NOT NULL
order_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_order_perawat	( order_perawat_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_order_perawat_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_order_perawat_users	( perawat_id ) ref users (user_id)
🔗	fk_order_perawat_tarif_tindakan	( layanan_id ) ref tarif_tindakan (tt_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table order_psikolog

Kolom	Tipe Data	Atribut
order_psikolog_id	bigint(20)	NOT NULL AUTO_INCREMENT
antrian_pasien_id	bigint(20)	NOT NULL
tp_ids	varchar(200)	NOT NULL
booking_fee	varchar(200)	DEFAULT NULL
booking_dp	varchar(200)	DEFAULT NULL
bukti_pembayaran	varchar(250)	NOT NULL
order_token	varchar(256)	DEFAULT NULL
isian_form	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
isian_form_at	datetime	DEFAULT NULL
jadwal_approved	datetime	DEFAULT NULL
is_psikolog_approved	varchar(1)	NOT NULL DEFAULT ‘1’
is_reopened	varchar(1)	DEFAULT NULL
order_created_at	datetime	NOT NULL
order_expired_at	datetime	DEFAULT NULL
order_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_order_psikolog	( order_psikolog_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_order_psikolog_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)

Check Constraints

• CHECK (json_valid(isian_form))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table order_vaksin

Kolom	Tipe Data	Atribut
order_vaksin_id	int(11)	NOT NULL AUTO_INCREMENT
antrian_pasien_id	bigint(20)	NOT NULL
tt_id	varchar(150)	NOT NULL
cancelled_tt_id	varchar(150)	DEFAULT NULL
ordered_by	int(11)	NOT NULL
taken_by	int(11)	NOT NULL
ordered_at	datetime	NOT NULL
order_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_order_vaksin	( order_vaksin_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_order_vaksin_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_order_vaksin_users	( ordered_by ) ref users (user_id)
🔗	fk_order_vaksin_users_0	( taken_by ) ref users (user_id)
🔗	fk_order_vaksin_tarif_tindakan	( tt_id ) ref tarif_tindakan (tt_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table pasien

Kolom	Tipe Data	Atribut
pasien_id	bigint(20)	NOT NULL AUTO_INCREMENT
pasien_name	varchar(50)	NOT NULL
dob	date	NOT NULL
gender	enum(‘Laki - Laki’,‘Perempuan’)	NOT NULL
pasien_created_at	datetime	DEFAULT NULL
pasien_custom_id	varchar(15)	DEFAULT NULL
pasien_updated_at	datetime	DEFAULT NULL
pj_id	bigint(20) unsigned	DEFAULT NULL
pasien_phone	varchar(25)	DEFAULT NULL
pasien_address	text	DEFAULT NULL
pasien_parent_id	bigint(20)	DEFAULT NULL
pasien_nik	text	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_pasien	( pasien_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_pasien_penanggung_jawab	( pj_id ) ref penanggung_jawab (pj_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table pembayaran

Kolom	Tipe Data	Atribut
pembayaran_id	bigint(20)	NOT NULL AUTO_INCREMENT
new_invoice_number	varchar(50)	DEFAULT NULL
invoice_farmasi	varchar(100)	DEFAULT NULL
receptionist_id	bigint(20) unsigned	NOT NULL
total_pembayaran	varchar(20)	NOT NULL
bayar	varchar(20)	NOT NULL
diskon	varchar(20)	NOT NULL DEFAULT ‘0’
kembalian	varchar(25)	DEFAULT NULL
metode_pembayaran_id	int(11)	DEFAULT NULL
metode_pembayaran	varchar(50)	DEFAULT NULL
bayar_gabungan	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
is_include_obat	enum(‘0’,‘1’)	NOT NULL DEFAULT ‘0’
tanggal_bayar	datetime	NOT NULL
updated_at	datetime	NOT NULL
is_lunas	enum(‘0’,‘1’)	DEFAULT ‘0’
medrec_id	bigint(20)	DEFAULT NULL
antrian_pasien_id	bigint(20) unsigned	DEFAULT NULL
pasien_id	bigint(20) unsigned	DEFAULT NULL
transaksi_obat	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
tarif_tindakan	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
tarif_lab	longtext	DEFAULT NULL
tumbuh_kembang	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
layanan_perawat	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
layanan_psikolog	longtext	DEFAULT NULL
member_pj_id	bigint(20)	DEFAULT NULL
alasan_koreksi	varchar(256)	DEFAULT NULL
voucher_pembayaran	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
diskon_kasir	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
bukti_pembayaran	varchar(256)	DEFAULT NULL
approve_free	int(1)	NOT NULL DEFAULT 0

Indexes

	Nama Index	Kolom
🔒	pk_pembayaran	( pembayaran_id )
🔍	idx_medrec_pembayaran	( medrec_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_pembayaran_users	( receptionist_id ) ref users (user_id)
🔗	fk_pembayaran_antrian_pasien	( antrian_pasien_id ) ref antrian_pasien (antrian_pasien_id)
🔗	fk_pembayaran_medical_records	( medrec_id ) ref medical_records (medrec_id)
🔗	fk_pembayaran_pasien	( pasien_id ) ref pasien (pasien_id)
🔗	fk_pembayaran_penanggung_jawab	( member_pj_id ) ref penanggung_jawab (pj_id)
🔗	fk_pembayaran_tarif_metode_bayar	( metode_pembayaran_id ) ref tarif_metode_bayar (tarif_metode_bayar_id)

Check Constraints

• CHECK (json_valid(transaksi_obat))
• CHECK (json_valid(tarif_tindakan))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table pembayaran_diskon

Kolom	Tipe Data	Atribut
pd_id	bigint(20)	NOT NULL AUTO_INCREMENT
pembayaran_id	bigint(20)	NOT NULL
diskon_option_id	varchar(50)	NOT NULL
custom_diskon	varchar(50)	NOT NULL DEFAULT ‘0’
total_diskon	varchar(50)	NOT NULL DEFAULT ‘0’
keterangan_diskon	varchar(300)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_pembayaran_diskon	( pd_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_pembayaran_diskon_pembayaran	( pembayaran_id ) ref pembayaran (pembayaran_id)
🔗	fk_pembayaran_diskon_options	( diskon_option_id ) ref options (option_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table penanggung_jawab

Kolom	Tipe Data	Atribut
pj_id	bigint(20)	NOT NULL AUTO_INCREMENT
receptionist_id	bigint(20) unsigned	NOT NULL
pj_name	varchar(150)	NOT NULL
agama	varchar(60)	DEFAULT NULL
pj_phone	varchar(15)	NOT NULL
pj_job	varchar(100)	DEFAULT NULL
pj_address	text	NOT NULL
pj_created_at	datetime	NOT NULL
pj_updated_at	datetime	NOT NULL
pj_relation	varchar(100)	DEFAULT NULL
pj_email	varchar(100)	DEFAULT NULL
pj_password	varchar(256)	DEFAULT NULL
pj_instagram	varchar(50)	DEFAULT NULL
pj_nik	text	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_penanggung_jawab	( pj_id )
🔍	idx_pj_phone_pj	( pj_phone )
🔍	idx_pj_email_pj	( pj_email )

Foreign Keys

	Nama FK	Detail
🔗	fk_penanggung_jawab_users	( receptionist_id ) ref users (user_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table po

Kolom	Tipe Data	Atribut
po_id	int(11)	NOT NULL AUTO_INCREMENT
created_by	int(11)	NOT NULL
tipe_po	varchar(100)	NOT NULL
metode_pembayaran	varchar(100)	NOT NULL
tanggal_tempo	date	DEFAULT NULL
distributor	varchar(255)	NOT NULL
status_po	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
approved_by	int(11)	DEFAULT NULL
received_by	int(11)	DEFAULT NULL
invoice_file	varchar(255)	DEFAULT NULL
catatan	varchar(255)	DEFAULT NULL
faktur_distributor	longtext	DEFAULT NULL
customer_panel_id	bigint(20)	DEFAULT NULL
is_pre_kursor	tinyint(1)	NOT NULL DEFAULT 0
is_panel	tinyint(1)	NOT NULL DEFAULT 0
komisi_po	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
pembayaran_po	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
created_at	timestamp	NOT NULL DEFAULT current_timestamp()
updated_at	timestamp	NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
history_po	longtext	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_po	( po_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_po_users	( created_by ) ref users (user_id)
🔗	fk_po_distributor	( distributor ) ref distributor (distributor_id)
🔗	fk_po_users_1	( approved_by ) ref users (user_id)
🔗	fk_po_users_2	( received_by ) ref users (user_id)
🔗	fk_po_customer_panel	( customer_panel_id ) ref customer_panel (customer_panel_id)

Check Constraints

• CHECK (json_valid(status_po))
• CHECK (json_valid(komisi_po))
• CHECK (json_valid(pembayaran_po))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table po_detail

Kolom	Tipe Data	Atribut
po_detail_id	int(11)	NOT NULL AUTO_INCREMENT
po_id	int(11)	NOT NULL
no_batch	longtext	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
obat_id	int(11)	NOT NULL
jumlah_beli	int(11)	NOT NULL
jumlah_beli_approved	int(11)	DEFAULT 0
jumlah_beli_received	int(11)	DEFAULT 0
jumlah_stok_masuk	int(11)	DEFAULT 0
harga_beli_sebelumnya	int(11)	NOT NULL
harga_perkiraan	int(11)	NOT NULL
harga_beli	int(11)	NOT NULL
harga_jual	int(11)	NOT NULL DEFAULT 0
diskon	int(11)	NOT NULL DEFAULT 0
approved	tinyint(1)	NOT NULL DEFAULT 1
date_received	date	DEFAULT NULL
catatan	text	DEFAULT NULL
is_free	tinyint(1)	NOT NULL DEFAULT 0
biaya_tambahan	int(11)	NOT NULL DEFAULT 0
keterangan_pre_kursor	varchar(255)	DEFAULT NULL
created_at	timestamp	NOT NULL DEFAULT current_timestamp()
updated_at	timestamp	NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Indexes

	Nama Index	Kolom
🔒	pk_po_detail	( po_detail_id )
🔍	idx_pl_phone_pj	( pj_phone )

Foreign Keys

	Nama FK	Detail
🔗	fk_po_detail_po	( po_id ) ref po (po_id)
🔗	fk_po_detail_obat	( obat_id ) ref obat (obat_id)

Check Constraints

• CHECK (json_valid(no_batch))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table record_order_vaksin

Kolom	Tipe Data	Atribut
record_id	bigint(20)	NOT NULL AUTO_INCREMENT
order_id	int(11)	NOT NULL
status_id	int(11)	NOT NULL
recorded_at	datetime	NOT NULL
record_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_record_order_vaksin	( record_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_record_order_vaksin_order_vaksin	( order_id ) ref order_vaksin (order_vaksin_id)
🔗	fk_record_status_order_vaksin	( status_id ) ref status_antrian_pasien (status_antrian_pasien_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table rekomendasi_pembelian_obat

Kolom	Tipe Data	Atribut
id	int(11)	NOT NULL AUTO_INCREMENT
obat_id	int(11)	NOT NULL
obat_name	varchar(255)	NOT NULL
kategori	varchar(50)	NOT NULL
arah_tren	varchar(100)	NOT NULL
persentase_perubahan	varchar(50)	NOT NULL
avg_frequency	int(11)	NOT NULL
avg_qty_per_frequency	int(11)	NOT NULL
priority_score	int(11)	NOT NULL
alasan_rekomendasi	text	NOT NULL
created_at	datetime	NOT NULL DEFAULT current_timestamp()

Indexes

	Nama Index	Kolom
🔒	pk_rekomendasi_pembelian_obat	( id )

Foreign Keys

	Nama FK	Detail
🔗	fk_rekomendasi_pembelian_obat_obat	( obat_id ) ref obat (obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table relasi_obat

Kolom	Tipe Data	Atribut
relasi_obat_id	bigint(20)	NOT NULL AUTO_INCREMENT
obat_a	bigint(20)	NOT NULL
obat_b	bigint(20)	NOT NULL
relasi_created_at	datetime	NOT NULL
relasi_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_relasi_obat	( relasi_obat_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_relasi_obat_obat	( obat_a ) ref obat (obat_id)
🔗	fk_relasi_obat_obat_0	( obat_b ) ref obat (obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table reset_password_token

Kolom	Tipe Data	Atribut
token_id	bigint(20)	NOT NULL AUTO_INCREMENT
token	varchar(256)	NOT NULL
user_id	bigint(20)	NOT NULL
user_type	varchar(20)	NOT NULL
token_created_at	datetime	NOT NULL
token_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_reset_password_token	( token_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_reset_password_token_users	( user_id ) ref users (user_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table rm_visibility

Kolom	Tipe Data	Atribut
rm_visibility_id	bigint(20)	NOT NULL AUTO_INCREMENT
rm_id	bigint(20)	NOT NULL
user_id	bigint(20)	NOT NULL
user_allowed_id	bigint(20)	DEFAULT NULL
visibility_created_at	datetime	NOT NULL
visibility_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_rm_visibility	( rm_visibility_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_rm_visibility_medical_records	( rm_id ) ref medical_records (medrec_id)
🔗	fk_rm_visibility_users	( user_id ) ref users (user_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table roles

Kolom	Tipe Data	Atribut
role_id	int(11)	NOT NULL AUTO_INCREMENT
role_name	varchar(50)	NOT NULL
token	varchar(150)	DEFAULT NULL
is_admin	varchar(1)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_role	( role_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table sidebar

Kolom	Tipe Data	Atribut
sb_id	int(11)	NOT NULL AUTO_INCREMENT
sb_title	varchar(50)	NOT NULL
sb_url	varchar(100)	NOT NULL
sb_role_id	int(11)	NOT NULL
sb_icon	varchar(50)	DEFAULT NULL
sb_show	int(1)	NOT NULL DEFAULT 1
order_view	int(3)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_sidebar	( sb_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_sidebar_role	( sb_role_id ) ref roles (role_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table spesialis_dokter

Kolom	Tipe Data	Atribut
spesialis_id	int(3)	NOT NULL AUTO_INCREMENT
spesialis_name	varchar(100)	NOT NULL
hide	varchar(1)	DEFAULT ‘0’
order_at	varchar(50)	NOT NULL DEFAULT ‘1’

Indexes

	Nama Index	Kolom
🔒	pk_spesialis_dokter	( spesialis_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table status_antrian_pasien

Kolom	Tipe Data	Atribut
status_antrian_pasien_id	int(11)	NOT NULL AUTO_INCREMENT
status_antrian_pasien_title	varchar(100)	NOT NULL
status_antrian_pasien_desc	text	DEFAULT NULL
view_order	int(2)	DEFAULT NULL
color	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_status_antrian_pasien	( status_antrian_pasien_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table stock_opname

Kolom	Tipe Data	Atribut
stock_opname_id	int(11)	NOT NULL AUTO_INCREMENT
judul	varchar(255)	NOT NULL
terakhir_dicek_oleh	int(11)	NOT NULL
is_done	tinyint(1)	NOT NULL DEFAULT 0
is_approved	tinyint(1)	NOT NULL DEFAULT 0
is_realisasi	tinyint(1)	NOT NULL DEFAULT 0
detail	longtext	NOT NULL
tanggal_mulai	datetime	DEFAULT NULL
tanggal_selesai	datetime	DEFAULT NULL
pdf_path	varchar(255)	DEFAULT NULL
created_at	datetime	NOT NULL DEFAULT current_timestamp()
updated_at	datetime	NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
log_alur	longtext	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_stock_opname	( stock_opname_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_stock_opname_users	( terakhir_dicek_oleh ) ref users (user_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table sub_pembayaran

Kolom	Tipe Data	Atribut
sub_pembayaran_id	bigint(255)	NOT NULL AUTO_INCREMENT
pembayaran_id	bigint(255)	DEFAULT NULL
total_pembulatan	varchar(45)	DEFAULT ‘0’
jumlah_pembulatan	varchar(45)	DEFAULT ‘0’

Indexes

	Nama Index	Kolom
🔒	pk_sub_pembayaran	( sub_pembayaran_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_sub_pembayaran_pembayaran	( pembayaran_id ) ref pembayaran (pembayaran_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table sub_sidebar

Kolom	Tipe Data	Atribut
sb_id	int(11)	NOT NULL
sub_sb_id	int(11)	NOT NULL AUTO_INCREMENT
sub_title	varchar(50)	NOT NULL
sub_url	varchar(100)	NOT NULL
new_tab	int(1)	DEFAULT NULL
sub_icon	varchar(50)	NOT NULL
sub_sb_show	int(1)	DEFAULT 1
sub_order	int(11)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_sub_sidebar	( sub_sb_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_sub_sidebar_sidebar	( sb_id ) ref sidebar (sb_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table sub_template_racikan

Kolom	Tipe Data	Atribut
sub_template_racikan_id	bigint(20)	NOT NULL AUTO_INCREMENT
template_racikan_id	bigint(20)	NOT NULL
obat_id	bigint(20)	NOT NULL
obat_racikan_subtotal	float	DEFAULT NULL
sub_template_created_at	date	NOT NULL
sub_template_updated_at	date	NOT NULL
obat_racikan_unit_satuan	varchar(50)	DEFAULT NULL
layanan_perawat	int(1)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_sub_template_racikan	( sub_template_racikan_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_sub_template_racikan_template_racikan	( template_racikan_id ) ref template_racikan (template_racikan_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table suggestions

Kolom	Tipe Data	Atribut
suggestion_id	bigint(20)	NOT NULL AUTO_INCREMENT
vocabulary	varchar(256)	NOT NULL
owner_id	bigint(20)	NOT NULL
field_name	varchar(50)	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_suggestions	( suggestion_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_suggestions_users	( owner_id ) ref users (user_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table tabungan

Kolom	Tipe Data	Atribut
tabungan_id	int(11)	NOT NULL AUTO_INCREMENT
pasien_id	bigint(20)	NOT NULL
tumbang_id	int(11)	NOT NULL
pembayaran_id	bigint(20)	NOT NULL
rujukan_by	bigint(20)	DEFAULT NULL
pertemuan_terpakai	int(3)	NOT NULL DEFAULT 0
pertemuan	varchar(3)	NOT NULL
vendor_name	varchar(120)	DEFAULT NULL
lampiran	varchar(256)	NOT NULL
tabungan_created_at	datetime	NOT NULL DEFAULT current_timestamp()
tabungan_updated_at	datetime	NOT NULL DEFAULT current_timestamp()

Indexes

	Nama Index	Kolom
🔒	pk_suggestions	( suggestion_id )
🔍	idx_pembayaran_rujukan	( rujukan_by )

Foreign Keys

	Nama FK	Detail
🔗	fk_tabungan_pembayaran	( pembayaran_id ) ref pembayaran (pembayaran_id)
🔗	fk_tabungan_pasien	( pasien_id ) ref pasien (pasien_id)
🔗	fk_tabungan_users	( rujukan_by ) ref users (user_id)
🔗	fk_tabungan_tarif_tumbuh_kembang	( tumbang_id ) ref tarif_tumbuh_kembang (tk_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table tarif_laboratorium

Kolom	Tipe Data	Atribut
tl_id	bigint(11)	NOT NULL AUTO_INCREMENT
tl_name	varchar(60)	NOT NULL
tarif_lab	varchar(20)	NOT NULL DEFAULT ‘0’
tarif_klinik	varchar(20)	NOT NULL DEFAULT ‘0’
tarif_dokter	varchar(20)	NOT NULL DEFAULT ‘0’
total_tarif_lab	varchar(20)	NOT NULL DEFAULT ‘0’
kategori_tl_id	int(11)	NOT NULL
published	int(1)	NOT NULL DEFAULT 1
tl_alias	varchar(256)	DEFAULT NULL
tl_order	varchar(10)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_tarif_laboratorium	( tl_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_tarif_laboratorium_kategori_tarif_laboratorium	( kategori_tl_id ) ref kategori_tarif_laboratorium (kategori_tl_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table tarif_metode_bayar

Kolom	Tipe Data	Atribut
tarif_metode_bayar_id	int(11)	NOT NULL AUTO_INCREMENT
metode_name	varchar(150)	NOT NULL
metode_percentage	float	DEFAULT 0
metode_desc	text	NOT NULL
is_cash	int(1)	NOT NULL DEFAULT 0

Indexes

	Nama Index	Kolom
🔒	pk_tarif_metode_bayar	( tarif_metode_bayar_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table tarif_psikolog

Kolom	Tipe Data	Atribut
tp_id	bigint(20)	NOT NULL AUTO_INCREMENT
owner_id	bigint(20)	DEFAULT NULL
tp_name	varchar(100)	NOT NULL
tp_tarif	varchar(100)	NOT NULL
tp_satuan	varchar(100)	NOT NULL
tp_desc	text	NOT NULL
included_once	varchar(1)	DEFAULT NULL
is_booking_dp	varchar(1)	DEFAULT NULL
tp_ratio_klinik	int(3)	NOT NULL DEFAULT 15
tp_ratio_psikolog	int(3)	NOT NULL DEFAULT 85
tp_porsi_klinik	int(11)	NOT NULL DEFAULT 0
tp_porsi_psikolog	int(11)	NOT NULL DEFAULT 0
is_default	int(1)	NOT NULL DEFAULT 0
is_admin_default	int(1)	NOT NULL DEFAULT 0
tp_created_at	datetime	NOT NULL
tp_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_tarif_psikolog	( tp_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_tarif_psikolog_users	( owner_id ) ref users (users_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table tarif_tindakan

Kolom	Tipe Data	Atribut
tt_id	int(11)	NOT NULL AUTO_INCREMENT
owner_id	bigint(20) unsigned	DEFAULT NULL
created_by	bigint(20) unsigned	DEFAULT NULL
tt_name	varchar(256)	NOT NULL
tt_price	float	DEFAULT NULL
t_admin	varchar(50)	DEFAULT ‘0’
t_perawat	varchar(50)	DEFAULT ‘0’
t_bhp	varchar(50)	DEFAULT ‘0’
t_titipan	varchar(50)	NOT NULL DEFAULT ‘0’
tt_desc	varchar(256)	NOT NULL
tt_created_at	datetime	NOT NULL
tt_updated_at	datetime	NOT NULL
is_default	int(1)	DEFAULT 0
tt_type	enum(‘default’,‘vaksin’)	DEFAULT ‘default’
setting_persentase	longtext	DEFAULT {"setting_persentase":"0","setting_porsi_klinik":0,"setting_porsi_dokter":0,"setting_ratio_klinik":0,"setting_ratio_dokter":0}

Indexes

	Nama Index	Kolom
🔒	pk_tarif_tindakan	( tt_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_tarif_tindakan_users	( owner_id ) ref users (users_id)
🔗	fk_tarif_tindakan_users_1	( created_by ) ref users (users_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table tarif_tumbuh_kembang

Kolom	Tipe Data	Atribut
tk_id	bigint(20)	NOT NULL AUTO_INCREMENT
tk_name	varchar(100)	NOT NULL
tk_pertemuan	int(2)	NOT NULL
tk_durasi	varchar(100)	NOT NULL
tk_tarif_unit	varchar(50)	NOT NULL
tk_diskon	int(3)	NOT NULL
tk_desc	text	NOT NULL
is_assessment	int(1)	DEFAULT NULL
tk_created_at	datetime	NOT NULL DEFAULT current_timestamp()
tk_updated_at	datetime	NOT NULL DEFAULT current_timestamp()

Indexes

	Nama Index	Kolom
🔒	pk_tarif_tumbuh_kembang	( tk_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table tarif_vaksin

Kolom	Tipe Data	Atribut
tarif_vaksin_id	bigint(20)	NOT NULL AUTO_INCREMENT
tt_id	bigint(20)	NOT NULL
harga_jual	varchar(15)	NOT NULL
tarif_vaksin_created_at	datetime	DEFAULT NULL
tarif_vaksin_upated_at	datetime	DEFAULT NULL
history_stok_obat_id	bigint(20)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_tarif_vaksin	( tarif_vaksin_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_tarif_vaksin_tarif_tindakan	( tt_id ) ref tarif_tindakan (tt_id)
🔗	fk_tarif_vaksin_history_stok_obat	( history_stok_obat_id ) ref history_stok_obat (history_stok_obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table template_racikan

Kolom	Tipe Data	Atribut
template_racikan_id	bigint(20)	NOT NULL AUTO_INCREMENT
owner_id	bigint(20)	NOT NULL
compound_name	varchar(100)	DEFAULT NULL
signa	varchar(200)	DEFAULT NULL
signature	text	DEFAULT NULL
subscriptio	varchar(60)	DEFAULT NULL
template_created_at	date	NOT NULL
template_updated_at	date	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_template_racikan	( template_racikan_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_template_racikan_users	( owner_id ) ref users (user_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table temp_pembayaran_farmasi

Kolom	Tipe Data	Atribut
tanggal_bayar_raw	datetime	NOT NULL
tanggal_bayar	varchar(40)	DEFAULT NULL
transaksi_obat	longtext	DEFAULT NULL
tarif_tindakan	longtext	DEFAULT NULL
pasien_name	varchar(50)	DEFAULT NULL
prefix_name	varchar(100)	NOT NULL
user_name	varchar(100)	DEFAULT NULL
suffix_name	varchar(100)	NOT NULL
qty	int(1)	NOT NULL
notes1	varchar(100)	DEFAULT NULL
pj_name	varchar(150)	DEFAULT NULL
layanan_perawat	longtext	DEFAULT NULL
antrian_unique_code	varchar(60)	DEFAULT NULL
invoice_number	varchar(22)	DEFAULT NULL
invoice_farmasi	varchar(100)	DEFAULT NULL
pembayaran_id	bigint(20)	NOT NULL DEFAULT 0

Foreign Keys

	Nama FK	Detail
🔗	fk_temp_pembayaran_farmasi_pembayaran	( pembayaran_id ) ref pembayaran (pembayaran_id)

Check Constraints

• CHECK (json_valid(transaksi_obat))
• CHECK (json_valid(tarif_tindakan))

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table temp_penggunaan_obat

Kolom	Tipe Data	Atribut
temp_id	bigint(20)	NOT NULL AUTO_INCREMENT
user_id	bigint(20)	DEFAULT NULL
user_name	varchar(200)	DEFAULT NULL
obat_id	bigint(20)	NOT NULL
obat_name	varchar(200)	NOT NULL
obat_generic_name	varchar(200)	NOT NULL
pabrikan	varchar(200)	NOT NULL
jumlah	varchar(100)	NOT NULL DEFAULT ‘0’
sisa	float	NOT NULL DEFAULT 0
obat_konversi_satuan	varchar(100)	NOT NULL
obat_satuan	varchar(100)	NOT NULL
obat_unit	varchar(100)	NOT NULL
tgl_transaksi	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_temp_penggunaan_obat	( temp_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_temp_penggunaan_obat_users	( user_id ) ref users (user_id)
🔗	fk_temp_penggunaan_obat_obat	( obat_id ) ref obat (obat_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table unit_obat

Kolom	Tipe Data	Atribut
unit_id	int(11)	NOT NULL, AUTO_INCREMENT
obat_unit	varchar(60)	NOT NULL
batas_bawah_stok	varchar(4)	NOT NULL, DEFAULT ‘3’
kode_warna	varchar(100)	NOT NULL
simbol	text	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_unit_obat	( unit_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table users

Kolom	Tipe Data	Atribut
user_id	bigint(20)	NOT NULL, AUTO_INCREMENT
role_id	int(2)	NOT NULL
prefix_name	varchar(100)	NOT NULL
user_name	varchar(100)	NOT NULL
suffix_name	varchar(100)	NOT NULL
user_nik	text	DEFAULT NULL
user_email	varchar(100)	NOT NULL
user_password	varchar(256)	NOT NULL
user_created_at	datetime	NOT NULL
user_updated_at	datetime	DEFAULT NULL
login_at	datetime	DEFAULT NULL
is_online	int(1)	DEFAULT 0
spesialis_id	int(3)	DEFAULT NULL
sip	varchar(60)	DEFAULT NULL
is_pj	int(1)	DEFAULT NULL
is_manager	int(1)	DEFAULT NULL
is_suspend	int(1)	DEFAULT NULL
profile_picture	text	DEFAULT NULL
icon	text	NOT NULL
bio	text	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_users	( user_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_users_roles	( role_id ) ref roles (role_id)
🔗	fk_users_spesialis_dokter	( spesialis_id ) ref spesialis_dokter (spesialis_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table vital_signs

Kolom	Tipe Data	Atribut
vital_sign_id	bigint(20)	NOT NULL, AUTO_INCREMENT
pasien_id	bigint(20) unsigned	NOT NULL
tekanan_darah	varchar(20)	DEFAULT NULL
respirasi	varchar(20)	DEFAULT NULL
berat_badan	varchar(20)	DEFAULT NULL
nadi	varchar(20)	DEFAULT NULL
suhu	varchar(20)	DEFAULT NULL
tinggi_badan	varchar(20)	DEFAULT NULL
vital_sign_created_at	datetime	DEFAULT NULL
vital_sign_updated_at	datetime	DEFAULT NULL
keterangan_alergi	text	DEFAULT NULL
lingkar_kepala	varchar(5)	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_vital_signs	( vital_sign_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_vital_signs_pasien	( pasien_id ) ref pasien (pasien_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table vouchers

Kolom	Tipe Data	Atribut
voucher_id	bigint(20)	NOT NULL, AUTO_INCREMENT
voucher_img	varchar(200)	DEFAULT NULL
voucher_title	varchar(100)	NOT NULL
voucher_desc	text	NOT NULL
syarat_ketentuan	text	NOT NULL
nilai	varchar(20)	NOT NULL, DEFAULT ‘0’
voucher_percent	varchar(50)	NOT NULL, DEFAULT ‘100’
voucher_type_ids	varchar(200)	NOT NULL
voucher_tindakan_ids	varchar(200)	NOT NULL
quota	int(10)	NOT NULL, DEFAULT 100
voucher_expired_at	date	NOT NULL
voucher_created_at	datetime	NOT NULL
voucher_updated_at	datetime	NOT NULL

Indexes

	Nama Index	Kolom
🔒	pk_voucher	( voucher_id )

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---

Table voucher_penanggung_jawab

Kolom	Tipe Data	Atribut
voucher_pj_id	bigint(20)	NOT NULL, AUTO_INCREMENT
voucher_id	bigint(20)	NOT NULL
pj_id	bigint(20)	NOT NULL
voucher_pj_created_at	datetime	NOT NULL
voucher_pj_updated_at	datetime	NOT NULL
voucher_pj_used_at	datetime	DEFAULT NULL

Indexes

	Nama Index	Kolom
🔒	pk_voucher_penanggung_jawab	( voucher_pj_id )

Foreign Keys

	Nama FK	Detail
🔗	fk_voucher_penanggung_jawab_penanggung_jawab	( pj_id ) ref penanggung_jawab (pj_id)
🔗	fk_voucher_penanggung_jawab_vouchers	( voucher_id ) ref vouchers (voucher_id)

Options

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

---