Create public schema and define multiple tables #34
adela-bytebasedeclarative-sql-review-action.yml
on: pull_request
check-release-on-prod
13s
Annotations
7 errors
|
Comment Requirements (0):
schema/schema.sql#L13
Column 'operation' should have a comment explaining its purpose. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Index Requirements (0):
schema/schema.sql#L14
Column 'user_name' used frequently in WHERE clauses should be indexed. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Index Requirements (0):
schema/schema.sql#L13
Column 'operation' used frequently in WHERE clauses should be indexed. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Type Consistency (0):
schema/schema.sql#L18
Use BIGINT instead of serial for auto-incrementing primary keys. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Type Consistency (0):
schema/schema.sql#L9
Use TIMESTAMP instead of timestamp(6) with time zone for datetime values. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Column Standards (0):
schema/schema.sql#L14
Primary key column should be named 'id'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Table Naming Convention (0):
schema/schema.sql#L5
Table name 'fake_table' should be in snake_case. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|