Modernico
Tables (26)
categories
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- slug — varchar(255) — NOT NULL
- cover — text
- category_id — bigint — Foreign key → categories.id
- created_at — timestamp
- updated_at — timestamp
failed_jobs
- id — bigint — Primary key — NOT NULL
- uuid — varchar(255) — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
favorites
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- product_id — bigint — Foreign key → products.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
media
- id — bigint — Primary key — NOT NULL
- file_name — varchar(255) — NOT NULL
- file_type — varchar(255) — NOT NULL
- file_size — varchar(255) — NOT NULL
- file_status — tinyint(1) — NOT NULL
- file_sort — int — NOT NULL
- mediable_id — int — NOT NULL
- mediable_type — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
migrations
- id — int — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int — NOT NULL
oauth_access_tokens
- id — varchar(100) — Primary key — NOT NULL
- user_id — bigint
- client_id — char(36) — NOT NULL
- name — varchar(255)
- scopes — text
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- expires_at — datetime
oauth_auth_codes
- id — varchar(100) — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- client_id — char(36) — NOT NULL
- scopes — text
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
oauth_clients
- id — char(36) — Primary key — NOT NULL
- user_id — bigint
- name — varchar(255) — NOT NULL
- secret — varchar(100)
- provider — varchar(255)
- redirect — text — NOT NULL
- personal_access_client — tinyint(1) — NOT NULL
- password_client — tinyint(1) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_personal_access_clients
- id — bigint — Primary key — NOT NULL
- client_id — char(36) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_refresh_tokens
- id — varchar(100) — Primary key — NOT NULL
- access_token_id — varchar(100) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
order_items
- id — bigint — Primary key — NOT NULL
- qty — int — NOT NULL
- base_price — decimal(16,2) — NOT NULL
- base_total — decimal(16,2) — NOT NULL
- tax_amount — decimal(16,2) — NOT NULL
- tax_percent — decimal(16,2) — NOT NULL
- discount_amount — decimal(16,2) — NOT NULL
- discount_percent — decimal(16,2) — NOT NULL
- sub_total — decimal(16,2) — NOT NULL
- name — varchar(255) — NOT NULL
- weight — varchar(255) — NOT NULL
- order_id — bigint — Foreign key → orders.id
- product_id — bigint — Foreign key → products.id
- created_at — timestamp
- updated_at — timestamp
orders
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id
- code — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- order_date — datetime — NOT NULL
- payment_due — datetime — NOT NULL
- payment_status — varchar(255) — NOT NULL
- payment_token — varchar(255)
- payment_url — varchar(255)
- base_total_price — decimal(16,2) — NOT NULL
- tax_amount — decimal(16,2) — NOT NULL
- tax_percent — decimal(16,2) — NOT NULL
- discount_amount — decimal(16,2) — NOT NULL
- discount_percent — decimal(16,2) — NOT NULL
- shipping_cost — decimal(16,2) — NOT NULL
- grand_total — decimal(16,2) — NOT NULL
- note — text
- customer_first_name — varchar(255) — NOT NULL
- customer_last_name — varchar(255) — NOT NULL
- customer_address1 — varchar(255)
- customer_address2 — varchar(255)
- customer_phone — varchar(255)
- customer_email — varchar(255)
- customer_city_id — varchar(255)
- customer_province_id — varchar(255)
- customer_postcode — int
- shipping_courier — varchar(255)
- shipping_service_name — varchar(255)
- approved_by — bigint — Foreign key → users.id
- approved_at — datetime
- cancelled_by — bigint — Foreign key → users.id
- cancelled_at — datetime
- cancellation_note — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
payments
- id — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → orders.id — NOT NULL
- number — varchar(255) — NOT NULL
- amount — decimal(16,2) — NOT NULL
- method — varchar(255) — NOT NULL
- status — varchar(255)
- token — varchar(255)
- payloads — json
- payment_type — varchar(255)
- va_number — varchar(255)
- vendor_name — varchar(255)
- biller_code — varchar(255)
- bill_key — varchar(255)
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
permission_role
- id — bigint — Primary key — NOT NULL
- permission_id — bigint — Foreign key → permissions.id
- role_id — bigint — Foreign key → roles.id
- created_at — timestamp
- updated_at — timestamp
permissions
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
personal_access_tokens
- id — bigint — Primary key — NOT NULL
- tokenable_type — varchar(255) — NOT NULL
- tokenable_id — bigint — NOT NULL
- name — varchar(255) — NOT NULL
- token — varchar(64) — NOT NULL
- abilities — text
- last_used_at — timestamp
- created_at — timestamp
- updated_at — timestamp
product_tags
- id — bigint — Primary key — NOT NULL
- product_id — bigint — Foreign key → products.id
- tag_id — bigint — Foreign key → tags.id
- created_at — timestamp
- updated_at — timestamp
products
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- slug — varchar(255) — NOT NULL
- price — int — NOT NULL
- description — text — NOT NULL
- details — longtext — NOT NULL
- weight — int — NOT NULL
- quantity — int — NOT NULL
- status — tinyint(1) — NOT NULL
- review_able — tinyint — NOT NULL
- category_id — bigint — Foreign key → categories.id
- created_at — timestamp
- updated_at — timestamp
reviews
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id
- product_id — bigint — Foreign key → products.id — NOT NULL
- content — text — NOT NULL
- status — tinyint(1) — NOT NULL
- rating — tinyint — NOT NULL
- ip_address — varchar(255)
- created_at — timestamp
- updated_at — timestamp
role_user
- id — bigint — Primary key — NOT NULL
- role_id — bigint — Foreign key → roles.id
- user_id — bigint — Foreign key → users.id
- created_at — timestamp
- updated_at — timestamp
roles
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
shipments
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id
- order_id — bigint — Foreign key → orders.id
- track_number — varchar(255)
- status — varchar(255) — NOT NULL
- total_qty — int — NOT NULL
- total_weight — int — NOT NULL
- first_name — varchar(255) — NOT NULL
- last_name — varchar(255) — NOT NULL
- address1 — varchar(255)
- address2 — varchar(255)
- phone — varchar(255)
- email — varchar(255)
- city_id — varchar(255)
- province_id — varchar(255)
- postcode — int
- shipped_at — datetime
- shipped_by — bigint — Foreign key → users.id
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
slides
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- url — varchar(255)
- position — int — NOT NULL
- body — text
- cover — text — NOT NULL
- created_at — timestamp
- updated_at — timestamp
tags
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- slug — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
users
- id — bigint — Primary key — NOT NULL
- username — varchar(255) — NOT NULL
- first_name — varchar(255)
- last_name — varchar(255)
- email — varchar(255) — NOT NULL
- phone — varchar(255)
- address1 — varchar(255)
- address2 — varchar(255)
- province_id — int
- city_id — int
- postcode — int
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp