Create initial database schema with tables and views #29
declarative-sql-review-action.yml
on: pull_request
check-release-on-prod
13s
Annotations
7 errors
|
Type Consistency (0):
schema/schema.sql#L14
Use BIGINT 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#L8
Use TIMESTAMP for datetime values. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Type Consistency (0):
schema/schema.sql#L7
Use TEXT instead of VARCHAR for string columns. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Type Consistency (0):
schema/schema.sql#L6
Use TEXT instead of VARCHAR for string columns. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Column Standards (0):
schema/schema.sql#L44
Primary key column should be named 'id'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Column Standards (0):
schema/schema.sql#L23
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#L4
Table name 'fakeTable' should be in snake_case. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|