D
Engineering

Schema Index

Index skema database Konco — 55+ model dazo-whitelist (PostgreSQL, UUID PK) & 16 model dazo-whitelist-api (MySQL, UUID PK). Kategori: Order/Payment, Ads/Stock, Ticket, Transfer, User/Team, Fee/Coupon, System.

Halaman ini index skema tabel utama Konco. Setiap entitas memakai UUID primary key via trait App\Traits\UUID. Skema detail per-tabel ada di sub-halaman.

Database engine

RepoEngineDefault DB
dazo-whitelistPostgreSQL (pgsql)konco_db
dazo-whitelist-apiMySQL/MariaDB (mysql)konco_api_db

Kategori model (dazo-whitelist)

KategoriJumlah modelSub-halaman
Order & Payment14Orders
Ads & Stock16Ads Accounts, Stock BM & Ads
Ticketing5Tickets
Transfer Balance2Transfer Balance
User & Team & Auth9—
Admin Request3—
Fee & Coupon5—
System6—
Total60+—

Model dazo-whitelist-api

ModelFungsi
ApplicationAplikasi klien Passport — verify RSA signature
UserUser admin API engine
UserFacebookTokenLong-lived token Facebook
StockBm / StockAdsAccountStok BM & ad accounts
AdsAccount / AdsAccountFundingAkun iklan & funding
MemberBmBM member
TransferBalance / TransferBalanceDetailTransfer saldo
ImportJobProgress import massal
AdminRequest / AdminRequestItemMirror request dari web app
OrderMirror order
FacebookAdAccountCache ad account dari Meta
JobsModel tabel jobs queue worker

Trait wajib

TraitFungsi
App\Traits\UUIDAuto-generate UUIDv4 PK, $keyType='string', $incrementing=false
App\Traits\WithAuthorAuto-isi created_by / updated_by dari Auth::id()
App\Traits\DateTimeTraitUtility date/time formatting

Konvensi kolom

PolaContohCatatan
Primary keyid (UUID)$table->uuid('id')->primary()
Foreign key<tabel_singular>_id$table->foreignUuid('stock_ads_account_id')->constrained()
Authorcreated_by, updated_byUUID, diisi oleh WithAuthor trait
Soft deletedeleted_atSoftDeletes trait pada model
Timestampcreated_at, updated_atStandar Laravel
Booleanis_active, is_deletedDefault true / false
Amountdecimal:2balance, amount_spent, spend_cap

Sub-halaman schema

  • Ads Accounts — ads_accounts, stock_ads_accounts, ads_account_fundings, ads_account_business_managers, ad_campaigns/adsets/ads
  • Orders — orders (polymorphic), order_subscribes, order_topups, order_withdraws, order_transfer_balances, order_deducts, payments, refunds
  • Stock BM & Ads — stock_bms, stock_ads_accounts, member_bms, facebook_businesses, facebook_ad_accounts
  • Tickets — tickets, ticket_messages, ticket_ads_accounts, ticket_activities, attachments
  • Transfer Balance — order_transfer_balances, order_transfer_balance_details, transfer_balances, transfer_balance_details (API engine)

Langkah berikutnya