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