Sql table to store status

CREATE TABLE status
(
  id integer PRIMARY KEY,
  name TEXT NOT NULL,
  next_status Integer references status
);

insert into status(id, name, next_status)
values 
(1,'init', 2),
(2,'waiting ror price approve', 3),
(3,'sent', 4),
(4,'accepted', 5),
(5,'finished', null);

Source: stackoverflow.com

Similar codes

0 vote181 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote215 views1 answer
Selecting all columns from table sql database
SQL
0 vote153 views1 answer
Oracle function select into
SQL
0 vote260 views1 answer
Best sql collation
SQL
1 vote213 views1 answer
Postgres cast as currency format
SQL
0 vote205 views1 answer
Criteria builder select subset of column
SQL
0 vote200 views1 answer
Print orcale
SQL
13 votes190 views5 answers
Alter table query sql server change column
SQL
1 vote195 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote215 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL