nightmarket

Tables (12)

image_manager

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • entity_image_type — VARCHAR(255)
  • display_order — INT
  • image_owner_model — BINARY(16) — Foreign key → image_owner_model.id
  • image_url — VARCHAR(255)

image_owner_model

  • id — BINARY(16) — Primary key — NOT NULL
  • owner_type — VARCHAR(31)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

option_group

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • product_id — BINARY(16) — NOT NULL
  • display_order — INT
  • name — VARCHAR(255)

option_value

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • name — VARCHAR(255)
  • display_order — INT
  • option_group_id — BINARY(16) — Foreign key → option_group.id
  • price — DECIMAL

product

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • description — VARCHAR(255)
  • name — VARCHAR(255)
  • price — DECIMAL

product_post

  • id — BINARY(16) — Foreign key → image_owner_model.id — NOT NULL
  • product_id — BINARY(16) — Foreign key → product.id
  • user_id — BINARY(16) — Foreign key → users.id
  • deleted — BOOLEAN — NOT NULL
  • rating — FLOAT

product_variant

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • product_id — BINARY(16) — NOT NULL
  • user_id — BINARY(16) — NOT NULL
  • sku_code — VARCHAR(255) — NOT NULL
  • quantity — DECIMAL

reply

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted — BOOLEAN — NOT NULL
  • users_id — BINARY(16) — Foreign key → users.id
  • review_id — BINARY(16) — Foreign key → review.id — NOT NULL
  • comment_text — VARCHAR(255)

review

  • id — BINARY(16) — Foreign key → image_owner_model.id — NOT NULL
  • deleted — BOOLEAN — NOT NULL
  • users_id — BINARY(16) — Foreign key → users.id
  • product_post_id — BINARY(16) — Foreign key → product_post.id
  • comment_text — VARCHAR(255)
  • rating — FLOAT

shopping_basket_product

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • product_variant — BINARY(16) — Foreign key → product_variant.id
  • user_id — BINARY(16) — Foreign key → users.id
  • name — VARCHAR(255)
  • quantity — DECIMAL
  • price — DECIMAL

users

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • name — VARCHAR(255)

variant_option_value

  • id — BINARY(16) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • product_variant_id — BINARY(16) — Foreign key → product_variant.id
  • option_group_id — BINARY(16) — Foreign key → option_group.id
  • option_value_id — BINARY(16) — Foreign key → option_value.id