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

1 vote114 views1 answer
Insert column after column mysql
SQL
15 votes254 views2 answers
How to sort names in alphabetical order in sql
SQL
-1 vote113 views2 answers
First letter capital in mysql query
SQL
1 vote119 views1 answer
Postgres select as csv
SQL
0 vote112 views1 answer
Sql server select top 2 of each group
SQL
1 vote126 views1 answer
Sql group by sum with condition
SQL
0 vote111 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote90 views1 answer
Clear query cache sql server
SQL
0 vote106 views1 answer
Set default value now() date
SQL
0 vote124 views1 answer
PSQL use LIKE with timestamps
SQL