create_tables.sql 786 Bytes
CREATE TABLE IF NOT EXISTS "market_activity" (
    "id" bigint(20) NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "title" varchar(50) NOT NULL,
    "activity_type" tinyint(4) NOT NULL,
    "status" tinyint(4) NOT NULL,
    "start_time" datetime NOT NULL,
    "end_time" datetime NOT NULL,
    "invalid_time" datetime,
    "delete_time" datetime,
    "time_limited_discount" varchar(2000),
    "full_privilege" varchar(2000),
    "creator" varchar(64) DEFAULT '',
    "create_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint(20) NOT NULL,
    PRIMARY KEY ("id")
    ) COMMENT '促销活动';