| id | bigint(20) unsigned |
|
|
|
| nama_perusahaan | varchar(255) |
|
|
|
| nama_singkat | varchar(100) |
|
|
|
| jenis_perusahaan | enum | -- |
|
Rumah Sakit
|
| tentang_kami | text |
|
|
|
| visi | text |
|
|
|
| misi | text |
|
|
|
| sejarah | text |
|
|
|
| alamat | varchar(500) |
|
|
|
| kota | varchar(100) |
|
|
|
| provinsi | varchar(100) |
|
|
|
| kode_pos | varchar(10) |
|
|
|
| no_telepon | varchar(20) |
|
|
|
| no_fax | varchar(20) |
|
|
|
| email | varchar(255) |
|
|
|
| website | varchar(255) |
|
|
|
| logo | varchar(255) |
|
|
|
| foto_utama | varchar(255) |
|
|
|
| foto_galeri | longtext |
|
|
|
| layanan_utama | text |
|
|
|
| fasilitas | text |
|
|
|
| keunggulan | text |
|
|
|
| akreditasi | varchar(100) |
|
|
|
| sertifikasi | varchar(255) |
|
|
|
| nomor_izin | varchar(100) |
|
|
|
| npwp | varchar(20) |
|
|
|
| siup | varchar(50) |
|
|
|
| sosial_media | text |
|
|
|
| kontak_darurat | text |
|
|
|
| jam_operasional | varchar(255) |
|
|
|
| peta_lokasi | text |
|
|
|
| status_aktif | tinyint(1) |
|
|
1
|
| theme_primary_color | varchar(7) |
|
|
#dc2626
|
| theme_dark_color | varchar(7) |
|
|
#b91c1c
|
| theme_light_color | varchar(7) |
|
|
#fef2f2
|
| model_template | varchar(255) |
|
|
default
|
| theme_corporate_dark_color | varchar(255) |
|
|
#1f2937
|
| theme_corporate_bg_color | varchar(255) |
|
|
#111827
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| fitur_section_title | varchar(255) |
|
|
|
| fitur_section_subtitle | varchar(255) |
|
|
|
| fitur_1_icon | varchar(255) |
|
|
|
| fitur_1_title | varchar(255) |
|
|
|
| fitur_1_description | text |
|
|
|
| fitur_2_icon | varchar(255) |
|
|
|
| fitur_2_title | varchar(255) |
|
|
|
| fitur_2_description | text |
|
|
|
| fitur_3_icon | varchar(255) |
|
|
|
| fitur_3_title | varchar(255) |
|
|
|
| fitur_3_description | text |
|
|
|
| director_name | varchar(255) |
|
|
|
| director_position | varchar(255) |
|
|
|
| director_quote | text |
|
|
|
| director_photo | varchar(255) |
|
|
|
| director_signature | varchar(255) |
|
|
|
| director_social_media | longtext |
|
|
|