Database · dazo/docs

Konco memakai dua database terpisah — PostgreSQL untuk dazo-whitelist (web app, default pgsql) dan MySQL/MariaDB untuk dazo-whitelist-api (engine). Seluruh tabel utama memakai UUID string sebagai primary key via trait App\Traits\UUID.

Koneksi database

Repo	Default driver	DB
`dazo-whitelist`	`pgsql` (PostgreSQL)	`konco_db` (default)
`dazo-whitelist-api`	`mysql` (MySQL/MariaDB)	`konco_api_db`

Primary key: UUID

Semua model utama memakai UUIDv4 string. Trait App\Traits\UUID (app/Traits/UUID.php) otomatis generate UUID saat creating event:

php

trait UUID
&#123;
    protected static function boot()
    &#123;
        parent::boot();
        static::creating(function ($model) &#123;
            if ($model->getKey() === null) &#123;
                $model->setAttribute($model->getKeyName(), Str::uuid()->toString());
            &#125;
        &#125;);
    &#125;

    public function getIncrementing()
    &#123;
        return false;
    &#125;

    public function getKeyType()
    &#123;
        return 'string';
    &#125;
&#125;

Di migration, primary key didefinisikan sebagai:

php

$table->uuid('id')->primary();

Trait wajib model

Trait	Lokasi	Fungsi
`App\Traits\UUID`	`app/Traits/UUID.php`	Generate UUIDv4 primary key, set `$keyType='string'`, `$incrementing=false`
`App\Traits\WithAuthor`	`app/Traits/WithAuthor.php`	Auto-isi `created_by` / `updated_by` dari `Auth::id()` saat `saving` event
`App\Traits\DateTimeTrait`	`app/Traits/DateTimeTrait.php`	Utility date/time formatting

Contoh model baru:

php

use App\Traits\UUID;
use App\Traits\WithAuthor;

class YourModel extends Model
&#123;
    use UUID, WithAuthor;

    protected $keyType = 'string';
    public $incrementing = false;
&#125;

Model `dazo-whitelist` (55+)

Dikategorikan berdasarkan domain:

Order & Payment

Model	Catatan
`Order`	Master order — polymorphic ke `OrderSubscribe`, `OrderTopup`, `OrderWithdraw`, `OrderTransferBalance`, `OrderDeduct`, `OrderPayment`, `OrderBusinessManager`
`OrderSubscribe`	Order sewa akun
`OrderTopup`	Order top up spend cap
`OrderWithdraw`	Order penarikan saldo
`OrderTransferBalance` + `OrderTransferBalanceDetail`	Order transfer saldo antar-akun
`OrderDeduct`	Order biaya admin/fee
`OrderPayment`	Order pembayaran
`OrderBusinessManager`	Order BM
`Payment`	Record pembayaran
`PaymentMethod`	Master metode pembayaran
`Refund`	Record refund
`BankAccount`	Master rekening bank

Ads & Stock

Model	Catatan
`AdsAccount`	Akun iklan member — konstanta `EXPIRED_BEFORE=7`, `EXPIRED_AFTER=4`
`StockAdsAccount`	Stok akun iklan (inventaris)
`StockBm`	Stok Business Manager
`MemberBm`	BM milik member
`AdsAccountBusinessManager`	Relasi akun iklan ↔ BM
`AdsAccountFunding`	Funding history akun iklan
`AdCampaign`	Campaign cache
`AdAdset`	Ad set cache
`AdAd`	Ad cache
`AdsExportSchedule`	Jadwal export laporan iklan (daily/weekly)
`UserAdsColumnPreference`	Preferensi kolom ads manager per user
`PixelConfiguration`	Konfigurasi pixel
`FacebookBusiness` / `FacebookAdAccount`	Data BM/Ad Account dari Meta (cache lokal)
`UserFacebookToken`	Token Facebook per user (di web app)

Admin Request & Approval

Model	Catatan
`AdminRequest`	Master request — approval workflow (akun baru, topup, transfer, withdraw, refund, rename, share pixel)
`AdminRequestItem`	Item detail per request
`AdminRequestHistory`	Audit log perubahan status request

Ticketing

Model	Catatan
`Ticket`	Master tiket bantuan
`TicketMessage`	Pesan tiket (member ↔ admin) — event `TicketMessageCreated`
`TicketAdsAccount`	Relasi tiket ↔ akun iklan
`TicketActivity`	Audit aktivitas tiket (status change)
`Attachment`	Lampiran pesan tiket

Transfer Balance

Model	Catatan
`TransferBalance`	Master transaksi transfer saldo antar-akun
`TransferBalanceDetail`	Detail per-item transfer

Fee & Coupon

Model	Catatan
`FeeSetting`	Master tarif sewa, biaya admin, persentase topup
`FeeSegment`	Segment fee per tier member
`FeeSegmentMember`	Mapping member ke segment
`Coupon`	Master voucher
`CouponFor`	Target member kupon

User & Team & Auth

Model	Catatan
`User`	User gabungan (admin + member) — guard dibedakan via role
`Member`	Profil member
`Team`	Tim member
`Role` / `Permission`	Spatie RBAC
`UserAuthenticator`	Google 2FA secret per user
`Notification`	Notifikasi in-app
`NotificationSetting`	Preferensi notifikasi per user

System

Model	Catatan
`Config`	Key-value store — termasuk `api_token` Passport client
`Application`	Aplikasi klien Passport (id, secret, public_key)
`WebhookLog`	Audit trail webhook payment gateway
`ImportJob`	Progress import massal BM/Ad Accounts
`News`	Pengumuman sistem
`Subscribe`	Master paket subscription

Model `dazo-whitelist-api` (16)

Model	Catatan
`Application`	Aplikasi klien Passport — verify RSA signature
`User`	User admin API engine
`UserFacebookToken`	Long-lived token Facebook + `needs_reauth` flag
`StockBm`	Stok BM
`StockAdsAccount`	Stok akun iklan
`AdsAccount`	Akun iklan aktif
`AdsAccountFunding`	Funding history
`MemberBm`	BM member
`TransferBalance` / `TransferBalanceDetail`	Transfer saldo
`ImportJob`	Progress import massal
`AdminRequest` / `AdminRequestItem`	Mirror request dari web app
`Order`	Mirror order
`FacebookAdAccount`	Cache ad account dari Meta
`Jobs`	Model untuk tabel `jobs` queue worker

Migration vs seeder

dazo-whitelist memakai migration standar Laravel untuk schema (database/migrations/). Tidak seperti dazoapp yang memakai MongoDB + seeder, Konco memakai PostgreSQL relasional — migration adalah sumber kebenaran schema.

Tabel utama menggunakan pola:

php

Schema::create('ads_accounts', function (Blueprint $table) &#123;
    $table->uuid('id')->primary();
    $table->foreignUuid('stock_ads_account_id')->constrained();
    $table->foreignUuid('member_bm_id')->constrained();
    $table->date('expired');
    $table->boolean('is_active')->default(true);
    $table->uuid('created_by')->nullable();
    $table->uuid('updated_by')->nullable();
    $table->timestamps();
&#125;);

Konstanta penting

Konstanta	Lokasi	Nilai	Dampak
`AdsAccount::EXPIRED_BEFORE`	`app/Models/AdsAccount.php:26`	`7`	Hari sebelum expired untuk trigger reminder H-7
`AdsAccount::EXPIRED_AFTER`	`app/Models/AdsAccount.php:27`	`4`	Hari grace period setelah expired sebelum deactivate

Raw query PostgreSQL

Beberapa query memakai syntax PostgreSQL spesifik — break bila pindah MySQL:

Lokasi	Syntax	Catatan
`AdsExpired.php:188-190`	`data::jsonb ->> 'model' = ?`	Query JSONB kolom `data` di tabel `notifications`
`WithdrawIndexWire.php:126`	`INTERVAL '4 days'`	Interval date
`AdsBalanceIndexWire.php:114`	`INTERVAL '4 days'`	Interval date

Langkah berikutnya

Detail RSA handshake + Passport token? Baca Auth & Security.
Skema tabel utama? Lihat Schema.
Konvensi kode & trait? Lihat Conventions.