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