✓ Veritabanı bağlantısı başarılı
✓ subscription_packages tablosu mevcut
| Kolon Adı | Tip | Null | Key | Default |
|---|---|---|---|---|
| id | int(10) unsigned | NO | PRI | NULL |
| name | varchar(255) | NO | NULL | |
| name_tr | varchar(255) | NO | NULL | |
| name_en | varchar(255) | NO | NULL | |
| description | text | YES | NULL | |
| description_tr | text | YES | NULL | |
| description_en | text | YES | NULL | |
| duration_months | int(11) | NO | 1 | |
| price | decimal(10,2) | NO | 0.00 | |
| currency | varchar(3) | NO | TRY | |
| ios_product_id | varchar(255) | YES | NULL | |
| android_product_id | varchar(255) | YES | NULL | |
| features | text | YES | NULL | |
| is_active | tinyint(1) | NO | MUL | 1 |
| sort_order | int(11) | NO | MUL | 0 |
| created_at | timestamp | NO | current_timestamp() | |
| updated_at | timestamp | NO | current_timestamp() |
✓ ios_product_id kolonu mevcut
✓ android_product_id kolonu mevcut
| id | name | name_tr | name_en | description | description_tr | description_en | duration_months | price | currency | ios_product_id | android_product_id | features | is_active | sort_order | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Aylık Paket | Aylık Paket | Monthly Package | NULL | 1 aylık abonelik paketi | 1 month subscription package | 1 | 500.00 | TRY | ihars.dental.paket1 | ihars.dental.paket1 | NULL | 1 | 1 | 2025-12-07 14:11:18 | 2025-12-10 00:27:19 |
| 5 | Trial | 30 Günlük Deneme | 30 Day Trial | NULL | 30 günlük ücretsiz deneme paketi | 30 day free trial package | 1 | 0.00 | TRY | ihars.dental.paket1 | ihars.dental.paket1 | {"trial":true} | 1 | 0 | 2025-12-08 01:28:17 | 2025-12-10 00:27:19 |
| 2 | 3 Aylık Paket | 3 Aylık Paket | 3 Months Package | NULL | 3 aylık abonelik paketi (10% indirim) | 3 months subscription package (10% discount) | 3 | 1350.00 | TRY | NULL | NULL | NULL | 1 | 2 | 2025-12-07 14:11:18 | 2025-12-07 14:11:18 |
| 3 | 6 Aylık Paket | 6 Aylık Paket | 6 Months Package | NULL | 6 aylık abonelik paketi (15% indirim) | 6 months subscription package (15% discount) | 6 | 2550.00 | TRY | NULL | NULL | NULL | 1 | 3 | 2025-12-07 14:11:18 | 2025-12-07 14:11:18 |
| 4 | Yıllık Paket | Yıllık Paket | Yearly Package | NULL | 12 aylık abonelik paketi (20% indirim) | 12 months subscription package (20% discount) | 12 | 4800.00 | TRY | ihars.dental.paket2 | ihars.dental.paket2 | NULL | 1 | 4 | 2025-12-07 14:11:18 | 2025-12-10 00:27:19 |