ccp
Tables (13)
item
- item_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- image — VARCHAR(500)
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
item_attribute_mapping
- item_attribute_mapping_id — BIGINT — Primary key — NOT NULL
- item_id — BIGINT — Foreign key → item.item_id — NOT NULL
- standard_attribute_value_id — BIGINT — Foreign key → standard_attribute_value.standard_attribute_value_id — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
item_option_mapping
- item_option_mapping_id — BIGINT — Primary key — NOT NULL
- item_id — BIGINT — Foreign key → item.item_id — NOT NULL
- standard_option_value_id — BIGINT — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
platform_category
- id — BIGINT — Primary key — NOT NULL
- category_code — VARCHAR(100) — NOT NULL
- category_name — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255)
- parent_category_code — VARCHAR(100)
- is_leaf — BOOLEAN — NOT NULL
- depth — INT — NOT NULL
- sort_order — INT
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
- is_use — BOOLEAN — NOT NULL
- mall_id — BIGINT
- standard_category_code — VARCHAR(100) — Foreign key → standard_category.category_code
platform_category_and_product_notice_mapping
- id — BIGINT — Primary key — NOT NULL
- category_code — VARCHAR(100) — Foreign key → platform_category.category_code — NOT NULL
- product_notice_code — VARCHAR(100) — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
platforms
- platform_id — BIGINT — Primary key — NOT NULL
- platform_code — VARCHAR(100) — NOT NULL
- platform_name — VARCHAR(255) — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
product
- product_id — BIGINT — Primary key — NOT NULL
- standard_category_code — VARCHAR(100) — Foreign key → standard_category.category_code — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
seller_item
- seller_item_id — BIGINT — Primary key — NOT NULL
- seller_product_id — BIGINT — Foreign key → seller_product.seller_product_id — NOT NULL
- platform_option_item_id — BIGINT
- seller_item_name — VARCHAR(255)
- product_normal_price — DECIMAL(18,2)
- option_price — DECIMAL(18,2)
- option_image — VARCHAR(500)
- partner_item_sku — VARCHAR(100)
- activated — BOOLEAN — NOT NULL
- out_of_stock — BOOLEAN — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
seller_product
- seller_product_id — BIGINT — Primary key — NOT NULL
- platform_id — BIGINT — Foreign key → platforms.platform_id — NOT NULL
- platform_product_id — BIGINT
- platform_company_id — VARCHAR(100)
- platform_brand_id — VARCHAR(100)
- platform_category_code — VARCHAR(100)
- product_name — VARCHAR(255)
- image — VARCHAR(500)
- status — VARCHAR(50)
- normal_price — DECIMAL(18,2)
- sell_price — DECIMAL(18,2)
- cost_price — DECIMAL(18,2)
- tax_type — VARCHAR(50)
- purchase_type — VARCHAR(50)
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
standard_attribute_name
- standard_attribute_name_id — BIGINT — Primary key — NOT NULL
- text — VARCHAR(255) — NOT NULL
- code — VARCHAR(100) — NOT NULL
- standard_category_code — VARCHAR(100) — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
standard_attribute_value
- standard_attribute_value_id — BIGINT — Primary key — NOT NULL
- standard_attribute_name_id — BIGINT — Foreign key → standard_attribute_name.standard_attribute_name_id — NOT NULL
- text — VARCHAR(255) — NOT NULL
- code — VARCHAR(100) — NOT NULL
- standard_category_code — VARCHAR(100) — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
standard_category
- id — BIGINT — Primary key — NOT NULL
- category_code — VARCHAR(100) — NOT NULL
- category_name — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255)
- parent_category_code — VARCHAR(100)
- is_leaf — BOOLEAN — NOT NULL
- depth — INT — NOT NULL
- sort_order — INT
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL
- is_use — BOOLEAN — NOT NULL
standard_category_and_product_notice_mapping
- id — BIGINT — Primary key — NOT NULL
- category_code — VARCHAR(100) — Foreign key → standard_category.category_code — NOT NULL
- product_notice_code — VARCHAR(100) — NOT NULL
- rt — DATETIME — NOT NULL
- ut — DATETIME — NOT NULL
- dt — DATETIME — NOT NULL