Create initial database schema with tables and views #28
adela-bytebasedeclarative-sql-review-action.yml
on: pull_request
check-release-on-prod
18s
Annotations
10 errors
|
Index Requirements (0):
schema/schema.sql#L62
Missing index for foreign key 'emp_no' in table 'salary'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Index Requirements (0):
schema/schema.sql#L53
Missing index for foreign key 'emp_no' in table 'dept_manager'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Index Requirements (0):
schema/schema.sql#L53
Missing index for foreign key 'dept_no' in table 'dept_manager'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Index Requirements (0):
schema/schema.sql#L45
Missing index for foreign key 'emp_no' in table 'dept_emp'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Index Requirements (0):
schema/schema.sql#L45
Missing index for foreign key 'dept_no' in table 'dept_emp'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Column Standards (0):
schema/schema.sql#L52
Primary key column should be named 'id' in table 't0'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Table Naming Convention (0):
schema/schema.sql#L51
Table name 't0' should be a plural noun. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Column Standards (0):
schema/schema.sql#L4
Missing 'updated_at' column in table 'fakeTable'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Column Standards (0):
schema/schema.sql#L4
Missing 'created_at' column in table 'fakeTable'. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|
|
Table Naming Convention (0):
schema/schema.sql#L6
Table name 'fakeTable' should be in snake_case and a plural noun. Targets: instances/prod-sample-instance/databases/hr_prod https://docs.bytebase.com/sql-review/error-codes#0
|