lqbz-USER_TABLE_CONFIG.sql 792 B

1234567891011121314151617
  1. /**
  2. * Exported by SQLark 2025-03-04 11:37:49
  3. */
  4. CREATE TABLE "lqbz"."USER_TABLE_CONFIG"
  5. (
  6. "ID" VARCHAR(50) NOT NULL,
  7. "USER_ID" VARCHAR(50) NOT NULL,
  8. "TABLE_NAME" VARCHAR(100) NOT NULL,
  9. "COLUMN_CONFIG" CLOB NOT NULL,
  10. "UPDATE_TIME" TIMESTAMP(6) DEFAULT SYSTIMESTAMP,
  11. NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
  12. COMMENT ON TABLE "lqbz"."USER_TABLE_CONFIG" IS '用户表格配置表';
  13. COMMENT ON COLUMN "lqbz"."USER_TABLE_CONFIG"."ID" IS '主键ID';
  14. COMMENT ON COLUMN "lqbz"."USER_TABLE_CONFIG"."USER_ID" IS '用户ID';
  15. COMMENT ON COLUMN "lqbz"."USER_TABLE_CONFIG"."TABLE_NAME" IS '表格名称';
  16. COMMENT ON COLUMN "lqbz"."USER_TABLE_CONFIG"."COLUMN_CONFIG" IS '列配置信息(JSON存储)';
  17. COMMENT ON COLUMN "lqbz"."USER_TABLE_CONFIG"."UPDATE_TIME" IS '更新时间';