DB foundation_store

store_core

column name	definition
store_core_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
store_id	BIGINT UNSIGNED NOT NULL COMMENT 'store id。一定和【group_core.group_id】相等，因为【store is a group】。'
type	TINYINT UNSIGNED NOT NULL COMMENT '店铺类型'
state	TINYINT UNSIGNED NOT NULL COMMENT '店铺状态'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

store_general

column name	definition
store_general_id	BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
store_id	BIGINT UNSIGNED NOT NULL COMMENT '主键'
store_name	VARCHAR (45) NOT NULL COMMENT '店铺名称'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0