Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- statement: CREATE TABLE book(id int, creatorId int)
changeType: 1
want:
- status: 2
code: 302
title: NAMING_COLUMN
content: '`book`.`creatorId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE book(id int, gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx int)
changeType: 1
want:
- status: 2
code: 302
title: NAMING_COLUMN
content: '`book`.`gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx` mismatches column naming convention, its length should be within 64 characters'
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE book(id int, creator_id int)
changeType: 1
- statement: |-
CREATE TABLE book(id int, creator_id int);
ALTER TABLE book RENAME COLUMN creator_id TO creatorId
changeType: 1
want:
- status: 2
code: 302
title: NAMING_COLUMN
content: '`book`.`creatorId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 2
column: 0
endposition: null
- statement: ALTER TABLE tech_book RENAME COLUMN id TO creator_id;
changeType: 1
- statement: |-
CREATE TABLE book(
id int,
creator_id int,
created_ts timestamp,
updater_id int,
updated_ts timestamp);
ALTER TABLE book CHANGE COLUMN creator_id creatorId int;
changeType: 1
want:
- status: 2
code: 302
title: NAMING_COLUMN
content: '`book`.`creatorId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 7
column: 0
endposition: null
- statement: ALTER TABLE tech_book CHANGE COLUMN id creator_id int;
changeType: 1
- statement: ALTER TABLE tech_book DROP COLUMN id;
changeType: 1
- statement: |-
CREATE TABLE book(
id int,
creator_id int,
created_ts timestamp,
updated_ts timestamp);
ALTER TABLE book ADD COLUMN contentString varchar(255);
changeType: 1
want:
- status: 2
code: 302
title: NAMING_COLUMN
content: '`book`.`contentString` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 6
column: 0
endposition: null
- statement: |-
CREATE TABLE book(
id int,
createdTs timestamp,
updaterId int,
updated_ts timestamp);
CREATE TABLE student(
id int,
createdTs timestamp,
updatedTs timestamp);
changeType: 1
want:
- status: 2
code: 302
title: NAMING_COLUMN
content: '`book`.`createdTs` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 3
column: 0
endposition: null
- status: 2
code: 302
title: NAMING_COLUMN
content: '`book`.`updaterId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 4
column: 0
endposition: null
- status: 2
code: 302
title: NAMING_COLUMN
content: '`student`.`createdTs` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 8
column: 0
endposition: null
- status: 2
code: 302
title: NAMING_COLUMN
content: '`student`.`updatedTs` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
startposition:
line: 9
column: 0
endposition: null