| | |
| | | ) COMMENT '分销用户'; |
| | | CREATE TABLE IF NOT EXISTS "trade_brokerage_record" |
| | | ( |
| | | "id" int NOT NULL GENERATED BY DEFAULT AS IDENTITY, |
| | | "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, |
| | | "user_id" bigint NOT NULL, |
| | | "biz_id" varchar NOT NULL, |
| | | "biz_type" varchar NOT NULL, |
| | |
| | | "status" varchar NOT NULL, |
| | | "frozen_days" int NOT NULL, |
| | | "unfreeze_time" varchar, |
| | | "source_user_level" int, |
| | | "source_user_id" bigint, |
| | | "creator" varchar DEFAULT '', |
| | | "create_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| | | "updater" varchar DEFAULT '', |
| | |
| | | "update_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| | | "deleted" bit NOT NULL DEFAULT FALSE, |
| | | PRIMARY KEY ("id") |
| | | ) COMMENT '佣金提现'; |
| | | ) COMMENT '佣金提现'; |